Download doc - Amortizacion de Prestamos

Transcript
Page 1: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

AMORTIZACIÓN DE PRESTAMOS

Amortizar es pagar o redimir el capital de un préstamo mediante cuotas periódicas. En Colombia existen actualmente dos sistemas básicos de amortización de prestamos:

Abonos constantes de capital e intereses sobre saldos Cuotas iguales (uniformes o anualidades) de capital e interés.

AMORTIZACIÓN MEDIANTE ABONOS CONSTANTES DE CAPITAL

En este sistema se divide el capital inicial (monto del préstamo) en el numero cuotas con las que se vaya a cancelar, y el resultado es la parte de cada cuota que se abona al capital del préstamo que en este caso siempre es constante. La parte de intereses de la cuota se calcula multiplicando el saldo adeudado del periodo anterior por la tasa de interés efectiva periódica. EL valor de cada una de las cuotas es la simple suma de el abono a capital y la parte de interés, y el nuevo saldo adeudado se encuentra restándole al saldo del periodo anterior el abono a capital de la cuota respectiva.

ABONOS TRIMESTRALES CONSTANTES DE CAPITAL (INTERESES TRIMESTRALES SOBRE SALDOS)

Valor Préstamo $100,000,000.00 Tasa de interés 6% Efectivo TrimestralPlazo 1 Añon 4

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $100,000,000.00 1 $31,000,000.00 $6,000,000.00 $25,000,000.00 $75,000,000.002 $29,500,000.00 $4,500,000.00 $25,000,000.00 $50,000,000.003 $28,000,000.00 $3,000,000.00 $25,000,000.00 $25,000,000.004 $26,500,000.00 $1,500,000.00 $25,000,000.00 $0.00

1

Page 2: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

ABONOS SEMESTRALES CONSTANTES DE CAPITAL(INTERESES TRIMESTRALES SOBRE SALDOS)

Valor Préstamo $100,000,000.00 Tasa de interés 6% Efectivo TrimestralPlazo 1 Añon 4# de abonos 2

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $100,000,000.00 1 $6,000,000.00 $6,000,000.00 $0.00 $100,000,000.002 $56,000,000.00 $6,000,000.00 $50,000,000.00 $50,000,000.003 $3,000,000.00 $3,000,000.00 $0.00 $50,000,000.004 $53,000,000.00 $3,000,000.00 $50,000,000.00 $0.00

ABONOS MENSUALES IGUALES DE CAPITAL(INTERESES MENSUALES SOBRE SALDOS)

Valor Préstamo $100,000,000.00 Tasa de interés 6% Efectivo TrimestralTasa de interés 1.9613% Efectivo MensualPlazo 1 Añon 12

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $100,000,000.00 1 $10,294,615.58 $1,961,282.24 $8,333,333.33 $91,666,666.672 $10,131,175.39 $1,797,842.06 $8,333,333.33 $83,333,333.333 $9,967,735.20 $1,634,401.87 $8,333,333.33 $75,000,000.004 $9,804,295.01 $1,470,961.68 $8,333,333.33 $66,666,666.675 $9,640,854.83 $1,307,521.49 $8,333,333.33 $58,333,333.336 $9,477,414.64 $1,144,081.31 $8,333,333.33 $50,000,000.007 $9,313,974.45 $980,641.12 $8,333,333.33 $41,666,666.678 $9,150,534.27 $817,200.93 $8,333,333.33 $33,333,333.339 $8,987,094.08 $653,760.75 $8,333,333.33 $25,000,000.00

10 $8,823,653.89 $490,320.56 $8,333,333.33 $16,666,666.6711 $8,660,213.71 $326,880.37 $8,333,333.33 $8,333,333.3312 $8,496,773.52 $163,440.19 $8,333,333.33 $0.00

2

Page 3: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

AMORTIZACIÓN MEDIANTE CUOTAS CONSTANTES O ANUALIDADES

En este sistema lo primero que se debe calcular es el valor de las anualidades y esto se hace con base en el monto del préstamo(VP), la tasa de interés efectiva periódica y el numero de cuotas con las que se cancelará el préstamo. Luego calculamos la parte de interés de cada cuota, que al igual que en el sistema anterior, multiplicando el saldo adeudado del periodo anterior por la tasa de interés efectiva periódica. Como ya conocemos el valor de la cuota y la parte que de esta es interés, el abono a capital se obtiene como la diferencia de los rubros anteriores, es decir, restándole al valor de la cuota la parte de interés de la misma. Por ultimo, el nuevo saldo adeudado se encuentra restándole al saldo del periodo anterior el abono a capital de la cuota respectiva.

PAGOS O CUOTAS TRIMESTRALES IGUALES(CUOTAS CONSTANTES TRIMESTRALES)

