x $ 16,743,248.

07
30 años Periodos Cuota Interés
0
Tasa de Interés 15% EF 1 $ 2,550,000.00 $ 2,511,487.21
2 $ 2,550,000.00 $ 2,505,710.29
$ 2,550,000.00 Anual 3 $ 2,550,000.00 $ 2,499,066.84
4 $ 2,550,000.00 $ 2,491,426.86
5 $ 2,550,000.00 $ 2,482,640.89
6 $ 2,550,000.00 $ 2,472,537.03
7 $ 2,550,000.00 $ 2,460,917.58
8 $ 2,550,000.00 $ 2,447,555.22
9 $ 2,550,000.00 $ 2,432,188.50
10 $ 2,550,000.00 $ 2,414,516.77
11 $ 2,550,000.00 $ 2,394,194.29
12 $ 2,550,000.00 $ 2,370,823.43
13 $ 2,550,000.00 $ 2,343,946.95
14 $ 2,550,000.00 $ 2,313,038.99
15 $ 2,550,000.00 $ 2,277,494.84
16 $ 2,550,000.00 $ 2,236,619.06
17 $ 2,550,000.00 $ 2,189,611.92
18 $ 2,550,000.00 $ 2,135,553.71
19 $ 2,550,000.00 $ 2,073,386.77
20 $ 2,550,000.00 $ 2,001,894.78
21 $ 2,550,000.00 $ 1,919,679.00
22 $ 2,550,000.00 $ 1,825,130.85
23 $ 2,550,000.00 $ 1,716,400.48
24 $ 2,550,000.00 $ 1,591,360.55
25 $ 2,550,000.00 $ 1,447,564.63
26 $ 2,550,000.00 $ 1,282,199.32
27 $ 2,550,000.00 $ 1,092,029.22
28 $ 2,550,000.00 $ 873,333.61
29 $ 2,550,000.00 $ 621,833.65
30 $ 2,550,000.00 $ 332,608.70
Capital Saldos
$ 16,743,248.07
$ 38,512.79 $ 16,704,735.28
$ 44,289.71 $ 16,660,445.58
$ 50,933.16 $ 16,609,512.41
$ 58,573.14 $ 16,550,939.28
$ 67,359.11 $ 16,483,580.17
$ 77,462.97 $ 16,406,117.19
$ 89,082.42 $ 16,317,034.77
$ 102,444.78 $ 16,214,589.99
$ 117,811.50 $ 16,096,778.49
$ 135,483.23 $ 15,961,295.26
$ 155,805.71 $ 15,805,489.55
$ 179,176.57 $ 15,626,312.98
$ 206,053.05 $ 15,420,259.93
$ 236,961.01 $ 15,183,298.91
$ 272,505.16 $ 14,910,793.75
$ 313,380.94 $ 14,597,412.81
$ 360,388.08 $ 14,237,024.74
$ 414,446.29 $ 13,822,578.45
$ 476,613.23 $ 13,345,965.21
$ 548,105.22 $ 12,797,860.00
$ 630,321.00 $ 12,167,539.00
$ 724,869.15 $ 11,442,669.84
$ 833,599.52 $ 10,609,070.32
$ 958,639.45 $ 9,650,430.87
$ 1,102,435.37 $ 8,547,995.50
$ 1,267,800.68 $ 7,280,194.82
$ 1,457,970.78 $ 5,822,224.05
$ 1,676,666.39 $ 4,145,557.66
$ 1,928,166.35 $ 2,217,391.30
$ 2,217,391.30 $ 0.00
Deuda $ 85,000,000.00
12 Años Periodos Cuota Interés
144 Meses 0
Tasa de interés 18% NM 1 $ 1,444,251.60 $ 1,275,000.00
1.50% EM 2 $ 1,444,251.60 $ 1,272,461.23
3 $ 1,444,251.60 $ 1,269,884.37
Cuota $ 1,444,251.60 4 $ 1,444,251.60 $ 1,267,268.86
5 $ 1,444,251.60 $ 1,264,614.12
6 $ 1,444,251.60 $ 1,261,919.56
Con buscar objetivo, no se hizo nada + 7 $ 1,444,251.60 $ 1,259,184.58
8 $ 1,444,251.60 $ 1,256,408.57
9 $ 1,444,251.60 $ 1,253,590.93
10 $ 1,444,251.60 $ 1,250,731.02
11 $ 1,444,251.60 $ 1,247,828.21
12 $ 1,444,251.60 $ 1,244,881.86
13 $ 1,444,251.60 $ 1,241,891.31
14 $ 1,444,251.60 $ 1,238,855.91
15 $ 1,444,251.60 $ 1,235,774.97
16 $ 1,444,251.60 $ 1,232,647.82
17 $ 1,444,251.60 $ 1,229,473.77
18 $ 1,444,251.60 $ 1,226,252.10
19 $ 1,444,251.60 $ 1,222,982.11
20 $ 1,444,251.60 $ 1,219,663.06
21 $ 1,444,251.60 $ 1,216,294.24
22 $ 1,444,251.60 $ 1,212,874.88
23 $ 1,444,251.60 $ 1,209,404.23
24 $ 1,444,251.60 $ 1,205,881.51
25 $ 1,444,251.60 $ 1,202,305.96
26 $ 1,444,251.60 $ 1,198,676.78
27 $ 1,444,251.60 $ 1,194,993.16
28 $ 1,444,251.60 $ 1,191,254.28
29 $ 1,444,251.60 $ 1,187,459.32
30 $ 1,444,251.60 $ 1,183,607.44
31 $ 1,444,251.60 $ 1,179,697.77
32 $ 1,444,251.60 $ 1,175,729.47
33 $ 1,444,251.60 $ 1,171,701.63
34 $ 1,444,251.60 $ 1,167,613.39
35 $ 1,444,251.60 $ 1,163,463.81
36 $ 1,444,251.60 $ 1,159,252.00
37 $ 1,444,251.60 $ 1,154,977.00
38 $ 1,444,251.60 $ 1,150,637.88
39 $ 1,444,251.60 $ 1,146,233.68
40 $ 1,444,251.60 $ 1,141,763.41
41 $ 1,444,251.60 $ 1,137,226.09
42 $ 1,444,251.60 $ 1,132,620.70
43 $ 1,444,251.60 $ 1,127,946.24
44 $ 1,444,251.60 $ 1,123,201.66
45 $ 1,444,251.60 $ 1,118,385.91
46 $ 1,444,251.60 $ 1,113,497.92
47 $ 1,444,251.60 $ 1,108,536.62
48 $ 1,444,251.60 $ 1,103,500.89
49 $ 1,444,251.60 $ 1,098,389.63
50 $ 1,444,251.60 $ 1,093,201.70
51 $ 1,444,251.60 $ 1,087,935.96
52 $ 1,444,251.60 $ 1,082,591.22
53 $ 1,444,251.60 $ 1,077,166.32
54 $ 1,444,251.60 $ 1,071,660.04
55 $ 1,444,251.60 $ 1,066,071.16
56 $ 1,444,251.60 $ 1,060,398.46
57 $ 1,444,251.60 $ 1,054,640.66
58 $ 1,444,251.60 $ 1,048,796.50
59 $ 1,444,251.60 $ 1,042,864.67
60 $ 1,444,251.60 $ 1,036,843.87
61 $ 1,444,251.60 $ 1,030,732.75
62 $ 1,444,251.60 $ 1,024,529.97
63 $ 1,444,251.60 $ 1,018,234.14
64 $ 1,444,251.60 $ 1,011,843.88
65 $ 1,444,251.60 $ 1,005,357.77
66 $ 1,444,251.60 $ 998,774.36
67 $ 1,444,251.60 $ 992,092.20
68 $ 1,444,251.60 $ 985,309.81
69 $ 1,444,251.60 $ 978,425.68
70 $ 1,444,251.60 $ 971,438.29
71 $ 1,444,251.60 $ 964,346.09
72 $ 1,444,251.60 $ 957,147.51
73 $ 1,444,251.60 $ 949,840.95
74 $ 1,444,251.60 $ 942,424.79
75 $ 1,444,251.60 $ 934,897.39
76 $ 1,444,251.60 $ 927,257.07
77 $ 1,444,251.60 $ 919,502.16
78 $ 1,444,251.60 $ 911,630.92
79 $ 1,444,251.60 $ 903,641.60
80 $ 1,444,251.60 $ 895,532.45
81 $ 1,444,251.60 $ 887,301.67
82 $ 1,444,251.60 $ 878,947.42
83 $ 1,444,251.60 $ 870,467.86
84 $ 1,444,251.60 $ 861,861.10
85 $ 1,444,251.60 $ 853,125.24
86 $ 1,444,251.60 $ 844,258.35
87 $ 1,444,251.60 $ 835,258.45
88 $ 1,444,251.60 $ 826,123.55
89 $ 1,444,251.60 $ 816,851.63
90 $ 1,444,251.60 $ 807,440.63
91 $ 1,444,251.60 $ 797,888.47
92 $ 1,444,251.60 $ 788,193.02
93 $ 1,444,251.60 $ 778,352.14
94 $ 1,444,251.60 $ 768,363.65
95 $ 1,444,251.60 $ 758,225.33
96 $ 1,444,251.60 $ 747,934.94
97 $ 1,444,251.60 $ 737,490.19
98 $ 1,444,251.60 $ 726,888.77
99 $ 1,444,251.60 $ 716,128.32
100 $ 1,444,251.60 $ 705,206.47
101 $ 1,444,251.60 $ 694,120.80
102 $ 1,444,251.60 $ 682,868.83
103 $ 1,444,251.60 $ 671,448.09
104 $ 1,444,251.60 $ 659,856.04
105 $ 1,444,251.60 $ 648,090.11
106 $ 1,444,251.60 $ 636,147.69
107 $ 1,444,251.60 $ 624,026.13
108 $ 1,444,251.60 $ 611,722.74
109 $ 1,444,251.60 $ 599,234.81
110 $ 1,444,251.60 $ 586,559.56
111 $ 1,444,251.60 $ 573,694.18
112 $ 1,444,251.60 $ 560,635.82
113 $ 1,444,251.60 $ 547,381.58
114 $ 1,444,251.60 $ 533,928.53
115 $ 1,444,251.60 $ 520,273.69
116 $ 1,444,251.60 $ 506,414.02
117 $ 1,444,251.60 $ 492,346.45
118 $ 1,444,251.60 $ 478,067.88
119 $ 1,444,251.60 $ 463,575.12
120 $ 1,444,251.60 $ 448,864.97
121 $ 1,444,251.60 $ 433,934.17
122 $ 1,444,251.60 $ 418,779.41
123 $ 1,444,251.60 $ 403,397.33
124 $ 1,444,251.60 $ 387,784.52
125 $ 1,444,251.60 $ 371,937.51
126 $ 1,444,251.60 $ 355,852.80
127 $ 1,444,251.60 $ 339,526.82
128 $ 1,444,251.60 $ 322,955.94
129 $ 1,444,251.60 $ 306,136.51
130 $ 1,444,251.60 $ 289,064.78
131 $ 1,444,251.60 $ 271,736.98
132 $ 1,444,251.60 $ 254,149.26
133 $ 1,444,251.60 $ 236,297.73
134 $ 1,444,251.60 $ 218,178.42
135 $ 1,444,251.60 $ 199,787.32
136 $ 1,444,251.60 $ 181,120.36
137 $ 1,444,251.60 $ 162,173.39
138 $ 1,444,251.60 $ 142,942.22
139 $ 1,444,251.60 $ 123,422.57
140 $ 1,444,251.60 $ 103,610.14
141 $ 1,444,251.60 $ 83,500.52
142 $ 1,444,251.60 $ 63,089.25
143 $ 1,444,251.60 $ 42,371.82
144 $ 1,444,251.60 $ 21,343.62
Capital Saldos
$ 85,000,000.00
$ 169,251.60 $ 84,830,748.40
$ 171,790.37 $ 84,658,958.03
$ 174,367.23 $ 84,484,590.81
$ 176,982.73 $ 84,307,608.08
$ 179,637.47 $ 84,127,970.60
$ 182,332.04 $ 83,945,638.56
$ 185,067.02 $ 83,760,571.55
$ 187,843.02 $ 83,572,728.52
$ 190,660.67 $ 83,382,067.86
$ 193,520.58 $ 83,188,547.28
$ 196,423.39 $ 82,992,123.89
$ 199,369.74 $ 82,792,754.15
$ 202,360.28 $ 82,590,393.87
$ 205,395.69 $ 82,384,998.18
$ 208,476.62 $ 82,176,521.56
$ 211,603.77 $ 81,964,917.79
$ 214,777.83 $ 81,750,139.96
$ 217,999.50 $ 81,532,140.46
$ 221,269.49 $ 81,310,870.97
$ 224,588.53 $ 81,086,282.44
$ 227,957.36 $ 80,858,325.08
$ 231,376.72 $ 80,626,948.36
$ 234,847.37 $ 80,392,100.99
$ 238,370.08 $ 80,153,730.91
$ 241,945.63 $ 79,911,785.28
$ 245,574.82 $ 79,666,210.46
$ 249,258.44 $ 79,416,952.02
$ 252,997.32 $ 79,163,954.71
$ 256,792.28 $ 78,907,162.43
$ 260,644.16 $ 78,646,518.27
$ 264,553.82 $ 78,381,964.45
$ 268,522.13 $ 78,113,442.32
$ 272,549.96 $ 77,840,892.36
$ 276,638.21 $ 77,564,254.15
$ 280,787.78 $ 77,283,466.37
$ 284,999.60 $ 76,998,466.77
$ 289,274.59 $ 76,709,192.17
$ 293,613.71 $ 76,415,578.46
$ 298,017.92 $ 76,117,560.54
$ 302,488.19 $ 75,815,072.35
$ 307,025.51 $ 75,508,046.84
$ 311,630.89 $ 75,196,415.95
$ 316,305.36 $ 74,880,110.59
$ 321,049.94 $ 74,559,060.66
$ 325,865.69 $ 74,233,194.97
$ 330,753.67 $ 73,902,441.30
$ 335,714.98 $ 73,566,726.32
$ 340,750.70 $ 73,225,975.62
$ 345,861.96 $ 72,880,113.66
$ 351,049.89 $ 72,529,063.77
$ 356,315.64 $ 72,172,748.13
$ 361,660.37 $ 71,811,087.76
$ 367,085.28 $ 71,444,002.48
$ 372,591.56 $ 71,071,410.92
$ 378,180.43 $ 70,693,230.49
$ 383,853.14 $ 70,309,377.35
$ 389,610.94 $ 69,919,766.41
$ 395,455.10 $ 69,524,311.31
$ 401,386.93 $ 69,122,924.39
$ 407,407.73 $ 68,715,516.66
$ 413,518.85 $ 68,301,997.81
$ 419,721.63 $ 67,882,276.18
$ 426,017.45 $ 67,456,258.73
$ 432,407.71 $ 67,023,851.01
$ 438,893.83 $ 66,584,957.18
$ 445,477.24 $ 66,139,479.95
$ 452,159.40 $ 65,687,320.55
$ 458,941.79 $ 65,228,378.76
$ 465,825.91 $ 64,762,552.85
$ 472,813.30 $ 64,289,739.54
$ 479,905.50 $ 63,809,834.04
$ 487,104.09 $ 63,322,729.96
$ 494,410.65 $ 62,828,319.31
$ 501,826.81 $ 62,326,492.50
$ 509,354.21 $ 61,817,138.29
$ 516,994.52 $ 61,300,143.77
$ 524,749.44 $ 60,775,394.33
$ 532,620.68 $ 60,242,773.65
$ 540,609.99 $ 59,702,163.66
$ 548,719.14 $ 59,153,444.52
$ 556,949.93 $ 58,596,494.59
$ 565,304.18 $ 58,031,190.42
$ 573,783.74 $ 57,457,406.68
$ 582,390.50 $ 56,875,016.18
$ 591,126.35 $ 56,283,889.83
$ 599,993.25 $ 55,683,896.58
$ 608,993.15 $ 55,074,903.43
$ 618,128.04 $ 54,456,775.39
$ 627,399.96 $ 53,829,375.42
$ 636,810.96 $ 53,192,564.46
 $ 646,363.13 $ 52,546,201.33
