Nothing Special   »   [go: up one dir, main page]

Tablas Armotizacion Fija y Variable

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

NO cuota CUOTA VARIABLE INTERESES AMORTIZACION SALDO PUNTO 1

0 $ 11,000,000
1 -$ 266,933.33 $ 191,400 $ 458,333.33 $ 10,541,666.67
2 -$ 274,908.33 $ 183,425.00 $ 458,333.33 $ 10,083,333.33
3 -$ 282,883.33 $ 175,450.00 $ 458,333.33 $ 9,625,000.00
4 -$ 290,858.33 $ 167,475.00 $ 458,333.33 $ 9,166,666.67
5 -$ 298,833.33 $ 159,500.00 $ 458,333.33 $ 8,708,333.33
6 -$ 306,808.33 $ 151,525.00 $ 458,333.33 $ 8,250,000.00
7 -$ 314,783.33 $ 143,550.00 $ 458,333.33 $ 7,791,666.67
8 -$ 322,758.33 $ 135,575.00 $ 458,333.33 $ 7,333,333.33
9 -$ 330,733.33 $ 127,600.00 $ 458,333.33 $ 6,875,000.00
10 -$ 338,708.33 $ 119,625.00 $ 458,333.33 $ 6,416,666.67
11 -$ 346,683.33 $ 111,650.00 $ 458,333.33 $ 5,958,333.33 PUNTO 2
12 -$ 354,658.33 $ 103,675.00 $ 458,333.33 $ 5,500,000.00
13 -$ 362,633.33 $ 95,700.00 $ 458,333.33 $ 5,041,666.67
14 -$ 370,608.33 $ 87,725.00 $ 458,333.33 $ 4,583,333.33
15 -$ 378,583.33 $ 79,750.00 $ 458,333.33 $ 4,125,000.00
16 -$ 386,558.33 $ 71,775.00 $ 458,333.33 $ 3,666,666.67
17 -$ 394,533.33 $ 63,800.00 $ 458,333.33 $ 3,208,333.33
18 -$ 402,508.33 $ 55,825.00 $ 458,333.33 $ 2,750,000.00
19 -$ 410,483.33 $ 47,850.00 $ 458,333.33 $ 2,291,666.67
20 -$ 418,458.33 $ 39,875.00 $ 458,333.33 $ 1,833,333.33
21 -$ 426,433.33 $ 31,900.00 $ 458,333.33 $ 1,375,000.00
22 -$ 434,408.33 $ 23,925.00 $ 458,333.33 $ 916,666.67
23 -$ 442,383.33 $ 15,950.00 $ 458,333.33 $ 458,333.33
24 -$ 450,358.33 $ 7,975.00 $ 458,333.33 $ -
$ 2,392,500.00

NO. PERIODOCUOTA FIJA INTERESES AMORTIZACION SALDO