Valor Préstamo $100,000,000.00 Tasa de interés 6% Efectivo TrimestralPlazo 1 Añon 4

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $100,000,000.00 1 $28,859,149.24 $6,000,000.00 $22,859,149.24 $77,140,850.762 $28,859,149.24 $4,628,451.05 $24,230,698.19 $52,910,152.573 $28,859,149.24 $3,174,609.15 $25,684,540.08 $27,225,612.494 $28,859,149.24 $1,633,536.75 $27,225,612.49 $0.00

PAGOS O CUOTAS MENSUALES IGUALES(CUOTAS CONSTANTES MENSUALES)

Valor Préstamo $100,000,000.00 Tasa de interés 6% Efectivo TrimestralTasa de interés 1.9613% Efectivo MensualPlazo 1 Año

3

Page 4: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

n 12

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $100,000,000.00 1 $9,433,489.49 $1,961,282.24 $7,472,207.25 $92,527,792.752 $9,433,489.49 $1,814,731.17 $7,618,758.32 $84,909,034.443 $9,433,489.49 $1,665,305.81 $7,768,183.67 $77,140,850.764 $9,433,489.49 $1,512,949.81 $7,920,539.68 $69,220,311.085 $9,433,489.49 $1,357,605.67 $8,075,883.82 $61,144,427.266 $9,433,489.49 $1,199,214.79 $8,234,274.69 $52,910,152.577 $9,433,489.49 $1,037,717.43 $8,395,772.06 $44,514,380.518 $9,433,489.49 $873,052.64 $8,560,436.85 $35,953,943.669 $9,433,489.49 $705,158.31 $8,728,331.18 $27,225,612.49

10 $9,433,489.49 $533,971.10 $8,899,518.38 $18,326,094.1011 $9,433,489.49 $359,426.43 $9,074,063.06 $9,252,031.0512 $9,433,489.49 $181,458.44 $9,252,031.05 $0.00

PAGOS O CUOTAS MENSUALES IGUALES ANTICIPADAS(CUOTAS CONSTANTES MENSUALES ANTICIPADAS)

Valor Préstamo $100,000,000.00 Tasa de interés 6% Efectivo TrimestralTasa de interés 1.9613% Efectivo MensualPlazo 1 Añon 12

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $9,252,031.05 $0.00 $9,252,031.05 $ 90,747,968.95 1 $9,252,031.05 $1,779,823.80 $7,472,207.25 $83,275,761.712 $9,252,031.05 $1,633,272.73 $7,618,758.32 $75,657,003.393 $9,252,031.05 $1,483,847.37 $7,768,183.67 $67,888,819.724 $9,252,031.05 $1,331,491.37 $7,920,539.68 $59,968,280.045 $9,252,031.05 $1,176,147.23 $8,075,883.82 $51,892,396.226 $9,252,031.05 $1,017,756.35 $8,234,274.69 $43,658,121.537 $9,252,031.05 $856,258.98 $8,395,772.06 $35,262,349.468 $9,252,031.05 $691,594.20 $8,560,436.85 $26,701,912.629 $9,252,031.05 $523,699.87 $8,728,331.18 $17,973,581.44

10 $9,252,031.05 $352,512.66 $8,899,518.38 $9,074,063.0611 $9,252,031.05 $177,967.99 $9,074,063.06 $0.0012 $0.00 $0.00 $0.00 $0.00

4

Page 5: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

COMPRA DE UN INMUEBLE CUYO 70% SE FINANCIA A 15 AÑOS PARA AMORTIZARLO MEDIANTE ABONOS MENSUALES

CONSTANTES DE CAPITAL E INTERESES SOBRE SALDOS

Valor Propiedad $ 80,000,000.00 Valor Préstamo $ 56,000,000.00 Tasa de interés 22% Efectivo AnualTasa de interés 1.6709% Efectivo MensualPlazo 15 Añosn 180

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $ 56,000,000.00 1 $1,246,813.09 $935,701.98 $311,111.11 $55,688,888.892 $1,241,614.74 $930,503.63 $311,111.11 $55,377,777.783 $1,236,416.40 $925,305.29 $311,111.11 $55,066,666.674 $1,231,218.06 $920,106.94 $311,111.11 $54,755,555.565 $1,226,019.71 $914,908.60 $311,111.11 $54,444,444.446 $1,220,821.37 $909,710.26 $311,111.11 $54,133,333.337 $1,215,623.02 $904,511.91 $311,111.11 $53,822,222.228 $1,210,424.68 $899,313.57 $311,111.11 $53,511,111.119 $1,205,226.33 $894,115.22 $311,111.11 $53,200,000.00