$ 656,058.58 $ 51,890,142.75
$ 665,899.45 $ 51,224,243.30
$ 675,887.95 $ 50,548,355.35
$ 686,026.27 $ 49,862,329.09
$ 696,316.66 $ 49,166,012.43
$ 706,761.41 $ 48,459,251.02
$ 717,362.83 $ 47,741,888.19
$ 728,123.27 $ 47,013,764.92
$ 739,045.12 $ 46,274,719.79
$ 750,130.80 $ 45,524,588.99
$ 761,382.76 $ 44,763,206.23
$ 772,803.50 $ 43,990,402.73
$ 784,395.55 $ 43,206,007.18
$ 796,161.49 $ 42,409,845.69
$ 808,103.91 $ 41,601,741.78
$ 820,225.47 $ 40,781,516.31
$ 832,528.85 $ 39,948,987.46
$ 845,016.78 $ 39,103,970.67
$ 857,692.04 $ 38,246,278.64
$ 870,557.42 $ 37,375,721.22
$ 883,615.78 $ 36,492,105.44
$ 896,870.01 $ 35,595,235.43
$ 910,323.06 $ 34,684,912.37
$ 923,977.91 $ 33,760,934.46
$ 937,837.58 $ 32,823,096.88
$ 951,905.14 $ 31,871,191.73
$ 966,183.72 $ 30,905,008.01
$ 980,676.48 $ 29,924,331.54
$ 995,386.62 $ 28,928,944.92
$ 1,010,317.42 $ 27,918,627.49
$ 1,025,472.18 $ 26,893,155.31
$ 1,040,854.27 $ 25,852,301.04
$ 1,056,467.08 $ 24,795,833.96
$ 1,072,314.09 $ 23,723,519.88
$ 1,088,398.80 $ 22,635,121.08
$ 1,104,724.78 $ 21,530,396.30
$ 1,121,295.65 $ 20,409,100.65
$ 1,138,115.09 $ 19,270,985.56
$ 1,155,186.81 $ 18,115,798.75
$ 1,172,514.61 $ 16,943,284.14
$ 1,190,102.33 $ 15,753,181.80
$ 1,207,953.87 $ 14,545,227.93
$ 1,226,073.18 $ 13,319,154.76
$ 1,244,464.27 $ 12,074,690.48
$ 1,263,131.24 $ 10,811,559.24
$ 1,282,078.21 $ 9,529,481.04
$ 1,301,309.38 $ 8,228,171.66
$ 1,320,829.02 $ 6,907,342.63
$ 1,340,641.46 $ 5,566,701.18
$ 1,360,751.08 $ 4,205,950.10
$ 1,381,162.34 $ 2,824,787.76
$ 1,401,879.78 $ 1,422,907.98
$ 1,422,907.98 $ 0.00
Deuda x
10 Años Periodos Cuota Interés
40 trimestres 0
20 Semestres 1 $ 1,800,000.00 $ 0.00
Tasa de interés 14% NS 2 $ 1,800,000.00 $ 61,934.48
7.00% ES 3 $ 1,800,000.00 $ 126,000.00
3.44% ET 4 $ 1,800,000.00 $ 192,269.89
Cuota $ 1,800,000.00 Trimest 5 $ 1,800,000.00 $ 260,820.00
$ 3,600,000.00 Semestral 6 $ 1,800,000.00 $ 331,728.78
7 $ 1,800,000.00 $ 405,077.40
8 $ 1,800,000.00 $ 480,949.80
9 $ 1,800,000.00 $ 559,432.82
10 $ 1,800,000.00 $ 640,616.28
11 $ 1,800,000.00 $ 724,593.12
12 $ 1,800,000.00 $ 811,459.42
Cambio las tasas y trabajo en trimestres 13 $ 1,800,000.00 $ 901,314.63
Luego cambio la fórmula a + (cap, sald) pq 14 $ 1,800,000.00 $ 994,261.58
son ingresos, empiezo con 0 y termino con 15 $ 1,800,000.00 $ 1,090,406.66
un valor 16 $ 1,800,000.00 $ 1,189,859.90
17 $ 1,800,000.00 $ 1,292,735.12
18 $ 1,800,000.00 $ 1,399,150.09
19 $ 1,800,000.00 $ 1,509,226.58
20 $ 1,800,000.00 $ 1,623,090.59
21 $ 1,800,000.00 $ 1,740,872.44
22 $ 1,800,000.00 $ 1,862,706.94
23 $ 1,800,000.00 $ 1,988,733.51
24 $ 1,800,000.00 $ 2,119,096.42
25 $ 1,800,000.00 $ 2,253,944.86
26 $ 1,800,000.00 $ 2,393,433.17
27 $ 1,800,000.00 $ 2,537,721.00
28 $ 1,800,000.00 $ 2,686,973.49
29 $ 1,800,000.00 $ 2,841,361.47
30 $ 1,800,000.00 $ 3,001,061.64
31 $ 1,800,000.00 $ 3,166,256.77
32 $ 1,800,000.00 $ 3,337,135.95
33 $ 1,800,000.00 $ 3,513,894.75
34 $ 1,800,000.00 $ 3,696,735.47
35 $ 1,800,000.00 $ 3,885,867.38
36 $ 1,800,000.00 $ 4,081,506.95
37 $ 1,800,000.00 $ 4,283,878.10
38 $ 1,800,000.00 $ 4,493,212.44
39 $ 1,800,000.00 $ 4,709,749.56
40 $ 1,800,000.00 $ 4,933,737.31
 Capital Saldos
