Calculo Del Van y Tir

TIPO DE INTERES VAN TIR

PERIODOS

DATOS FLUJO DE CAJA 0 -51 -51767 7674.30 4.3017 173 30903 0903 1 47111 2 49347 3 51582 4 52696 5 53812 6 54926 7 56041 8 57155 9 59390 10 60505 11 61619 12 62733 13 63849 14 66084 15 67199 16 68313 17 69427 18 70542 19 71656 20 73892

RESULTADOS

VAN TIR

 

0% 1576 157639 39..70 0.09 RENTABLE

RENTABLE

0% -51 -517674 7674.3 .30 0 47111.00 49347.00 51582.00 52696.00 53812.00 54926.00 56041.00 57155.00 59390.00 60505.00 61619.00 62733.00 63849.00 66084.00 67199.00 68313.00 69427.00 70542.00 71656.00 73892.00

1% -517 -5176 674.3 74.30 0 46644.55 48374.67 50064.98 50639.82 51200.27 51742.78 52270.45 52781.68 54302.64 54774.39 55230.57 55672.35 56101.73 57490.63 57881.82 58258.78 58622.60 58974.33 59312.53 60557.78

7002 700204 04..70 9.12%

5732 573225 25.0 .06 6

RENTABLE

-517674.30173

1 47111

1% 1209 120911 11.2 .20 0 0.09

2 49347

RENTABLE

3 51582

VAN

2% 86998.43 0.09 RENTABLE

3% 55642.96 0.09 RENTABLE

5% -517674.30 44867.62 44759.18 44558.47 43353.13 42163.11 40986.63 39827.29 38684.75 38283.32 37144.82 36027.35 34932.08 33860.49 33376.91 32323.87 31294.97 30290.77 29311.66 28356.71 27849.12

9% -517674.30 43221.10 41534.38 39830.77 37331.17 34974.11 32750.58 30656.35 28684.17 27344.81 25557.97 23879.39 22303.76 20826.18 19775.40 18448.68 17205.98 16042.72 14954.46 13936.35 13184.62

214577.96

4768.64 9.12%

RENTABLE

4 52696

RENTABLE

5 53812

4% 26613.27 0.09 RENTABLE

10% -109005.32 0.09 NO RENTABLE

 TIPO DE INTERES 10% 14% -517674.30 -517674.30 42828.18 41325.44 40782.64 37970.91 38754.32 34816.38 35992.08 31200.26 33413.02 27948.27 31004.30 25023.55 28757.89 22396.08 26663.23 20036.20 25187.16 18262.90 23327.30 16320.85 21597.08 14580.13 19988.67 13020.81 18494.78 11624.95 17401.98 10554.27 16086.91 9414.34 14866.90 8395.10 13735.76 7484.21 12687.60 6670.53 11716.33 5943.75 10983.57 5376.51

-33404.60 NO RENTABLE

6 54926

-149308.88 NO RENTABLE

7 56041

14% -172663.26 0.09 NO RENTABLE

20% -517674.30 39259.17 34268.75 29850.69 25412.81 21625.84 18394.61 15640.01 13292.43 11510.18 9771.90 8293.18 7035.92 5967.58 5147.06 4361.58 3694.91 3129.30 2649.63 2242.89 1927.40

-254198.47 NO RENTABLE

8 57155

20% -242455.03 0.09

19% -233229.97

22% -259076.51

25% -517674.30 37688.80 31582.08 26409.98 21584.28 17633.12 14398.52 11752.65 9589.02 7971.19 6496.67 5293.03 4310.98 3510.14 2906.41 2364.35 1922.84 1563.36 1270.77 1032.67 851.92

30% -517674.30 36239.23 29199.41 23478.38 18450.33 14493.14 11379.36 8931.05 7006.60 5600.45 4388.92 3438.25 2692.62 2108.10 1678.38 1312.84 1026.62 802.59 627.29 490.15 388.80

35% -517674.30 34897.04 27076.54 20965.10 15865.09 12000.80 9073.51 6857.56 5180.65 3987.58 3009.22 2270.09 1711.95 1290.67 989.52 745.34 561.26 422.53 318.01 239.28 182.78

-307541.52

-343941.79

-370029.79

NO RENTABLE

NO RENTABLE

9 59390

NO RENTABLE

10 60505

NO RENTABLE

11 61619

12 62733

13 63849

14 66084

15 67199

16 68313

17 69427

18 70542

19 71656

20 73892