10 $1,200,027.99 $888,916.88 $311,111.11 $52,888,888.8911 $1,194,829.64 $883,718.53 $311,111.11 $52,577,777.7812 $1,189,631.30 $878,520.19 $311,111.11 $52,266,666.6713 $1,184,432.96 $873,321.85 $311,111.11 $51,955,555.5614 $1,179,234.61 $868,123.50 $311,111.11 $51,644,444.4415 $1,174,036.27 $862,925.16 $311,111.11 $51,333,333.3316 $1,168,837.92 $857,726.81 $311,111.11 $51,022,222.2217 $1,163,639.58 $852,528.47 $311,111.11 $50,711,111.1118 $1,158,441.23 $847,330.12 $311,111.11 $50,400,000.0019 $1,153,242.89 $842,131.78 $311,111.11 $50,088,888.8920 $1,148,044.55 $836,933.43 $311,111.11 $49,777,777.7821 $1,142,846.20 $831,735.09 $311,111.11 $49,466,666.6722 $1,137,647.86 $826,536.75 $311,111.11 $49,155,555.5623 $1,132,449.51 $821,338.40 $311,111.11 $48,844,444.4424 $1,127,251.17 $816,140.06 $311,111.11 $48,533,333.3325 $1,122,052.82 $810,941.71 $311,111.11 $48,222,222.2226 $1,116,854.48 $805,743.37 $311,111.11 $47,911,111.1127 $1,111,656.14 $800,545.02 $311,111.11 $47,600,000.0028 $1,106,457.79 $795,346.68 $311,111.11 $47,288,888.8929 $1,101,259.45 $790,148.34 $311,111.11 $46,977,777.7830 $1,096,061.10 $784,949.99 $311,111.11 $46,666,666.6731 $1,090,862.76 $779,751.65 $311,111.11 $46,355,555.5632 $1,085,664.41 $774,553.30 $311,111.11 $46,044,444.4433 $1,080,466.07 $769,354.96 $311,111.11 $45,733,333.3334 $1,075,267.73 $764,156.61 $311,111.11 $45,422,222.2235 $1,070,069.38 $758,958.27 $311,111.11 $45,111,111.1136 $1,064,871.04 $753,759.93 $311,111.11 $44,800,000.00

5

Page 6: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

37 $1,059,672.69 $748,561.58 $311,111.11 $44,488,888.8938 $1,054,474.35 $743,363.24 $311,111.11 $44,177,777.7839 $1,049,276.00 $738,164.89 $311,111.11 $43,866,666.6740 $1,044,077.66 $732,966.55 $311,111.11 $43,555,555.5641 $1,038,879.32 $727,768.20 $311,111.11 $43,244,444.4442 $1,033,680.97 $722,569.86 $311,111.11 $42,933,333.3343 $1,028,482.63 $717,371.52 $311,111.11 $42,622,222.2244 $1,023,284.28 $712,173.17 $311,111.11 $42,311,111.1145 $1,018,085.94 $706,974.83 $311,111.11 $42,000,000.0046 $1,012,887.59 $701,776.48 $311,111.11 $41,688,888.8947 $1,007,689.25 $696,578.14 $311,111.11 $41,377,777.7848 $1,002,490.91 $691,379.79 $311,111.11 $41,066,666.6749 $997,292.56 $686,181.45 $311,111.11 $40,755,555.5650 $992,094.22 $680,983.11 $311,111.11 $40,444,444.4451 $986,895.87 $675,784.76 $311,111.11 $40,133,333.3352 $981,697.53 $670,586.42 $311,111.11 $39,822,222.2253 $976,499.18 $665,388.07 $311,111.11 $39,511,111.1154 $971,300.84 $660,189.73 $311,111.11 $39,200,000.0055 $966,102.49 $654,991.38 $311,111.11 $38,888,888.8956 $960,904.15 $649,793.04 $311,111.11 $38,577,777.7857 $955,705.81 $644,594.70 $311,111.11 $38,266,666.6758 $950,507.46 $639,396.35 $311,111.11 $37,955,555.5659 $945,309.12 $634,198.01 $311,111.11 $37,644,444.4460 $940,110.77 $628,999.66 $311,111.11 $37,333,333.3361 $934,912.43 $623,801.32 $311,111.11 $37,022,222.2262 $929,714.08 $618,602.97 $311,111.11 $36,711,111.1163 $924,515.74 $613,404.63 $311,111.11 $36,400,000.0064 $919,317.40 $608,206.28 $311,111.11 $36,088,888.8965 $914,119.05 $603,007.94 $311,111.11 $35,777,777.7866 $908,920.71 $597,809.60 $311,111.11 $35,466,666.6767 $903,722.36 $592,611.25 $311,111.11 $35,155,555.5668 $898,524.02 $587,412.91 $311,111.11 $34,844,444.4469 $893,325.67 $582,214.56 $311,111.11 $34,533,333.3370 $888,127.33 $577,016.22 $311,111.11 $34,222,222.2271 $882,928.99 $571,817.87 $311,111.11 $33,911,111.1172 $877,730.64 $566,619.53 $311,111.11 $33,600,000.0073 $872,532.30 $561,421.19 $311,111.11 $33,288,888.8974 $867,333.95 $556,222.84 $311,111.11 $32,977,777.7875 $862,135.61 $551,024.50 $311,111.11 $32,666,666.6776 $856,937.26 $545,826.15 $311,111.11 $32,355,555.5677 $851,738.92 $540,627.81 $311,111.11 $32,044,444.4478 $846,540.58 $535,429.46 $311,111.11 $31,733,333.3379 $841,342.23 $530,231.12 $311,111.11 $31,422,222.2280 $836,143.89 $525,032.78 $311,111.11 $31,111,111.1181 $830,945.54 $519,834.43 $311,111.11 $30,800,000.0082 $825,747.20 $514,636.09 $311,111.11 $30,488,888.8983 $820,548.85 $509,437.74 $311,111.11 $30,177,777.7884 $815,350.51 $504,239.40 $311,111.11 $29,866,666.6785 $810,152.17 $499,041.05 $311,111.11 $29,555,555.5686 $804,953.82 $493,842.71 $311,111.11 $29,244,444.44