$ 0.00
$ 1,800,000.00 $ 1,800,000.00
$ 1,861,934.48 $ 3,661,934.48
$ 1,926,000.00 $ 5,587,934.48
$ 1,992,269.89 $ 7,580,204.37
$ 2,060,820.00 $ 9,641,024.37
$ 2,131,728.78 $ 11,772,753.15
$ 2,205,077.40 $ 13,977,830.55
$ 2,280,949.80 $ 16,258,780.35
$ 2,359,432.82 $ 18,618,213.17
$ 2,440,616.28 $ 21,058,829.45
$ 2,524,593.12 $ 23,583,422.57
$ 2,611,459.42 $ 26,194,881.99
$ 2,701,314.63 $ 28,896,196.63
$ 2,794,261.58 $ 31,690,458.21
$ 2,890,406.66 $ 34,580,864.87
$ 2,989,859.90 $ 37,570,724.76
$ 3,092,735.12 $ 40,663,459.89
$ 3,199,150.09 $ 43,862,609.98
$ 3,309,226.58 $ 47,171,836.56
$ 3,423,090.59 $ 50,594,927.15
$ 3,540,872.44 $ 54,135,799.59
$ 3,662,706.94 $ 57,798,506.53
$ 3,788,733.51 $ 61,587,240.04
$ 3,919,096.42 $ 65,506,336.47
$ 4,053,944.86 $ 69,560,281.33
$ 4,193,433.17 $ 73,753,714.50
$ 4,337,721.00 $ 78,091,435.50
$ 4,486,973.49 $ 82,578,408.99
$ 4,641,361.47 $ 87,219,770.46
$ 4,801,061.64 $ 92,020,832.10
$ 4,966,256.77 $ 96,987,088.87
$ 5,137,135.95 $ 102,124,224.82
$ 5,313,894.75 $ 107,438,119.57
$ 5,496,735.47 $ 112,934,855.04
$ 5,685,867.38 $ 118,620,722.41
$ 5,881,506.95 $ 124,502,229.37
$ 6,083,878.10 $ 130,586,107.46
$ 6,293,212.44 $ 136,879,319.90
$ 6,509,749.56 $ 143,389,069.46
$ 6,733,737.31 $ 150,122,806.77
Deuda $ 35,000,000.00
18 Meses Periodos Cuota Interés
0
Tasa de interés 20% EA 1 $ 2,239,403.20 $ 535,831.47
1.53% ET 2 $ 2,239,403.20 $ 509,750.69
Cuota 3 $ 2,239,403.20 $ 483,270.62
4 $ 2,239,403.20 $ 456,385.16
5 $ 2,239,403.20 $ 429,088.10
6 $ 2,239,403.20 $ 401,373.13
Se cambia la tasa, luego normal con 7 $ 2,239,403.20 $ 373,233.87
buscar objetivo, importante entender 8 $ 2,239,403.20 $ 344,663.80
que pagaba el saldo anterior + interés 9 $ 2,239,403.20 $ 315,656.35
10 $ 2,239,403.20 $ 286,204.80
11 $ 2,239,403.20 $ 256,302.37
12 $ 2,239,403.20 $ 225,942.14
13 $ 2,239,403.20 $ 195,117.12
14 $ 2,239,403.20 $ 163,820.18
15 $ 2,239,403.20 $ 132,044.11
16 $ 2,239,403.20 $ 99,781.55
17 $ 2,239,403.20 $ 67,025.08
18 $ 2,239,403.20 $ 33,767.12
 Capital Saldos
$ 35,000,000.00
$ 1,703,571.74 $ 33,296,428.26
$ 1,729,652.52 $ 31,566,775.75
$ 1,756,132.58 $ 29,810,643.17
$ 1,783,018.04 $ 28,027,625.12
$ 1,810,315.10 $ 26,217,310.02
$ 1,838,030.07 $ 24,379,279.95
$ 1,866,169.34 $ 22,513,110.62
$ 1,894,739.40 $ 20,618,371.22
$ 1,923,746.86 $ 18,694,624.36
$ 1,953,198.40 $ 16,741,425.95
$ 1,983,100.84 $ 14,758,325.12
$ 2,013,461.06 $ 12,744,864.06 $ 12,939,981.18 En el mes trece, debía pagar el Saldo que tenía + los intereses de ese m
$ 2,044,286.08 $ 10,700,577.97
$ 2,075,583.02 $ 8,624,994.95
$ 2,107,359.10 $ 6,517,635.86
$ 2,139,621.65 $ 4,378,014.21
$ 2,172,378.12 $ 2,205,636.08
$ 2,205,636.08 $ 0.00
ía + los intereses de ese mes
Deuda $ 48,000,000.00 Periodos Cuota
16% EA
Tasa Interés 1.24% EM 0 $ 9,600,000.00
Plazo 36 Meses 1 $ 947,365.15
Pago extra programado $ 5,000,000.00 6 meses 2 $ 947,365.15
Valor presente del pago ex $ 4,642,383.45 3 $ 947,365.15
Pago extra 2 $ 8,000,000.00 18 meses 4 $ 947,365.15
$ 6,403,287.52 5 $ 947,365.15
6 $ 5,947,365.15
Cuota fija $ 947,365.15 7 $ 947,365.15
Couta inicial $ 9,600,000.00 8 $ 947,365.15
9 $ 947,365.15
Deuda - Pago extra $ 27,354,329.02 10 $ 947,365.15
11 $ 947,365.15
12 $ 947,365.15
13 $ 947,365.15
14 $ 947,365.15
15 $ 947,365.15
1. Se descontó el primer pago del 20% 16 $ 947,365.15
2. Se cambió la tasa de interés 17 $ 947,365.15
3. Se hizo lo de siempre 18 $ 8,947,365.15
4. Se sumaron los pagos extras en los meses indicados 19 $ 947,365.15
5. Con buscar objetivo, hallo la cuota 20 $ 947,365.15
21 $ 947,365.15
22 $ 947,365.15
23 $ 947,365.15
24 $ 947,365.15
25 $ 947,365.15
26 $ 947,365.15
27 $ 947,365.15
28 $ 947,365.15
29 $ 947,365.15
30 $ 947,365.15
31 $ 947,365.15
32 $ 947,365.15
33 $ 947,365.15
34 $ 947,365.15
35 $ 947,365.15
36 $ 947,365.15

Esta tabla se hace teniendo la cuota inicial no

meses pactados
 Interés Capital Saldos Periodos Cuota

$ 38,400,000.00 0 $ 9,600,000.00
$ 477,893.30 $ 469,471.85 $ 37,930,528.15 1 $ 1,329,910.95
$ 472,050.65 $ 475,314.50 $ 37,455,213.65 2 $ 1,329,910.95
$ 466,135.30 $ 481,229.85 $ 36,973,983.80 3 $ 1,329,910.95
$ 460,146.33 $ 487,218.82 $ 36,486,764.97 4 $ 1,329,910.95
$ 454,082.82 $ 493,282.33 $ 35,993,482.64 5 $ 1,329,910.95
$ 447,943.86 $ 5,499,421.30 $ 30,494,061.35 6 $ 1,329,910.95
$ 379,502.80 $ 567,862.35 $ 29,926,199.00 7 $ 1,329,910.95
$ 372,435.67 $ 574,929.48 $ 29,351,269.52 8 $ 1,329,910.95
$ 365,280.60 $ 582,084.55 $ 28,769,184.97 9 $ 1,329,910.95
$ 358,036.47 $ 589,328.68 $ 28,179,856.29 10 $ 1,329,910.95
$ 350,702.20 $ 596,662.95 $ 27,583,193.34 11 $ 1,329,910.95
$ 343,276.65 $ 604,088.51 $ 26,979,104.83 12 $ 1,329,910.95
$ 335,758.68 $ 611,606.47 $ 26,367,498.36 13 $ 1,329,910.95
$ 328,147.15 $ 619,218.00 $ 25,748,280.36 14 $ 1,329,910.95
$ 320,440.90 $ 626,924.25 $ 25,121,356.11 15 $ 1,329,910.95
$ 312,638.74 $ 634,726.41 $ 24,486,629.70 16 $ 1,329,910.95
$ 304,739.48 $ 642,625.67 $ 23,844,004.04 17 $ 1,329,910.95
$ 296,741.92 $ 8,650,623.23 $ 15,193,380.80 18 $ 1,329,910.95
$ 189,083.72 $ 758,281.43 $ 14,435,099.37 19 $ 1,329,910.95
$ 179,646.80 $ 767,718.35 $ 13,667,381.02 20 $ 1,329,910.95
$ 170,092.44 $ 777,272.71 $ 12,890,108.32 21 $ 1,329,910.95
$ 160,419.18 $ 786,945.98 $ 12,103,162.34 22 $ 1,329,910.95
$ 150,625.52 $ 796,739.63 $ 11,306,422.71 23 $ 1,329,910.95
$ 140,709.99 $ 806,655.16 $ 10,499,767.55 24 $ 1,329,910.95
$ 130,671.06 $ 816,694.10 $ 9,683,073.46 25 $ 1,329,910.95
$ 120,507.18 $ 826,857.97 $ 8,856,215.49 26 $ 1,329,910.95
$ 110,216.82 $ 837,148.33 $ 8,019,067.16 27 $ 1,329,910.95
$ 99,798.40 $ 847,566.75 $ 7,171,500.41 28 $ 1,329,910.95
$ 89,250.31 $ 858,114.84 $ 6,313,385.57 29 $ 1,329,910.95
$ 78,570.95 $ 868,794.20 $ 5,444,591.37 30 $ 1,329,910.95
$ 67,758.69 $ 879,606.46 $ 4,564,984.91 31 $ 1,329,910.95
$ 56,811.87 $ 890,553.28 $ 3,674,431.63 32 $ 1,329,910.95
$ 45,728.81 $ 901,636.34 $ 2,772,795.28 33 $ 1,329,910.95
$ 34,507.82 $ 912,857.33 $ 1,859,937.95 34 $ 1,329,910.95
$ 23,147.18 $ 924,217.97 $ 935,719.99 35 $ 1,329,910.95
$ 11,645.16 $ 935,719.99 $ 0.00 36 $ 1,329,910.95