0 $ 246,800,000
1 $ 9,283,007.57 $ 4,294,320 $ 4,988,687.57 $ 241,811,312.43
2 $ 9,283,007.57 $ 4,207,517 $ 5,075,490.73 $ 236,735,821.69
3 $ 9,283,007.57 $ 4,119,203 $ 5,163,804.27 $ 231,572,017.42
4 $ 9,283,007.57 $ 4,029,353 $ 5,253,654.47 $ 226,318,362.95
5 $ 9,283,007.57 $ 3,937,940 $ 5,345,068.06 $ 220,973,294.90
6 $ 9,283,007.57 $ 3,844,935 $ 5,438,072.24 $ 215,535,222.66
7 $ 9,283,007.57 $ 3,750,313 $ 5,532,694.70 $ 210,002,527.96
8 $ 9,283,007.57 $ 3,654,044 $ 5,628,963.58 $ 204,373,564.38
9 $ 9,283,007.57 $ 3,556,100 $ 5,726,907.55 $ 198,646,656.82
10 $ 9,283,007.57 $ 3,456,452 $ 5,826,555.74 $ 192,820,101.08
11 $ 9,283,007.57 $ 3,355,070 $ 5,927,937.81 $ 186,892,163.27
12 $ 9,283,007.57 $ 3,251,924 $ 6,031,083.93 $ 180,861,079.34
13 $ 9,283,007.57 $ 3,146,983 $ 6,136,024.79 $ 174,725,054.55
14 $ 9,283,007.57 $ 3,040,216 $ 6,242,791.62 $ 168,482,262.93
15 $ 9,283,007.57 $ 2,931,591 $ 6,351,416.20 $ 162,130,846.73
16 $ 9,283,007.57 $ 2,821,077 $ 6,461,930.84 $ 155,668,915.89
17 $ 9,283,007.57 $ 2,708,639 $ 6,574,368.43 $ 149,094,547.46
18 $ 9,283,007.57 $ 2,594,245 $ 6,688,762.45 $ 142,405,785.01
19 $ 9,283,007.57 $ 2,477,861 $ 6,805,146.91 $ 135,600,638.10
20 $ 9,283,007.57 $ 2,359,451 $ 6,923,556.47 $ 128,677,081.63
21 $ 9,283,007.57 $ 2,238,981 $ 7,044,026.35 $ 121,633,055.28
22 $ 9,283,007.57 $ 2,116,415 $ 7,166,592.41 $ 114,466,462.87
23 $ 9,283,007.57 $ 1,991,716 $ 7,291,291.12 $ 107,175,171.75
24 $ 9,283,007.57 $ 1,864,848 $ 7,418,159.58 $ 99,757,012.17
25 $ 9,283,007.57 $ 1,735,772 $ 7,547,235.56 $ 92,209,776.61
26 $ 9,283,007.57 $ 1,604,450 $ 7,678,557.46 $ 84,531,219.15
27 $ 9,283,007.57 $ 1,470,843 $ 7,812,164.36 $ 76,719,054.80
28 $ 9,283,007.57 $ 1,334,912 $ 7,948,096.02 $ 68,770,958.78
29 $ 9,283,007.57 $ 1,196,615 $ 8,086,392.89 $ 60,684,565.89
30 $ 9,283,007.57 $ 1,055,911 $ 8,227,096.12 $ 52,457,469.77
31 $ 9,283,007.57 $ 912,760 $ 8,370,247.60 $ 44,087,222.17
32 $ 9,283,007.57 $ 767,118 $ 8,515,889.91 $ 35,571,332.26
33 $ 9,283,007.57 $ 618,941 $ 8,664,066.39 $ 26,907,265.87
34 $ 9,283,007.57 $ 468,186 $ 8,814,821.14 $ 18,092,444.73
35 $ 9,283,007.57 $ 314,809 $ 8,968,199.03 $ 9,124,245.70
36 $ 9,283,007.57 $ 158,762 $ 9,124,245.70 $ 0.00
CAPITAL $ 246,800,000.00 NO cuota
PLAZO MESES 36 0
TASA EA 23% 1
TASA MV 1.74% 2
3
4
0.02340569079629 2.340569079629 5
6
7
8
9
10
CAPITAL $ 3,500,000.00 11
PLAZO MESES 12 12
TASA EA 32%
TASA MV 2.34%

NO. PERIODOS CUOTA FIJA INTERESES AMORTIZACIONSALDO


0 $ 50,000,000
1 $ 29,437,570.85 $ 3,000,000 ### $ 23,562,429.15
2 $ 29,437,570.85 $ 1,413,746 ### -$ 4,461,395.95
3 $ 29,437,570.85 -$ 267,684 ### -$ 34,166,650.56
4 $ 29,437,570.85 -$ 2,049,999 ### -$ 65,654,220.45
5 $ 29,437,570.85 -$ 3,939,253 ### -$ 99,031,044.52
6 $ 29,437,570.85 -$ 5,941,863 ### -$ 134,410,478.05
7 $ 29,437,570.85 -$ 8,064,629 ### -$ 171,912,677.58
8 $ 29,437,570.85 -$ 10,314,761 ### -$ 211,665,009.09
9 $ 29,437,570.85 -$ 12,699,901 ### -$ 253,802,480.48
10 $ 29,437,570.85 -$ 15,228,149 ### -$ 298,468,200.16
11 $ 29,437,570.85 -$ 17,908,092 ### -$ 345,813,863.02
12 $ 29,437,570.85 -$ 20,748,832 ### -$ 396,000,265.66
CUOTA VARIABLE INTERESES AMORTIZACION SALDO
$ 3,500,000.00
-$ 209,746.75 $ 81,920 $ 291,666.67 $ 3,208,333.33
-$ 216,573.41 $ 75,093 $ 291,666.67 $ 2,916,666.67
-$ 223,400.07 $ 68,267 $ 291,666.67 $ 2,625,000.00
-$ 230,226.73 $ 61,440 $ 291,666.67 $ 2,333,333.33
-$ 237,053.39 $ 54,613 $ 291,666.67 $ 2,041,666.67
-$ 243,880.05 $ 47,787 $ 291,666.67 $ 1,750,000.00
-$ 250,706.71 $ 40,960 $ 291,666.67 $ 1,458,333.33
-$ 257,533.37 $ 34,133 $ 291,666.67 $ 1,166,666.67
-$ 264,360.03 $ 27,307 $ 291,666.67 $ 875,000.00
-$ 271,186.69 $ 20,480 $ 291,666.67 $ 583,333.33
-$ 278,013.35 $ 13,653 $ 291,666.67 $ 291,666.67
-$ 284,840.01 $ 6,827 $ 291,666.67 $ -

capital saldo inicial $ 246,800,000.00


plazo en meses 2 años
tasa bv 6%

También podría gustarte