Page 76 - libro, alexis briones
P. 76

Repaso PR, VPN Y TIR




                                PERFORADORA C               INV INICIAL  130000
                    AÑO         ENTRADA DE EFECTIVO
                     1                50000
                     2                30000
                     3                20000
                     4                20000
                     5                20000
                     6                30000
                     7                40000
                     8                50000


           PR                                           67.5        2 MESES
                          130000             10000 2.219178082      6 DIAS
                           80000            -10000 0.219178082     16 HRS
                           50000                4 6.666666667
                           30000               4.5 0.666666667     16

           VPN                                              I              0.086
                   12000                11049.72376 76831.67241 INV       60000
                   14000                11870.48286 16831.67241
                   16000                12491.95776
                   18000                12940.56397
                   20000                13239.78307
                   25000                15239.16099
           TIR                  INV                    60000
                   12000        N                         6
                   14000
                   16000
                   18000
                   20000
                   25000
                          105000
                           17500
                      3.428571429
           TABLA                              19%
                                              17%

                   12000                    0.8547    10256.4
                   14000                    0.7305     10227
                   16000                    0.6244     9990.4
                   18000                    0.5337     9606.6
                   20000                    0.4561      9122
                   25000                    0.3898      9745
                                                      58947.4
                                                      -1052.6   1052.6

                                              16%
                   12000                    0.8621    10345.2
                   14000                    0.7432    10404.8
                   16000                    0.6407    10251.2
                   18000                    0.5523     9941.4
                   20000                    0.4761      9522
                   25000                    0.4104     10260
                                                      60724.6
                                                       724.6

                      16.40772001
   71   72   73   74   75   76