teniendo la cuota inicial normal y poniendo los pagos extras en los Esta tabla es para saber cual era la cuota inicial, sin tener en
Solo se pone el primer pago, que es del 20%
 Interés Capital Saldos Periodos Cuota

$ 38,400,000.00 0 $ 9,600,000.00
$ 477,893.30 $ 852,017.66 $ 37,547,982.34 1 $ 947,365.15
$ 467,289.82 $ 862,621.13 $ 36,685,361.21 2 $ 947,365.15
$ 456,554.38 $ 873,356.57 $ 35,812,004.63 3 $ 947,365.15
$ 445,685.34 $ 884,225.62 $ 34,927,779.02 4 $ 947,365.15
$ 434,681.03 $ 895,229.93 $ 34,032,549.09 5 $ 947,365.15
$ 423,539.77 $ 906,371.19 $ 33,126,177.90 6 $ 947,365.15
$ 412,259.85 $ 917,651.10 $ 32,208,526.80 7 $ 947,365.15
$ 400,839.56 $ 929,071.40 $ 31,279,455.41 8 $ 947,365.15
$ 389,277.14 $ 940,633.82 $ 30,338,821.59 9 $ 947,365.15
$ 377,570.82 $ 952,340.13 $ 29,386,481.45 10 $ 947,365.15
$ 365,718.81 $ 964,192.14 $ 28,422,289.32 11 $ 947,365.15
$ 353,719.31 $ 976,191.64 $ 27,446,097.67 12 $ 947,365.15
$ 341,570.47 $ 988,340.48 $ 26,457,757.19 13 $ 947,365.15
$ 329,270.44 $ 1,000,640.52 $ 25,457,116.67 14 $ 947,365.15
$ 316,817.33 $ 1,013,093.63 $ 24,444,023.05 15 $ 947,365.15
$ 304,209.24 $ 1,025,701.72 $ 23,418,321.33 16 $ 947,365.15
$ 291,444.24 $ 1,038,466.71 $ 22,379,854.62 17 $ 947,365.15
$ 278,520.38 $ 1,051,390.58 $ 21,328,464.04 18 $ 947,365.15
$ 265,435.68 $ 1,064,475.28 $ 20,263,988.76 19 $ 947,365.15
$ 252,188.13 $ 1,077,722.82 $ 19,186,265.94 20 $ 947,365.15
$ 238,775.73 $ 1,091,135.23 $ 18,095,130.72 21 $ 947,365.15
$ 225,196.40 $ 1,104,714.56 $ 16,990,416.16 22 $ 947,365.15
$ 211,448.07 $ 1,118,462.88 $ 15,871,953.28 23 $ 947,365.15
$ 197,528.65 $ 1,132,382.31 $ 14,739,570.97 24 $ 947,365.15
$ 183,435.99 $ 1,146,474.96 $ 13,593,096.01 25 $ 947,365.15
$ 169,167.95 $ 1,160,743.00 $ 12,432,353.01 26 $ 947,365.15
$ 154,722.35 $ 1,175,188.61 $ 11,257,164.41 27 $ 947,365.15
$ 140,096.96 $ 1,189,813.99 $ 10,067,350.42 28 $ 947,365.15
$ 125,289.56 $ 1,204,621.39 $ 8,862,729.03 29 $ 947,365.15
$ 110,297.89 $ 1,219,613.07 $ 7,643,115.96 30 $ 947,365.15
$ 95,119.63 $ 1,234,791.32 $ 6,408,324.64 31 $ 947,365.15
$ 79,752.48 $ 1,250,158.47 $ 5,158,166.17 32 $ 947,365.15
$ 64,194.09 $ 1,265,716.86 $ 3,892,449.30 33 $ 947,365.15
$ 48,442.07 $ 1,281,468.89 $ 2,610,980.42 34 $ 947,365.15
$ 32,494.01 $ 1,297,416.94 $ 1,313,563.48 35 $ 947,365.15
$ 16,347.48 $ 1,313,563.48 $ 0.00 36 $ 947,365.15

er cual era la cuota inicial, sin tener en cuenta los pagos extra Esta tabla es para demostar que yo puedo también alte
pago, que es del 20% los pagos extras, y restarselo y ya hacerla normal, da lo
 Interés Capital Saldos

$ 27,354,329.02
$ 340,428.40 $ 606,936.75 $ 26,747,392.27
$ 332,874.99 $ 614,490.17 $ 26,132,902.10
$ 325,227.57 $ 622,137.58 $ 25,510,764.52
$ 317,484.98 $ 629,880.17 $ 24,880,884.36
$ 309,646.04 $ 637,719.11 $ 24,243,165.24
$ 301,709.54 $ 645,655.62 $ 23,597,509.63
$ 293,674.26 $ 653,690.89 $ 22,943,818.74
$ 285,538.99 $ 661,826.16 $ 22,281,992.57
$ 277,302.47 $ 670,062.68 $ 21,611,929.89
$ 268,963.45 $ 678,401.70 $ 20,933,528.19
$ 260,520.65 $ 686,844.51 $ 20,246,683.68
$ 251,972.77 $ 695,392.38 $ 19,551,291.30
$ 243,318.52 $ 704,046.63 $ 18,847,244.67
$ 234,556.56 $ 712,808.59 $ 18,134,436.08
$ 225,685.56 $ 721,679.59 $ 17,412,756.49
$ 216,704.16 $ 730,661.00 $ 16,682,095.49
$ 207,610.98 $ 739,754.17 $ 15,942,341.32
$ 198,404.64 $ 748,960.51 $ 15,193,380.80
$ 189,083.72 $ 758,281.43 $ 14,435,099.37
$ 179,646.80 $ 767,718.35 $ 13,667,381.02
$ 170,092.44 $ 777,272.71 $ 12,890,108.32
$ 160,419.18 $ 786,945.98 $ 12,103,162.34
$ 150,625.52 $ 796,739.63 $ 11,306,422.71
$ 140,709.99 $ 806,655.16 $ 10,499,767.55
$ 130,671.06 $ 816,694.10 $ 9,683,073.46
$ 120,507.18 $ 826,857.97 $ 8,856,215.49
$ 110,216.82 $ 837,148.33 $ 8,019,067.16
$ 99,798.40 $ 847,566.75 $ 7,171,500.41
$ 89,250.31 $ 858,114.84 $ 6,313,385.57
$ 78,570.95 $ 868,794.20 $ 5,444,591.37
$ 67,758.69 $ 879,606.46 $ 4,564,984.91
$ 56,811.87 $ 890,553.28 $ 3,674,431.63
$ 45,728.81 $ 901,636.34 $ 2,772,795.28
$ 34,507.82 $ 912,857.33 $ 1,859,937.95
$ 23,147.18 $ 924,217.97 $ 935,719.99
$ 11,645.16 $ 935,719.99 $ 0.00

emostar que yo puedo también alterar la cuota inicial con los valores presentes de
estarselo y ya hacerla normal, da lo mismo
Deuda $ 15,000,000.00
2 Años Periodos Cuota Interés
24 Meses 0
1 $ 706,102.08 ###
Tasa de interés 1.00% EM 2 $ 706,102.08 ###
3 $ 706,102.08 ###
Cuota $ 706,102.08 4 $ 706,102.08 ###
5 $ 706,102.08 ###
$ 706,102.08 Cuota con pago Excel 6 $ 706,102.08 ###
7 $ 706,102.08 ###
8 $ 706,102.08 ###
1. Con buscar objetivo halle la cuota 9 $ 2,782,737.87 ###
2. Puse en el mes 10, 11 y 12 valor 0 10 $ 0.00 $ 77,135.07
3. Actualicé la casilla 13 igual a la 8, para 11 $ 0.00 $ 77,906.42
que me saliera la misma cuota de arriba 12 $ 0.00 $ 78,685.48
4. Pongo un valor x en la casilla 9 13 $ 706,102.08 $ 79,472.34
5. Con buscar objetivo, hallo ese valor 14 $ 706,102.08 $ 73,206.04
15 $ 706,102.08 $ 66,877.08
16 $ 706,102.08 $ 60,484.83
17 $ 706,102.08 $ 54,028.66
18 $ 706,102.08 $ 47,507.92
19 $ 706,102.08 $ 40,921.98
20 $ 706,102.08 $ 34,270.18
21 $ 706,102.08 $ 27,551.86
22 $ 706,102.08 $ 20,766.36
23 $ 706,102.08 $ 13,913.00
24 $ 706,102.08 $ 6,991.11
 Capital Saldos
$ 15,000,000.00
$ 556,102.08 $ 14,443,897.92
$ 561,663.10 $ 13,882,234.81
$ 567,279.74 $ 13,314,955.08
$ 572,952.53 $ 12,742,002.54
$ 578,682.06 $ 12,163,320.49
$ 584,468.88 $ 11,578,851.61
$ 590,313.57 $ 10,988,538.04
$ 596,216.70 $ 10,392,321.34
$ 2,678,814.65 $ 7,713,506.69
-$ 77,135.07 $ 7,790,641.75
-$ 77,906.42 $ 7,868,548.17
-$ 78,685.48 $ 7,947,233.65
$ 626,629.75 $ 7,320,603.91
$ 632,896.04 $ 6,687,707.86
$ 639,225.00 $ 6,048,482.86
$ 645,617.25 $ 5,402,865.60
$ 652,073.43 $ 4,750,792.17
$ 658,594.16 $ 4,092,198.01
$ 665,180.10 $ 3,427,017.91
$ 671,831.90 $ 2,755,186.01
$ 678,550.22 $ 2,076,635.78
$ 685,335.73 $ 1,391,300.06
$ 692,189.08 $ 699,110.97
$ 699,110.97 $ 0.00

