MES PAGO INTERESES ABONO SALDO TASA

0 $ 10,000,000.00 3.12%
1 $370,517.38 $ 311,805.53 $58,711.85 $ 9,941,288.15
2 $370,517.38 $ 309,974.86 $60,542.51 $ 9,880,745.64
3 $370,517.38 $ 308,087.12 $62,430.26 $ 9,818,315.38
4 $370,517.38 $ 306,140.51 $64,376.87 $ 9,753,938.51
5 $370,517.38 $ 304,133.20 $66,384.18 $ 9,687,554.33
6 $370,517.38 $ 302,063.30 $68,454.07 $ 9,619,100.25
7 $370,517.38 $ 299,928.87 $70,588.51 $ 9,548,511.74
8 $370,517.38 $ 297,727.88 $72,789.50 $ 9,475,722.24
9 $370,517.38 $ 295,458.26 $75,059.12 $ 9,400,663.13
10 $370,517.38 $ 293,117.88 $77,399.50 $ 9,323,263.63
11 $370,517.38 $ 290,704.52 $79,812.86 $ 9,243,450.77
12 $370,517.38 $ 288,215.91 $82,301.47 $ 9,161,149.30
13 $370,517.38 $ 285,649.70 $84,867.67 $ 9,076,281.62
14 $370,517.38 $ 283,003.48 $87,513.90 $ 8,988,767.73
15 $370,517.38 $ 280,274.75 $90,242.63 $ 8,898,525.10
16 $370,517.38 $ 277,460.94 $93,056.44 $ 8,805,468.66
17 $370,517.38 $ 274,559.38 $95,957.99 $ 8,709,510.67
18 $370,517.38 $ 271,567.36 $98,950.02 $ 8,610,560.65
19 $370,517.38 $ 268,482.04 $102,035.33 $ 8,508,525.32
20 $370,517.38 $ 265,300.53 $105,216.85 $ 8,403,308.46
21 $370,517.38 $ 262,019.81 $108,497.57 $ 8,294,810.89
22 $370,517.38 $ 258,636.79 $111,880.59 $ 8,182,930.31
23 $370,517.38 $ 255,148.29 $115,369.08 $ 8,067,561.22
24 $370,517.38 $ 251,551.02 $118,966.36 $ 7,948,594.87
25 $370,517.38 $ 247,841.59 $122,675.79 $ 7,825,919.08
26 $370,517.38 $ 244,016.49 $126,500.89 $ 7,699,418.19
27 $370,517.38 $ 240,072.12 $130,445.26 $ 7,568,972.93
28 $370,517.38 $ 236,004.76 $134,512.61 $ 7,434,460.31
29 $370,517.38 $ 231,810.59 $138,706.79 $ 7,295,753.52
30 $370,517.38 $ 227,485.63 $143,031.75 $ 7,152,721.77
31 $370,517.38 $ 223,025.82 $147,491.56 $ 7,005,230.22
32 $370,517.38 $ 218,426.95 $152,090.42 $ 6,853,139.79
33 $370,517.38 $ 213,684.69 $156,832.69 $ 6,696,307.11
34 $370,517.38 $ 208,794.56 $161,722.82 $ 6,534,584.29
35 $370,517.38 $ 203,751.95 $166,765.42 $ 6,367,818.86
36 $370,517.38 $ 198,552.11 $171,965.26 $ 6,195,853.60
37 $370,517.38 $ 193,190.14 $177,327.23 $ 6,018,526.37
38 $370,517.38 $ 187,660.98 $182,856.40 $ 5,835,669.97
39 $370,517.38 $ 181,959.42 $188,557.96 $ 5,647,112.01
40 $370,517.38 $ 176,080.08 $194,437.30 $ 5,452,674.71
41 $370,517.38 $ 170,017.41 $200,499.96 $ 5,252,174.75
42 $370,517.38 $ 163,765.71 $206,751.66 $ 5,045,423.08
 43 $370,517.38 $ 157,319.08 $213,198.29 $ 4,832,224.79
44 $370,517.38 $ 150,671.44 $219,845.94 $ 4,612,378.85
45 $370,517.38 $ 143,816.52 $226,700.85 $ 4,385,678.00
46 $370,517.38 $ 136,747.87 $233,769.51 $ 4,151,908.49
47 $370,517.38 $ 129,458.80 $241,058.57 $ 3,910,849.91
48 $370,517.38 $ 121,942.46 $248,574.91 $ 3,662,275.00
49 $370,517.38 $ 114,191.76 $256,325.62 $ 3,405,949.38
50 $370,517.38 $ 106,199.39 $264,317.99 $ 3,141,631.39
51 $370,517.38 $ 97,957.80 $272,559.57 $ 2,869,071.82
52 $370,517.38 $ 89,459.25 $281,058.13 $ 2,588,013.69
53 $370,517.38 $ 80,695.70 $289,821.68 $ 2,298,192.01
54 $370,517.38 $ 71,658.90 $298,858.48 $ 1,999,333.53
55 $370,517.38 $ 62,340.33 $308,177.05 $ 1,691,156.48
56 $370,517.38 $ 52,731.19 $317,786.18 $ 1,373,370.29
57 $370,517.38 $ 42,822.45 $327,694.93 $ 1,045,675.36
58 $370,517.38 $ 32,604.74 $337,912.64 $ 707,762.72
59 $370,517.38 $ 22,068.43 $348,448.94 $ 359,313.78
60 $370,517.38 $ 11,203.60 $359,313.78 $ 0.00
TOTAL $ 12,231,042.66 $ 10,000,000.00
TOTAL A PAG
 TASA 38% NABV A MV
