Spreadsheet: 696220d1600705988-valuation-npv-irr-and-terminal-value-on-monthly-cash-flows-project-valuation
Sheet: Hoja1

 |  | 2020-12-31 00:00:00
 | EBIT | -614780000 | -5247006.089 | -5247006.089 | -5247006.089 | -5247006.089 | -5247006.089 | -5247006.089 | -34642446.089 | -2623536746.089 | -2623536746.089 | -2622164740 | -2622164740 | -2622164740 | -158784233.0144492 | -158784233.0144492 | -158784233.0144492 | -158784233.0144492 | -158784233.0144492 | -158784233.0144492 | -188179673.0144492 | -158784233.0144492 | -158784233.0144492 | -158784233.0144492 | 5649691866.985551 | 2350911066.985551 | 699824404.9247043 | 179526352.1747043 | 99357938.67470431 | 99357938.67470431 | 179526352.1747043 | 494270887.1747043 | 464875447.1747043 | 494270887.1747043 | 99357938.67470431 | 99357938.67470431 | 333004463.6747043 | 737322524.6747043 | 938466292.1900678 | 294863731.9811381 | 195959201.813758 | 195959201.813758 | 294863731.9811381 | 684236772.711658 | 654841332.711658 | 684236772.711658 | 195959201.813758 | 195959201.813758 | 484711688.4077981 | 984854466.1703978 | 1072826745.855633 | 278216723.7912426 | 155680697.1100947 | 155680697.1100947 | 278216723.7912426 | 759140606.7674797 | 729745166.7674797 | 759140606.7674797 | 155680697.1100947 | 155680697.1100947 | 512483113.7652235 | 1129900028.895321 | 1568102325.688433 | 572139313.0719148 | 418514241.6922014 | 418514241.6922014 | 572139313.0719148 | 1174866545.39525 | 8854395672.74728 | 1685816713.312821 | 929695920.1753136 | 929927430.7408544 | 1377528298.573249 | 2146341532.419296 | 1960034146.089167 | 729787072.0526364 | 539889685.0002353 | 539889685.0002353 | 729787072.0526364 | 1474051429.246204 | 1444655989.246204 | 1474051429.246204 | 539889685.0002353 | 539889685.0002353 | 1092377387.259508 | 2046535309.826362 | 2399083530.023793 | 942319498.6195312 | 717148702.6098325 | 717148702.6098325 | 942319498.6195312 | 1826401093.697255 | 1797005653.697255 | 4024476122.817103 | 1045079202.424601 | 1051410772.490879 | 1759935526.779662 | 2995128707.411891 | 3096486940.63827 | 1270635506.875406 | 983348596.237624 | 983348596.237624 | 1270635506.875406 | 2393994365.380093 | 2364598925.380093 | 2393994365.380093 | 983348596.237624 | 983348596.237624 | 1814882068.74131 | 3265494398.58073 | 3592671728.362454 | 1447023288.351442 | 1107315396.216825 | 1107315396.216825 | 1447023288.351442 | 2771866099.011139 | 2742470659.011139 | 2771866099.011139 | 1107315396.216825 | 1107315396.216825 | 2087886169.663029 | 3785666208.629334 | 4262943678.69662 | 1817648407.671497 | 1430075490.976915 | 1430075490.976915 | 1817648407.671497 | 3329019561.926793 | 9542958067.521805 | 3416891257.521807 | 3531926823.354805 | 1480106073.354805 | 2637645666.449948 | 4663326961.554053
 | Less: Cash Taxes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1807901397.435376 | 752291541.4353763 | 223943809.5759054 | 57448432.69590538 | 31794540.37590538 | 31794540.37590538 | 57448432.69590538 | 158166683.8959054 | 148760143.0959054 | 158166683.8959054 | 31794540.37590538 | 31794540.37590538 | 106561428.3759054 | 235943207.8959054 | 300309213.5008217 | 94356394.23396419 | 62706944.58040257 | 62706944.58040257 | 94356394.23396419 | 218955767.2677306 | 209549226.4677306 | 218955767.2677306 | 62706944.58040257 | 62706944.58040257 | 155107740.2904954 | 315153429.1745273 | 343304558.6738024 | 89029351.61319764 | 49817823.07523029 | 49817823.07523029 | 89029351.61319764 | 242924994.1655935 | 233518453.3655935 | 242924994.1655935 | 49817823.07523029 | 49817823.07523029 | 163994596.4048715 | 361568009.2465026 | 501792744.2202986 | 183084580.1830127 | 133924557.3415044 | 133924557.3415044 | 183084580.1830127 | 375957294.5264801 | 2833406615.27913 | 539461348.2601027 | 297502694.4561003 | 297576777.8370734 | 440809055.5434396 | 686829290.3741748 | 627210926.7485336 | 233531863.0568436 | 172764699.2000753 | 172764699.2000753 | 233531863.0568436 | 471696457.3587854 | 462289916.5587854 | 471696457.3587854 | 172764699.2000753 | 172764699.2000753 | 349560763.9230426 | 654891299.1444359 | 767706729.6076137 | 301542239.55825 | 229487584.8351464 | 229487584.8351464 | 301542239.55825 | 584448349.9831216 | 575041809.1831216 | 1287832359.301473 | 334425344.7758723 | 336451447.1970812 | 563179368.5694919 | 958441186.371805 | 990875821.0042466 | 406603362.2001299 | 314671550.7960397 | 314671550.7960397 | 406603362.2001299 | 766078196.9216297 | 756671656.1216296 | 766078196.9216297 | 314671550.7960397 | 314671550.7960397 | 580762261.9972192 | 1044958207.545834 | 1149654953.075985 | 463047452.2724615 | 354340926.789384 | 354340926.789384 | 463047452.2724615 | 886997151.6835644 | 877590610.8835645 | 886997151.6835644 | 354340926.789384 | 354340926.789384 | 668123574.2921695 | 1211413186.761387 | 1364141977.182919 | 581647490.454879 | 457624157.1126129 | 457624157.1126129 | 581647490.454879 | 1065286259.816574 | 3053746581.606977 | 1093405202.406978 | 1130216583.473538 | 473633943.4735377 | 844046613.2639835 | 1492264627.697297
 | NOPAT
 | Plus: D&A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89523749.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 89786249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 95036249.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 97048749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 102458749.5138889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889 | 118357487.2638889
 | Less: Change in NWC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 537600000 | 806400000 | 806400000 | 2595600000 | 2058000000 | 949200000 | 411600000 | 0 | 949200000 | 411600000 | 949200000 | 411600000 | 949200000 | 411600000 | 0 | -8542800000 | -3704400000 | 292024904.5 | -75872926.5 | -10075905 | 0 | 10075905 | 38646258 | 0 | 0 | -48722163 | 0 | 28444416 | 50925798 | 43968165.81990007 | -93907191.24150006 | -12406811.39880001 | 0 | 12406811.39880001 | 47843246.34180002 | 0 | 0 | -60250057.74060002 | 0 | 35141706.81840001 | 63034019.68500004 | 375254498.8331663 | 206621888.4588937 | 1315141704.944382 | 322560000 | 1345978295.055618 | 381658476.97845 | 2197440000 | 403200000 | 1558443227.965932 | 483840000 | 527287074.794214 | 1791450422.497302 | 272838211.4780414 | 1247691362.448506 | 142198421.4679126 | 1471680000 | 261001578.5320874 | 234374849.2320513 | -10910811709.91001 | -645447054.6084623 | -818263482.372601 | -726087054.6084623 | -672300489.7111117 | -629876215.3234689 | 216185310.9546579 | 24459038.21431857 | 177989866.1156962 | 201600000 | 225210133.8843038 | 291856673.7855619 | 201600000 | 588000000 | 138133192.3301343 | 638400000 | 368829588.575838 | 421354551.5842175 | 562148495.6351169 | -111625683.0392272 | 408696444.6482003 | 100800000 | 515303555.3517997 | 208668453.9590304 | 100800000 | -3419144470.698388 | -549942533.8004838 | -453920786.5322365 | -366347795.3261194 | -293807052.2220644 | 112875800.2687723 | -288728537.5801825 | -37856303.08074746 | 0 | 37856303.08074746 | 144544987.0229909 | 0 | 0 | -182401290.1037384 | 0 | 105968013.7458656 | 191577744.7943668 | 135150895.0283506 | -348195500.5190659 | 1130330109.354595 | 0 | 1221669890.645405 | 173664096.2583187 | 2058000000 | 0 | 2132666013.096277 | 0 | 421352298.9081647 | 1112620786.755124 | 130339684.0092393 | 777121915.8014073 | -52281705.64448246 | 1176000000 | 52281705.64448246 | 492805504.68875 | -7924362706.514793 | 0 | -2905235000.762372 | 0 | 153085148.431345 | 277522740.7566751
 | Less: CAPEX | -320000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1463158200 | -638076600 | -4716624696 | -1462488804 | -1214861844 | -731244402 | -790325697 | -731244402 | -790325697 | -731244402 | -424536147 | -365789550 | 2926651098 | -4277850927 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -25200000 | -12600000 | 0 | -6300000 | 0 | -6300000 | -1823392620 | -124905480 | -1030301790 | -177908220 | -640056375 | -207559590 | -544802265 | -118605480 | -515150895 | -88954110 | -59302740 | -515150895 | 4499178810 | 237210960 | 266862330 | 266862330 | 266862329.9999999 | -333486299.9999999 | -25200000 | -12600000 | 0 | -6300000 | 0 | -6300000 | 0 | -711190200 | -91942200 | -444387300 | -144213300 | -524135850 | -68956650 | -245179200 | -45971100 | -222193650 | -45971100 | -45971100 | -199208100 | 1716254400 | 206869950 | 206869950 | 206869950 | -224584500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -25200000 | -12600000 | 0 | -6300000 | 0 | -6300000 | -1056289500 | -6300000 | -880241250 | 0 | -446420625 | -1876348530 | -352096500 | 0 | -352096500 | 0 | -88024125 | -264072375 | 2640723750 | -88024125 | 880241250 | 0 | 0 | 0
 | Unlevered FCFF
 | Discount Rate | 0.18 | Annual Rate
 |  |  | Monthly Rate
 | NPV
 | XNPV
 | XIRR
 | IRR