$ 2,678,814.65
Deuda $ 12,852,661.77 Periodos
Tasa Interés 1.00% EM 0
Plazo 24 Meses 1
Periodo de gracia 7 Meses 2
$ 832,000.00 3
4
5
6
7
8
9
10
11
Cuota nueva en el mes 7 $ 12,947,793.05 12
13
14
15
16
17
18
19
20
21
22
23
24
Cuota Interés Capital Saldos
$ 12,852,661.77
$ 0.00 $ 128,526.62 -$ 128,526.62 $ 12,981,188.39
$ 0.00 $ 129,811.88 -$ 129,811.88 $ 13,111,000.27
$ 0.00 $ 131,110.00 -$ 131,110.00 $ 13,242,110.28
$ 0.00 $ 132,421.10 -$ 132,421.10 $ 13,374,531.38
$ 0.00 $ 133,745.31 -$ 133,745.31 $ 13,508,276.69
$ 0.00 $ 135,082.77 -$ 135,082.77 $ 13,643,359.46
$ 832,000.00 $ 136,433.59 $ 695,566.41 $ 12,947,793.05
$ 832,000.00 $ 129,477.93 $ 702,522.07 $ 12,245,270.98
$ 832,000.00 $ 122,452.71 $ 709,547.29 $ 11,535,723.69
$ 832,000.00 $ 115,357.24 $ 716,642.76 $ 10,819,080.93
$ 832,000.00 $ 108,190.81 $ 723,809.19 $ 10,095,271.74
$ 832,000.00 $ 100,952.72 $ 731,047.28 $ 9,364,224.46
$ 832,000.00 $ 93,642.24 $ 738,357.76 $ 8,625,866.70
$ 832,000.00 $ 86,258.67 $ 745,741.33 $ 7,880,125.37
$ 832,000.00 $ 78,801.25 $ 753,198.75 $ 7,126,926.62
$ 832,000.00 $ 71,269.27 $ 760,730.73 $ 6,366,195.89
$ 832,000.00 $ 63,661.96 $ 768,338.04 $ 5,597,857.85
$ 832,000.00 $ 55,978.58 $ 776,021.42 $ 4,821,836.43
$ 832,000.00 $ 48,218.36 $ 783,781.64 $ 4,038,054.79
$ 832,000.00 $ 40,380.55 $ 791,619.45 $ 3,246,435.34
$ 832,000.00 $ 32,464.35 $ 799,535.65 $ 2,446,899.69
$ 832,000.00 $ 24,469.00 $ 807,531.00 $ 1,639,368.69
$ 832,000.00 $ 16,393.69 $ 815,606.31 $ 823,762.38
$ 832,000.00 $ 8,237.62 $ 823,762.38 $ 0.00
 $ 20,000,000.00 Hoy
Periodos Cuota
$ 25,000,000.00 2 años 0 $ 20,000,000.00
1
$ 2,500,000.00 7 años 2 $ 25,000,000.00
3
4 $ 2,500,000.00
5 $ 2,500,000.00
Tasa 13% NSA 6 $ 2,500,000.00
6.50% ESA 7 $ 2,500,000.00
6.95% ES 8 $ 2,500,000.00
14.4% EA 9 $ 2,500,000.00
10 $ 2,500,000.00
11 $ 0.00
12 $ 0.00
 Interés Capital Saldos
$ 20,000,000.00
$ 2,877,405.70 $ 2,877,405.70 $ 22,877,405.70
$ 3,291,378.88 $ 28,291,378.88 $ 51,168,784.58
$ 7,361,667.63 $ 7,361,667.63 $ 58,530,452.21
$ 8,420,792.85 $ 10,920,792.85 $ 69,451,245.06
$ 9,991,970.43 $ 12,491,970.43 $ 81,943,215.48
$ 11,789,193.77 $ 14,289,193.77 $ 96,232,409.26
$ 13,844,984.16 $ 16,344,984.16 $ 112,577,393.42
$ 16,196,541.69 $ 18,696,541.69 $ 131,273,935.10
$ 18,886,418.47 $ 21,386,418.47 $ 152,660,353.57
$ 21,963,288.59 $ 24,463,288.59 $ 177,123,642.17
$ 25,482,828.90 $ 25,482,828.90 $ 202,606,471.07
$ 29,149,050.76 $ 29,149,050.76 $ 231,755,521.82
 Deuda $ 7,200,000.00 Periodos Cuota
25% $ 1,800,000.00 0 $ 1,800,000.00
1 $ 0.00
Tasa 1 17.40% NM 2 $ 0.00
1.45% EM 3 $ 0.00
Tasa 2 19.80% NM 4 $ 0.00
1.65% EM 5 $ 0.00
Tasa 1 6 $ 430,851.10
Tasa 2 7 $ 430,851.10
8 $ 430,851.10
9 $ 430,851.10
10 $ 430,851.10
1. Convierto tasas a NM 11 $ 430,851.10
2. Le resto la primera cuota al primer saldo 12 $ 430,851.10
3. Pongo que los primeros meses no pago (0) 13 $ 430,851.10
4. En el mes 6 pongo un valor x 14 $ 430,851.10
5. Cambie los intereses desde el mes 7, y me aseguro 15 $ 430,851.10
que se halla cambiado en todos los siguientes 16 $ 430,851.10
6. Pongo el último pago de 1500000 17 $ 430,851.10
7. Con buscar objetivo, hallo la cuota 18 $ 0.00
19 $ 0.00
20 $ 0.00
21 $ 0.00
22 $ 1,500,000.00
Interés Capital Saldos
$ 5,400,000.00
$ 78,300.00 -$ 78,300.00 $ 5,478,300.00
$ 79,435.35 -$ 79,435.35 $ 5,557,735.35
$ 80,587.16 -$ 80,587.16 $ 5,638,322.51
$ 81,755.68 -$ 81,755.68 $ 5,720,078.19
$ 82,941.13 -$ 82,941.13 $ 5,803,019.32
$ 84,143.78 $ 346,707.32 $ 5,456,312.00
$ 90,029.15 $ 340,821.95 $ 5,115,490.05
$ 84,405.59 $ 346,445.52 $ 4,769,044.53
$ 78,689.23 $ 352,161.87 $ 4,416,882.67
$ 72,878.56 $ 357,972.54 $ 4,058,910.13
$ 66,972.02 $ 363,879.08 $ 3,695,031.05
$ 60,968.01 $ 369,883.09 $ 3,325,147.96
$ 54,864.94 $ 375,986.16 $ 2,949,161.80
$ 48,661.17 $ 382,189.93 $ 2,566,971.87
$ 42,355.04 $ 388,496.07 $ 2,178,475.80
$ 35,944.85 $ 394,906.25 $ 1,783,569.55
$ 29,428.90 $ 401,422.20 $ 1,382,147.35
$ 22,805.43 -$ 22,805.43 $ 1,404,952.78
$ 23,181.72 -$ 23,181.72 $ 1,428,134.50
$ 23,564.22 -$ 23,564.22 $ 1,451,698.72
$ 23,953.03 -$ 23,953.03 $ 1,475,651.75
$ 24,348.25 $ 1,475,651.75 $ 0.00
 Inversión $ 25,000.00 Periodos Cuota Interés
12% EA 0
10 años 1 $ 12,000.00 $ 3,000.00
2 $ 12,000.00 $ 4,800.00
3 $ 12,000.00 $ 6,816.00
Mes 7 18000 4 $ 12,000.00 $ 9,073.92
Mes 8 No paga 5 $ 12,000.00 $ 11,602.79
Mes 9 Retira 50 6 $ 12,000.00 $ 14,435.13
Mes 10 Retira 150 7 $ 18,000.00 $ 17,607.34
8 $ 0.00 $ 21,880.22
9 -$ 50,000.00 $ 24,505.85
10 -$ 150,000.00 $ 21,446.55
 Capital Saldos
$ 25,000.00
$ 15,000.00 $ 40,000.00
$ 16,800.00 $ 56,800.00
$ 18,816.00 $ 75,616.00
$ 21,073.92 $ 96,689.92
$ 23,602.79 $ 120,292.71
$ 26,435.13 $ 146,727.84
$ 35,607.34 $ 182,335.18
$ 21,880.22 $ 204,215.40
-$ 25,494.15 $ 178,721.24
-$ 128,553.45 $ 50,167.79
 Deuda $ 85,000,000.00 Periodos Cuota
0
1 $ 1,125,766.07
Tasa 1 12.00% NM 2 $ 1,125,766.07
1.00% EM 3 $ 1,125,766.07
Tasa 2 18.00% NM 4 $ 1,125,766.07
1.50% EM 5 $ 1,125,766.07
6 $ 1,125,766.07
Años Meses 7 $ 1,125,766.07
5 60 8 $ 1,125,766.07
9 $ 1,125,766.07
10 $ 1,125,766.07
11 $ 1,125,766.07
12 $ 1,125,766.07
13 $ 1,125,766.07
14 $ 1,125,766.07
15 $ 1,125,766.07
16 $ 1,125,766.07
17 $ 1,125,766.07
18 $ 1,125,766.07
19 $ 1,125,766.07
20 $ 1,125,766.07
21 $ 1,125,766.07
22 $ 1,125,766.07
23 $ 1,125,766.07
24 $ 1,125,766.07
25 $ 1,125,766.07
26 $ 1,125,766.07
27 $ 1,125,766.07
28 $ 1,125,766.07
29 $ 1,125,766.07
30 $ 1,125,766.07
31 $ 1,125,766.07
32 $ 1,125,766.07
33 $ 1,125,766.07
34 $ 1,125,766.07
35 $ 1,125,766.07
36 $ 1,125,766.07
37 $ 1,125,766.07
38 $ 1,125,766.07
39 $ 1,125,766.07
40 $ 1,125,766.07
41 $ 1,125,766.07
42 $ 1,125,766.07
43 $ 1,125,766.07
44 $ 1,125,766.07
 45 $ 1,125,766.07
46 $ 1,125,766.07
47 $ 1,125,766.07
48 $ 1,125,766.07
49 $ 1,125,766.07
50 $ 1,125,766.07
51 $ 1,125,766.07
52 $ 1,125,766.07
53 $ 1,125,766.07
54 $ 1,125,766.07
55 $ 1,125,766.07
56 $ 1,125,766.07
57 $ 1,125,766.07
58 $ 1,125,766.07
59 $ 1,125,766.07
Cual es el saldo en el mes 60- 5 años 60 $ 1,125,766.07
61 $ 1,125,766.07
62 $ 1,125,766.07
63 $ 1,125,766.07
64 $ 1,125,766.07
65 $ 1,125,766.07
66 $ 1,125,766.07
67 $ 1,125,766.07
68 $ 1,125,766.07
69 $ 1,125,766.07
70 $ 1,125,766.07
71 $ 1,125,766.07
72 $ 1,125,766.07
73 $ 1,125,766.07
74 $ 1,125,766.07
75 $ 1,125,766.07
76 $ 1,125,766.07
77 $ 1,125,766.07
78 $ 1,125,766.07
79 $ 1,125,766.07
80 $ 1,125,766.07
81 $ 1,125,766.07
82 $ 1,125,766.07
83 $ 1,125,766.07
84 $ 1,125,766.07
85 $ 1,125,766.07
86 $ 1,125,766.07
87 $ 1,125,766.07
88 $ 1,125,766.07
89 $ 1,125,766.07
90 $ 1,125,766.07
91 $ 1,125,766.07
 92 $ 1,125,766.07
