Planilla de Plan de Pago

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 16

Prestamo 60,000.00 $us.

Plazo 15.0 años


Tasa 6.00 %
Amortizacion Cda. 1 mes

Total cuotas 180

Casa o Terreno

PLAN DE PAGO TERRENO O VIVIENDA


Nº Fecha de PagoSaldo de capital Amortización Intereses

1 20-ago-20 60000.00 199.37 320.00


2 20-sep-20 59800.63 200.43 318.94
3 20-oct-20 59600.19 201.50 317.87
4 20-nov-20 59398.69 202.58 316.79
5 20-dic-20 59196.11 203.66 315.71
6 20-ene-21 58992.45 204.75 314.63
7 20-feb-21 58787.71 205.84 313.53
8 20-mar-21 58581.87 206.94 312.44
9 20-abr-21 58374.93 208.04 311.33
10 20-may-21 58166.90 209.15 310.22
11 20-jun-21 57957.75 210.26 309.11
12 20-jul-21 57747.48 211.39 307.99
13 20-ago-21 57536.10 212.51 306.86
14 20-sep-21 57323.59 213.65 305.73
15 20-oct-21 57109.94 214.79 304.59
16 20-nov-21 56895.16 215.93 303.44
17 20-dic-21 56679.22 217.08 302.29
18 20-ene-22 56462.14 218.24 301.13
19 20-feb-22 56243.90 219.40 299.97
20 20-mar-22 56024.50 220.57 298.80
21 20-abr-22 55803.92 221.75 297.62
22 20-may-22 55582.17 222.93 296.44
23 20-jun-22 55359.24 224.12 295.25
24 20-jul-22 55135.12 225.32 294.05
25 20-ago-22 54909.80 226.52 292.85
26 20-sep-22 54683.28 227.73 291.64
27 20-oct-22 54455.55 228.94 290.43
28 20-nov-22 54226.61 230.16 289.21
29 20-dic-22 53996.45 231.39 287.98
30 20-ene-23 53765.06 232.62 286.75
31 20-feb-23 53532.43 233.87 285.51
32 20-mar-23 53298.57 235.11 284.26
33 20-abr-23 53063.45 236.37 283.01
34 20-may-23 52827.09 237.63 281.74
35 20-jun-23 52589.46 238.89 280.48
36 20-jul-23 52350.57 240.17 279.20
37 20-ago-23 52110.40 241.45 277.92
38 20-sep-23 51868.95 242.74 276.63
39 20-oct-23 51626.21 244.03 275.34
40 20-nov-23 51382.18 245.33 274.04
41 20-dic-23 51136.84 246.64 272.73
42 20-ene-24 50890.20 247.96 271.41
43 20-feb-24 50642.25 249.28 270.09
44 20-mar-24 50392.97 250.61 268.76
45 20-abr-24 50142.36 251.95 267.43
46 20-may-24 49890.41 253.29 266.08
47 20-jun-24 49637.12 254.64 264.73
48 20-jul-24 49382.48 256.00 263.37
49 20-ago-24 49126.48 257.36 262.01
50 20-sep-24 48869.12 258.74 260.64
51 20-oct-24 48610.38 260.12 259.26
52 20-nov-24 48350.27 261.50 257.87
53 20-dic-24 48088.76 262.90 256.47
54 20-ene-25 47825.87 264.30 255.07
55 20-feb-25 47561.56 265.71 253.66
56 20-mar-25 47295.85 267.13 252.24
57 20-abr-25 47028.73 268.55 250.82
58 20-may-25 46760.18 269.98 249.39
59 20-jun-25 46490.19 271.42 247.95
60 20-jul-25 46218.77 272.87 246.50
61 20-ago-25 45945.90 274.33 245.04
62 20-sep-25 45671.57 275.79 243.58
63 20-oct-25 45395.78 277.26 242.11
64 20-nov-25 45118.52 278.74 240.63
65 20-dic-25 44839.78 280.23 239.15
66 20-ene-26 44559.55 281.72 237.65
67 20-feb-26 44277.83 283.22 236.15
68 20-mar-26 43994.61 284.73 234.64
69 20-abr-26 43709.88 286.25 233.12
70 20-may-26 43423.62 287.78 231.59
71 20-jun-26 43135.84 289.31 230.06
72 20-jul-26 42846.53 290.86 228.51
73 20-ago-26 42555.67 292.41 226.96
74 20-sep-26 42263.27 293.97 225.40
75 20-oct-26 41969.30 295.54 223.84
76 20-nov-26 41673.76 297.11 222.26
77 20-dic-26 41376.65 298.70 220.68
78 20-ene-27 41077.95 300.29 219.08
79 20-feb-27 40777.67 301.89 217.48
80 20-mar-27 40475.77 303.50 215.87
81 20-abr-27 40172.27 305.12 214.25
82 20-may-27 39867.15 306.75 212.62
83 20-jun-27 39560.41 308.38 210.99
84 20-jul-27 39252.02 310.03 209.34
85 20-ago-27 38942.00 311.68 207.69
86 20-sep-27 38630.32 313.34 206.03
87 20-oct-27 38316.97 315.01 204.36
88 20-nov-27 38001.96 316.69 202.68
89 20-dic-27 37685.26 318.38 200.99
90 20-ene-28 37366.88 320.08 199.29
91 20-feb-28 37046.80 321.79 197.58
92 20-mar-28 36725.01 323.50 195.87
93 20-abr-28 36401.51 325.23 194.14
94 20-may-28 36076.27 326.96 192.41
95 20-jun-28 35749.31 328.71 190.66
96 20-jul-28 35420.60 330.46 188.91
97 20-ago-28 35090.14 332.22 187.15
98 20-sep-28 34757.92 334.00 185.38
99 20-oct-28 34423.92 335.78 183.59
100 20-nov-28 34088.14 337.57 181.80
101 20-dic-28 33750.57 339.37 180.00
102 20-ene-29 33411.21 341.18 178.19
103 20-feb-29 33070.03 343.00 176.37
104 20-mar-29 32727.03 344.83 174.54
105 20-abr-29 32382.20 346.67 172.71
106 20-may-29 32035.53 348.52 170.86
107 20-jun-29 31687.02 350.37 169.00
108 20-jul-29 31336.64 352.24 167.13
109 20-ago-29 30984.40 354.12 165.25
110 20-sep-29 30630.28 356.01 163.36
111 20-oct-29 30274.27 357.91 161.46
112 20-nov-29 29916.36 359.82 159.55
113 20-dic-29 29556.54 361.74 157.63
114 20-ene-30 29194.81 363.67 155.71
115 20-feb-30 28831.14 365.61 153.77
116 20-mar-30 28465.54 367.56 151.82
117 20-abr-30 28097.98 369.52 149.86
118 20-may-30 27728.46 371.49 147.89
119 20-jun-30 27356.98 373.47 145.90
120 20-jul-30 26983.51 375.46 143.91
121 20-ago-30 26608.05 377.46 141.91
122 20-sep-30 26230.59 379.48 139.90
123 20-oct-30 25851.11 381.50 137.87
124 20-nov-30 25469.61 383.53 135.84
125 20-dic-30 25086.08 385.58 133.79
126 20-ene-31 24700.50 387.64 131.74
127 20-feb-31 24312.87 389.70 129.67
128 20-mar-31 23923.16 391.78 127.59
129 20-abr-31 23531.38 393.87 125.50
130 20-may-31 23137.51 395.97 123.40
131 20-jun-31 22741.54 398.08 121.29
132 20-jul-31 22343.45 400.21 119.17
133 20-ago-31 21943.25 402.34 117.03
134 20-sep-31 21540.91 404.49 114.88
135 20-oct-31 21136.42 406.64 112.73
136 20-nov-31 20729.78 408.81 110.56
137 20-dic-31 20320.96 410.99 108.38
138 20-ene-32 19909.97 413.19 106.19
139 20-feb-32 19496.79 415.39 103.98
140 20-mar-32 19081.40 417.60 101.77
141 20-abr-32 18663.79 419.83 99.54
142 20-may-32 18243.96 422.07 97.30
143 20-jun-32 17821.89 424.32 95.05
144 20-jul-32 17397.57 426.58 92.79
145 20-ago-32 16970.98 428.86 90.51
146 20-sep-32 16542.12 431.15 88.22
147 20-oct-32 16110.98 433.45 85.93
148 20-nov-32 15677.53 435.76 83.61
149 20-dic-32 15241.77 438.08 81.29
150 20-ene-33 14803.69 440.42 78.95
151 20-feb-33 14363.27 442.77 76.60
152 20-mar-33 13920.50 445.13 74.24
153 20-abr-33 13475.38 447.50 71.87
154 20-may-33 13027.87 449.89 69.48
155 20-jun-33 12577.98 452.29 67.08
156 20-jul-33 12125.69 454.70 64.67
157 20-ago-33 11670.99 457.13 62.25
158 20-sep-33 11213.87 459.56 59.81
159 20-oct-33 10754.30 462.02 57.36
160 20-nov-33 10292.29 464.48 54.89
161 20-dic-33 9827.81 466.96 52.41
162 20-ene-34 9360.85 469.45 49.92
163 20-feb-34 8891.40 471.95 47.42
164 20-mar-34 8419.45 474.47 44.90
165 20-abr-34 7944.98 477.00 42.37
166 20-may-34 7467.99 479.54 39.83
167 20-jun-34 6988.44 482.10 37.27
168 20-jul-34 6506.34 484.67 34.70
169 20-ago-34 6021.67 487.26 32.12
170 20-sep-34 5534.42 489.85 29.52
171 20-oct-34 5044.56 492.47 26.90
172 20-nov-34 4552.09 495.09 24.28
173 20-dic-34 4057.00 497.73 21.64
174 20-ene-35 3559.27 500.39 18.98
175 20-feb-35 3058.88 503.06 16.31
176 20-mar-35 2555.82 505.74 13.63
177 20-abr-35 2050.08 508.44 10.93
178 20-may-35 1541.64 511.15 8.22
179 20-jun-35 1030.49 513.88 5.50
180 20-jul-35 516.62 516.62 2.76
181 20-ago-35 0.00 519.37 0.00
182 20-sep-35 -519.37 522.14 -2.77
183 20-oct-35 -1041.51 524.93 -5.55
184 20-nov-35 -1566.44 527.73 -8.35
185 20-dic-35 -2094.17 530.54 -11.17
186 20-ene-36 -2624.71 533.37 -14.00
187 20-feb-36 -3158.08 536.21 -16.84
188 20-mar-36 -3694.29 539.07 -19.70
189 20-abr-36 -4233.37 541.95 -22.58
190 20-may-36 -4775.32 544.84 -25.47
191 20-jun-36 -5320.16 547.75 -28.37
192 20-jul-36 -5867.90 550.67 -31.30
193 20-ago-36 -6418.57 553.60 -34.23
194 20-sep-36 -6972.17 556.56 -37.18
195 20-oct-36 -7528.73 559.52 -40.15
196 20-nov-36 -8088.25 562.51 -43.14
197 20-dic-36 -8650.76 565.51 -46.14
198 20-ene-37 -9216.27 568.53 -49.15
199 20-feb-37 -9784.80 571.56 -52.19
200 20-mar-37 -10356.35 574.61 -55.23
201 20-abr-37 -10930.96 577.67 -58.30
202 20-may-37 -11508.63 580.75 -61.38
203 20-jun-37 -12089.38 583.85 -64.48
204 20-jul-37 -12673.23 586.96 -67.59
205 20-ago-37 -13260.19 590.09 -70.72
206 20-sep-37 -13850.28 593.24 -73.87
207 20-oct-37 -14443.52 596.40 -77.03
208 20-nov-37 -15039.93 599.58 -80.21
209 20-dic-37 -15639.51 602.78 -83.41
210 20-ene-38 -16242.29 606.00 -86.63
211 20-feb-38 -16848.29 609.23 -89.86
212 20-mar-38 -17457.52 612.48 -93.11
213 20-abr-38 -18070.00 615.74 -96.37
214 20-may-38 -18685.74 619.03 -99.66
215 20-jun-38 -19304.77 622.33 -102.96
216 20-jul-38 -19927.10 625.65 -106.28
217 20-ago-38 -20552.75 628.99 -109.61
218 20-sep-38 -21181.74 632.34 -112.97
219 20-oct-38 -21814.08 635.71 -116.34
220 20-nov-38 -22449.79 639.10 -119.73
221 20-dic-38 -23088.90 642.51 -123.14
222 20-ene-39 -23731.41 645.94 -126.57
223 20-feb-39 -24377.35 649.38 -130.01
224 20-mar-39 -25026.73 652.85 -133.48
225 20-abr-39 -25679.58 656.33 -136.96
226 20-may-39 -26335.91 659.83 -140.46
227 20-jun-39 -26995.74 663.35 -143.98
228 20-jul-39 -27659.09 666.89 -147.52
229 20-ago-39 -28325.98 670.44 -151.07
230 20-sep-39 -28996.42 674.02 -154.65
231 20-oct-39 -29670.44 677.61 -158.24
232 20-nov-39 -30348.05 681.23 -161.86
233 20-dic-39 -31029.28 684.86 -165.49
234 20-ene-40 -31714.14 688.51 -169.14
235 20-feb-40 -32402.66 692.19 -172.81
236 20-mar-40 -33094.84 695.88 -176.51
237 20-abr-40 -33790.72 699.59 -180.22
238 20-may-40 -34490.31 703.32 -183.95
239 20-jun-40 -35193.63 707.07 -187.70
240 20-jul-40 -35900.70 710.84 -191.47
241 20-ago-40 -36611.54 714.63 -195.26
242 20-sep-40 -37326.17 718.44 -199.07
243 20-oct-40 -38044.62 722.28 -202.90
244 20-nov-40 -38766.89 726.13 -206.76
245 20-dic-40 -39493.02 730.00 -210.63
246 20-ene-41 -40223.02 733.89 -214.52
247 20-feb-41 -40956.92 737.81 -218.44
248 20-mar-41 -41694.73 741.74 -222.37
249 20-abr-41 -42436.47 745.70 -226.33
250 20-may-41 -43182.17 749.68 -230.30
251 20-jun-41 -43931.85 753.67 -234.30
252 20-jul-41 -44685.52 757.69 -238.32
253 20-ago-41 -45443.22 761.74 -242.36
254 20-sep-41 -46204.95 765.80 -246.43
255 20-oct-41 -46970.75 769.88 -250.51
256 20-nov-41 -47740.63 773.99 -254.62
257 20-dic-41 -48514.62 778.12 -258.74
258 20-ene-42 -49292.74 782.27 -262.89
259 20-feb-42 -50075.00 786.44 -267.07
260 20-mar-42 -50861.44 790.63 -271.26
261 20-abr-42 -51652.07 794.85 -275.48
262 20-may-42 -52446.92 799.09 -279.72
263 20-jun-42 -53246.01 803.35 -283.98
264 20-jul-42 -54049.36 807.63 -288.26
265 20-ago-42 -54857.00 811.94 -292.57
266 20-sep-42 -55668.94 816.27 -296.90
267 20-oct-42 -56485.21 820.63 -301.25
268 20-nov-42 -57305.84 825.00 -305.63
269 20-dic-42 -58130.84 829.40 -310.03
270 20-ene-43 -58960.24 833.83 -314.45
271 20-feb-43 -59794.07 838.27 -318.90
272 20-mar-43 -60632.34 842.74 -323.37
273 20-abr-43 -61475.09 847.24 -327.87
274 20-may-43 -62322.33 851.76 -332.39
275 20-jun-43 -63174.08 856.30 -336.93
276 20-jul-43 -64030.38 860.87 -341.50
277 20-ago-43 -64891.25 865.46 -346.09
278 20-sep-43 -65756.71 870.07 -350.70
279 20-oct-43 -66626.78 874.71 -355.34
280 20-nov-43 -67501.50 879.38 -360.01
281 20-dic-43 -68380.88 884.07 -364.70
282 20-ene-44 -69264.95 888.78 -369.41
283 20-feb-44 -70153.73 893.52 -374.15
284 20-mar-44 -71047.26 898.29 -378.92
285 20-abr-44 -71945.55 903.08 -383.71
286 20-may-44 -72848.63 907.90 -388.53
287 20-jun-44 -73756.52 912.74 -393.37
288 20-jul-44 -74669.26 917.61 -398.24
289 20-ago-44 -75586.87 922.50 -403.13
290 20-sep-44 -76509.37 927.42 -408.05
291 20-oct-44 -77436.80 932.37 -413.00
292 20-nov-44 -78369.16 937.34 -417.97
293 20-dic-44 -79306.50 942.34 -422.97
294 20-ene-45 -80248.84 947.37 -427.99
295 20-feb-45 -81196.21 952.42 -433.05
296 20-mar-45 -82148.63 957.50 -438.13
297 20-abr-45 -83106.12 962.60 -443.23
298 20-may-45 -84068.73 967.74 -448.37
299 20-jun-45 -85036.47 972.90 -453.53
300 20-jul-45 -86009.37 978.09 -458.72
301 20-ago-45 -86987.46 983.30 -463.93
302 20-sep-45 -87970.76 988.55 -469.18
303 20-oct-45 -88959.31 993.82 -474.45
304 20-nov-45 -89953.13 999.12 -479.75
305 20-dic-45 -90952.25 1004.45 -485.08
306 20-ene-46 -91956.70 1009.81 -490.44
307 20-feb-46 -92966.51 1015.19 -495.82
308 20-mar-46 -93981.70 1020.61 -501.24
309 20-abr-46 -95002.31 1026.05 -506.68
310 20-may-46 -96028.36 1031.52 -512.15
311 20-jun-46 -97059.88 1037.02 -517.65
312 20-jul-46 -98096.91 1042.56 -523.18
313 20-ago-46 -99139.46 1048.12 -528.74
314 20-sep-46 -100187.58 1053.71 -534.33
315 20-oct-46 -101241.28 1059.33 -539.95
316 20-nov-46 -102300.61 1064.97 -545.60
317 20-dic-46 -103365.58 1070.65 -551.28
318 20-ene-47 -104436.24 1076.36 -556.99
319 20-feb-47 -105512.60 1082.11 -562.73
320 20-mar-47 -106594.71 1087.88 -568.51
321 20-abr-47 -107682.59 1093.68 -574.31
322 20-may-47 -108776.26 1099.51 -580.14
323 20-jun-47 -109875.78 1105.38 -586.00
324 20-jul-47 -110981.15 1111.27 -591.90
325 20-ago-47 -112092.42 1117.20 -597.83
326 20-sep-47 -113209.62 1123.16 -603.78
327 20-oct-47 -114332.78 1129.15 -609.77
328 20-nov-47 -115461.92 1135.17 -615.80
329 20-dic-47 -116597.09 1141.22 -621.85
330 20-ene-48 -117738.32 1147.31 -627.94
331 20-feb-48 -118885.62 1153.43 -634.06
332 20-mar-48 -120039.05 1159.58 -640.21
VIENDA
Cuota
Fija
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37
519.37

También podría gustarte