Upload
negro-a-carlos
View
254
Download
0
Embed Size (px)
8/18/2019 AMORTIZACION Planilla
1/88
MATEMATICAS FINANCIERAS II MENU PRINCIPAL
OSCAR ABEL LUNA RIOJAS
DATOS DE ENTRADA
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
FORMA DE PAGO
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
AMORTIZACIÓN No. 1
AMORTIZACIÓN No. 2 AMORTIZACIÓN No. 3 AMORTIZACION No. 4 AMORTIZACION No. 5 AMORTIZACIÓN No. 6 AMORTIZACION No. 7 AMORTIZACION No. 8CAPITALIZACION No. 1CAPITALIZACION No. 2CAPITALIZACION No. 3
8/18/2019 AMORTIZACION Planilla
2/88
AMORTIZACIÓN CON CUOTA CONSTANTE
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
VALOR DE LA CUOTA 493,985.68
n SALDO INICIAL CUOTA INTERESES AMORTIZACIÓN SALDO FINAL
1 24,000,000.00 493,985.68 480,000.00 13,985.68 23,986,014.32
2 23,986,014.32 493,985.68 479,720.29 14,265.39 23,971,748.94
3 23,971,748.94 493,985.68 479,434.98 14,550.70 23,957,198.24
4 23,957,198.24 493,985.68 479,143.96 14,841.71 23,942,356.53
5 23,942,356.53 493,985.68 478,847.13 15,138.54 23,927,217.98
6 23,927,217.98 493,985.68 478,544.36 15,441.32 23,911,776.67
7 23,911,776.67 493,985.68 478,235.53 15,750.14 23,896,026.53
8 23,896,026.53 493,985.68 477,920.53 16,065.14 23,879,961.38
9 23,879,961.38 493,985.68 477,599.23 16,386.45 23,863,574.94
10 23,863,574.94 493,985.68 477,271.50 16,714.18 23,846,860.76
11 23,846,860.76 493,985.68 476,937.22 17,048.46 23,829,812.30
12 23,829,812.30 493,985.68 476,596.25 17,389.43 23,812,422.87
13 23,812,422.87 493,985.68 476,248.46 17,737.22 23,794,685.65
14 23,794,685.65 493,985.68 475,893.71 18,091.96 23,776,593.69
15 23,776,593.69 493,985.68 475,531.87 18,453.80 23,758,139.89
16 23,758,139.89 493,985.68 475,162.80 18,822.88 23,739,317.01
17 23,739,317.01 493,985.68 474,786.34 19,199.33 23,720,117.68
18 23,720,117.68 493,985.68 474,402.35 19,583.32 23,700,534.35
19 23,700,534.35 493,985.68 474,010.69 19,974.99 23,680,559.37
20 23,680,559.37 493,985.68 473,611.19 20,374.49 23,660,184.88
21 23,660,184.88 493,985.68 473,203.70 20,781.98 23,639,402.90
22 23,639,402.90 493,985.68 472,788.06 21,197.62 23,618,205.28
23 23,618,205.28 493,985.68 472,364.11 21,621.57 23,596,583.71
24 23,596,583.71 493,985.68 471,931.67 22,054.00 23,574,529.71
25 23,574,529.71 493,985.68 471,490.59 22,495.08 23,552,034.63
26 23,552,034.63 493,985.68 471,040.69 22,944.98 23,529,089.65
27 23,529,089.65 493,985.68 470,581.79 23,403.88 23,505,685.77
28 23,505,685.77 493,985.68 470,113.72 23,871.96 23,481,813.81
29 23,481,813.81 493,985.68 469,636.28 24,349.40 23,457,464.41
30 23,457,464.41 493,985.68 469,149.29 24,836.39 23,432,628.02
31 23,432,628.02 493,985.68 468,652.56 25,333.11 23,407,294.91
32 23,407,294.91 493,985.68 468,145.90 25,839.78 23,381,455.13
33 23,381,455.13 493,985.68 467,629.10 26,356.57 23,355,098.56
34 23,355,098.56 493,985.68 467,101.97 26,883.70 23,328,214.85
35 23,328,214.85 493,985.68 466,564.30 27,421.38 23,300,793.47
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
8/18/2019 AMORTIZACION Planilla
3/88
36 23,300,793.47 493,985.68 466,015.87 27,969.81 23,272,823.67
37 23,272,823.67 493,985.68 465,456.47 28,529.20 23,244,294.47
38 23,244,294.47 493,985.68 464,885.89 29,099.79 23,215,194.68
39 23,215,194.68 493,985.68 464,303.89 29,681.78 23,185,512.90
40 23,185,512.90 493,985.68 463,710.26 30,275.42 23,155,237.48
41 23,155,237.48 493,985.68 463,104.75 30,880.93 23,124,356.56
42 23,124,356.56 493,985.68 462,487.13 31,498.54 23,092,858.0143 23,092,858.01 493,985.68 461,857.16 32,128.51 23,060,729.50
44 23,060,729.50 493,985.68 461,214.59 32,771.09 23,027,958.41
45 23,027,958.41 493,985.68 460,559.17 33,426.51 22,994,531.90
46 22,994,531.90 493,985.68 459,890.64 34,095.04 22,960,436.87
47 22,960,436.87 493,985.68 459,208.74 34,776.94 22,925,659.93
48 22,925,659.93 493,985.68 458,513.20 35,472.48 22,890,187.45
49 22,890,187.45 493,985.68 457,803.75 36,181.93 22,854,005.53
50 22,854,005.53 493,985.68 457,080.11 36,905.56 22,817,099.96
51 22,817,099.96 493,985.68 456,342.00 37,643.68 22,779,456.29
52 22,779,456.29 493,985.68 455,589.13 38,396.55 22,741,059.74
53 22,741,059.74 493,985.68 454,821.19 39,164.48 22,701,895.26
54 22,701,895.26 493,985.68 454,037.91 39,947.77 22,661,947.4955 22,661,947.49 493,985.68 453,238.95 40,746.73 22,621,200.76
56 22,621,200.76 493,985.68 452,424.02 41,561.66 22,579,639.10
57 22,579,639.10 493,985.68 451,592.78 42,392.89 22,537,246.21
58 22,537,246.21 493,985.68 450,744.92 43,240.75 22,494,005.46
59 22,494,005.46 493,985.68 449,880.11 44,105.57 22,449,899.89
60 22,449,899.89 493,985.68 448,998.00 44,987.68 22,404,912.21
61 22,404,912.21 493,985.68 448,098.24 45,887.43 22,359,024.78
62 22,359,024.78 493,985.68 447,180.50 46,805.18 22,312,219.60
63 22,312,219.60 493,985.68 446,244.39 47,741.28 22,264,478.32
64 22,264,478.32 493,985.68 445,289.57 48,696.11 22,215,782.21
65 22,215,782.21 493,985.68 444,315.64 49,670.03 22,166,112.18
66 22,166,112.18 493,985.68 443,322.24 50,663.43 22,115,448.7567 22,115,448.75 493,985.68 442,308.97 51,676.70 22,063,772.05
68 22,063,772.05 493,985.68 441,275.44 52,710.23 22,011,061.81
69 22,011,061.81 493,985.68 440,221.24 53,764.44 21,957,297.38
70 21,957,297.38 493,985.68 439,145.95 54,839.73 21,902,457.65
71 21,902,457.65 493,985.68 438,049.15 55,936.52 21,846,521.13
72 21,846,521.13 493,985.68 436,930.42 57,055.25 21,789,465.87
73 21,789,465.87 493,985.68 435,789.32 58,196.36 21,731,269.51
74 21,731,269.51 493,985.68 434,625.39 59,360.28 21,671,909.23
75 21,671,909.23 493,985.68 433,438.18 60,547.49 21,611,361.74
76 21,611,361.74 493,985.68 432,227.23 61,758.44 21,549,603.30
77 21,549,603.30 493,985.68 430,992.07 62,993.61 21,486,609.69
78 21,486,609.69 493,985.68 429,732.19 64,253.48 21,422,356.2179 21,422,356.21 493,985.68 428,447.12 65,538.55 21,356,817.66
80 21,356,817.66 493,985.68 427,136.35 66,849.32 21,289,968.34
81 21,289,968.34 493,985.68 425,799.37 68,186.31 21,221,782.03
82 21,221,782.03 493,985.68 424,435.64 69,550.03 21,152,231.99
83 21,152,231.99 493,985.68 423,044.64 70,941.04 21,081,290.96
84 21,081,290.96 493,985.68 421,625.82 72,359.86 21,008,931.10
85 21,008,931.10 493,985.68 420,178.62 73,807.05 20,935,124.05
8/18/2019 AMORTIZACION Planilla
4/88
86 20,935,124.05 493,985.68 418,702.48 75,283.19 20,859,840.85
87 20,859,840.85 493,985.68 417,196.82 76,788.86 20,783,051.99
88 20,783,051.99 493,985.68 415,661.04 78,324.64 20,704,727.36
89 20,704,727.36 493,985.68 414,094.55 79,891.13 20,624,836.23
90 20,624,836.23 493,985.68 412,496.72 81,488.95 20,543,347.28
91 20,543,347.28 493,985.68 410,866.95 83,118.73 20,460,228.55
92 20,460,228.55 493,985.68 409,204.57 84,781.10 20,375,447.4593 20,375,447.45 493,985.68 407,508.95 86,476.73 20,288,970.72
94 20,288,970.72 493,985.68 405,779.41 88,206.26 20,200,764.46
95 20,200,764.46 493,985.68 404,015.29 89,970.39 20,110,794.07
96 20,110,794.07 493,985.68 402,215.88 91,769.79 20,019,024.28
97 20,019,024.28 493,985.68 400,380.49 93,605.19 19,925,419.09
98 19,925,419.09 493,985.68 398,508.38 95,477.29 19,829,941.80
99 19,829,941.80 493,985.68 396,598.84 97,386.84 19,732,554.96
100 19,732,554.96 493,985.68 394,651.10 99,334.58 19,633,220.38
101 19,633,220.38 493,985.68 392,664.41 101,321.27 19,531,899.11
102 19,531,899.11 493,985.68 390,637.98 103,347.69 19,428,551.42
103 19,428,551.42 493,985.68 388,571.03 105,414.65 19,323,136.77
104 19,323,136.77 493,985.68 386,462.74 107,522.94 19,215,613.84105 19,215,613.84 493,985.68 384,312.28 109,673.40 19,105,940.44
106 19,105,940.44 493,985.68 382,118.81 111,866.87 18,994,073.57
107 18,994,073.57 493,985.68 379,881.47 114,104.20 18,879,969.37
108 18,879,969.37 493,985.68 377,599.39 116,386.29 18,763,583.08
109 18,763,583.08 493,985.68 375,271.66 118,714.01 18,644,869.06
110 18,644,869.06 493,985.68 372,897.38 121,088.29 18,523,780.77
111 18,523,780.77 493,985.68 370,475.62 123,510.06 18,400,270.71
112 18,400,270.71 493,985.68 368,005.41 125,980.26 18,274,290.45
113 18,274,290.45 493,985.68 365,485.81 128,499.87 18,145,790.58
114 18,145,790.58 493,985.68 362,915.81 131,069.86 18,014,720.72
115 18,014,720.72 493,985.68 360,294.41 133,691.26 17,881,029.46
116 17,881,029.46 493,985.68 357,620.59 136,365.09 17,744,664.37117 17,744,664.37 493,985.68 354,893.29 139,092.39 17,605,571.99
118 17,605,571.99 493,985.68 352,111.44 141,874.24 17,463,697.75
119 17,463,697.75 493,985.68 349,273.96 144,711.72 17,318,986.03
120 17,318,986.03 493,985.68 346,379.72 147,605.95 17,171,380.08
121 17,171,380.08 493,985.68 343,427.60 150,558.07 17,020,822.00
122 17,020,822.00 493,985.68 340,416.44 153,569.24 16,867,252.77
123 16,867,252.77 493,985.68 337,345.06 156,640.62 16,710,612.15
124 16,710,612.15 493,985.68 334,212.24 159,773.43 16,550,838.71
125 16,550,838.71 493,985.68 331,016.77 162,968.90 16,387,869.81
126 16,387,869.81 493,985.68 327,757.40 166,228.28 16,221,641.53
127 16,221,641.53 493,985.68 324,432.83 169,552.84 16,052,088.69
128 16,052,088.69 493,985.68 321,041.77 172,943.90 15,879,144.79129 15,879,144.79 493,985.68 317,582.90 176,402.78 15,702,742.01
130 15,702,742.01 493,985.68 314,054.84 179,930.84 15,522,811.17
131 15,522,811.17 493,985.68 310,456.22 183,529.45 15,339,281.72
132 15,339,281.72 493,985.68 306,785.63 187,200.04 15,152,081.68
133 15,152,081.68 493,985.68 303,041.63 190,944.04 14,961,137.64
134 14,961,137.64 493,985.68 299,222.75 194,762.92 14,766,374.72
135 14,766,374.72 493,985.68 295,327.49 198,658.18 14,567,716.54
8/18/2019 AMORTIZACION Planilla
5/88
136 14,567,716.54 493,985.68 291,354.33 202,631.34 14,365,085.19
137 14,365,085.19 493,985.68 287,301.70 206,683.97 14,158,401.22
138 14,158,401.22 493,985.68 283,168.02 210,817.65 13,947,583.57
139 13,947,583.57 493,985.68 278,951.67 215,034.00 13,732,549.57
140 13,732,549.57 493,985.68 274,650.99 219,334.68 13,513,214.88
141 13,513,214.88 493,985.68 270,264.30 223,721.38 13,289,493.51
142 13,289,493.51 493,985.68 265,789.87 228,195.81 13,061,297.70143 13,061,297.70 493,985.68 261,225.95 232,759.72 12,828,537.98
144 12,828,537.98 493,985.68 256,570.76 237,414.92 12,591,123.06
145 12,591,123.06 493,985.68 251,822.46 242,163.21 12,348,959.85
146 12,348,959.85 493,985.68 246,979.20 247,006.48 12,101,953.37
147 12,101,953.37 493,985.68 242,039.07 251,946.61 11,850,006.76
148 11,850,006.76 493,985.68 237,000.14 256,985.54 11,593,021.22
149 11,593,021.22 493,985.68 231,860.42 262,125.25 11,330,895.97
150 11,330,895.97 493,985.68 226,617.92 267,367.76 11,063,528.22
151 11,063,528.22 493,985.68 221,270.56 272,715.11 10,790,813.11
152 10,790,813.11 493,985.68 215,816.26 278,169.41 10,512,643.69
153 10,512,643.69 493,985.68 210,252.87 283,732.80 10,228,910.89
154 10,228,910.89 493,985.68 204,578.22 289,407.46 9,939,503.43155 9,939,503.43 493,985.68 198,790.07 295,195.61 9,644,307.83
156 9,644,307.83 493,985.68 192,886.16 301,099.52 9,343,208.31
157 9,343,208.31 493,985.68 186,864.17 307,121.51 9,036,086.80
158 9,036,086.80 493,985.68 180,721.74 313,263.94 8,722,822.86
159 8,722,822.86 493,985.68 174,456.46 319,529.22 8,403,293.64
160 8,403,293.64 493,985.68 168,065.87 325,919.80 8,077,373.84
161 8,077,373.84 493,985.68 161,547.48 332,438.20 7,744,935.64
162 7,744,935.64 493,985.68 154,898.71 339,086.96 7,405,848.68
163 7,405,848.68 493,985.68 148,116.97 345,868.70 7,059,979.98
164 7,059,979.98 493,985.68 141,199.60 352,786.08 6,707,193.90
165 6,707,193.90 493,985.68 134,143.88 359,841.80 6,347,352.11
166 6,347,352.11 493,985.68 126,947.04 367,038.63 5,980,313.47167 5,980,313.47 493,985.68 119,606.27 374,379.41 5,605,934.07
168 5,605,934.07 493,985.68 112,118.68 381,866.99 5,224,067.07
169 5,224,067.07 493,985.68 104,481.34 389,504.33 4,834,562.74
170 4,834,562.74 493,985.68 96,691.25 397,294.42 4,437,268.32
171 4,437,268.32 493,985.68 88,745.37 405,240.31 4,032,028.01
172 4,032,028.01 493,985.68 80,640.56 413,345.11 3,618,682.90
173 3,618,682.90 493,985.68 72,373.66 421,612.02 3,197,070.88
174 3,197,070.88 493,985.68 63,941.42 430,044.26 2,767,026.62
175 2,767,026.62 493,985.68 55,340.53 438,645.14 2,328,381.48
176 2,328,381.48 493,985.68 46,567.63 447,418.05 1,880,963.43
177 1,880,963.43 493,985.68 37,619.27 456,366.41 1,424,597.03
178 1,424,597.03 493,985.68 28,491.94 465,493.73 959,103.29179 959,103.29 493,985.68 19,182.07 474,803.61 484,299.68
180 484,299.68 493,985.68 9,685.99 484,299.68 (0.0
TOTAL 88,917,421.54 64,917,421.54 24,000,000.00
0.00
IR AL INICIO DE LA TABLA
8/18/2019 AMORTIZACION Planilla
6/88
AMORTIZACIÓN CON CUOTA CONSTANTE Y PAGO EXTRA
VALOR DE LA DEUDA 24,000,000.00TASA DE INTERES 2.00%
CUOTAS E!TRAS PACTADAS
PERIODO VALOR
0 0.00
0 0.00
VALOR DE LA CUOTA 493,985.68
n SALDO INICIAL CUOTA INTERESES AMORTIZACIÓN 1 24,000,000.00 493,985.68 480,000.00 13,985.68
2 23,986,014.32 493,985.68 479,720.29 14,265.39
3 23,971,748.94 493,985.68 479,434.98 14,550.70
4 23,957,198.24 493,985.68 479,143.96 14,841.71
5 23,942,356.53 493,985.68 478,847.13 15,138.54
6 23,927,217.98 493,985.68 478,544.36 15,441.32
7 23,911,776.67 493,985.68 478,235.53 15,750.14
8 23,896,026.53 493,985.68 477,920.53 16,065.14
9 23,879,961.38 493,985.68 477,599.23 16,386.45
10 23,863,574.94 493,985.68 477,271.50 16,714.18
11 23,846,860.76 493,985.68 476,937.22 17,048.46
12 23,829,812.30 493,985.68 476,596.25 17,389.4313 23,812,422.87 493,985.68 476,248.46 17,737.22
14 23,794,685.65 493,985.68 475,893.71 18,091.96
15 23,776,593.69 493,985.68 475,531.87 18,453.80
16 23,758,139.89 493,985.68 475,162.80 18,822.88
17 23,739,317.01 493,985.68 474,786.34 19,199.33
18 23,720,117.68 493,985.68 474,402.35 19,583.32
19 23,700,534.35 493,985.68 474,010.69 19,974.99
20 23,680,559.37 493,985.68 473,611.19 20,374.49
21 23,660,184.88 493,985.68 473,203.70 20,781.98
22 23,639,402.90 493,985.68 472,788.06 21,197.62
23 23,618,205.28 493,985.68 472,364.11 21,621.57
24 23,596,583.71 493,985.68 471,931.67 22,054.0025 23,574,529.71 493,985.68 471,490.59 22,495.08
26 23,552,034.63 493,985.68 471,040.69 22,944.98
27 23,529,089.65 493,985.68 470,581.79 23,403.88
28 23,505,685.77 493,985.68 470,113.72 23,871.96
29 23,481,813.81 493,985.68 469,636.28 24,349.40
30 23,457,464.41 493,985.68 469,149.29 24,836.39
31 23,432,628.02 493,985.68 468,652.56 25,333.11
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
8/18/2019 AMORTIZACION Planilla
7/88
32 23,407,294.91 493,985.68 468,145.90 25,839.78
33 23,381,455.13 493,985.68 467,629.10 26,356.57
34 23,355,098.56 493,985.68 467,101.97 26,883.70
35 23,328,214.85 493,985.68 466,564.30 27,421.38
36 23,300,793.47 493,985.68 466,015.87 27,969.81
37 23,272,823.67 493,985.68 465,456.47 28,529.20
38 23,244,294.47 493,985.68 464,885.89 29,099.7939 23,215,194.68 493,985.68 464,303.89 29,681.78
40 23,185,512.90 493,985.68 463,710.26 30,275.42
41 23,155,237.48 493,985.68 463,104.75 30,880.93
42 23,124,356.56 493,985.68 462,487.13 31,498.54
43 23,092,858.01 493,985.68 461,857.16 32,128.51
44 23,060,729.50 493,985.68 461,214.59 32,771.09
45 23,027,958.41 493,985.68 460,559.17 33,426.51
46 22,994,531.90 493,985.68 459,890.64 34,095.04
47 22,960,436.87 493,985.68 459,208.74 34,776.94
48 22,925,659.93 493,985.68 458,513.20 35,472.48
49 22,890,187.45 493,985.68 457,803.75 36,181.93
50 22,854,005.53 493,985.68 457,080.11 36,905.5651 22,817,099.96 493,985.68 456,342.00 37,643.68
52 22,779,456.29 493,985.68 455,589.13 38,396.55
53 22,741,059.74 493,985.68 454,821.19 39,164.48
54 22,701,895.26 493,985.68 454,037.91 39,947.77
55 22,661,947.49 493,985.68 453,238.95 40,746.73
56 22,621,200.76 493,985.68 452,424.02 41,561.66
57 22,579,639.10 493,985.68 451,592.78 42,392.89
58 22,537,246.21 493,985.68 450,744.92 43,240.75
59 22,494,005.46 493,985.68 449,880.11 44,105.57
60 22,449,899.89 493,985.68 448,998.00 44,987.68
61 22,404,912.21 493,985.68 448,098.24 45,887.43
62 22,359,024.78 493,985.68 447,180.50 46,805.1863 22,312,219.60 493,985.68 446,244.39 47,741.28
64 22,264,478.32 493,985.68 445,289.57 48,696.11
65 22,215,782.21 493,985.68 444,315.64 49,670.03
66 22,166,112.18 493,985.68 443,322.24 50,663.43
67 22,115,448.75 493,985.68 442,308.97 51,676.70
68 22,063,772.05 493,985.68 441,275.44 52,710.23
69 22,011,061.81 493,985.68 440,221.24 53,764.44
70 21,957,297.38 493,985.68 439,145.95 54,839.73
71 21,902,457.65 493,985.68 438,049.15 55,936.52
72 21,846,521.13 493,985.68 436,930.42 57,055.25
73 21,789,465.87 493,985.68 435,789.32 58,196.36
74 21,731,269.51 493,985.68 434,625.39 59,360.2875 21,671,909.23 493,985.68 433,438.18 60,547.49
76 21,611,361.74 493,985.68 432,227.23 61,758.44
77 21,549,603.30 493,985.68 430,992.07 62,993.61
78 21,486,609.69 493,985.68 429,732.19 64,253.48
79 21,422,356.21 493,985.68 428,447.12 65,538.55
80 21,356,817.66 493,985.68 427,136.35 66,849.32
81 21,289,968.34 493,985.68 425,799.37 68,186.31
8/18/2019 AMORTIZACION Planilla
8/88
82 21,221,782.03 493,985.68 424,435.64 69,550.03
83 21,152,231.99 493,985.68 423,044.64 70,941.04
84 21,081,290.96 493,985.68 421,625.82 72,359.86
85 21,008,931.10 493,985.68 420,178.62 73,807.05
86 20,935,124.05 493,985.68 418,702.48 75,283.19
87 20,859,840.85 493,985.68 417,196.82 76,788.86
88 20,783,051.99 493,985.68 415,661.04 78,324.6489 20,704,727.36 493,985.68 414,094.55 79,891.13
90 20,624,836.23 493,985.68 412,496.72 81,488.95
91 20,543,347.28 493,985.68 410,866.95 83,118.73
92 20,460,228.55 493,985.68 409,204.57 84,781.10
93 20,375,447.45 493,985.68 407,508.95 86,476.73
94 20,288,970.72 493,985.68 405,779.41 88,206.26
95 20,200,764.46 493,985.68 404,015.29 89,970.39
96 20,110,794.07 493,985.68 402,215.88 91,769.79
97 20,019,024.28 493,985.68 400,380.49 93,605.19
98 19,925,419.09 493,985.68 398,508.38 95,477.29
99 19,829,941.80 493,985.68 396,598.84 97,386.84
100 19,732,554.96 493,985.68 394,651.10 99,334.58101 19,633,220.38 493,985.68 392,664.41 101,321.27
102 19,531,899.11 493,985.68 390,637.98 103,347.69
103 19,428,551.42 493,985.68 388,571.03 105,414.65
104 19,323,136.77 493,985.68 386,462.74 107,522.94
105 19,215,613.84 493,985.68 384,312.28 109,673.40
106 19,105,940.44 493,985.68 382,118.81 111,866.87
107 18,994,073.57 493,985.68 379,881.47 114,104.20
108 18,879,969.37 493,985.68 377,599.39 116,386.29
109 18,763,583.08 493,985.68 375,271.66 118,714.01
110 18,644,869.06 493,985.68 372,897.38 121,088.29
111 18,523,780.77 493,985.68 370,475.62 123,510.06
112 18,400,270.71 493,985.68 368,005.41 125,980.26113 18,274,290.45 493,985.68 365,485.81 128,499.87
114 18,145,790.58 493,985.68 362,915.81 131,069.86
115 18,014,720.72 493,985.68 360,294.41 133,691.26
116 17,881,029.46 493,985.68 357,620.59 136,365.09
117 17,744,664.37 493,985.68 354,893.29 139,092.39
118 17,605,571.99 493,985.68 352,111.44 141,874.24
119 17,463,697.75 493,985.68 349,273.96 144,711.72
120 17,318,986.03 493,985.68 346,379.72 147,605.95
121 17,171,380.08 493,985.68 343,427.60 150,558.07
122 17,020,822.00 493,985.68 340,416.44 153,569.24
123 16,867,252.77 493,985.68 337,345.06 156,640.62
124 16,710,612.15 493,985.68 334,212.24 159,773.43125 16,550,838.71 493,985.68 331,016.77 162,968.90
126 16,387,869.81 493,985.68 327,757.40 166,228.28
127 16,221,641.53 493,985.68 324,432.83 169,552.84
128 16,052,088.69 493,985.68 321,041.77 172,943.90
129 15,879,144.79 493,985.68 317,582.90 176,402.78
130 15,702,742.01 493,985.68 314,054.84 179,930.84
131 15,522,811.17 493,985.68 310,456.22 183,529.45
8/18/2019 AMORTIZACION Planilla
9/88
132 15,339,281.72 493,985.68 306,785.63 187,200.04
133 15,152,081.68 493,985.68 303,041.63 190,944.04
134 14,961,137.64 493,985.68 299,222.75 194,762.92
135 14,766,374.72 493,985.68 295,327.49 198,658.18
136 14,567,716.54 493,985.68 291,354.33 202,631.34
137 14,365,085.19 493,985.68 287,301.70 206,683.97
138 14,158,401.22 493,985.68 283,168.02 210,817.65139 13,947,583.57 493,985.68 278,951.67 215,034.00
140 13,732,549.57 493,985.68 274,650.99 219,334.68
141 13,513,214.88 493,985.68 270,264.30 223,721.38
142 13,289,493.51 493,985.68 265,789.87 228,195.81
143 13,061,297.70 493,985.68 261,225.95 232,759.72
144 12,828,537.98 493,985.68 256,570.76 237,414.92
145 12,591,123.06 493,985.68 251,822.46 242,163.21
146 12,348,959.85 493,985.68 246,979.20 247,006.48
147 12,101,953.37 493,985.68 242,039.07 251,946.61
148 11,850,006.76 493,985.68 237,000.14 256,985.54
149 11,593,021.22 493,985.68 231,860.42 262,125.25
150 11,330,895.97 493,985.68 226,617.92 267,367.76151 11,063,528.22 493,985.68 221,270.56 272,715.11
152 10,790,813.11 493,985.68 215,816.26 278,169.41
153 10,512,643.69 493,985.68 210,252.87 283,732.80
154 10,228,910.89 493,985.68 204,578.22 289,407.46
155 9,939,503.43 493,985.68 198,790.07 295,195.61
156 9,644,307.83 493,985.68 192,886.16 301,099.52
157 9,343,208.31 493,985.68 186,864.17 307,121.51
158 9,036,086.80 493,985.68 180,721.74 313,263.94
159 8,722,822.86 493,985.68 174,456.46 319,529.22
160 8,403,293.64 493,985.68 168,065.87 325,919.80
161 8,077,373.84 493,985.68 161,547.48 332,438.20
162 7,744,935.64 493,985.68 154,898.71 339,086.96163 7,405,848.68 493,985.68 148,116.97 345,868.70
164 7,059,979.98 493,985.68 141,199.60 352,786.08
165 6,707,193.90 493,985.68 134,143.88 359,841.80
166 6,347,352.11 493,985.68 126,947.04 367,038.63
167 5,980,313.47 493,985.68 119,606.27 374,379.41
168 5,605,934.07 493,985.68 112,118.68 381,866.99
169 5,224,067.07 493,985.68 104,481.34 389,504.33
170 4,834,562.74 493,985.68 96,691.25 397,294.42
171 4,437,268.32 493,985.68 88,745.37 405,240.31
172 4,032,028.01 493,985.68 80,640.56 413,345.11
173 3,618,682.90 493,985.68 72,373.66 421,612.02
174 3,197,070.88 493,985.68 63,941.42 430,044.26175 2,767,026.62 493,985.68 55,340.53 438,645.14
176 2,328,381.48 493,985.68 46,567.63 447,418.05
177 1,880,963.43 493,985.68 37,619.27 456,366.41
178 1,424,597.03 493,985.68 28,491.94 465,493.73
179 959,103.29 493,985.68 19,182.07 474,803.61
180 484,299.68 493,985.68 9,685.99 484,299.68
TOTAL 88,917,421.54 64,917,421.54 24,000,000.00
8/18/2019 AMORTIZACION Planilla
10/88
0.00
IR AL INICIO DE LA TABLA
8/18/2019 AMORTIZACION Planilla
11/88
CTADO
4
SALDO FINAL23,986,014.32
23,971,748.94
23,957,198.24
23,942,356.53
23,927,217.98
23,911,776.67
23,896,026.53
23,879,961.38
23,863,574.94
23,846,860.76
23,829,812.30
23,812,422.8723,794,685.65
23,776,593.69
23,758,139.89
23,739,317.01
23,720,117.68
23,700,534.35
23,680,559.37
23,660,184.88
23,639,402.90
23,618,205.28
23,596,583.71
23,574,529.7123,552,034.63
23,529,089.65
23,505,685.77
23,481,813.81
23,457,464.41
23,432,628.02
23,407,294.91
8/18/2019 AMORTIZACION Planilla
12/88
23,381,455.13
23,355,098.56
23,328,214.85
23,300,793.47
23,272,823.67
23,244,294.47
23,215,194.6823,185,512.90
23,155,237.48
23,124,356.56
23,092,858.01
23,060,729.50
23,027,958.41
22,994,531.90
22,960,436.87
22,925,659.93
22,890,187.45
22,854,005.53
22,817,099.9622,779,456.29
22,741,059.74
22,701,895.26
22,661,947.49
22,621,200.76
22,579,639.10
22,537,246.21
22,494,005.46
22,449,899.89
22,404,912.21
22,359,024.78
22,312,219.6022,264,478.32
22,215,782.21
22,166,112.18
22,115,448.75
22,063,772.05
22,011,061.81
21,957,297.38
21,902,457.65
21,846,521.13
21,789,465.87
21,731,269.51
21,671,909.2321,611,361.74
21,549,603.30
21,486,609.69
21,422,356.21
21,356,817.66
21,289,968.34
21,221,782.03
8/18/2019 AMORTIZACION Planilla
13/88
21,152,231.99
21,081,290.96
21,008,931.10
20,935,124.05
20,859,840.85
20,783,051.99
20,704,727.3620,624,836.23
20,543,347.28
20,460,228.55
20,375,447.45
20,288,970.72
20,200,764.46
20,110,794.07
20,019,024.28
19,925,419.09
19,829,941.80
19,732,554.96
19,633,220.3819,531,899.11
19,428,551.42
19,323,136.77
19,215,613.84
19,105,940.44
18,994,073.57
18,879,969.37
18,763,583.08
18,644,869.06
18,523,780.77
18,400,270.71
18,274,290.4518,145,790.58
18,014,720.72
17,881,029.46
17,744,664.37
17,605,571.99
17,463,697.75
17,318,986.03
17,171,380.08
17,020,822.00
16,867,252.77
16,710,612.15
16,550,838.7116,387,869.81
16,221,641.53
16,052,088.69
15,879,144.79
15,702,742.01
15,522,811.17
15,339,281.72
8/18/2019 AMORTIZACION Planilla
14/88
15,152,081.68
14,961,137.64
14,766,374.72
14,567,716.54
14,365,085.19
14,158,401.22
13,947,583.5713,732,549.57
13,513,214.88
13,289,493.51
13,061,297.70
12,828,537.98
12,591,123.06
12,348,959.85
12,101,953.37
11,850,006.76
11,593,021.22
11,330,895.97
11,063,528.2210,790,813.11
10,512,643.69
10,228,910.89
9,939,503.43
9,644,307.83
9,343,208.31
9,036,086.80
8,722,822.86
8,403,293.64
8,077,373.84
7,744,935.64
7,405,848.687,059,979.98
6,707,193.90
6,347,352.11
5,980,313.47
5,605,934.07
5,224,067.07
4,834,562.74
4,437,268.32
4,032,028.01
3,618,682.90
3,197,070.88
2,767,026.622,328,381.48
1,880,963.43
1,424,597.03
959,103.29
484,299.68
(0.00
8/18/2019 AMORTIZACION Planilla
15/88
8/18/2019 AMORTIZACION Planilla
16/88
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
CUOTAS EXTRAS NO PACTADAS
PERIODO VALOR SALDO "INAL
2 1,000,000.00 22,971,748.94
VALOR DE LA CUOTA 493,985.68
VALOR DE LA CUOTA 473,378.68
n CUOTA INTERESES AMORTIZACIÓN SALDO FINAL
1 24,000,000.00 493,985.68 480,000.00 13,985.68 23,986,014.32
2 23,986,014.32 1,493,985.68 479,720.29 1,014,265.39 22,971,748.94
3 22,971,748.94 473,378.68 459,434.98 13,943.70 22,957,805.23
4 22,957,805.23 473,378.68 459,156.10 14,222.58 22,943,582.66
5 22,943,582.66 473,378.68 458,871.65 14,507.03 22,929,075.63
6 22,929,075.63 473,378.68 458,581.51 14,797.17 22,914,278.46
7 22,914,278.46 473,378.68 458,285.57 15,093.11 22,899,185.35
8 22,899,185.35 473,378.68 457,983.71 15,394.97 22,883,790.37
9 22,883,790.37 473,378.68 457,675.81 15,702.87 22,868,087.5010 22,868,087.50 473,378.68 457,361.75 16,016.93 22,852,070.57
11 22,852,070.57 473,378.68 457,041.41 16,337.27 22,835,733.29
12 22,835,733.29 473,378.68 456,714.67 16,664.02 22,819,069.28
13 22,819,069.28 473,378.68 456,381.39 16,997.30 22,802,071.98
14 22,802,071.98 473,378.68 456,041.44 17,337.24 22,784,734.74
15 22,784,734.74 473,378.68 455,694.69 17,683.99 22,767,050.75
16 22,767,050.75 473,378.68 455,341.02 18,037.67 22,749,013.09
17 22,749,013.09 473,378.68 454,980.26 18,398.42 22,730,614.67
18 22,730,614.67 473,378.68 454,612.29 18,766.39 22,711,848.28
19 22,711,848.28 473,378.68 454,236.97 19,141.72 22,692,706.56
20 22,692,706.56 473,378.68 453,854.13 19,524.55 22,673,182.01
21 22,673,182.01 473,378.68 453,463.64 19,915.04 22,653,266.9722 22,653,266.97 473,378.68 453,065.34 20,313.34 22,632,953.63
23 22,632,953.63 473,378.68 452,659.07 20,719.61 22,612,234.02
24 22,612,234.02 473,378.68 452,244.68 21,134.00 22,591,100.02
25 22,591,100.02 473,378.68 451,822.00 21,556.68 22,569,543.34
26 22,569,543.34 473,378.68 451,390.87 21,987.81 22,547,555.52
27 22,547,555.52 473,378.68 450,951.11 22,427.57 22,525,127.95
28 22,525,127.95 473,378.68 450,502.56 22,876.12 22,502,251.83
AMORTIZACIÓN CON CUOTA CONSTANTE, CUOTA EXTRA NO PACTADA Y MODIFICACION DE CUOTA
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
SALDO INICIAL
8/18/2019 AMORTIZACION Planilla
17/88
29 22,502,251.83 473,378.68 450,045.04 23,333.65 22,478,918.18
30 22,478,918.18 473,378.68 449,578.36 23,800.32 22,455,117.87
31 22,455,117.87 473,378.68 449,102.36 24,276.32 22,430,841.54
32 22,430,841.54 473,378.68 448,616.83 24,761.85 22,406,079.69
33 22,406,079.69 473,378.68 448,121.59 25,257.09 22,380,822.60
34 22,380,822.60 473,378.68 447,616.45 25,762.23 22,355,060.37
35 22,355,060.37 473,378.68 447,101.21 26,277.47 22,328,782.9036 22,328,782.90 473,378.68 446,575.66 26,803.02 22,301,979.87
37 22,301,979.87 473,378.68 446,039.60 27,339.08 22,274,640.79
38 22,274,640.79 473,378.68 445,492.82 27,885.87 22,246,754.92
39 22,246,754.92 473,378.68 444,935.10 28,443.58 22,218,311.34
40 22,218,311.34 473,378.68 444,366.23 29,012.45 22,189,298.89
41 22,189,298.89 473,378.68 443,785.98 29,592.70 22,159,706.18
42 22,159,706.18 473,378.68 443,194.12 30,184.56 22,129,521.62
43 22,129,521.62 473,378.68 442,590.43 30,788.25 22,098,733.38
44 22,098,733.38 473,378.68 441,974.67 31,404.01 22,067,329.36
45 22,067,329.36 473,378.68 441,346.59 32,032.09 22,035,297.27
46 22,035,297.27 473,378.68 440,705.95 32,672.74 22,002,624.53
47 22,002,624.53 473,378.68 440,052.49 33,326.19 21,969,298.3448 21,969,298.34 473,378.68 439,385.97 33,992.71 21,935,305.62
49 21,935,305.62 473,378.68 438,706.11 34,672.57 21,900,633.06
50 21,900,633.06 473,378.68 438,012.66 35,366.02 21,865,267.04
51 21,865,267.04 473,378.68 437,305.34 36,073.34 21,829,193.69
52 21,829,193.69 473,378.68 436,583.87 36,794.81 21,792,398.89
53 21,792,398.89 473,378.68 435,847.98 37,530.70 21,754,868.18
54 21,754,868.18 473,378.68 435,097.36 38,281.32 21,716,586.86
55 21,716,586.86 473,378.68 434,331.74 39,046.94 21,677,539.92
56 21,677,539.92 473,378.68 433,550.80 39,827.88 21,637,712.04
57 21,637,712.04 473,378.68 432,754.24 40,624.44 21,597,087.60
58 21,597,087.60 473,378.68 431,941.75 41,436.93 21,555,650.67
59 21,555,650.67 473,378.68 431,113.01 42,265.67 21,513,385.0060 21,513,385.00 473,378.68 430,267.70 43,110.98 21,470,274.02
61 21,470,274.02 473,378.68 429,405.48 43,973.20 21,426,300.81
62 21,426,300.81 473,378.68 428,526.02 44,852.67 21,381,448.15
63 21,381,448.15 473,378.68 427,628.96 45,749.72 21,335,698.43
64 21,335,698.43 473,378.68 426,713.97 46,664.71 21,289,033.72
65 21,289,033.72 473,378.68 425,780.67 47,598.01 21,241,435.71
66 21,241,435.71 473,378.68 424,828.71 48,549.97 21,192,885.74
67 21,192,885.74 473,378.68 423,857.71 49,520.97 21,143,364.78
68 21,143,364.78 473,378.68 422,867.30 50,511.39 21,092,853.39
69 21,092,853.39 473,378.68 421,857.07 51,521.61 21,041,331.78
70 21,041,331.78 473,378.68 420,826.64 52,552.05 20,988,779.73
71 20,988,779.73 473,378.68 419,775.59 53,603.09 20,935,176.6472 20,935,176.64 473,378.68 418,703.53 54,675.15 20,880,501.49
73 20,880,501.49 473,378.68 417,610.03 55,768.65 20,824,732.84
74 20,824,732.84 473,378.68 416,494.66 56,884.02 20,767,848.82
75 20,767,848.82 473,378.68 415,356.98 58,021.71 20,709,827.11
76 20,709,827.11 473,378.68 414,196.54 59,182.14 20,650,644.97
77 20,650,644.97 473,378.68 413,012.90 60,365.78 20,590,279.19
78 20,590,279.19 473,378.68 411,805.58 61,573.10 20,528,706.09
8/18/2019 AMORTIZACION Planilla
18/88
79 20,528,706.09 473,378.68 410,574.12 62,804.56 20,465,901.53
80 20,465,901.53 473,378.68 409,318.03 64,060.65 20,401,840.88
81 20,401,840.88 473,378.68 408,036.82 65,341.86 20,336,499.02
82 20,336,499.02 473,378.68 406,729.98 66,648.70 20,269,850.32
83 20,269,850.32 473,378.68 405,397.01 67,981.68 20,201,868.64
84 20,201,868.64 473,378.68 404,037.37 69,341.31 20,132,527.33
85 20,132,527.33 473,378.68 402,650.55 70,728.14 20,061,799.2086 20,061,799.20 473,378.68 401,235.98 72,142.70 19,989,656.50
87 19,989,656.50 473,378.68 399,793.13 73,585.55 19,916,070.95
88 19,916,070.95 473,378.68 398,321.42 75,057.26 19,841,013.68
89 19,841,013.68 473,378.68 396,820.27 76,558.41 19,764,455.28
90 19,764,455.28 473,378.68 395,289.11 78,089.58 19,686,365.70
91 19,686,365.70 473,378.68 393,727.31 79,651.37 19,606,714.33
92 19,606,714.33 473,378.68 392,134.29 81,244.40 19,525,469.94
93 19,525,469.94 473,378.68 390,509.40 82,869.28 19,442,600.66
94 19,442,600.66 473,378.68 388,852.01 84,526.67 19,358,073.99
95 19,358,073.99 473,378.68 387,161.48 86,217.20 19,271,856.78
96 19,271,856.78 473,378.68 385,437.14 87,941.55 19,183,915.24
97 19,183,915.24 473,378.68 383,678.30 89,700.38 19,094,214.8698 19,094,214.86 473,378.68 381,884.30 91,494.38 19,002,720.48
99 19,002,720.48 473,378.68 380,054.41 93,324.27 18,909,396.21
100 18,909,396.21 473,378.68 378,187.92 95,190.76 18,814,205.45
101 18,814,205.45 473,378.68 376,284.11 97,094.57 18,717,110.88
102 18,717,110.88 473,378.68 374,342.22 99,036.46 18,618,074.41
103 18,618,074.41 473,378.68 372,361.49 101,017.19 18,517,057.22
104 18,517,057.22 473,378.68 370,341.14 103,037.54 18,414,019.68
105 18,414,019.68 473,378.68 368,280.39 105,098.29 18,308,921.39
106 18,308,921.39 473,378.68 366,178.43 107,200.25 18,201,721.14
107 18,201,721.14 473,378.68 364,034.42 109,344.26 18,092,376.88
108 18,092,376.88 473,378.68 361,847.54 111,531.14 17,980,845.74
109 17,980,845.74 473,378.68 359,616.91 113,761.77 17,867,083.97110 17,867,083.97 473,378.68 357,341.68 116,037.00 17,751,046.97
111 17,751,046.97 473,378.68 355,020.94 118,357.74 17,632,689.22
112 17,632,689.22 473,378.68 352,653.78 120,724.90 17,511,964.33
113 17,511,964.33 473,378.68 350,239.29 123,139.40 17,388,824.93
114 17,388,824.93 473,378.68 347,776.50 125,602.18 17,263,222.75
115 17,263,222.75 473,378.68 345,264.45 128,114.23 17,135,108.52
116 17,135,108.52 473,378.68 342,702.17 130,676.51 17,004,432.01
117 17,004,432.01 473,378.68 340,088.64 133,290.04 16,871,141.97
118 16,871,141.97 473,378.68 337,422.84 135,955.84 16,735,186.13
119 16,735,186.13 473,378.68 334,703.72 138,674.96 16,596,511.17
120 16,596,511.17 473,378.68 331,930.22 141,448.46 16,455,062.71
121 16,455,062.71 473,378.68 329,101.25 144,277.43 16,310,785.28122 16,310,785.28 473,378.68 326,215.71 147,162.98 16,163,622.31
123 16,163,622.31 473,378.68 323,272.45 150,106.24 16,013,516.07
124 16,013,516.07 473,378.68 320,270.32 153,108.36 15,860,407.71
125 15,860,407.71 473,378.68 317,208.15 156,170.53 15,704,237.18
126 15,704,237.18 473,378.68 314,084.74 159,293.94 15,544,943.24
127 15,544,943.24 473,378.68 310,898.86 162,479.82 15,382,463.43
128 15,382,463.43 473,378.68 307,649.27 165,729.41 15,216,734.01
8/18/2019 AMORTIZACION Planilla
19/88
129 15,216,734.01 473,378.68 304,334.68 169,044.00 15,047,690.01
130 15,047,690.01 473,378.68 300,953.80 172,424.88 14,875,265.13
131 14,875,265.13 473,378.68 297,505.30 175,873.38 14,699,391.75
132 14,699,391.75 473,378.68 293,987.84 179,390.85 14,520,000.91
133 14,520,000.91 473,378.68 290,400.02 182,978.66 14,337,022.24
134 14,337,022.24 473,378.68 286,740.44 186,638.24 14,150,384.01
135 14,150,384.01 473,378.68 283,007.68 190,371.00 13,960,013.00136 13,960,013.00 473,378.68 279,200.26 194,178.42 13,765,834.58
137 13,765,834.58 473,378.68 275,316.69 198,061.99 13,567,772.59
138 13,567,772.59 473,378.68 271,355.45 202,023.23 13,365,749.36
139 13,365,749.36 473,378.68 267,314.99 206,063.69 13,159,685.67
140 13,159,685.67 473,378.68 263,193.71 210,184.97 12,949,500.70
141 12,949,500.70 473,378.68 258,990.01 214,388.67 12,735,112.03
142 12,735,112.03 473,378.68 254,702.24 218,676.44 12,516,435.59
143 12,516,435.59 473,378.68 250,328.71 223,049.97 12,293,385.62
144 12,293,385.62 473,378.68 245,867.71 227,510.97 12,065,874.65
145 12,065,874.65 473,378.68 241,317.49 232,061.19 11,833,813.46
146 11,833,813.46 473,378.68 236,676.27 236,702.41 11,597,111.05
147 11,597,111.05 473,378.68 231,942.22 241,436.46 11,355,674.59148 11,355,674.59 473,378.68 227,113.49 246,265.19 11,109,409.40
149 11,109,409.40 473,378.68 222,188.19 251,190.49 10,858,218.91
150 10,858,218.91 473,378.68 217,164.38 256,214.30 10,602,004.60
151 10,602,004.60 473,378.68 212,040.09 261,338.59 10,340,666.01
152 10,340,666.01 473,378.68 206,813.32 266,565.36 10,074,100.65
153 10,074,100.65 473,378.68 201,482.01 271,896.67 9,802,203.98
154 9,802,203.98 473,378.68 196,044.08 277,334.60 9,524,869.38
155 9,524,869.38 473,378.68 190,497.39 282,881.29 9,241,988.09
156 9,241,988.09 473,378.68 184,839.76 288,538.92 8,953,449.17
157 8,953,449.17 473,378.68 179,068.98 294,309.70 8,659,139.47
158 8,659,139.47 473,378.68 173,182.79 300,195.89 8,358,943.58
159 8,358,943.58 473,378.68 167,178.87 306,199.81 8,052,743.77160 8,052,743.77 473,378.68 161,054.88 312,323.81 7,740,419.96
161 7,740,419.96 473,378.68 154,808.40 318,570.28 7,421,849.68
162 7,421,849.68 473,378.68 148,436.99 324,941.69 7,096,907.99
163 7,096,907.99 473,378.68 141,938.16 331,440.52 6,765,467.47
164 6,765,467.47 473,378.68 135,309.35 338,069.33 6,427,398.14
165 6,427,398.14 473,378.68 128,547.96 344,830.72 6,082,567.42
166 6,082,567.42 473,378.68 121,651.35 351,727.33 5,730,840.08
167 5,730,840.08 473,378.68 114,616.80 358,761.88 5,372,078.20
168 5,372,078.20 473,378.68 107,441.56 365,937.12 5,006,141.09
169 5,006,141.09 473,378.68 100,122.82 373,255.86 4,632,885.23
170 4,632,885.23 473,378.68 92,657.70 380,720.98 4,252,164.25
171 4,252,164.25 473,378.68 85,043.28 388,335.40 3,863,828.85172 3,863,828.85 473,378.68 77,276.58 396,102.10 3,467,726.75
173 3,467,726.75 473,378.68 69,354.53 404,024.15 3,063,702.60
174 3,063,702.60 473,378.68 61,274.05 412,104.63 2,651,597.97
175 2,651,597.97 473,378.68 53,031.96 420,346.72 2,231,251.25
176 2,231,251.25 473,378.68 44,625.02 428,753.66 1,802,497.59
177 1,802,497.59 473,378.68 36,049.95 437,328.73 1,365,168.86
178 1,365,168.86 473,378.68 27,303.38 446,075.30 919,093.56
8/18/2019 AMORTIZACION Planilla
20/88
179 919,093.56 473,378.68 18,381.87 454,996.81 464,096.75
180 464,096.75 473,378.68 9,281.93 464,096.75 (0.00
TOTAL 86,249,376.69 62,249,376.69 24,000,000.00
(0.00)
IR AL INICIO DE LA TABLA
8/18/2019 AMORTIZACION Planilla
21/88
4
8/18/2019 AMORTIZACION Planilla
22/88
8/18/2019 AMORTIZACION Planilla
23/88
8/18/2019 AMORTIZACION Planilla
24/88
8/18/2019 AMORTIZACION Planilla
25/88
8/18/2019 AMORTIZACION Planilla
26/88
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
CUOTAS EXTRAS NO PACTADAS
PERIODO NUEVO PERIODO TOTAL PERIODOS VALOR
5 133.0444 139.00 1,000,000.00
PENULTIMO PERIODO SALDO "INAL
138.00 21,697.29
VALOR DE LA CUOTA 493,985.68
VALOR DE LA ULTIMA CUOTA 22,131
n SALDO INICIAL CUOTA INTERESES AMORTIZACIÓN
1 24,000,000.00 493,985.68 480,000.00 13,985.68
2 23,986,014.32 493,985.68 479,720.29 14,265.39
3 23,971,748.94 493,985.68 479,434.98 14,550.70
4 23,957,198.24 493,985.68 479,143.96 14,841.71
5 23,942,356.53 1,493,985.68 478,847.13 1,015,138.54
6 22,927,217.98 493,985.68 458,544.36 35,441.32
7 22,891,776.67 493,985.68 457,835.53 36,150.148 22,855,626.53 493,985.68 457,112.53 36,873.14
9 22,818,753.38 493,985.68 456,375.07 37,610.61
10 22,781,142.78 493,985.68 455,622.86 38,362.82
11 22,742,779.96 493,985.68 454,855.60 39,130.08
12 22,703,649.88 493,985.68 454,073.00 39,912.68
13 22,663,737.20 493,985.68 453,274.74 40,710.93
14 22,623,026.27 493,985.68 452,460.53 41,525.15
15 22,581,501.12 493,985.68 451,630.02 42,355.65
16 22,539,145.47 493,985.68 450,782.91 43,202.77
17 22,495,942.70 493,985.68 449,918.85 44,066.82
18 22,451,875.88 493,985.68 449,037.52 44,948.16
19 22,406,927.72 493,985.68 448,138.55 45,847.1220 22,361,080.60 493,985.68 447,221.61 46,764.06
21 22,314,316.54 493,985.68 446,286.33 47,699.34
22 22,266,617.20 493,985.68 445,332.34 48,653.33
23 22,217,963.86 493,985.68 444,359.28 49,626.40
24 22,168,337.47 493,985.68 443,366.75 50,618.93
25 22,117,718.54 493,985.68 442,354.37 51,631.30
26 22,066,087.24 493,985.68 441,321.74 52,663.93
27 22,013,423.30 493,985.68 440,268.47 53,717.21
AMORTIZACIÓN CON CUOTA CONSTANTE, CUOTA EXTRA NO P MODIFICACION DEL PLAZO
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
8/18/2019 AMORTIZACION Planilla
27/88
28 21,959,706.10 493,985.68 439,194.12 54,791.55
29 21,904,914.54 493,985.68 438,098.29 55,887.38
30 21,849,027.16 493,985.68 436,980.54 57,005.13
31 21,792,022.03 493,985.68 435,840.44 58,145.23
32 21,733,876.79 493,985.68 434,677.54 59,308.14
33 21,674,568.65 493,985.68 433,491.37 60,494.30
34 21,614,074.35 493,985.68 432,281.49 61,704.1935 21,552,370.16 493,985.68 431,047.40 62,938.27
36 21,489,431.89 493,985.68 429,788.64 64,197.04
37 21,425,234.85 493,985.68 428,504.70 65,480.98
38 21,359,753.87 493,985.68 427,195.08 66,790.60
39 21,292,963.28 493,985.68 425,859.27 68,126.41
40 21,224,836.87 493,985.68 424,496.74 69,488.94
41 21,155,347.93 493,985.68 423,106.96 70,878.72
42 21,084,469.21 493,985.68 421,689.38 72,296.29
43 21,012,172.92 493,985.68 420,243.46 73,742.22
44 20,938,430.70 493,985.68 418,768.61 75,217.06
45 20,863,213.64 493,985.68 417,264.27 76,721.40
46 20,786,492.24 493,985.68 415,729.84 78,255.8347 20,708,236.41 493,985.68 414,164.73 79,820.95
48 20,628,415.46 493,985.68 412,568.31 81,417.37
49 20,546,998.10 493,985.68 410,939.96 83,045.71
50 20,463,952.38 493,985.68 409,279.05 84,706.63
51 20,379,245.76 493,985.68 407,584.92 86,400.76
52 20,292,845.00 493,985.68 405,856.90 88,128.78
53 20,204,716.22 493,985.68 404,094.32 89,891.35
54 20,114,824.87 493,985.68 402,296.50 91,689.18
55 20,023,135.69 493,985.68 400,462.71 93,522.96
56 19,929,612.73 493,985.68 398,592.25 95,393.42
57 19,834,219.31 493,985.68 396,684.39 97,301.29
58 19,736,918.02 493,985.68 394,738.36 99,247.3159 19,637,670.71 493,985.68 392,753.41 101,232.26
60 19,536,438.45 493,985.68 390,728.77 103,256.91
61 19,433,181.54 493,985.68 388,663.63 105,322.04
62 19,327,859.50 493,985.68 386,557.19 107,428.49
63 19,220,431.01 493,985.68 384,408.62 109,577.05
64 19,110,853.96 493,985.68 382,217.08 111,768.60
65 18,999,085.36 493,985.68 379,981.71 114,003.97
66 18,885,081.39 493,985.68 377,701.63 116,284.05
67 18,768,797.34 493,985.68 375,375.95 118,609.73
68 18,650,187.62 493,985.68 373,003.75 120,981.92
69 18,529,205.69 493,985.68 370,584.11 123,401.56
70 18,405,804.13 493,985.68 368,116.08 125,869.5971 18,279,934.54 493,985.68 365,598.69 128,386.98
72 18,151,547.55 493,985.68 363,030.95 130,954.72
73 18,020,592.83 493,985.68 360,411.86 133,573.82
74 17,887,019.01 493,985.68 357,740.38 136,245.29
75 17,750,773.72 493,985.68 355,015.47 138,970.20
76 17,611,803.52 493,985.68 352,236.07 141,749.60
77 17,470,053.91 493,985.68 349,401.08 144,584.60
8/18/2019 AMORTIZACION Planilla
28/88
78 17,325,469.31 493,985.68 346,509.39 147,476.29
79 17,177,993.03 493,985.68 343,559.86 150,425.81
80 17,027,567.21 493,985.68 340,551.34 153,434.33
81 16,874,132.88 493,985.68 337,482.66 156,503.02
82 16,717,629.86 493,985.68 334,352.60 159,633.08
83 16,557,996.78 493,985.68 331,159.94 162,825.74
84 16,395,171.04 493,985.68 327,903.42 166,082.2585 16,229,088.79 493,985.68 324,581.78 169,403.90
86 16,059,684.89 493,985.68 321,193.70 172,791.98
87 15,886,892.91 493,985.68 317,737.86 176,247.82
88 15,710,645.10 493,985.68 314,212.90 179,772.77
89 15,530,872.32 493,985.68 310,617.45 183,368.23
90 15,347,504.09 493,985.68 306,950.08 187,035.59
91 15,160,468.50 493,985.68 303,209.37 190,776.31
92 14,969,692.20 493,985.68 299,393.84 194,591.83
93 14,775,100.37 493,985.68 295,502.01 198,483.67
94 14,576,616.70 493,985.68 291,532.33 202,453.34
95 14,374,163.36 493,985.68 287,483.27 206,502.41
96 14,167,660.95 493,985.68 283,353.22 210,632.4697 13,957,028.49 493,985.68 279,140.57 214,845.11
98 13,742,183.39 493,985.68 274,843.67 219,142.01
99 13,523,041.38 493,985.68 270,460.83 223,524.85
100 13,299,516.53 493,985.68 265,990.33 227,995.34
101 13,071,521.19 493,985.68 261,430.42 232,555.25
102 12,838,965.94 493,985.68 256,779.32 237,206.36
103 12,601,759.58 493,985.68 252,035.19 241,950.48
104 12,359,809.09 493,985.68 247,196.18 246,789.49
105 12,113,019.60 493,985.68 242,260.39 251,725.28
106 11,861,294.32 493,985.68 237,225.89 256,759.79
107 11,604,534.53 493,985.68 232,090.69 261,894.98
108 11,342,639.54 493,985.68 226,852.79 267,132.88109 11,075,506.66 493,985.68 221,510.13 272,475.54
110 10,803,031.12 493,985.68 216,060.62 277,925.05
111 10,525,106.07 493,985.68 210,502.12 283,483.55
112 10,241,622.51 493,985.68 204,832.45 289,153.22
113 9,952,469.29 493,985.68 199,049.39 294,936.29
114 9,657,533.00 493,985.68 193,150.66 300,835.02
115 9,356,697.98 493,985.68 187,133.96 306,851.72
116 9,049,846.27 493,985.68 180,996.93 312,988.75
117 8,736,857.52 493,985.68 174,737.15 319,248.52
118 8,417,608.99 493,985.68 168,352.18 325,633.50
119 8,091,975.50 493,985.68 161,839.51 332,146.17
120 7,759,829.33 493,985.68 155,196.59 338,789.09121 7,421,040.24 493,985.68 148,420.80 345,564.87
122 7,075,475.37 493,985.68 141,509.51 352,476.17
123 6,722,999.20 493,985.68 134,459.98 359,525.69
124 6,363,473.51 493,985.68 127,269.47 366,716.20
125 5,996,757.31 493,985.68 119,935.15 374,050.53
126 5,622,706.78 493,985.68 112,454.14 381,531.54
127 5,241,175.24 493,985.68 104,823.50 389,162.17
8/18/2019 AMORTIZACION Planilla
29/88
128 4,852,013.07 493,985.68 97,040.26 396,945.41
129 4,455,067.66 493,985.68 89,101.35 404,884.32
130 4,050,183.33 493,985.68 81,003.67 412,982.01
131 3,637,201.33 493,985.68 72,744.03 421,241.65
132 3,215,959.68 493,985.68 64,319.19 429,666.48
133 2,786,293.19 493,985.68 55,725.86 438,259.81
134 2,348,033.38 493,985.68 46,960.67 447,025.01135 1,901,008.38 493,985.68 38,020.17 455,965.51
136 1,445,042.87 493,985.68 28,900.86 465,084.82
137 979,958.05 493,985.68 19,599.16 474,386.51
138 505,571.54 493,985.68 10,111.43 483,874.24
139 21,697.29 22,131.24 433.95 21,697.29
140 0.00 493,985.68 0.00 493,985.68
141 0.00 0.00 0.00 0.00
142 0.00 0.00 0.00 0.00
143 0.00 0.00 0.00 0.00
144 0.00 0.00 0.00 0.00
145 0.00 0.00 0.00 0.00
146 0.00 0.00 0.00 0.00147 0.00 0.00 0.00 0.00
148 0.00 0.00 0.00 0.00
149 0.00 0.00 0.00 0.00
150 0.00 0.00 0.00 0.00
151 0.00 0.00 0.00 0.00
152 0.00 0.00 0.00 0.00
153 0.00 0.00 0.00 0.00
154 0.00 0.00 0.00 0.00
155 0.00 0.00 0.00 0.00
156 0.00 0.00 0.00 0.00
157 0.00 0.00 0.00 0.00
158 0.00 0.00 0.00 0.00159 0.00 0.00 0.00 0.00
160 0.00 0.00 0.00 0.00
161 0.00 0.00 0.00 0.00
162 0.00 0.00 0.00 0.00
163 0.00 0.00 0.00 0.00
164 0.00 0.00 0.00 0.00
165 0.00 0.00 0.00 0.00
166 0.00 0.00 0.00 0.00
167 0.00 0.00 0.00 0.00
168 0.00 0.00 0.00 0.00
169 0.00 0.00 0.00 0.00
170 0.00 0.00 0.00 0.00171 0.00 0.00 0.00 0.00
172 0.00 0.00 0.00 0.00
173 0.00 0.00 0.00 0.00
174 0.00 0.00 0.00 0.00
175 0.00 0.00 0.00 0.00
176 0.00 0.00 0.00 0.00
177 0.00 0.00 0.00 0.00
8/18/2019 AMORTIZACION Planilla
30/88
178 0.00 0.00 0.00 0.00
179 0.00 0.00 0.00 0.00
180 0.00 0.00 0.00 0.00
TOTAL 69,686,140.09 45,192,154.42 24,493,985.68
IR AL INICIO DE TABLA
8/18/2019 AMORTIZACION Planilla
31/88
SALDO "INAL
22,927,217.98
SALDO FINAL
23,986,014.32
23,971,748.94
23,957,198.24
23,942,356.53
22,927,217.98
22,891,776.67
22,855,626.5322,818,753.38
22,781,142.78
22,742,779.96
22,703,649.88
22,663,737.20
22,623,026.27
22,581,501.12
22,539,145.47
22,495,942.70
22,451,875.88
22,406,927.72
22,361,080.6022,314,316.54
22,266,617.20
22,217,963.86
22,168,337.47
22,117,718.54
22,066,087.24
22,013,423.30
21,959,706.10
CTADA Y
8/18/2019 AMORTIZACION Planilla
32/88
21,904,914.54
21,849,027.16
21,792,022.03
21,733,876.79
21,674,568.65
21,614,074.35
21,552,370.1621,489,431.89
21,425,234.85
21,359,753.87
21,292,963.28
21,224,836.87
21,155,347.93
21,084,469.21
21,012,172.92
20,938,430.70
20,863,213.64
20,786,492.24
20,708,236.4120,628,415.46
20,546,998.10
20,463,952.38
20,379,245.76
20,292,845.00
20,204,716.22
20,114,824.87
20,023,135.69
19,929,612.73
19,834,219.31
19,736,918.02
19,637,670.7119,536,438.45
19,433,181.54
19,327,859.50
19,220,431.01
19,110,853.96
18,999,085.36
18,885,081.39
18,768,797.34
18,650,187.62
18,529,205.69
18,405,804.13
18,279,934.5418,151,547.55
18,020,592.83
17,887,019.01
17,750,773.72
17,611,803.52
17,470,053.91
17,325,469.31
8/18/2019 AMORTIZACION Planilla
33/88
17,177,993.03
17,027,567.21
16,874,132.88
16,717,629.86
16,557,996.78
16,395,171.04
16,229,088.7916,059,684.89
15,886,892.91
15,710,645.10
15,530,872.32
15,347,504.09
15,160,468.50
14,969,692.20
14,775,100.37
14,576,616.70
14,374,163.36
14,167,660.95
13,957,028.4913,742,183.39
13,523,041.38
13,299,516.53
13,071,521.19
12,838,965.94
12,601,759.58
12,359,809.09
12,113,019.60
11,861,294.32
11,604,534.53
11,342,639.54
11,075,506.6610,803,031.12
10,525,106.07
10,241,622.51
9,952,469.29
9,657,533.00
9,356,697.98
9,049,846.27
8,736,857.52
8,417,608.99
8,091,975.50
7,759,829.33
7,421,040.247,075,475.37
6,722,999.20
6,363,473.51
5,996,757.31
5,622,706.78
5,241,175.24
4,852,013.07
8/18/2019 AMORTIZACION Planilla
34/88
4,455,067.66
4,050,183.33
3,637,201.33
3,215,959.68
2,786,293.19
2,348,033.38
1,901,008.381,445,042.87
979,958.05
505,571.54
21,697.29
0.00
(493,985.68
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
8/18/2019 AMORTIZACION Planilla
35/88
0.00
0.00
0.00
8/18/2019 AMORTIZACION Planilla
36/88
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
VALOR DE LA CUOTA 513,942.70
PERIODOS DE #RACIA MUERTOS 2.00
n CUOTA INTERESES AMORTIZACIÓN SALDO FINAL
1 24,000,000.00 0.00 480,000.00 (480,000.00 24,480,000.00
2 24,480,000.00 0.00 489,600.00 (489,600.00 24,969,600.003 24,969,600.00 513,942.70 499,392.00 14,550.70 24,955,049.30
4 24,955,049.30 513,942.70 499,100.99 14,841.71 24,940,207.59
5 24,940,207.59 513,942.70 498,804.15 15,138.54 24,925,069.05
6 24,925,069.05 513,942.70 498,501.38 15,441.32 24,909,627.73
7 24,909,627.73 513,942.70 498,192.55 15,750.14 24,893,877.59
8 24,893,877.59 513,942.70 497,877.55 16,065.14 24,877,812.45
9 24,877,812.45 513,942.70 497,556.25 16,386.45 24,861,426.00
10 24,861,426.00 513,942.70 497,228.52 16,714.18 24,844,711.82
11 24,844,711.82 513,942.70 496,894.24 17,048.46 24,827,663.36
12 24,827,663.36 513,942.70 496,553.27 17,389.43 24,810,273.93
13 24,810,273.93 513,942.70 496,205.48 17,737.22 24,792,536.72
14 24,792,536.72 513,942.70 495,850.73 18,091.96 24,774,444.7515 24,774,444.75 513,942.70 495,488.90 18,453.80 24,755,990.95
16 24,755,990.95 513,942.70 495,119.82 18,822.88 24,737,168.07
17 24,737,168.07 513,942.70 494,743.36 19,199.33 24,717,968.74
18 24,717,968.74 513,942.70 494,359.37 19,583.32 24,698,385.42
19 24,698,385.42 513,942.70 493,967.71 19,974.99 24,678,410.43
20 24,678,410.43 513,942.70 493,568.21 20,374.49 24,658,035.94
21 24,658,035.94 513,942.70 493,160.72 20,781.98 24,637,253.96
22 24,637,253.96 513,942.70 492,745.08 21,197.62 24,616,056.35
23 24,616,056.35 513,942.70 492,321.13 21,621.57 24,594,434.78
24 24,594,434.78 513,942.70 491,888.70 22,054.00 24,572,380.78
25 24,572,380.78 513,942.70 491,447.62 22,495.08 24,549,885.70
26 24,549,885.70 513,942.70 490,997.71 22,944.98 24,526,940.7127 24,526,940.71 513,942.70 490,538.81 23,403.88 24,503,536.83
28 24,503,536.83 513,942.70 490,070.74 23,871.96 24,479,664.87
29 24,479,664.87 513,942.70 489,593.30 24,349.40 24,455,315.47
30 24,455,315.47 513,942.70 489,106.31 24,836.39 24,430,479.08
31 24,430,479.08 513,942.70 488,609.58 25,333.11 24,405,145.97
32 24,405,145.97 513,942.70 488,102.92 25,839.78 24,379,306.19
33 24,379,306.19 513,942.70 487,586.12 26,356.57 24,352,949.62
34 24,352,949.62 513,942.70 487,058.99 26,883.70 24,326,065.92
AMORTIZACIÓN CON CUOTA CONSTANTE CON PERIODO DE GRACIA MUERTO
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
SALDO INICIAL
8/18/2019 AMORTIZACION Planilla
37/88
35 24,326,065.92 513,942.70 486,521.32 27,421.38 24,298,644.54
36 24,298,644.54 513,942.70 485,972.89 27,969.81 24,270,674.73
37 24,270,674.73 513,942.70 485,413.49 28,529.20 24,242,145.53
38 24,242,145.53 513,942.70 484,842.91 29,099.79 24,213,045.74
39 24,213,045.74 513,942.70 484,260.91 29,681.78 24,183,363.96
40 24,183,363.96 513,942.70 483,667.28 30,275.42 24,153,088.55
41 24,153,088.55 513,942.70 483,061.77 30,880.93 24,122,207.6242 24,122,207.62 513,942.70 482,444.15 31,498.54 24,090,709.08
43 24,090,709.08 513,942.70 481,814.18 32,128.51 24,058,580.56
44 24,058,580.56 513,942.70 481,171.61 32,771.09 24,025,809.48
45 24,025,809.48 513,942.70 480,516.19 33,426.51 23,992,382.97
46 23,992,382.97 513,942.70 479,847.66 34,095.04 23,958,287.93
47 23,958,287.93 513,942.70 479,165.76 34,776.94 23,923,510.99
48 23,923,510.99 513,942.70 478,470.22 35,472.48 23,888,038.52
49 23,888,038.52 513,942.70 477,760.77 36,181.93 23,851,856.59
50 23,851,856.59 513,942.70 477,037.13 36,905.56 23,814,951.03
51 23,814,951.03 513,942.70 476,299.02 37,643.68 23,777,307.35
52 23,777,307.35 513,942.70 475,546.15 38,396.55 23,738,910.80
53 23,738,910.80 513,942.70 474,778.22 39,164.48 23,699,746.3254 23,699,746.32 513,942.70 473,994.93 39,947.77 23,659,798.55
55 23,659,798.55 513,942.70 473,195.97 40,746.73 23,619,051.83
56 23,619,051.83 513,942.70 472,381.04 41,561.66 23,577,490.17
57 23,577,490.17 513,942.70 471,549.80 42,392.89 23,535,097.27
58 23,535,097.27 513,942.70 470,701.95 43,240.75 23,491,856.52
59 23,491,856.52 513,942.70 469,837.13 44,105.57 23,447,750.95
60 23,447,750.95 513,942.70 468,955.02 44,987.68 23,402,763.28
61 23,402,763.28 513,942.70 468,055.27 45,887.43 23,356,875.85
62 23,356,875.85 513,942.70 467,137.52 46,805.18 23,310,070.67
63 23,310,070.67 513,942.70 466,201.41 47,741.28 23,262,329.38
64 23,262,329.38 513,942.70 465,246.59 48,696.11 23,213,633.27
65 23,213,633.27 513,942.70 464,272.67 49,670.03 23,163,963.2466 23,163,963.24 513,942.70 463,279.26 50,663.43 23,113,299.81
67 23,113,299.81 513,942.70 462,266.00 51,676.70 23,061,623.11
68 23,061,623.11 513,942.70 461,232.46 52,710.23 23,008,912.88
69 23,008,912.88 513,942.70 460,178.26 53,764.44 22,955,148.44
70 22,955,148.44 513,942.70 459,102.97 54,839.73 22,900,308.71
71 22,900,308.71 513,942.70 458,006.17 55,936.52 22,844,372.19
72 22,844,372.19 513,942.70 456,887.44 57,055.25 22,787,316.94
73 22,787,316.94 513,942.70 455,746.34 58,196.36 22,729,120.58
74 22,729,120.58 513,942.70 454,582.41 59,360.28 22,669,760.29
75 22,669,760.29 513,942.70 453,395.21 60,547.49 22,609,212.80
76 22,609,212.80 513,942.70 452,184.26 61,758.44 22,547,454.36
77 22,547,454.36 513,942.70 450,949.09 62,993.61 22,484,460.7578 22,484,460.75 513,942.70 449,689.22 64,253.48 22,420,207.27
79 22,420,207.27 513,942.70 448,404.15 65,538.55 22,354,668.72
80 22,354,668.72 513,942.70 447,093.37 66,849.32 22,287,819.40
81 22,287,819.40 513,942.70 445,756.39 68,186.31 22,219,633.09
82 22,219,633.09 513,942.70 444,392.66 69,550.03 22,150,083.06
83 22,150,083.06 513,942.70 443,001.66 70,941.04 22,079,142.02
84 22,079,142.02 513,942.70 441,582.84 72,359.86 22,006,782.16
8/18/2019 AMORTIZACION Planilla
38/88
85 22,006,782.16 513,942.70 440,135.64 73,807.05 21,932,975.11
86 21,932,975.11 513,942.70 438,659.50 75,283.19 21,857,691.92
87 21,857,691.92 513,942.70 437,153.84 76,788.86 21,780,903.06
88 21,780,903.06 513,942.70 435,618.06 78,324.64 21,702,578.42
89 21,702,578.42 513,942.70 434,051.57 79,891.13 21,622,687.30
90 21,622,687.30 513,942.70 432,453.75 81,488.95 21,541,198.34
91 21,541,198.34 513,942.70 430,823.97 83,118.73 21,458,079.6292 21,458,079.62 513,942.70 429,161.59 84,781.10 21,373,298.51
93 21,373,298.51 513,942.70 427,465.97 86,476.73 21,286,821.78
94 21,286,821.78 513,942.70 425,736.44 88,206.26 21,198,615.52
95 21,198,615.52 513,942.70 423,972.31 89,970.39 21,108,645.14
96 21,108,645.14 513,942.70 422,172.90 91,769.79 21,016,875.34
97 21,016,875.34 513,942.70 420,337.51 93,605.19 20,923,270.15
98 20,923,270.15 513,942.70 418,465.40 95,477.29 20,827,792.86
99 20,827,792.86 513,942.70 416,555.86 97,386.84 20,730,406.02
100 20,730,406.02 513,942.70 414,608.12 99,334.58 20,631,071.45
101 20,631,071.45 513,942.70 412,621.43 101,321.27 20,529,750.18
102 20,529,750.18 513,942.70 410,595.00 103,347.69 20,426,402.49
103 20,426,402.49 513,942.70 408,528.05 105,414.65 20,320,987.84104 20,320,987.84 513,942.70 406,419.76 107,522.94 20,213,464.90
105 20,213,464.90 513,942.70 404,269.30 109,673.40 20,103,791.50
106 20,103,791.50 513,942.70 402,075.83 111,866.87 19,991,924.63
107 19,991,924.63 513,942.70 399,838.49 114,104.20 19,877,820.43
108 19,877,820.43 513,942.70 397,556.41 116,386.29 19,761,434.14
109 19,761,434.14 513,942.70 395,228.68 118,714.01 19,642,720.13
110 19,642,720.13 513,942.70 392,854.40 121,088.29 19,521,631.83
111 19,521,631.83 513,942.70 390,432.64 123,510.06 19,398,121.78
112 19,398,121.78 513,942.70 387,962.44 125,980.26 19,272,141.51
113 19,272,141.51 513,942.70 385,442.83 128,499.87 19,143,641.65
114 19,143,641.65 513,942.70 382,872.83 131,069.86 19,012,571.78
115 19,012,571.78 513,942.70 380,251.44 133,691.26 18,878,880.52116 18,878,880.52 513,942.70 377,577.61 136,365.09 18,742,515.44
117 18,742,515.44 513,942.70 374,850.31 139,092.39 18,603,423.05
118 18,603,423.05 513,942.70 372,068.46 141,874.24 18,461,548.81
119 18,461,548.81 513,942.70 369,230.98 144,711.72 18,316,837.09
120 18,316,837.09 513,942.70 366,336.74 147,605.95 18,169,231.14
121 18,169,231.14 513,942.70 363,384.62 150,558.07 18,018,673.07
122 18,018,673.07 513,942.70 360,373.46 153,569.24 17,865,103.83
123 17,865,103.83 513,942.70 357,302.08 156,640.62 17,708,463.21
124 17,708,463.21 513,942.70 354,169.26 159,773.43 17,548,689.78
125 17,548,689.78 513,942.70 350,973.80 162,968.90 17,385,720.88
126 17,385,720.88 513,942.70 347,714.42 166,228.28 17,219,492.60
127 17,219,492.60 513,942.70 344,389.85 169,552.84 17,049,939.75128 17,049,939.75 513,942.70 340,998.80 172,943.90 16,876,995.85
129 16,876,995.85 513,942.70 337,539.92 176,402.78 16,700,593.07
130 16,700,593.07 513,942.70 334,011.86 179,930.84 16,520,662.24
131 16,520,662.24 513,942.70 330,413.24 183,529.45 16,337,132.79
132 16,337,132.79 513,942.70 326,742.66 187,200.04 16,149,932.75
133 16,149,932.75 513,942.70 322,998.65 190,944.04 15,958,988.70
134 15,958,988.70 513,942.70 319,179.77 194,762.92 15,764,225.78
8/18/2019 AMORTIZACION Planilla
39/88
135 15,764,225.78 513,942.70 315,284.52 198,658.18 15,565,567.60
136 15,565,567.60 513,942.70 311,311.35 202,631.34 15,362,936.26
137 15,362,936.26 513,942.70 307,258.73 206,683.97 15,156,252.29
138 15,156,252.29 513,942.70 303,125.05 210,817.65 14,945,434.63
139 14,945,434.63 513,942.70 298,908.69 215,034.00 14,730,400.63
140 14,730,400.63 513,942.70 294,608.01 219,334.68 14,511,065.95
141 14,511,065.95 513,942.70 290,221.32 223,721.38 14,287,344.57142 14,287,344.57 513,942.70 285,746.89 228,195.81 14,059,148.76
143 14,059,148.76 513,942.70 281,182.98 232,759.72 13,826,389.04
144 13,826,389.04 513,942.70 276,527.78 237,414.92 13,588,974.13
145 13,588,974.13 513,942.70 271,779.48 242,163.21 13,346,810.91
146 13,346,810.91 513,942.70 266,936.22 247,006.48 13,099,804.44
147 13,099,804.44 513,942.70 261,996.09 251,946.61 12,847,857.83
148 12,847,857.83 513,942.70 256,957.16 256,985.54 12,590,872.29
149 12,590,872.29 513,942.70 251,817.45 262,125.25 12,328,747.04
150 12,328,747.04 513,942.70 246,574.94 267,367.76 12,061,379.28
151 12,061,379.28 513,942.70 241,227.59 272,715.11 11,788,664.17
152 11,788,664.17 513,942.70 235,773.28 278,169.41 11,510,494.76
153 11,510,494.76 513,942.70 230,209.90 283,732.80 11,226,761.96154 11,226,761.96 513,942.70 224,535.24 289,407.46 10,937,354.50
155 10,937,354.50 513,942.70 218,747.09 295,195.61 10,642,158.89
156 10,642,158.89 513,942.70 212,843.18 301,099.52 10,341,059.37
157 10,341,059.37 513,942.70 206,821.19 307,121.51 10,033,937.86
158 10,033,937.86 513,942.70 200,678.76 313,263.94 9,720,673.93
159 9,720,673.93 513,942.70 194,413.48 319,529.22 9,401,144.71
160 9,401,144.71 513,942.70 188,022.89 325,919.80 9,075,224.91
161 9,075,224.91 513,942.70 181,504.50 332,438.20 8,742,786.71
162 8,742,786.71 513,942.70 174,855.73 339,086.96 8,403,699.74
163 8,403,699.74 513,942.70 168,073.99 345,868.70 8,057,831.04
164 8,057,831.04 513,942.70 161,156.62 352,786.08 7,705,044.97
165 7,705,044.97 513,942.70 154,100.90 359,841.80 7,345,203.17166 7,345,203.17 513,942.70 146,904.06 367,038.63 6,978,164.54
167 6,978,164.54 513,942.70 139,563.29 374,379.41 6,603,785.13
168 6,603,785.13 513,942.70 132,075.70 381,866.99 6,221,918.14
169 6,221,918.14 513,942.70 124,438.36 389,504.33 5,832,413.80
170 5,832,413.80 513,942.70 116,648.28 397,294.42 5,435,119.38
171 5,435,119.38 513,942.70 108,702.39 405,240.31 5,029,879.07
172 5,029,879.07 513,942.70 100,597.58 413,345.11 4,616,533.96
173 4,616,533.96 513,942.70 92,330.68 421,612.02 4,194,921.94
174 4,194,921.94 513,942.70 83,898.44 430,044.26 3,764,877.68
175 3,764,877.68 513,942.70 75,297.55 438,645.14 3,326,232.54
176 3,326,232.54 513,942.70 66,524.65 447,418.05 2,878,814.50
177 2,878,814.50 513,942.70 57,576.29 456,366.41 2,422,448.09178 2,422,448.09 513,942.70 48,448.96 465,493.73 1,956,954.35
179 1,956,954.35 513,942.70 39,139.09 474,803.61 1,482,150.75
180 1,482,150.75 513,942.70 29,643.01 484,299.68 997,851.06
TOTAL 91,481,799.97 68,479,651.04 23,002,148.94
IR AL INICIO DE LA TABLA
8/18/2019 AMORTIZACION Planilla
40/88
0.00
8/18/2019 AMORTIZACION Planilla
41/88
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
VALOR DE LA CUOTA 493,985.68
PERIODO DE #RACIA MUERTOS CON CUOTA REDUCIDA 0
n SALDO INICIAL CUOTA INTERESES AMORTIZACIÓN 1 24,000,000.00 493,985.68 480,000.00 13,985.68
2 23,986,014.32 493,985.68 479,720.29 14,265.39
3 23,971,748.94 493,985.68 479,434.98 14,550.704 23,957,198.24 493,985.68 479,143.96 14,841.71
5 23,942,356.53 493,985.68 478,847.13 15,138.54
6 23,927,217.98 493,985.68 478,544.36 15,441.32
7 23,911,776.67 493,985.68 478,235.53 15,750.14
8 23,896,026.53 493,985.68 477,920.53 16,065.14
9 23,879,961.38 493,985.68 477,599.23 16,386.45
10 23,863,574.94 493,985.68 477,271.50 16,714.18
11 23,846,860.76 493,985.68 476,937.22 17,048.46
12 23,829,812.30 493,985.68 476,596.25 17,389.43
13 23,812,422.87 493,985.68 476,248.46 17,737.22
14 23,794,685.65 493,985.68 475,893.71 18,091.96
15 23,776,593.69 493,985.68 475,531.87 18,453.8016 23,758,139.89 493,985.68 475,162.80 18,822.88
17 23,739,317.01 493,985.68 474,786.34 19,199.33
18 23,720,117.68 493,985.68 474,402.35 19,583.32
19 23,700,534.35 493,985.68 474,010.69 19,974.99
20 23,680,559.37 493,985.68 473,611.19 20,374.49
21 23,660,184.88 493,985.68 473,203.70 20,781.98
22 23,639,402.90 493,985.68 472,788.06 21,197.62
23 23,618,205.28 493,985.68 472,364.11 21,621.57
24 23,596,583.71 493,985.68 471,931.67 22,054.00
25 23,574,529.71 493,985.68 471,490.59 22,495.08
26 23,552,034.63 493,985.68 471,040.69 22,944.98
27 23,529,089.65 493,985.68 470,581.79 23,403.8828 23,505,685.77 493,985.68 470,113.72 23,871.96
29 23,481,813.81 493,985.68 469,636.28 24,349.40
30 23,457,464.41 493,985.68 469,149.29 24,836.39
31 23,432,628.02 493,985.68 468,652.56 25,333.11
32 23,407,294.91 493,985.68 468,145.90 25,839.78
33 23,381,455.13 493,985.68 467,629.10 26,356.57
34 23,355,098.56 493,985.68 467,101.97 26,883.70
AMORTIZACIÓN CON CUOTA CONSTANTE CON PERIODO DE GRAC REDUCIDA
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
8/18/2019 AMORTIZACION Planilla
42/88
35 23,328,214.85 493,985.68 466,564.30 27,421.38
36 23,300,793.47 493,985.68 466,015.87 27,969.81
37 23,272,823.67 493,985.68 465,456.47 28,529.20
38 23,244,294.47 493,985.68 464,885.89 29,099.79
39 23,215,194.68 493,985.68 464,303.89 29,681.78
40 23,185,512.90 493,985.68 463,710.26 30,275.42
41 23,155,237.48 493,985.68 463,104.75 30,880.9342 23,124,356.56 493,985.68 462,487.13 31,498.54
43 23,092,858.01 493,985.68 461,857.16 32,128.51
44 23,060,729.50 493,985.68 461,214.59 32,771.09
45 23,027,958.41 493,985.68 460,559.17 33,426.51
46 22,994,531.90 493,985.68 459,890.64 34,095.04
47 22,960,436.87 493,985.68 459,208.74 34,776.94
48 22,925,659.93 493,985.68 458,513.20 35,472.48
49 22,890,187.45 493,985.68 457,803.75 36,181.93
50 22,854,005.53 493,985.68 457,080.11 36,905.56
51 22,817,099.96 493,985.68 456,342.00 37,643.68
52 22,779,456.29 493,985.68 455,589.13 38,396.55
53 22,741,059.74 493,985.68 454,821.19 39,164.4854 22,701,895.26 493,985.68 454,037.91 39,947.77
55 22,661,947.49 493,985.68 453,238.95 40,746.73
56 22,621,200.76 493,985.68 452,424.02 41,561.66
57 22,579,639.10 493,985.68 451,592.78 42,392.89
58 22,537,246.21 493,985.68 450,744.92 43,240.75
59 22,494,005.46 493,985.68 449,880.11 44,105.57
60 22,449,899.89 493,985.68 448,998.00 44,987.68
61 22,404,912.21 493,985.68 448,098.24 45,887.43
62 22,359,024.78 493,985.68 447,180.50 46,805.18
63 22,312,219.60 493,985.68 446,244.39 47,741.28
64 22,264,478.32 493,985.68 445,289.57 48,696.11
65 22,215,782.21 493,985.68 444,315.64 49,670.0366 22,166,112.18 493,985.68 443,322.24 50,663.43
67 22,115,448.75 493,985.68 442,308.97 51,676.70
68 22,063,772.05 493,985.68 441,275.44 52,710.23
69 22,011,061.81 493,985.68 440,221.24 53,764.44
70 21,957,297.38 493,985.68 439,145.95 54,839.73
71 21,902,457.65 493,985.68 438,049.15 55,936.52
72 21,846,521.13 493,985.68 436,930.42 57,055.25
73 21,789,465.87 493,985.68 435,789.32 58,196.36
74 21,731,269.51 493,985.68 434,625.39 59,360.28
75 21,671,909.23 493,985.68 433,438.18 60,547.49
76 21,611,361.74 493,985.68 432,227.23 61,758.44
77 21,549,603.30 493,985.68 430,992.07 62,993.6178 21,486,609.69 493,985.68 429,732.19 64,253.48
79 21,422,356.21 493,985.68 428,447.12 65,538.55
80 21,356,817.66 493,985.68 427,136.35 66,849.32
81 21,289,968.34 493,985.68 425,799.37 68,186.31
82 21,221,782.03 493,985.68 424,435.64 69,550.03
83 21,152,231.99 493,985.68 423,044.64 70,941.04
84 21,081,290.96 493,985.68 421,625.82 72,359.86
8/18/2019 AMORTIZACION Planilla
43/88
85 21,008,931.10 493,985.68 420,178.62 73,807.05
86 20,935,124.05 493,985.68 418,702.48 75,283.19
87 20,859,840.85 493,985.68 417,196.82 76,788.86
88 20,783,051.99 493,985.68 415,661.04 78,324.64
89 20,704,727.36 493,985.68 414,094.55 79,891.13
90 20,624,836.23 493,985.68 412,496.72 81,488.95
91 20,543,347.28 493,985.68 410,866.95 83,118.7392 20,460,228.55 493,985.68 409,204.57 84,781.10
93 20,375,447.45 493,985.68 407,508.95 86,476.73
94 20,288,970.72 493,985.68 405,779.41 88,206.26
95 20,200,764.46 493,985.68 404,015.29 89,970.39
96 20,110,794.07 493,985.68 402,215.88 91,769.79
97 20,019,024.28 493,985.68 400,380.49 93,605.19
98 19,925,419.09 493,985.68 398,508.38 95,477.29
99 19,829,941.80 493,985.68 396,598.84 97,386.84
100 19,732,554.96 493,985.68 394,651.10 99,334.58
101 19,633,220.38 493,985.68 392,664.41 101,321.27
102 19,531,899.11 493,985.68 390,637.98 103,347.69
103 19,428,551.42 493,985.68 388,571.03 105,414.65104 19,323,136.77 493,985.68 386,462.74 107,522.94
105 19,215,613.84 493,985.68 384,312.28 109,673.40
106 19,105,940.44 493,985.68 382,118.81 111,866.87
107 18,994,073.57 493,985.68 379,881.47 114,104.20
108 18,879,969.37 493,985.68 377,599.39 116,386.29
109 18,763,583.08 493,985.68 375,271.66 118,714.01
110 18,644,869.06 493,985.68 372,897.38 121,088.29
111 18,523,780.77 493,985.68 370,475.62 123,510.06
112 18,400,270.71 493,985.68 368,005.41 125,980.26
113 18,274,290.45 493,985.68 365,485.81 128,499.87
114 18,145,790.58 493,985.68 362,915.81 131,069.86
115 18,014,720.72 493,985.68 360,294.41 133,691.26116 17,881,029.46 493,985.68 357,620.59 136,365.09
117 17,744,664.37 493,985.68 354,893.29 139,092.39
118 17,605,571.99 493,985.68 352,111.44 141,874.24
119 17,463,697.75 493,985.68 349,273.96 144,711.72
120 17,318,986.03 493,985.68 346,379.72 147,605.95
121 17,171,380.08 493,985.68 343,427.60 150,558.07
122 17,020,822.00 493,985.68 340,416.44 153,569.24
123 16,867,252.77 493,985.68 337,345.06 156,640.62
124 16,710,612.15 493,985.68 334,212.24 159,773.43
125 16,550,838.71 493,985.68 331,016.77 162,968.90
126 16,387,869.81 493,985.68 327,757.40 166,228.28
127 16,221,641.53 493,985.68 324,432.83 169,552.84128 16,052,088.69 493,985.68 321,041.77 172,943.90
129 15,879,144.79 493,985.68 317,582.90 176,402.78
130 15,702,742.01 493,985.68 314,054.84 179,930.84
131 15,522,811.17 493,985.68 310,456.22 183,529.45
132 15,339,281.72 493,985.68 306,785.63 187,200.04
133 15,152,081.68 493,985.68 303,041.63 190,944.04
134 14,961,137.64 493,985.68 299,222.75 194,762.92
8/18/2019 AMORTIZACION Planilla
44/88
135 14,766,374.72 493,985.68 295,327.49 198,658.18
136 14,567,716.54 493,985.68 291,354.33 202,631.34
137 14,365,085.19 493,985.68 287,301.70 206,683.97
138 14,158,401.22 493,985.68 283,168.02 210,817.65
139 13,947,583.57 493,985.68 278,951.67 215,034.00
140 13,732,549.57 493,985.68 274,650.99 219,334.68
141 13,513,214.88 493,985.68 270,264.30 223,721.38142 13,289,493.51 493,985.68 265,789.87 228,195.81
143 13,061,297.70 493,985.68 261,225.95 232,759.72
144 12,828,537.98 493,985.68 256,570.76 237,414.92
145 12,591,123.06 493,985.68 251,822.46 242,163.21
146 12,348,959.85 493,985.68 246,979.20 247,006.48
147 12,101,953.37 493,985.68 242,039.07 251,946.61
148 11,850,006.76 493,985.68 237,000.14 256,985.54
149 11,593,021.22 493,985.68 231,860.42 262,125.25
150 11,330,895.97 493,985.68 226,617.92 267,367.76
151 11,063,528.22 493,985.68 221,270.56 272,715.11
152 10,790,813.11 493,985.68 215,816.26 278,169.41
153 10,512,643.69 493,985.68 210,252.87 283,732.80154 10,228,910.89 493,985.68 204,578.22 289,407.46
155 9,939,503.43 493,985.68 198,790.07 295,195.61
156 9,644,307.83 493,985.68 192,886.16 301,099.52
157 9,343,208.31 493,985.68 186,864.17 307,121.51
158 9,036,086.80 493,985.68 180,721.74 313,263.94
159 8,722,822.86 493,985.68 174,456.46 319,529.22
160 8,403,293.64 493,985.68 168,065.87 325,919.80
161 8,077,373.84 493,985.68 161,547.48 332,438.20
162 7,744,935.64 493,985.68 154,898.71 339,086.96
163 7,405,848.68 493,985.68 148,116.97 345,868.70
164 7,059,979.98 493,985.68 141,199.60 352,786.08
165 6,707,193.90 493,985.68 134,143.88 359,841.80166 6,347,352.11 493,985.68 126,947.04 367,038.63
167 5,980,313.47 493,985.68 119,606.27 374,379.41
168 5,605,934.07 493,985.68 112,118.68 381,866.99
169 5,224,067.07 493,985.68 104,481.34 389,504.33
170 4,834,562.74 493,985.68 96,691.25 397,294.42
171 4,437,268.32 493,985.68 88,745.37 405,240.31
172 4,032,028.01 493,985.68 80,640.56 413,345.11
173 3,618,682.90 493,985.68 72,373.66 421,612.02
174 3,197,070.88 493,985.68 63,941.42 430,044.26
175 2,767,026.62 493,985.68 55,340.53 438,645.14
176 2,328,381.48 493,985.68 46,567.63 447,418.05
177 1,880,963.43 493,985.68 37,619.27 456,366.41178 1,424,597.03 493,985.68 28,491.94 465,493.73
179 959,103.29 493,985.68 19,182.07 474,803.61
180 484,299.68 493,985.68 9,685.99 484,299.68
181 0.00 0.00 0.00 0.00
182 0.00 0.00 0.00 0.00
183 0.00 0.00 0.00 0.00
184 0.00 0.00 0.00 0.00
8/18/2019 AMORTIZACION Planilla
45/88
185 0.00 0.00 0.00 0.00
186 0.00 0.00 0.00 0.00
187 0.00 0.00 0.00 0.00
188 0.00 0.00 0.00 0.00
189 0.00 0.00 0.00 0.00
190 0.00 0.00 0.00 0.00
191 0.00 0.00 0.00 0.00192 0.00 0.00 0.00 0.00
193 0.00 0.00 0.00 0.00
194 0.00 0.00 0.00 0.00
195 0.00 0.00 0.00 0.00
196 0.00 0.00 0.00 0.00
197 0.00 0.00 0.00 0.00
198 0.00 0.00 0.00 0.00
199 0.00 0.00 0.00 0.00
200 0.00 0.00 0.00 0.00
201 0.00 0.00 0.00 0.00
202 0.00 0.00 0.00 0.00
203 0.00 0.00 0.00 0.00204 0.00 0.00 0.00 0.00
205 0.00 0.00 0.00 0.00
206 0.00 0.00 0.00 0.00
207 0.00 0.00 0.00 0.00
208 0.00 0.00 0.00 0.00
209 0.00 0.00 0.00 0.00
210 0.00 0.00 0.00 0.00
211 0.00 0.00 0.00 0.00
212 0.00 0.00 0.00 0.00
213 0.00 0.00 0.00 0.00
214 0.00 0.00 0.00 0.00
215 0.00 0.00 0.00 0.00216 0.00 0.00 0.00 0.00
217 0.00 0.00 0.00 0.00
218 0.00 0.00 0.00 0.00
219 0.00 0.00 0.00 0.00
220 0.00 0.00 0.00 0.00
221 0.00 0.00 0.00 0.00
222 0.00 0.00 0.00 0.00
223 0.00 0.00 0.00 0.00
224 0.00 0.00 0.00 0.00
225 0.00 0.00 0.00 0.00
226 0.00 0.00 0.00 0.00
227 0.00 0.00 0.00 0.00228 0.00 0.00 0.00 0.00
229 0.00 0.00 0.00 0.00
230 0.00 0.00 0.00 0.00
231 0.00 0.00 0.00 0.00
232 0.00 0.00 0.00 0.00
233 0.00 0.00 0.00 0.00
234 0.00 0.00 0.00 0.00
8/18/2019 AMORTIZACION Planilla
46/88
235 0.00 0.00 0.00 0.00
236 0.00 0.00 0.00 0.00
237 0.00 0.00 0.00 0.00
238 0.00 0.00 0.00 0.00
239 0.00 0.00 0.00 0.00
240 0.00 0.00 0.00 0.00
241 0.00 0.00 0.00 0.00242 0.00 0.00 0.00 0.00
243 0.00 0.00 0.00 0.00
244 0.00 0.00 0.00 0.00
245 0.00 0.00 0.00 0.00
246 0.00 0.00 0.00 0.00
247 0.00 0.00 0.00 0.00
248 0.00 0.00 0.00 0.00
249 0.00 0.00 0.00 0.00
250 0.00 0.00 0.00 0.00
251 0.00 0.00 0.00 0.00
252 0.00 0.00 0.00 0.00
253 0.00 0.00 0.00 0.00254 0.00 0.00 0.00 0.00
255 0.00 0.00 0.00 0.00
256 0.00 0.00 0.00 0.00
257 0.00 0.00 0.00 0.00
258 0.00 0.00 0.00 0.00
259 0.00 0.00 0.00 0.00
260 0.00 0.00 0.00 0.00
261 0.00 0.00 0.00 0.00
262 0.00 0.00 0.00 0.00
263 0.00 0.00 0.00 0.00
264 0.00 0.00 0.00 0.00
265 0.00 0.00 0.00 0.00266 0.00 0.00 0.00 0.00
267 0.00 0.00 0.00 0.00
268 0.00 0.00 0.00 0.00
269 0.00 0.00 0.00 0.00
270 0.00 0.00 0.00 0.00
271 0.00 0.00 0.00 0.00
272 0.00 0.00 0.00 0.00
273 0.00 0.00 0.00 0.00
274 0.00 0.00 0.00 0.00
275 0.00 0.00 0.00 0.00
276 0.00 0.00 0.00 0.00
277 0.00 0.00 0.00 0.00278 0.00 0.00 0.00 0.00
279 0.00 0.00 0.00 0.00
280 0.00 0.00 0.00 0.00
TOTAL 88,917,421.54 64,917,421.54 24,000,000.00
IR AL INICIO DE LA TABLA
8/18/2019 AMORTIZACION Planilla
47/88
0.00
8/18/2019 AMORTIZACION Planilla
48/88
$100
SALDO FINAL
23,986,014.32
23,971,748.94
23,957,198.2423,942,356.53
23,927,217.98
23,911,776.67
23,896,026.53
23,879,961.38
23,863,574.94
23,846,860.76
23,829,812.30
23,812,422.87
23,794,685.65
23,776,593.69
23,758,139.8923,739,317.01
23,720,117.68
23,700,534.35
23,680,559.37
23,660,184.88
23,639,402.90
23,618,205.28
23,596,583.71
23,574,529.71
23,552,034.63
23,529,089.65
23,505,685.7723,481,813.81
23,457,464.41
23,432,628.02
23,407,294.91
23,381,455.13
23,355,098.56
23,328,214.85
A CON CUOTA
8/18/2019 AMORTIZACION Planilla
49/88
23,300,793.47
23,272,823.67
23,244,294.47
23,215,194.68
23,185,512.90
23,155,237.48
23,124,356.5623,092,858.01
23,060,729.50
23,027,958.41
22,994,531.90
22,960,436.87
22,925,659.93
22,890,187.45
22,854,005.53
22,817,099.96
22,779,456.29
22,741,059.74
22,701,895.2622,661,947.49
22,621,200.76
22,579,639.10
22,537,246.21
22,494,005.46
22,449,899.89
22,404,912.21
22,359,024.78
22,312,219.60
22,264,478.32
22,215,782.21
22,166,112.1822,115,448.75
22,063,772.05
22,011,061.81
21,957,297.38
21,902,457.65
21,846,521.13
21,789,465.87
21,731,269.51
21,671,909.23
21,611,361.74
21,549,603.30
21,486,609.6921,422,356.21
21,356,817.66
21,289,968.34
21,221,782.03
21,152,231.99
21,081,290.96
21,008,931.10
8/18/2019 AMORTIZACION Planilla
50/88
20,935,124.05
20,859,840.85
20,783,051.99
20,704,727.36
20,624,836.23
20,543,347.28
20,460,228.5520,375,447.45
20,288,970.72
20,200,764.46
20,110,794.07
20,019,024.28
19,925,419.09
19,829,941.80
19,732,554.96
19,633,220.38
19,531,899.11
19,428,551.42
19,323,136.7719,215,613.84
19,105,940.44
18,994,073.57
18,879,969.37
18,763,583.08
18,644,869.06
18,523,780.77
18,400,270.71
18,274,290.45
18,145,790.58
18,014,720.72
17,881,029.4617,744,664.37
17,605,571.99
17,463,697.75
17,318,986.03
17,171,380.08
17,020,822.00
16,867,252.77
16,710,612.15
16,550,838.71
16,387,869.81
16,221,641.53
16,052,088.6915,879,144.79
15,702,742.01
15,522,811.17
15,339,281.72
15,152,081.68
14,961,137.64
14,766,374.72
8/18/2019 AMORTIZACION Planilla
51/88
14,567,716.54
14,365,085.19
14,158,401.22
13,947,583.57
13,732,549.57
13,513,214.88
13,289,493.5113,061,297.70
12,828,537.98
12,591,123.06
12,348,959.85
12,101,953.37
11,850,006.76
11,593,021.22
11,330,895.97
11,063,528.22
10,790,813.11
10,512,643.69
10,228,910.899,939,503.43
9,644,307.83
9,343,208.31
9,036,086.80
8,722,822.86
8,403,293.64
8,077,373.84
7,744,935.64
7,405,848.68
7,059,979.98
6,707,193.90
6,347,352.115,980,313.47
5,605,934.07
5,224,067.07
4,834,562.74
4,437,268.32
4,032,028.01
3,618,682.90
3,197,070.88
2,767,026.62
2,328,381.48
1,880,963.43
1,424,597.03959,103.29
484,299.68
(0.00
0.00
0.00
0.00
0.00
8/18/2019 AMORTIZACION Planilla
52/88
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
8/18/2019 AMORTIZACION Planilla
53/88
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.000.00
0.00
0.00
8/18/2019 AMORTIZACION Planilla
54/88
8/18/2019 AMORTIZACION Planilla
55/88
AMORTIZACIÓN CON ABONO CONSTANTE A CAPITAL E INTERES VENCIDO
VALOR DE LA DEUDA 24,000,000.00
TASA DE INTERES 2.00%
VALOR DE LA CUOTA 289,070.45
AONO CONSTANTE A CAPITAL 133,333.33
CON #RADIENTE #EOMETRICO DE 1.00% DI"ERENTE A
LA TASA (&
n SALDO INICIAL CUOTA INTERESES AMORTIZACIÓN SALDO FINAL1 24,000,000.00 289,070.45 480,000.00 133,333.33 23,866,666.67
2 23,866,666.67 291,961.16 477,333.33 133,333.33 23,733,333.33
3 23,733,333.33 294,880.77 474,666.67 133,333.33 23,600,000.00
4 23,600,000.00 297,829.58 472,000.00 133,333.33 23,466,666.67
5 23,466,666.67 300,807.87 469,333.33 133,333.33 23,333,333.33
6 23,333,333.33 303,815.95 466,666.67 133,333.33 23,200,000.00
7 23,200,000.00 306,854.11 464,000.00 133,333.33 23,066,666.67
8 23,066,666.67 309,922.65 461,333.33 133,333.33 22,933,333.33
9 22,933,333.33 313,021.88 458,666.67 133,333.33 22,800,000.00
10 22,800,000.00 316,152.10 456,000.00 133,333.33 22,666,666.67
11 22,666,666.67 319,313.62 453,333.33 133,333.33 22,533,333.33
12 22,533,333.33 322,506.75 450,666.67 133,333.33 22,400,000.00
13 22,400,000.00 325,731.82 448,000.00 133,333.33 22,266,666.67
14 22,266,666.67 328,989.14 445,333.33 133,333.33 22,133,333.33
15 22,133,333.33 332,279.03 442,666.67 133,333.33 22,000,000.00
16 22,000,000.00 335,601.82 440,000.00 133,333.33 21,866,666.67
17 21,866,666.67 338,957.84 437,333.33 133,333.33 21,733,333.33
18 21,733,333.33 342,347.42 434,666.67 133,333.33 21,600,000.00
19 21,600,000.00 345,770.89 432,000.00 133,333.33 21,466,666.67
20 21,466,666.67 349,228.60 429,333.33 133,333.33 21,333,333.33
21 21,333,333.33 352,720.89 426,666.67 133,333.33 21,200,000.00
22 21,200,000.00 356,248.10 424,000.00 133,333.33 21,066,666.67
23 21,066,666.67 359,810.58 421,333.33 133,333.33 20,933,333.33
24 20,933,333.33 363,408.68 418,666.67 133,333.33 20,800,000.00
25 20,800,000.00 367,042.77 416,000.00 133,333.33 20,666,666.67
26 20,666,666.67 370,713.20 413,333.33 133,333.33 20,533,333.33
27 20,533,333.33 374,420.33 410,666.67 133,333.33 20,400,000.00
28 20,400,000.00 378,164.53 408,000.00 133,333.33 20,266,666.67
29 20,266,666.67 381,946.18 405,333.33 133,333.33 20,133,333.33
30 20,133,333.33 385,765.64 402,666.67 133,333.33 20,000,000.00
31 20,000,000.00 389,623.30 400,000.00 133,333.33 19,866,666.67
32 19,866,666.67 393,519.53 397,333.33 133,333.33 19,733,333.33
33 19,733,333.33 397,454.72 394,666.67 133,333.33 19,600,000.00
MENU PRINCIPAL
IR AL FINAL DE LA TABLA
8/18/2019 AMORTIZACION Planilla
56/88
34 19,600,000.00 401,429.27 392,000.00 133,333.33 19,466,666.67
35 19,466,666.67 405,443.56 389,333.33 133,333.33 19,333,333.33
36