6

Page 7: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

87 $799,755.48 $488,644.37 $311,111.11 $28,933,333.3388 $794,557.13 $483,446.02 $311,111.11 $28,622,222.2289 $789,358.79 $478,247.68 $311,111.11 $28,311,111.1190 $784,160.44 $473,049.33 $311,111.11 $28,000,000.0091 $778,962.10 $467,850.99 $311,111.11 $27,688,888.8992 $773,763.76 $462,652.64 $311,111.11 $27,377,777.7893 $768,565.41 $457,454.30 $311,111.11 $27,066,666.6794 $763,367.07 $452,255.96 $311,111.11 $26,755,555.5695 $758,168.72 $447,057.61 $311,111.11 $26,444,444.4496 $752,970.38 $441,859.27 $311,111.11 $26,133,333.3397 $747,772.03 $436,660.92 $311,111.11 $25,822,222.2298 $742,573.69 $431,462.58 $311,111.11 $25,511,111.1199 $737,375.35 $426,264.23 $311,111.11 $25,200,000.00

100 $732,177.00 $421,065.89 $311,111.11 $24,888,888.89101 $726,978.66 $415,867.55 $311,111.11 $24,577,777.78102 $721,780.31 $410,669.20 $311,111.11 $24,266,666.67103 $716,581.97 $405,470.86 $311,111.11 $23,955,555.56104 $711,383.62 $400,272.51 $311,111.11 $23,644,444.44105 $706,185.28 $395,074.17 $311,111.11 $23,333,333.33106 $700,986.93 $389,875.82 $311,111.11 $23,022,222.22107 $695,788.59 $384,677.48 $311,111.11 $22,711,111.11108 $690,590.25 $379,479.14 $311,111.11 $22,400,000.00109 $685,391.90 $374,280.79 $311,111.11 $22,088,888.89110 $680,193.56 $369,082.45 $311,111.11 $21,777,777.78111 $674,995.21 $363,884.10 $311,111.11 $21,466,666.67112 $669,796.87 $358,685.76 $311,111.11 $21,155,555.56113 $664,598.52 $353,487.41 $311,111.11 $20,844,444.44114 $659,400.18 $348,289.07 $311,111.11 $20,533,333.33115 $654,201.84 $343,090.72 $311,111.11 $20,222,222.22116 $649,003.49 $337,892.38 $311,111.11 $19,911,111.11117 $643,805.15 $332,694.04 $311,111.11 $19,600,000.00118 $638,606.80 $327,495.69 $311,111.11 $19,288,888.89119 $633,408.46 $322,297.35 $311,111.11 $18,977,777.78120 $628,210.11 $317,099.00 $311,111.11 $18,666,666.67121 $623,011.77 $311,900.66 $311,111.11 $18,355,555.56122 $617,813.43 $306,702.31 $311,111.11 $18,044,444.44123 $612,615.08 $301,503.97 $311,111.11 $17,733,333.33124 $607,416.74 $296,305.63 $311,111.11 $17,422,222.22125 $602,218.39 $291,107.28 $311,111.11 $17,111,111.11126 $597,020.05 $285,908.94 $311,111.11 $16,800,000.00127 $591,821.70 $280,710.59 $311,111.11 $16,488,888.89128 $586,623.36 $275,512.25 $311,111.11 $16,177,777.78129 $581,425.02 $270,313.90 $311,111.11 $15,866,666.67130 $576,226.67 $265,115.56 $311,111.11 $15,555,555.56131 $571,028.33 $259,917.22 $311,111.11 $15,244,444.44132 $565,829.98 $254,718.87 $311,111.11 $14,933,333.33133 $560,631.64 $249,520.53 $311,111.11 $14,622,222.22134 $555,433.29 $244,322.18 $311,111.11 $14,311,111.11135 $550,234.95 $239,123.84 $311,111.11 $14,000,000.00136 $545,036.61 $233,925.49 $311,111.11 $13,688,888.89