93 $ 1,125,766.07
94 $ 1,125,766.07
95 $ 1,125,766.07
96 $ 1,125,766.07
97 $ 1,125,766.07
98 $ 1,125,766.07
99 $ 1,125,766.07
100 $ 1,125,766.07
101 $ 1,125,766.07
102 $ 1,125,766.07
103 $ 1,125,766.07
104 $ 1,125,766.07
105 $ 1,125,766.07
106 $ 1,125,766.07
107 $ 1,125,766.07
108 $ 1,125,766.07
109 $ 1,125,766.07
110 $ 1,125,766.07
111 $ 1,125,766.07
112 $ 1,125,766.07
113 $ 1,125,766.07
114 $ 1,125,766.07
115 $ 1,125,766.07
116 $ 1,125,766.07
117 $ 1,125,766.07
118 $ 1,125,766.07
119 $ 1,125,766.07
120 $ 1,125,766.07
121 $ 1,125,766.07
122 $ 1,125,766.07
123 $ 1,125,766.07
124 $ 1,125,766.07
125 $ 1,125,766.07
126 $ 1,125,766.07
127 $ 1,125,766.07
128 $ 1,125,766.07
129 $ 1,125,766.07
130 $ 1,125,766.07
131 $ 1,125,766.07
132 $ 1,125,766.07
133 $ 1,125,766.07
134 $ 1,125,766.07
135 $ 1,125,766.07
136 $ 1,125,766.07
137 $ 1,125,766.07
138 $ 1,125,766.07
139 $ 1,125,766.07
140 $ 1,125,766.07
141 $ 1,125,766.07
142 $ 1,125,766.07
143 $ 1,125,766.07
144 $ 1,125,766.07
145 $ 1,125,766.07
146 $ 1,125,766.07
147 $ 1,125,766.07
148 $ 1,125,766.07
149 $ 1,125,766.07
150 $ 1,125,766.07
151 $ 1,125,766.07
152 $ 1,125,766.07
153 $ 1,125,766.07
154 $ 1,125,766.07
155 $ 1,125,766.07
156 $ 1,125,766.07
157 $ 1,125,766.07
158 $ 1,125,766.07
159 $ 1,125,766.07
160 $ 1,125,766.07
161 $ 1,125,766.07
162 $ 1,125,766.07
163 $ 1,125,766.07
164 $ 1,125,766.07
165 $ 1,125,766.07
166 $ 1,125,766.07
167 $ 1,125,766.07
168 $ 1,125,766.07
169 $ 1,125,766.07
170 $ 1,125,766.07
171 $ 1,125,766.07
172 $ 1,125,766.07
173 $ 1,125,766.07
174 $ 1,125,766.07
175 $ 1,125,766.07
176 $ 1,125,766.07
177 $ 1,125,766.07
178 $ 1,125,766.07
179 $ 1,125,766.07
180 $ 1,125,766.07
Interés Capital Saldos
$ 85,000,000.00
$ 850,000.00 $ 275,766.07 $ 84,724,233.93
$ 847,242.34 $ 278,523.73 $ 84,445,710.21
$ 844,457.10 $ 281,308.96 $ 84,164,401.24
$ 841,644.01 $ 284,122.05 $ 83,880,279.19
$ 838,802.79 $ 286,963.27 $ 83,593,315.91
$ 835,933.16 $ 289,832.91 $ 83,303,483.01
$ 833,034.83 $ 292,731.24 $ 83,010,751.77
$ 830,107.52 $ 295,658.55 $ 82,715,093.22
$ 827,150.93 $ 298,615.13 $ 82,416,478.09
$ 824,164.78 $ 301,601.29 $ 82,114,876.80
$ 821,148.77 $ 304,617.30 $ 81,810,259.50
$ 818,102.60 $ 307,663.47 $ 81,502,596.03
$ 815,025.96 $ 310,740.11 $ 81,191,855.92
$ 811,918.56 $ 313,847.51 $ 80,878,008.42
$ 808,780.08 $ 316,985.98 $ 80,561,022.43
$ 805,610.22 $ 320,155.84 $ 80,240,866.59
$ 802,408.67 $ 323,357.40 $ 79,917,509.19
$ 799,175.09 $ 326,590.97 $ 79,590,918.22
$ 795,909.18 $ 329,856.88 $ 79,261,061.33
$ 792,610.61 $ 333,155.45 $ 78,927,905.88
$ 789,279.06 $ 336,487.01 $ 78,591,418.87
$ 785,914.19 $ 339,851.88 $ 78,251,566.99
$ 782,515.67 $ 343,250.40 $ 77,908,316.60
$ 779,083.17 $ 346,682.90 $ 77,561,633.70
$ 775,616.34 $ 350,149.73 $ 77,211,483.97
$ 772,114.84 $ 353,651.23 $ 76,857,832.74
$ 768,578.33 $ 357,187.74 $ 76,500,645.00
$ 765,006.45 $ 360,759.62 $ 76,139,885.38
$ 761,398.85 $ 364,367.21 $ 75,775,518.17
$ 757,755.18 $ 368,010.88 $ 75,407,507.28
$ 754,075.07 $ 371,690.99 $ 75,035,816.29
$ 750,358.16 $ 375,407.90 $ 74,660,408.39
$ 746,604.08 $ 379,161.98 $ 74,281,246.40
$ 742,812.46 $ 382,953.60 $ 73,898,292.80
$ 738,982.93 $ 386,783.14 $ 73,511,509.66
$ 735,115.10 $ 390,650.97 $ 73,120,858.69
$ 731,208.59 $ 394,557.48 $ 72,726,301.21
$ 727,263.01 $ 398,503.05 $ 72,327,798.16
$ 723,277.98 $ 402,488.08 $ 71,925,310.07
$ 719,253.10 $ 406,512.97 $ 71,518,797.11
$ 715,187.97 $ 410,578.10 $ 71,108,219.01
$ 711,082.19 $ 414,683.88 $ 70,693,535.14
$ 706,935.35 $ 418,830.72 $ 70,274,704.42
$ 702,747.04 $ 423,019.02 $ 69,851,685.40
$ 698,516.85 $ 427,249.21 $ 69,424,436.19
$ 694,244.36 $ 431,521.70 $ 68,992,914.48
$ 689,929.14 $ 435,836.92 $ 68,557,077.56
$ 685,570.78 $ 440,195.29 $ 68,116,882.27
$ 681,168.82 $ 444,597.24 $ 67,672,285.03
$ 676,722.85 $ 449,043.22 $ 67,223,241.81
$ 672,232.42 $ 453,533.65 $ 66,769,708.16
$ 667,697.08 $ 458,068.98 $ 66,311,639.18
$ 663,116.39 $ 462,649.67 $ 65,848,989.50
$ 658,489.90 $ 467,276.17 $ 65,381,713.33
$ 653,817.13 $ 471,948.93 $ 64,909,764.40
$ 649,097.64 $ 476,668.42 $ 64,433,095.97
$ 644,330.96 $ 481,435.11 $ 63,951,660.87
$ 639,516.61 $ 486,249.46 $ 63,465,411.41
$ 634,654.11 $ 491,111.95 $ 62,974,299.46
$ 629,742.99 $ 496,023.07 $ 62,478,276.38
$ 937,174.15 $ 188,591.92 $ 62,289,684.46
$ 934,345.27 $ 191,420.80 $ 62,098,263.66
$ 931,473.95 $ 194,292.11 $ 61,903,971.55
$ 928,559.57 $ 197,206.49 $ 61,706,765.06
$ 925,601.48 $ 200,164.59 $ 61,506,600.47
$ 922,599.01 $ 203,167.06 $ 61,303,433.41
$ 919,551.50 $ 206,214.57 $ 61,097,218.84
$ 916,458.28 $ 209,307.78 $ 60,887,911.06
$ 913,318.67 $ 212,447.40 $ 60,675,463.66
$ 910,131.95 $ 215,634.11 $ 60,459,829.55
$ 906,897.44 $ 218,868.62 $ 60,240,960.92
$ 903,614.41 $ 222,151.65 $ 60,018,809.27
$ 900,282.14 $ 225,483.93 $ 59,793,325.34
$ 896,899.88 $ 228,866.19 $ 59,564,459.16
$ 893,466.89 $ 232,299.18 $ 59,332,159.98
$ 889,982.40 $ 235,783.67 $ 59,096,376.31
$ 886,445.64 $ 239,320.42 $ 58,857,055.89
$ 882,855.84 $ 242,910.23 $ 58,614,145.66
$ 879,212.18 $ 246,553.88 $ 58,367,591.78
$ 875,513.88 $ 250,252.19 $ 58,117,339.59
$ 871,760.09 $ 254,005.97 $ 57,863,333.62
$ 867,950.00 $ 257,816.06 $ 57,605,517.55
$ 864,082.76 $ 261,683.30 $ 57,343,834.25
$ 860,157.51 $ 265,608.55 $ 57,078,225.70
$ 856,173.39 $ 269,592.68 $ 56,808,633.02
$ 852,129.50 $ 273,636.57 $ 56,534,996.44
$ 848,024.95 $ 277,741.12 $ 56,257,255.32
$ 843,858.83 $ 281,907.24 $ 55,975,348.09
$ 839,630.22 $ 286,135.85 $ 55,689,212.24
$ 835,338.18 $ 290,427.88 $ 55,398,784.36
$ 830,981.77 $ 294,784.30 $ 55,104,000.06
$ 826,560.00 $ 299,206.07 $ 54,804,793.99
$ 822,071.91 $ 303,694.16 $ 54,501,099.84
$ 817,516.50 $ 308,249.57 $ 54,192,850.27
$ 812,892.75 $ 312,873.31 $ 53,879,976.95
$ 808,199.65 $ 317,566.41 $ 53,562,410.54
$ 803,436.16 $ 322,329.91 $ 53,240,080.63
$ 798,601.21 $ 327,164.86 $ 52,912,915.78
$ 793,693.74 $ 332,072.33 $ 52,580,843.45
$ 788,712.65 $ 337,053.41 $ 52,243,790.03
$ 783,656.85 $ 342,109.22 $ 51,901,680.82
$ 778,525.21 $ 347,240.85 $ 51,554,439.96
$ 773,316.60 $ 352,449.47 $ 51,201,990.49
$ 768,029.86 $ 357,736.21 $ 50,844,254.28
$ 762,663.81 $ 363,102.25 $ 50,481,152.03
$ 757,217.28 $ 368,548.79 $ 50,112,603.25
$ 751,689.05 $ 374,077.02 $ 49,738,526.23
$ 746,077.89 $ 379,688.17 $ 49,358,838.05
$ 740,382.57 $ 385,383.50 $ 48,973,454.56
$ 734,601.82 $ 391,164.25 $ 48,582,290.31
$ 728,734.35 $ 397,031.71 $ 48,185,258.60
$ 722,778.88 $ 402,987.19 $ 47,782,271.41
$ 716,734.07 $ 409,032.00 $ 47,373,239.42
$ 710,598.59 $ 415,167.48 $ 46,958,071.94
$ 704,371.08 $ 421,394.99 $ 46,536,676.95
$ 698,050.15 $ 427,715.91 $ 46,108,961.04
$ 691,634.42 $ 434,131.65 $ 45,674,829.39
$ 685,122.44 $ 440,643.63 $ 45,234,185.76
$ 678,512.79 $ 447,253.28 $ 44,786,932.48
$ 671,803.99 $ 453,962.08 $ 44,332,970.40
$ 664,994.56 $ 460,771.51 $ 43,872,198.89
$ 658,082.98 $ 467,683.08 $ 43,404,515.81
$ 651,067.74 $ 474,698.33 $ 42,929,817.48
$ 643,947.26 $ 481,818.80 $ 42,447,998.68
$ 636,719.98 $ 489,046.09 $ 41,958,952.59
$ 629,384.29 $ 496,381.78 $ 41,462,570.81
$ 621,938.56 $ 503,827.50 $ 40,958,743.31
$ 614,381.15 $ 511,384.92 $ 40,447,358.39
$ 606,710.38 $ 519,055.69 $ 39,928,302.70
$ 598,924.54 $ 526,841.53 $ 39,401,461.17
$ 591,021.92 $ 534,744.15 $ 38,866,717.03
$ 583,000.76 $ 542,765.31 $ 38,323,951.71
$ 574,859.28 $ 550,906.79 $ 37,773,044.92
$ 566,595.67 $ 559,170.39 $ 37,213,874.53
$ 558,208.12 $ 567,557.95 $ 36,646,316.58
$ 549,694.75 $ 576,071.32 $ 36,070,245.26
$ 541,053.68 $ 584,712.39 $ 35,485,532.88
$ 532,282.99 $ 593,483.07 $ 34,892,049.80
$ 523,380.75 $ 602,385.32 $ 34,289,664.48
$ 514,344.97 $ 611,421.10 $ 33,678,243.38
$ 505,173.65 $ 620,592.42 $ 33,057,650.97
$ 495,864.76 $ 629,901.30 $ 32,427,749.67
$ 486,416.24 $ 639,349.82 $ 31,788,399.84
$ 476,826.00 $ 648,940.07 $ 31,139,459.78
$ 467,091.90 $ 658,674.17 $ 30,480,785.61
$ 457,211.78 $ 668,554.28 $ 29,812,231.32
$ 447,183.47 $ 678,582.60 $ 29,133,648.73
$ 437,004.73 $ 688,761.34 $ 28,444,887.39
$ 426,673.31 $ 699,092.76 $ 27,745,794.64
$ 416,186.92 $ 709,579.15 $ 27,036,215.49
$ 405,543.23 $ 720,222.83 $ 26,315,992.65
$ 394,739.89 $ 731,026.18 $ 25,584,966.48
$ 383,774.50 $ 741,991.57 $ 24,842,974.91
$ 372,644.62 $ 753,121.44 $ 24,089,853.46
$ 361,347.80 $ 764,418.26 $ 23,325,435.20
$ 349,881.53 $ 775,884.54 $ 22,549,550.66
$ 338,243.26 $ 787,522.81 $ 21,762,027.85
$ 326,430.42 $ 799,335.65 $ 20,962,692.21
$ 314,440.38 $ 811,325.68 $ 20,151,366.52
$ 302,270.50 $ 823,495.57 $ 19,327,870.95
$ 289,918.06 $ 835,848.00 $ 18,492,022.95
$ 277,380.34 $ 848,385.72 $ 17,643,637.23
$ 264,654.56 $ 861,111.51 $ 16,782,525.72
$ 251,737.89 $ 874,028.18 $ 15,908,497.54
$ 238,627.46 $ 887,138.60 $ 15,021,358.94
$ 225,320.38 $ 900,445.68 $ 14,120,913.25
$ 211,813.70 $ 913,952.37 $ 13,206,960.89
$ 198,104.41 $ 927,661.65 $ 12,279,299.23
$ 184,189.49 $ 941,576.58 $ 11,337,722.66
$ 170,065.84 $ 955,700.23 $ 10,382,022.43
$ 155,730.34 $ 970,035.73 $ 9,411,986.70
$ 141,179.80 $ 984,586.27 $ 8,427,400.43
$ 126,411.01 $ 999,355.06 $ 7,428,045.37
$ 111,420.68 $ 1,014,345.39 $ 6,413,699.99
$ 96,205.50 $ 1,029,560.57 $ 5,384,139.42
$ 80,762.09 $ 1,045,003.98 $ 4,339,135.44
$ 65,087.03 $ 1,060,679.03 $ 3,278,456.41
$ 49,176.85 $ 1,076,589.22 $ 2,201,867.19
$ 33,028.01 $ 1,092,738.06 $ 1,109,129.13
$ 16,636.94 $ 1,109,129.13 $ 0.00
 Deuda $ 42,000,000.00