FRECUENCIA 6 0.06333333333333 3.12%

AÑO INGRESO INVERSIÓN IN INTERESES DEPRECIACIÓN COSTO PROD

0 $ 10,000,000
1 $ 3,000,000 $ 4,446,209 $ 1,800,000 $ 800,000
2 $ 3,900,000 $ 4,446,209 $ 1,800,000 $ 1,000,000
3 $ 5,070,000 $ 4,446,209 $ 1,800,000 $ 1,200,000
4 $ 6,591,000 $ 4,446,209 $ 1,800,000 $ 1,400,000
5 $ 9,568,300 $ 4,446,209 $ 1,800,000 $ 1,600,000

AÑO INGRESO EGRESOS UTILIDAD INTERESES EGRESOS+INT

0
1
2
3
4
5
 VPN -$ 15,670,914.80 TIO 38%
TIR -62%
B/C 0.39

EGRESOS UTILIDAD INTERESES EGRESOS+INT FN VPE VPI

$ 10,000,000 -$ 10,000,000 $ 10,000,000 -$ 10,000,000 $ 10,000,000 $ -
$ 7,046,209 -$ 4,046,209 $ 7,046,209 -$ 4,046,209 $ 5,105,948 $ 2,173,913
$ 7,246,209 -$ 3,346,209 $ 7,246,209 -$ 3,346,209 $ 3,804,982 $ 2,047,889
$ 7,446,209 -$ 2,376,209 $ 7,446,209 -$ 2,376,209 $ 2,833,335 $ 1,929,171
$ 7,646,209 -$ 1,055,209 $ 7,646,209 -$ 1,055,209 $ 2,108,287 $ 1,817,335
$ 7,846,209 $ 1,722,091 $ 654,395 $ 8,500,603 $ 1,067,697 $ 1,698,456 $ 1,911,786
$ 25,551,009 $ 9,880,094

FN VPE VPI
MES PAGO INTERESES ABONO SALDO
0 $ 15,000,000.00
1 $733,503.63 $ 682,738.76 $50,764.88 $ 14,949,235.12
2 $733,503.63 $ 680,428.15 $53,075.49 $ 14,896,159.64
3 $733,503.63 $ 678,012.37 $55,491.27 $ 14,840,668.37
4 $733,503.63 $ 675,486.63 $58,017.00 $ 14,782,651.37
5 $733,503.63 $ 672,845.94 $60,657.70 $ 14,721,993.67
6 $733,503.63 $ 670,085.04 $63,418.59 $ 14,658,575.08
7 $733,503.63 $ 667,198.49 $66,305.14 $ 14,592,269.94
8 $733,503.63 $ 664,180.55 $69,323.08 $ 14,522,946.86
9 $733,503.63 $ 661,025.25 $72,478.39 $ 14,450,468.47
10 $733,503.63 $ 657,726.33 $75,777.31 $ 14,374,691.16
11 $733,503.63 $ 654,277.25 $79,226.38 $ 14,295,464.78
12 $733,503.63 $ 650,671.19 $82,832.44 $ 14,212,632.34
13 $733,503.63 $ 646,901.00 $86,602.64 $ 14,126,029.70
14 $733,503.63 $ 642,959.20 $90,544.44 $ 14,035,485.26
15 $733,503.63 $ 638,837.98 $94,665.65 $ 13,940,819.62
16 $733,503.63 $ 634,529.19 $98,974.44 $ 13,841,845.17
17 $733,503.63 $ 630,024.28 $103,479.36 $ 13,738,365.82
18 $733,503.63 $ 625,314.32 $108,189.31 $ 13,630,176.51
19 $733,503.63 $ 620,389.98 $113,113.65 $ 13,517,062.86
20 $733,503.63 $ 615,241.51 $118,262.12 $ 13,398,800.74
21 $733,503.63 $ 609,858.70 $123,644.93 $ 13,275,155.81
22 $733,503.63 $ 604,230.89 $129,272.74 $ 13,145,883.07
23 $733,503.63 $ 598,346.92 $135,156.71 $ 13,010,726.36
24 $733,503.63 $ 592,195.14 $141,308.49 $ 12,869,417.87
25 $733,503.63 $ 585,763.36 $147,740.28 $ 12,721,677.59
26 $733,503.63 $ 579,038.82 $154,464.81 $ 12,567,212.78
27 $733,503.63 $ 572,008.22 $161,495.42 $ 12,405,717.36
28 $733,503.63 $ 564,657.60 $168,846.03 $ 12,236,871.33
29 $733,503.63 $ 556,972.42 $176,531.21 $ 12,060,340.12
30 $733,503.63 $ 548,937.44 $184,566.19 $ 11,875,773.93
31 $733,503.63 $ 540,536.74 $192,966.89 $ 11,682,807.04
32 $733,503.63 $ 531,753.68 $201,749.96 $ 11,481,057.08
33 $733,503.63 $ 522,570.84 $210,932.79 $ 11,270,124.29
34 $733,503.63 $ 512,970.04 $220,533.59 $ 11,049,590.70
35 $733,503.63 $ 502,932.26 $230,571.38 $ 10,819,019.33
36 $733,503.63 $ 492,437.59 $241,066.05 $ 10,577,953.28
37 $733,503.63 $ 481,465.25 $252,038.39 $ 10,325,914.89
38 $733,503.63 $ 469,993.49 $263,510.15 $ 10,062,404.75
39 $733,503.63 $ 457,999.58 $275,504.05 $ 9,786,900.69
40 $733,503.63 $ 445,459.76 $288,043.87 $ 9,498,856.82
41 $733,503.63 $ 432,349.18 $301,154.45 $ 9,197,702.37
42 $733,503.63 $ 418,641.86 $314,861.77 $ 8,882,840.59
 43 $733,503.63 $ 404,310.64 $329,193.00 $ 8,553,647.60