7

Page 8: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

137 $539,838.26 $228,727.15 $311,111.11 $13,377,777.78138 $534,639.92 $223,528.81 $311,111.11 $13,066,666.67139 $529,441.57 $218,330.46 $311,111.11 $12,755,555.56140 $524,243.23 $213,132.12 $311,111.11 $12,444,444.44141 $519,044.88 $207,933.77 $311,111.11 $12,133,333.33142 $513,846.54 $202,735.43 $311,111.11 $11,822,222.22143 $508,648.20 $197,537.08 $311,111.11 $11,511,111.11144 $503,449.85 $192,338.74 $311,111.11 $11,200,000.00145 $498,251.51 $187,140.40 $311,111.11 $10,888,888.89146 $493,053.16 $181,942.05 $311,111.11 $10,577,777.78147 $487,854.82 $176,743.71 $311,111.11 $10,266,666.67148 $482,656.47 $171,545.36 $311,111.11 $9,955,555.56149 $477,458.13 $166,347.02 $311,111.11 $9,644,444.44150 $472,259.78 $161,148.67 $311,111.11 $9,333,333.33151 $467,061.44 $155,950.33 $311,111.11 $9,022,222.22152 $461,863.10 $150,751.99 $311,111.11 $8,711,111.11153 $456,664.75 $145,553.64 $311,111.11 $8,400,000.00154 $451,466.41 $140,355.30 $311,111.11 $8,088,888.89155 $446,268.06 $135,156.95 $311,111.11 $7,777,777.78156 $441,069.72 $129,958.61 $311,111.11 $7,466,666.67157 $435,871.37 $124,760.26 $311,111.11 $7,155,555.56158 $430,673.03 $119,561.92 $311,111.11 $6,844,444.44159 $425,474.69 $114,363.57 $311,111.11 $6,533,333.33160 $420,276.34 $109,165.23 $311,111.11 $6,222,222.22161 $415,078.00 $103,966.89 $311,111.11 $5,911,111.11162 $409,879.65 $98,768.54 $311,111.11 $5,600,000.00163 $404,681.31 $93,570.20 $311,111.11 $5,288,888.89164 $399,482.96 $88,371.85 $311,111.11 $4,977,777.78165 $394,284.62 $83,173.51 $311,111.11 $4,666,666.67166 $389,086.28 $77,975.16 $311,111.11 $4,355,555.56167 $383,887.93 $72,776.82 $311,111.11 $4,044,444.44168 $378,689.59 $67,578.48 $311,111.11 $3,733,333.33169 $373,491.24 $62,380.13 $311,111.11 $3,422,222.22170 $368,292.90 $57,181.79 $311,111.11 $3,111,111.11171 $363,094.55 $51,983.44 $311,111.11 $2,800,000.00172 $357,896.21 $46,785.10 $311,111.11 $2,488,888.89173 $352,697.87 $41,586.75 $311,111.11 $2,177,777.78174 $347,499.52 $36,388.41 $311,111.11 $1,866,666.67175 $342,301.18 $31,190.07 $311,111.11 $1,555,555.56176 $337,102.83 $25,991.72 $311,111.11 $1,244,444.44177 $331,904.49 $20,793.38 $311,111.11 $933,333.33178 $326,706.14 $15,595.03 $311,111.11 $622,222.22179 $321,507.80 $10,396.69 $311,111.11 $311,111.11180 $316,309.46 $5,198.34 $311,111.11 -$0.00

COMPRA DE UN INMUEBLE CUYO 70% SE FINANCIA A 15 AÑOS PARA AMORTIZARLO MEDIANTE CUOTAS MENSUALES IGUALES

8

Page 9: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

Valor Propiedad $ 80,000,000.00 Valor Préstamo $ 56,000,000.00 Tasa de interés 22% Efectivo AnualTasa de interés 1.6709% Efectivo MensualPlazo 15 Añosn 180