15% Cuota inicial $ 6,300,000.00 Periodos Cuota
3 años 0 $ 6,300,000.00
36 meses 1 $ 0.00
Tasa interés 18% NT 2 $ 0.00
5% ET 3 $ 0.00
1.48% EM 4 $ 0.00
5 $ 0.00
Primeros 5 Tasa interés 18% EA 6 $ 1,553,771.88
meses 1.39% EM 7 $ 1,553,771.88
8 $ 1,553,771.88
Tasa interés 20% EA 9 $ 1,553,771.88
1.53% EM 10 $ 1,553,771.88
11 $ 1,553,771.88
12 $ 1,553,771.88
13 $ 1,553,771.88
14 $ 1,553,771.88
15 $ 1,553,771.88
16 $ 1,553,771.88
17 $ 1,553,771.88
EN EL PRIMER COSO 18 $ 1,553,771.88
1. Cambie la tasa (18 NT a EM) 19 $ 1,553,771.88
2. Se puso que en los primeros 5 meses 0 20 $ 1,553,771.88
3. La cuota inicial 42-6300000 21 $ 1,553,771.88
4. Normal con buscar objetivo 22 $ 1,553,771.88
23 $ 1,553,771.88
EN EL SEGUNDO COSO 24 $ 1,553,771.88
1. Se cambian las tasas nuevas 25 $ 1,553,771.88
2. 26 $ 1,553,771.88
27 $ 1,553,771.88
28 $ 1,553,771.88
29 $ 1,553,771.88
30 $ 1,553,771.88
31 $ 1,553,771.88
32 $ 1,553,771.88
33 $ 1,553,771.88
34 $ 1,553,771.88
35 $ 1,553,771.88
36 $ 1,553,771.88
 Interés Capital Saldos Periodos Cuota Interés
$ 35,700,000.00 0 $ 6,300,000.00
$ 527,662.48 -$ 527,662.48 $ 36,227,662.48 1 $ 0.00 $ 495,816.96
$ 535,461.58 -$ 535,461.58 $ 36,763,124.06 2 $ 0.00 $ 502,703.08
$ 543,375.94 -$ 543,375.94 $ 37,306,500.00 3 $ 0.00 $ 509,684.84
$ 551,407.29 -$ 551,407.29 $ 37,857,907.29 4 $ 0.00 $ 516,763.56
$ 559,557.35 -$ 559,557.35 $ 38,417,464.64 5 $ 0.00 $ 523,940.60
$ 567,827.86 $ 985,944.02 $ 37,431,520.62 6 $ 1,556,758.89 $ 531,217.31
$ 553,255.15 $ 1,000,516.72 $ 36,431,003.90 7 $ 1,556,758.89 $ 569,870.05
$ 538,467.06 $ 1,015,304.82 $ 35,415,699.07 8 $ 1,556,758.89 $ 554,761.30
$ 523,460.38 $ 1,030,311.50 $ 34,385,387.58 9 $ 1,556,758.89 $ 539,421.25
$ 508,231.90 $ 1,045,539.98 $ 33,339,847.60 10 $ 1,556,758.89 $ 523,846.35
$ 492,778.34 $ 1,060,993.54 $ 32,278,854.06 11 $ 1,556,758.89 $ 508,033.00
$ 477,096.36 $ 1,076,675.51 $ 31,202,178.55 12 $ 1,556,758.89 $ 491,977.57
$ 461,182.60 $ 1,092,589.28 $ 30,109,589.27 13 $ 1,556,758.89 $ 475,676.33
$ 445,033.63 $ 1,108,738.25 $ 29,000,851.02 14 $ 1,556,758.89 $ 459,125.53
$ 428,645.97 $ 1,125,125.91 $ 27,875,725.11 15 $ 1,556,758.89 $ 442,321.34
$ 412,016.09 $ 1,141,755.79 $ 26,733,969.32 16 $ 1,556,758.89 $ 425,259.89
$ 395,140.41 $ 1,158,631.47 $ 25,575,337.85 17 $ 1,556,758.89 $ 407,937.24
$ 378,015.30 $ 1,175,756.58 $ 24,399,581.27 18 $ 1,556,758.89 $ 390,349.39
$ 360,637.07 $ 1,193,134.80 $ 23,206,446.46 19 $ 1,556,758.89 $ 372,492.28
$ 343,001.99 $ 1,210,769.89 $ 21,995,676.58 20 $ 1,556,758.89 $ 354,361.78
$ 325,106.25 $ 1,228,665.62 $ 20,767,010.95 21 $ 1,556,758.89 $ 335,953.72
$ 306,946.01 $ 1,246,825.87 $ 19,520,185.08 22 $ 1,556,758.89 $ 317,263.84
$ 288,517.35 $ 1,265,254.53 $ 18,254,930.55 23 $ 1,556,758.89 $ 298,287.83
$ 269,816.30 $ 1,283,955.58 $ 16,970,974.97 24 $ 1,556,758.89 $ 279,021.30
$ 250,838.84 $ 1,302,933.03 $ 15,668,041.94 25 $ 1,556,758.89 $ 259,459.81
$ 231,580.89 $ 1,322,190.99 $ 14,345,850.95 26 $ 1,556,758.89 $ 239,598.85
$ 212,038.30 $ 1,341,733.58 $ 13,004,117.37 27 $ 1,556,758.89 $ 219,433.83
$ 192,206.86 $ 1,361,565.02 $ 11,642,552.35 28 $ 1,556,758.89 $ 198,960.09
$ 172,082.30 $ 1,381,689.58 $ 10,260,862.77 29 $ 1,556,758.89 $ 178,172.91
$ 151,660.29 $ 1,402,111.59 $ 8,858,751.18 30 $ 1,556,758.89 $ 157,067.49
$ 130,936.43 $ 1,422,835.45 $ 7,435,915.74 31 $ 1,556,758.89 $ 135,638.96
$ 109,906.27 $ 1,443,865.61 $ 5,992,050.13 32 $ 1,556,758.89 $ 113,882.36
$ 88,565.27 $ 1,465,206.61 $ 4,526,843.51 33 $ 1,556,758.89 $ 91,792.69
$ 66,908.84 $ 1,486,863.04 $ 3,039,980.47 34 $ 1,556,758.89 $ 69,364.83
$ 44,932.31 $ 1,508,839.56 $ 1,531,140.91 35 $ 1,556,758.89 $ 46,593.61
$ 22,630.97 $ 1,531,140.91 $ 0.00 36 $ 1,556,758.89 $ 23,473.78
 Capital Saldos