44 $733,503.63 $ 389,327.12 $344,176.52 $ 8,209,471.08
45 $733,503.63 $ 373,661.61 $359,842.03 $ 7,849,629.05
46 $733,503.63 $ 357,283.07 $376,220.57 $ 7,473,408.48
47 $733,503.63 $ 340,159.04 $393,344.59 $ 7,080,063.89
48 $733,503.63 $ 322,255.60 $411,248.03 $ 6,668,815.86
49 $733,503.63 $ 303,537.27 $429,966.36 $ 6,238,849.50
50 $733,503.63 $ 283,966.96 $449,536.68 $ 5,789,312.82
51 $733,503.63 $ 263,505.88 $469,997.75 $ 5,319,315.07
52 $733,503.63 $ 242,113.50 $491,390.13 $ 4,827,924.94
53 $733,503.63 $ 219,747.43 $513,756.20 $ 4,314,168.74
54 $733,503.63 $ 196,363.35 $537,140.29 $ 3,777,028.45
55 $733,503.63 $ 171,914.91 $561,588.72 $ 3,215,439.73
56 $733,503.63 $ 146,353.69 $587,149.94 $ 2,628,289.79
57 $733,503.63 $ 119,629.02 $613,874.61 $ 2,014,415.17
58 $733,503.63 $ 91,687.95 $641,815.68 $ 1,372,599.49
59 $733,503.63 $ 62,475.12 $671,028.51 $ 701,570.99
60 $733,503.63 $ 31,932.65 $701,570.99 $ 0.00
TOTAL $ 29,010,218.00 $ 15,000,000.00
TOTAL A PAG
TASA AÑO INGRESO INVERSION
4.55% 0 $ 15,000,000
1 $ 20,000,000
2 $ 27,000,000
3 $ 36,450,000
4 $ 49,207,500
5 $ 69,430,125

PAGO $8,802,044
 INTERESES DEPRECIACIÓN PAGO OPERARIO COSTO PROD EGRESOS
$ 15,000,000
$ 8,802,044 $ 2,400,000 $ 1,000,000 $ 100,000 $ 12,302,044
$ 8,802,044 $ 2,400,000 $ 1,250,000 $ 115,000 $ 12,567,044
$ 8,802,044 $ 2,400,000 $ 1,562,500 $ 132,250 $ 12,896,794
$ 8,802,044 $ 2,400,000 $ 1,953,125 $ 152,087 $ 13,307,256
$ 8,802,044 $ 2,400,000 $ 2,441,406 $ 174,901 $ 13,818,350
 UTILIDAD INTERESES EGRESOS+INT FN VPE
-$ 15,000,000 $ 15,000,000 -$ 15,000,000 $ 15,000,000
$ 7,697,956 $ 1,770,530 $ 14,072,574 $ 5,927,426 $ 10,424,129
$ 14,432,956 $ 3,319,580 $ 15,886,624 $ 11,113,376 $ 8,716,940
$ 23,553,206 $ 5,417,237 $ 18,314,031 $ 18,135,969 $ 7,443,593
$ 35,900,244 $ 8,257,056 $ 21,564,312 $ 27,643,188 $ 6,492,329
$ 55,611,775 $ 12,790,708 $ 26,609,059 $ 42,821,066 $ 5,934,179
 VPI TASA 25% NSTA A MV
$ - FREC 2 12.50%
$ 14,814,815 TA
$ 14,814,815 14.29% 4.55%
$ 14,814,815 TV
$ 14,814,815
$ 15,483,855
TIO 35%
T INT 23%

VPN $ 20,731,943.79
TIR 79%
TIO 35%
B/C