Periodo Valor Cuota Intereses Abono a Capital Saldo Adeudado0 $0.00 $0.00 $0.00 $ 56,000,000.00 1 $985,626.62 $935,701.98 $49,924.64 $55,950,075.362 $985,626.62 $934,867.79 $50,758.83 $55,899,316.533 $985,626.62 $934,019.66 $51,606.96 $55,847,709.574 $985,626.62 $933,157.36 $52,469.26 $55,795,240.315 $985,626.62 $932,280.65 $53,345.96 $55,741,894.346 $985,626.62 $931,389.30 $54,237.32 $55,687,657.027 $985,626.62 $930,483.05 $55,143.57 $55,632,513.458 $985,626.62 $929,561.66 $56,064.96 $55,576,448.499 $985,626.62 $928,624.87 $57,001.75 $55,519,446.74

10 $985,626.62 $927,672.43 $57,954.19 $55,461,492.5511 $985,626.62 $926,704.08 $58,922.54 $55,402,570.0112 $985,626.62 $925,719.54 $59,907.08 $55,342,662.9313 $985,626.62 $924,718.56 $60,908.06 $55,281,754.8714 $985,626.62 $923,700.84 $61,925.77 $55,219,829.0915 $985,626.62 $922,666.13 $62,960.49 $55,156,868.6016 $985,626.62 $921,614.12 $64,012.49 $55,092,856.1117 $985,626.62 $920,544.54 $65,082.08 $55,027,774.0318 $985,626.62 $919,457.09 $66,169.53 $54,961,604.5019 $985,626.62 $918,351.46 $67,275.16 $54,894,329.3420 $985,626.62 $917,227.37 $68,399.25 $54,825,930.0921 $985,626.62 $916,084.49 $69,542.13 $54,756,387.9522 $985,626.62 $914,922.51 $70,704.11 $54,685,683.8423 $985,626.62 $913,741.12 $71,885.50 $54,613,798.3424 $985,626.62 $912,539.98 $73,086.64 $54,540,711.7025 $985,626.62 $911,318.78 $74,307.84 $54,466,403.8726 $985,626.62 $910,077.17 $75,549.44 $54,390,854.4227 $985,626.62 $908,814.82 $76,811.80 $54,314,042.6228 $985,626.62 $907,531.38 $78,095.24 $54,235,947.3829 $985,626.62 $906,226.49 $79,400.13 $54,156,547.2530 $985,626.62 $904,899.79 $80,726.83 $54,075,820.4231 $985,626.62 $903,550.93 $82,075.69 $53,993,744.7332 $985,626.62 $902,179.53 $83,447.09 $53,910,297.6433 $985,626.62 $900,785.22 $84,841.40 $53,825,456.2334 $985,626.62 $899,367.60 $86,259.02 $53,739,197.2235 $985,626.62 $897,926.30 $87,700.31 $53,651,496.9036 $985,626.62 $896,460.92 $89,165.70 $53,562,331.2137 $985,626.62 $894,971.06 $90,655.56 $53,471,675.6538 $985,626.62 $893,456.30 $92,170.32 $53,379,505.3239 $985,626.62 $891,916.23 $93,710.39 $53,285,794.93

9

Page 10: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