$ 35,700,000.00
-$ 495,816.96 $ 36,195,816.96
-$ 502,703.08 $ 36,698,520.05
-$ 509,684.84 $ 37,208,204.89
-$ 516,763.56 $ 37,724,968.45
-$ 523,940.60 $ 38,248,909.04
$ 1,025,541.58 $ 37,223,367.47
$ 986,888.84 $ 36,236,478.62
$ 1,001,997.59 $ 35,234,481.03
$ 1,017,337.64 $ 34,217,143.39
$ 1,032,912.54 $ 33,184,230.85
$ 1,048,725.89 $ 32,135,504.97
$ 1,064,781.32 $ 31,070,723.64
$ 1,081,082.56 $ 29,989,641.08
$ 1,097,633.36 $ 28,892,007.72
$ 1,114,437.55 $ 27,777,570.17
$ 1,131,499.00 $ 26,646,071.17
$ 1,148,821.65 $ 25,497,249.53
$ 1,166,409.50 $ 24,330,840.03
$ 1,184,266.61 $ 23,146,573.42
$ 1,202,397.11 $ 21,944,176.31
$ 1,220,805.17 $ 20,723,371.14
$ 1,239,495.05 $ 19,483,876.09
$ 1,258,471.06 $ 18,225,405.03
$ 1,277,737.59 $ 16,947,667.44
$ 1,297,299.07 $ 15,650,368.37
$ 1,317,160.04 $ 14,333,208.33
$ 1,337,325.06 $ 12,995,883.27
$ 1,357,798.80 $ 11,638,084.48
$ 1,378,585.98 $ 10,259,498.50
$ 1,399,691.40 $ 8,859,807.10
$ 1,421,119.93 $ 7,438,687.17
$ 1,442,876.53 $ 5,995,810.64
$ 1,464,966.20 $ 4,530,844.44
$ 1,487,394.06 $ 3,043,450.38
$ 1,510,165.27 $ 1,533,285.11
$ 1,533,285.11 $ 0.00
 Tasas Periodos Cuota Interés
CM 13.2% NM 0
1.1% EM 1 $ 3,457,478.30 $ 0.00
2.21% EB 2 $ 3,457,478.30 $ 76,482.88
3 $ 3,457,478.30 $ 154,657.63
$ 15,000,000.00 Periodo 6 4 $ 3,457,478.30 $ 234,561.69
$ 18,000,000.00 Periodo 9 5 $ 3,457,478.30 $ 316,233.31
6 $ 3,457,478.30 $ 399,711.58
7 $ 3,457,478.30 $ 153,221.48
8 $ 3,457,478.30 $ 233,093.77
9 $ 3,457,478.30 $ 314,732.92
Bimestres
 Capital Saldos
$ 0.00
$ 3,457,478.30 $ 3,457,478.30
$ 3,533,961.18 $ 6,991,439.49
$ 3,612,135.94 $ 10,603,575.42
$ 3,692,040.00 $ 14,295,615.42
$ 3,773,711.61 $ 18,069,327.03
$ 3,857,189.89 $ 6,926,516.92 Antes de buscar objetivo, le resto los 15M
$ 3,610,699.79 $ 10,537,216.71
$ 3,690,572.08 $ 14,227,788.78
$ 3,772,211.22 $ 18,000,000.00
 Deuda $ 50,000,000.00 Periodos Cuota Interés
3 años 0
36 meses 1 $ 1,773,108.03 $ 650,000.00
Tasas 2 $ 1,773,108.03 $ 635,399.60
Primer año 1.30% EM 3 $ 1,773,108.03 $ 620,609.39
1.50% EM 4 $ 1,773,108.03 $ 605,626.90
5 $ 1,773,108.03 $ 590,449.65
Depósitos por trimestre anticipado 6 $ 1,773,108.03 $ 575,075.09
7 $ 1,773,108.03 $ 559,500.66
Tasas 8 $ 1,773,108.03 $ 543,723.77
CT 22% NT 9 $ 1,773,108.03 $ 527,741.77
5.50% ET 10 $ 1,773,108.03 $ 511,552.01
1.8% EM 11 $ 1,773,108.03 $ 495,151.78
25% NTV 12 $ 1,773,108.03 $ 478,538.35
6.25% ET 13 $ 1,773,108.03 $ 532,741.09
2.0% EM 14 $ 1,773,108.03 $ 514,135.58
15 $ 1,773,108.03 $ 495,251.00
16 $ 1,773,108.03 $ 476,083.14
17 $ 1,773,108.03 $ 456,627.77
18 $ 1,773,108.03 $ 436,880.57
19 $ 1,773,108.03 $ 416,837.15
20 $ 1,773,108.03 $ 396,493.09
21 $ 1,773,108.03 $ 375,843.87
22 $ 1,773,108.03 $ 354,884.90
23 $ 1,773,108.03 $ 333,611.56
24 $ 1,773,108.03 $ 312,019.11
25 $ 1,773,108.03 $ 290,102.78
26 $ 1,773,108.03 $ 267,857.70
27 $ 1,773,108.03 $ 245,278.94
28 $ 1,773,108.03 $ 222,361.51
29 $ 1,773,108.03 $ 199,100.31
30 $ 1,773,108.03 $ 175,490.19
31 $ 1,773,108.03 $ 151,525.92
32 $ 1,773,108.03 $ 127,202.19
33 $ 1,773,108.03 $ 102,513.61
34 $ 1,773,108.03 $ 77,454.69
35 $ 1,773,108.03 $ 52,019.89
36 $ 1,773,108.03 $ 26,203.57
 Capital Saldos Periodos Cuota Interés
$ 50,000,000.00 0 $ 5,119,223.86 $ 0.00
$ 1,123,108.03 $ 48,876,891.97 1 $ 5,119,223.86 $ 281,557.31
$ 1,137,708.43 $ 47,739,183.54 2 $ 5,119,223.86 $ 578,600.28
$ 1,152,498.64 $ 46,586,684.89 3 $ 5,119,223.86 $ 891,980.60
$ 1,167,481.13 $ 45,419,203.76 4 $ 5,119,223.86 $ 1,222,596.85
$ 1,182,658.38 $ 44,236,545.38 5 $ 5,119,223.86 $ 1,785,678.40
$ 1,198,032.94 $ 43,038,512.44 6 $ 5,119,223.86 $ 2,217,234.79
$ 1,213,607.37 $ 41,824,905.08 7 $ 5,119,223.86 $ 2,675,763.45
$ 1,229,384.26 $ 40,595,520.81 8 $ 5,119,223.86 $ 3,162,950.16
$ 1,245,366.26 $ 39,350,154.55 9 $ 5,119,223.86 $ 3,680,586.03
$ 1,261,556.02 $ 38,088,598.53 10 $ 5,119,223.86 $ 4,230,574.15
$ 1,277,956.25 $ 36,810,642.28 11 $ 5,119,223.86 $ 4,814,936.53
$ 1,294,569.68 $ 35,516,072.60 12 $ 0.00 $ 5,435,821.55
$ 1,240,366.94 $ 34,275,705.66 Trime
$ 1,258,972.45 $ 33,016,733.21
$ 1,277,857.03 $ 31,738,876.18 Tasas VF MESES Mes 12
$ 1,297,024.89 $ 30,441,851.30 1.8 VF 1 $ 23,516,345.98
$ 1,316,480.26 $ 29,125,371.03 2 VF 2
$ 1,336,227.46 $ 27,789,143.57 VF 1 Y 2 mes 36
$ 1,356,270.88 $ 26,432,872.69
$ 1,376,614.94 $ 25,056,257.75
$ 1,397,264.16 $ 23,658,993.59 Cuota $ 5,119,223.86
$ 1,418,223.13 $ 22,240,770.46
$ 1,439,496.47 $ 20,801,273.99
$ 1,461,088.92 $ 19,340,185.07
$ 1,483,005.25 $ 17,857,179.82
$ 1,505,250.33 $ 16,351,929.48
$ 1,527,829.09 $ 14,824,100.40
$ 1,550,746.52 $ 13,273,353.87
$ 1,574,007.72 $ 11,699,346.15
$ 1,597,617.84 $ 10,101,728.31
$ 1,621,582.11 $ 8,480,146.21
$ 1,645,905.84 $ 6,834,240.37
$ 1,670,594.42 $ 5,163,645.95
$ 1,695,653.34 $ 3,467,992.60
$ 1,721,088.14 $ 1,746,904.46
$ 1,746,904.46 $ 0.00
 Capital Saldos
$ 5,119,223.86 $ 5,119,223.86
$ 5,400,781.17 $ 10,520,005.02
$ 5,697,824.13 $ 16,217,829.16
$ 6,011,204.46 $ 22,229,033.62
$ 6,341,820.71 $ 28,570,854.32
$ 6,904,902.25 $ 35,475,756.57
$ 7,336,458.64 $ 42,812,215.22
$ 7,794,987.31 $ 50,607,202.52
$ 8,282,174.01 $ 58,889,376.54
$ 8,799,809.89 $ 67,689,186.43
$ 9,349,798.01 $ 77,038,984.44
$ 9,934,160.38 $ 86,973,144.82
$ 5,435,821.55 $ 92,408,966.37

Mes 36
$ 38,194,545.88
$ 54,214,420.48
$ 92,408,966.37