40 $985,626.62 $890,350.42 $95,276.20 $53,190,518.7341 $985,626.62 $888,758.46 $96,868.16 $53,093,650.5742 $985,626.62 $887,139.89 $98,486.73 $52,995,163.8443 $985,626.62 $885,494.28 $100,132.34 $52,895,031.5044 $985,626.62 $883,821.17 $101,805.45 $52,793,226.0545 $985,626.62 $882,120.11 $103,506.51 $52,689,719.5446 $985,626.62 $880,390.62 $105,236.00 $52,584,483.5447 $985,626.62 $878,632.24 $106,994.38 $52,477,489.1548 $985,626.62 $876,844.47 $108,782.15 $52,368,707.0049 $985,626.62 $875,026.83 $110,599.79 $52,258,107.2250 $985,626.62 $873,178.83 $112,447.79 $52,145,659.4251 $985,626.62 $871,299.94 $114,326.68 $52,031,332.7452 $985,626.62 $869,389.66 $116,236.96 $51,915,095.7853 $985,626.62 $867,447.46 $118,179.16 $51,796,916.6254 $985,626.62 $865,472.81 $120,153.81 $51,676,762.8155 $985,626.62 $863,465.16 $122,161.46 $51,554,601.3656 $985,626.62 $861,423.97 $124,202.65 $51,430,398.7157 $985,626.62 $859,348.67 $126,277.95 $51,304,120.7658 $985,626.62 $857,238.70 $128,387.92 $51,175,732.8459 $985,626.62 $855,093.47 $130,533.15 $51,045,199.7060 $985,626.62 $852,912.40 $132,714.22 $50,912,485.4761 $985,626.62 $850,694.88 $134,931.74 $50,777,553.7362 $985,626.62 $848,440.31 $137,186.31 $50,640,367.4363 $985,626.62 $846,148.07 $139,478.55 $50,500,888.8864 $985,626.62 $843,817.53 $141,809.09 $50,359,079.7965 $985,626.62 $841,448.04 $144,178.57 $50,214,901.2166 $985,626.62 $839,038.97 $146,587.65 $50,068,313.5667 $985,626.62 $836,589.64 $149,036.98 $49,919,276.5868 $985,626.62 $834,099.39 $151,527.23 $49,767,749.3569 $985,626.62 $831,567.53 $154,059.09 $49,613,690.2670 $985,626.62 $828,993.36 $156,633.26 $49,457,057.0071 $985,626.62 $826,376.18 $159,250.44 $49,297,806.5672 $985,626.62 $823,715.27 $161,911.35 $49,135,895.2173 $985,626.62 $821,009.90 $164,616.72 $48,971,278.4974 $985,626.62 $818,259.32 $167,367.30 $48,803,911.1975 $985,626.62 $815,462.79 $170,163.83 $48,633,747.3676 $985,626.62 $812,619.53 $173,007.09 $48,460,740.2777 $985,626.62 $809,728.76 $175,897.86 $48,284,842.4178 $985,626.62 $806,789.69 $178,836.93 $48,106,005.4779 $985,626.62 $803,801.51 $181,825.11 $47,924,180.3680 $985,626.62 $800,763.40 $184,863.22 $47,739,317.1481 $985,626.62 $797,674.53 $187,952.09 $47,551,365.0582 $985,626.62 $794,534.04 $191,092.58 $47,360,272.4783 $985,626.62 $791,341.08 $194,285.54 $47,165,986.9384 $985,626.62 $788,094.77 $197,531.85 $46,968,455.0885 $985,626.62 $784,794.22 $200,832.40 $46,767,622.6886 $985,626.62 $781,438.52 $204,188.10 $46,563,434.5887 $985,626.62 $778,026.75 $207,599.87 $46,355,834.7188 $985,626.62 $774,557.97 $211,068.65 $46,144,766.0689 $985,626.62 $771,031.23 $214,595.39 $45,930,170.67

10

Page 11: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

90 $985,626.62 $767,445.56 $218,181.06 $45,711,989.6191 $985,626.62 $763,799.98 $221,826.64 $45,490,162.9792 $985,626.62 $760,093.49 $225,533.13 $45,264,629.8493 $985,626.62 $756,325.06 $229,301.55 $45,035,328.2994 $985,626.62 $752,493.67 $233,132.95 $44,802,195.3495 $985,626.62 $748,598.26 $237,028.36 $44,565,166.9996 $985,626.62 $744,637.77 $240,988.85 $44,324,178.1397 $985,626.62 $740,611.09 $245,015.53 $44,079,162.6098 $985,626.62 $736,517.14 $249,109.48 $43,830,053.1299 $985,626.62 $732,354.77 $253,271.85 $43,576,781.27

100 $985,626.62 $728,122.86 $257,503.76 $43,319,277.52101 $985,626.62 $723,820.24 $261,806.38 $43,057,471.14102 $985,626.62 $719,445.73 $266,180.89 $42,791,290.25103 $985,626.62 $714,998.12 $270,628.50 $42,520,661.76104 $985,626.62 $710,476.20 $275,150.42 $42,245,511.34105 $985,626.62 $705,878.72 $279,747.90 $41,965,763.44106 $985,626.62 $701,204.43 $284,422.19 $41,681,341.25107 $985,626.62 $696,452.03 $289,174.59 $41,392,166.65108 $985,626.62 $691,620.22 $294,006.40 $41,098,160.25109 $985,626.62 $686,707.67 $298,918.94 $40,799,241.30110 $985,626.62 $681,713.05 $303,913.57 $40,495,327.73111 $985,626.62 $676,634.97 $308,991.65 $40,186,336.08112 $985,626.62 $671,472.04 $314,154.58 $39,872,181.50113 $985,626.62 $666,222.84 $319,403.78 $39,552,777.72114 $985,626.62 $660,885.93 $324,740.69 $39,228,037.04115 $985,626.62 $655,459.85 $330,166.77 $38,897,870.27116 $985,626.62 $649,943.11 $335,683.51 $38,562,186.76117 $985,626.62 $644,334.19 $341,292.43 $38,220,894.33118 $985,626.62 $638,631.54 $346,995.08 $37,873,899.25119 $985,626.62 $632,833.61 $352,793.01 $37,521,106.24120 $985,626.62 $626,938.81 $358,687.81 $37,162,418.43121 $985,626.62 $620,945.51 $364,681.11 $36,797,737.32122 $985,626.62 $614,852.06 $370,774.56 $36,426,962.77123 $985,626.62 $608,656.80 $376,969.81 $36,049,992.95124 $985,626.62 $602,358.03 $383,268.59 $35,666,724.36125 $985,626.62 $595,954.01 $389,672.61 $35,277,051.75126 $985,626.62 $589,442.98 $396,183.64 $34,880,868.11127 $985,626.62 $582,823.17 $402,803.45 $34,478,064.66128 $985,626.62 $576,092.74 $409,533.88 $34,068,530.78129 $985,626.62 $569,249.85 $416,376.77 $33,652,154.01130 $985,626.62 $562,292.63 $423,333.99 $33,228,820.01131 $985,626.62 $555,219.15 $430,407.47 $32,798,412.55132 $985,626.62 $548,027.49 $437,599.13 $32,360,813.42133 $985,626.62 $540,715.66 $444,910.96 $31,915,902.46134 $985,626.62 $533,281.66 $452,344.96 $31,463,557.50135 $985,626.62 $525,723.45 $459,903.17 $31,003,654.33136 $985,626.62 $518,038.94 $467,587.68 $30,536,066.65137 $985,626.62 $510,226.03 $475,400.58 $30,060,666.07138 $985,626.62 $502,282.58 $483,344.04 $29,577,322.03139 $985,626.62 $494,206.41 $491,420.21 $29,085,901.82

11

Page 12: Amortizacion de Prestamos

Matemáticas Financieras – Andrés Mora – Universidad EAFIT

140 $985,626.62 $485,995.28 $499,631.34 $28,586,270.48141 $985,626.62 $477,646.96 $507,979.66 $28,078,290.82142 $985,626.62 $469,159.15 $516,467.47 $27,561,823.35143 $985,626.62 $460,529.51 $525,097.11 $27,036,726.24144 $985,626.62 $451,755.68 $533,870.94 $26,502,855.30145 $985,626.62 $442,835.25 $542,791.37 $25,960,063.93146 $985,626.62 $433,765.77 $551,860.85 $25,408,203.08147 $985,626.62 $424,544.75 $561,081.87 $24,847,121.21148 $985,626.62 $415,169.65 $570,456.97 $24,276,664.24149 $985,626.62 $405,637.91 $579,988.71 $23,696,675.53150 $985,626.62 $395,946.90 $589,679.72 $23,106,995.81151 $985,626.62 $386,093.96 $599,532.66 $22,507,463.14152 $985,626.62 $376,076.39 $609,550.23 $21,897,912.91153 $985,626.62 $365,891.44 $619,735.18 $21,278,177.73154 $985,626.62 $355,536.30 $630,090.32 $20,648,087.41155 $985,626.62 $345,008.15 $640,618.47 $20,007,468.94156 $985,626.62 $334,304.08 $651,322.54 $19,356,146.40157 $985,626.62 $323,421.15 $662,205.47 $18,693,940.93158 $985,626.62 $312,356.38 $673,270.24 $18,020,670.69159 $985,626.62 $301,106.74 $684,519.88 $17,336,150.81160 $985,626.62 $289,669.12 $695,957.50 $16,640,193.31161 $985,626.62 $278,040.39 $707,586.23 $15,932,607.08162 $985,626.62 $266,217.36 $719,409.26 $15,213,197.81163 $985,626.62 $254,196.77 $731,429.85 $14,481,767.97164 $985,626.62 $241,975.34 $743,651.28 $13,738,116.68165 $985,626.62 $229,549.70 $756,076.92 $12,982,039.76166 $985,626.62 $216,916.43 $768,710.19 $12,213,329.57167 $985,626.62 $204,072.08 $781,554.54 $11,431,775.04168 $985,626.62 $191,013.12 $794,613.50 $10,637,161.53169 $985,626.62 $177,735.95 $807,890.67 $9,829,270.86170 $985,626.62 $164,236.93 $821,389.69 $9,007,881.17171 $985,626.62 $150,512.36 $835,114.26 $8,172,766.92172 $985,626.62 $136,558.47 $849,068.15 $7,323,698.76173 $985,626.62 $122,371.42 $863,255.20 $6,460,443.56174 $985,626.62 $107,947.32 $877,679.30 $5,582,764.26175 $985,626.62 $93,282.21 $892,344.41 $4,690,419.85176 $985,626.62 $78,372.06 $907,254.56 $3,783,165.28177 $985,626.62 $63,212.77 $922,413.85 $2,860,751.44178 $985,626.62 $47,800.19 $937,826.43 $1,922,925.01179 $985,626.62 $32,130.08 $953,496.53 $969,428.47180 $985,626.62 $16,198.15 $969,428.47 $0.00

12