Amortizacion de Prestamos

  • Published on
    14-Oct-2014

  • View
    107

  • Download
    2

Embed Size (px)

Transcript

<p>Matemticas Financieras Andrs Mora Universidad EAFIT AMORTIZACIN DE PRESTAMOS Amortizar es pagar o redimir el capital de un prstamo mediante cuotas peridicas. En Colombia existen actualmente dos sistemas bsicos de amortizacin de prestamos: Abonos constantes de capital e intereses sobre saldos Cuotas iguales (uniformes o anualidades) de capital e inters.</p> <p>AMORTIZACIN MEDIANTE ABONOS CONSTANTES DE CAPITAL En este sistema se divide el capital inicial (monto del prstamo) 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 prstamo 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 inters efectiva peridica. EL valor de cada una de las cuotas es la simple suma de el abono a capital y la parte de inters, y el nuevo saldo adeudado se encuentra restndole al saldo del periodo anterior el abono a capital de la cuota respectiva.</p> <p>ABONOS TRIMESTRALES CONSTANTES DE CAPITAL (INTERESES TRIMESTRALES SOBRE SALDOS)</p> <p>Valor Prstamo Tasa de inters Plazo n Periodo 0 1 2 3 4</p> <p>$100,000,000.00 6% Efectivo Trimestral 1 Ao 4 Valor Cuota $0.00 $31,000,000.00 $29,500,000.00 $28,000,000.00 $26,500,000.00 Intereses Abono a Capital Saldo Adeudado $0.00 $0.00 $100,000,000.00 $6,000,000.00 $25,000,000.00 $75,000,000.00 $4,500,000.00 $25,000,000.00 $50,000,000.00 $3,000,000.00 $25,000,000.00 $25,000,000.00 $1,500,000.00 $25,000,000.00 $0.00</p> <p>1</p> <p>Matemticas Financieras Andrs Mora Universidad EAFIT ABONOS SEMESTRALES CONSTANTES DE CAPITAL (INTERESES TRIMESTRALES SOBRE SALDOS)</p> <p>Valor Prstamo Tasa de inters Plazo n # de abonos Periodo 0 1 2 3 4</p> <p>$100,000,000.00 6% Efectivo Trimestral 1 Ao 4 2 Valor Cuota $0.00 $6,000,000.00 $56,000,000.00 $3,000,000.00 $53,000,000.00 Intereses Abono a Capital Saldo Adeudado $0.00 $0.00 $100,000,000.00 $6,000,000.00 $0.00 $100,000,000.00 $6,000,000.00 $50,000,000.00 $50,000,000.00 $3,000,000.00 $0.00 $50,000,000.00 $3,000,000.00 $50,000,000.00 $0.00</p> <p>ABONOS MENSUALES IGUALES DE CAPITAL (INTERESES MENSUALES SOBRE SALDOS)Valor Prstamo Tasa de inters Tasa de inters Plazo n Periodo 0 1 2 3 4 5 6 7 8 9 10 11 12 $100,000,000.00 6% Efectivo Trimestral 1.9613% Efectivo Mensual 1 Ao 12 Valor Cuota $0.00 $10,294,615.58 $10,131,175.39 $9,967,735.20 $9,804,295.01 $9,640,854.83 $9,477,414.64 $9,313,974.45 $9,150,534.27 $8,987,094.08 $8,823,653.89 $8,660,213.71 $8,496,773.52 Intereses Abono a Capital Saldo Adeudado $0.00 $0.00 $100,000,000.00 $1,961,282.24 $8,333,333.33 $91,666,666.67 $1,797,842.06 $8,333,333.33 $83,333,333.33 $1,634,401.87 $8,333,333.33 $75,000,000.00 $1,470,961.68 $8,333,333.33 $66,666,666.67 $1,307,521.49 $8,333,333.33 $58,333,333.33 $1,144,081.31 $8,333,333.33 $50,000,000.00 $980,641.12 $8,333,333.33 $41,666,666.67 $817,200.93 $8,333,333.33 $33,333,333.33 $653,760.75 $8,333,333.33 $25,000,000.00 $490,320.56 $8,333,333.33 $16,666,666.67 $326,880.37 $8,333,333.33 $8,333,333.33 $163,440.19 $8,333,333.33 $0.00</p> <p>2</p> <p>Matemticas Financieras Andrs Mora Universidad EAFIT AMORTIZACIN 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 prstamo(VP), la tasa de inters efectiva peridica y el numero de cuotas con las que se cancelar el prstamo. Luego calculamos la parte de inters de cada cuota, que al igual que en el sistema anterior, multiplicando el saldo adeudado del periodo anterior por la tasa de inters efectiva peridica. Como ya conocemos el valor de la cuota y la parte que de esta es inters, el abono a capital se obtiene como la diferencia de los rubros anteriores, es decir, restndole al valor de la cuota la parte de inters de la misma. Por ultimo, el nuevo saldo adeudado se encuentra restndole al saldo del periodo anterior el abono a capital de la cuota respectiva.</p> <p>PAGOS O CUOTAS TRIMESTRALES IGUALES (CUOTAS CONSTANTES TRIMESTRALES)</p> <p>Valor Prstamo Tasa de inters Plazo n Periodo 0 1 2 3 4</p> <p>$100,000,000.00 6% Efectivo Trimestral 1 Ao 4 Valor Cuota $0.00 $28,859,149.24 $28,859,149.24 $28,859,149.24 $28,859,149.24 Intereses Abono a Capital Saldo Adeudado $0.00 $0.00 $100,000,000.00 $6,000,000.00 $22,859,149.24 $77,140,850.76 $4,628,451.05 $24,230,698.19 $52,910,152.57 $3,174,609.15 $25,684,540.08 $27,225,612.49 $1,633,536.75 $27,225,612.49 $0.00</p> <p>PAGOS O CUOTAS MENSUALES IGUALES (CUOTAS CONSTANTES MENSUALES)Valor Prstamo Tasa de inters Tasa de inters Plazo n $100,000,000.00 6% Efectivo Trimestral 1.9613% Efectivo Mensual 1 Ao 12</p> <p>3</p> <p>Matemticas Financieras Andrs Mora Universidad EAFITPeriodo 0 1 2 3 4 5 6 7 8 9 10 11 12 Valor Cuota $0.00 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 $9,433,489.49 Intereses Abono a Capital Saldo Adeudado $0.00 $0.00 $100,000,000.00 $1,961,282.24 $7,472,207.25 $92,527,792.75 $1,814,731.17 $7,618,758.32 $84,909,034.44 $1,665,305.81 $7,768,183.67 $77,140,850.76 $1,512,949.81 $7,920,539.68 $69,220,311.08 $1,357,605.67 $8,075,883.82 $61,144,427.26 $1,199,214.79 $8,234,274.69 $52,910,152.57 $1,037,717.43 $8,395,772.06 $44,514,380.51 $873,052.64 $8,560,436.85 $35,953,943.66 $705,158.31 $8,728,331.18 $27,225,612.49 $533,971.10 $8,899,518.38 $18,326,094.10 $359,426.43 $9,074,063.06 $9,252,031.05 $181,458.44 $9,252,031.05 $0.00</p> <p>PAGOS O CUOTAS MENSUALES IGUALES ANTICIPADAS (CUOTAS CONSTANTES MENSUALES ANTICIPADAS)</p> <p>Valor Prstamo Tasa de inters Tasa de inters Plazo n Periodo 0 1 2 3 4 5 6 7 8 9 10 11 12</p> <p>$100,000,000.00 6% Efectivo Trimestral 1.9613% Efectivo Mensual 1 Ao 12 Valor Cuota $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $9,252,031.05 $0.00 Intereses Abono a Capital Saldo Adeudado $0.00 $9,252,031.05 $ 90,747,968.95 $1,779,823.80 $7,472,207.25 $83,275,761.71 $1,633,272.73 $7,618,758.32 $75,657,003.39 $1,483,847.37 $7,768,183.67 $67,888,819.72 $1,331,491.37 $7,920,539.68 $59,968,280.04 $1,176,147.23 $8,075,883.82 $51,892,396.22 $1,017,756.35 $8,234,274.69 $43,658,121.53 $856,258.98 $8,395,772.06 $35,262,349.46 $691,594.20 $8,560,436.85 $26,701,912.62 $523,699.87 $8,728,331.18 $17,973,581.44 $352,512.66 $8,899,518.38 $9,074,063.06 $177,967.99 $9,074,063.06 $0.00 $0.00 $0.00 $0.00</p> <p>4</p> <p>Matemticas Financieras Andrs Mora Universidad EAFIT COMPRA DE UN INMUEBLE CUYO 70% SE FINANCIA A 15 AOS PARA AMORTIZARLO MEDIANTE ABONOS MENSUALES CONSTANTES DE CAPITAL E INTERESES SOBRE SALDOSValor Propiedad $ 80,000,000.00 Valor Prstamo $ 56,000,000.00 Tasa de inters 22% Efectivo Anual Tasa de inters 1.6709% Efectivo Mensual Plazo 15 Aos n 180 Periodo 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Valor Cuota $0.00 $1,246,813.09 $1,241,614.74 $1,236,416.40 $1,231,218.06 $1,226,019.71 $1,220,821.37 $1,215,623.02 $1,210,424.68 $1,205,226.33 $1,200,027.99 $1,194,829.64 $1,189,631.30 $1,184,432.96 $1,179,234.61 $1,174,036.27 $1,168,837.92 $1,163,639.58 $1,158,441.23 $1,153,242.89 $1,148,044.55 $1,142,846.20 $1,137,647.86 $1,132,449.51 $1,127,251.17 $1,122,052.82 $1,116,854.48 $1,111,656.14 $1,106,457.79 $1,101,259.45 $1,096,061.10 $1,090,862.76 $1,085,664.41 $1,080,466.07 $1,075,267.73 $1,070,069.38 $1,064,871.04 Intereses Abono a Capital Saldo Adeudado $0.00 $0.00 $ 56,000,000.00 $935,701.98 $311,111.11 $55,688,888.89 $930,503.63 $311,111.11 $55,377,777.78 $925,305.29 $311,111.11 $55,066,666.67 $920,106.94 $311,111.11 $54,755,555.56 $914,908.60 $311,111.11 $54,444,444.44 $909,710.26 $311,111.11 $54,133,333.33 $904,511.91 $311,111.11 $53,822,222.22 $899,313.57 $311,111.11 $53,511,111.11 $894,115.22 $311,111.11 $53,200,000.00 $888,916.88 $311,111.11 $52,888,888.89 $883,718.53 $311,111.11 $52,577,777.78 $878,520.19 $311,111.11 $52,266,666.67 $873,321.85 $311,111.11 $51,955,555.56 $868,123.50 $311,111.11 $51,644,444.44 $862,925.16 $311,111.11 $51,333,333.33 $857,726.81 $311,111.11 $51,022,222.22 $852,528.47 $311,111.11 $50,711,111.11 $847,330.12 $311,111.11 $50,400,000.00 $842,131.78 $311,111.11 $50,088,888.89 $836,933.43 $311,111.11 $49,777,777.78 $831,735.09 $311,111.11 $49,466,666.67 $826,536.75 $311,111.11 $49,155,555.56 $821,338.40 $311,111.11 $48,844,444.44 $816,140.06 $311,111.11 $48,533,333.33 $810,941.71 $311,111.11 $48,222,222.22 $805,743.37 $311,111.11 $47,911,111.11 $800,545.02 $311,111.11 $47,600,000.00 $795,346.68 $311,111.11 $47,288,888.89 $790,148.34 $311,111.11 $46,977,777.78 $784,949.99 $311,111.11 $46,666,666.67 $779,751.65 $311,111.11 $46,355,555.56 $774,553.30 $311,111.11 $46,044,444.44 $769,354.96 $311,111.11 $45,733,333.33 $764,156.61 $311,111.11 $45,422,222.22 $758,958.27 $311,111.11 $45,111,111.11 $753,759.93 $311,111.11 $44,800,000.00</p> <p>5</p> <p>Matemticas Financieras Andrs Mora Universidad EAFIT37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 $1,059,672.69 $1,054,474.35 $1,049,276.00 $1,044,077.66 $1,038,879.32 $1,033,680.97 $1,028,482.63 $1,023,284.28 $1,018,085.94 $1,012,887.59 $1,007,689.25 $1,002,490.91 $997,292.56 $992,094.22 $986,895.87 $981,697.53 $976,499.18 $971,300.84 $966,102.49 $960,904.15 $955,705.81 $950,507.46 $945,309.12 $940,110.77 $934,912.43 $929,714.08 $924,515.74 $919,317.40 $914,119.05 $908,920.71 $903,722.36 $898,524.02 $893,325.67 $888,127.33 $882,928.99 $877,730.64 $872,532.30 $867,333.95 $862,135.61 $856,937.26 $851,738.92 $846,540.58 $841,342.23 $836,143.89 $830,945.54 $825,747.20 $820,548.85 $815,350.51 $810,152.17 $804,953.82 $748,561.58 $743,363.24 $738,164.89 $732,966.55 $727,768.20 $722,569.86 $717,371.52 $712,173.17 $706,974.83 $701,776.48 $696,578.14 $691,379.79 $686,181.45 $680,983.11 $675,784.76 $670,586.42 $665,388.07 $660,189.73 $654,991.38 $649,793.04 $644,594.70 $639,396.35 $634,198.01 $628,999.66 $623,801.32 $618,602.97 $613,404.63 $608,206.28 $603,007.94 $597,809.60 $592,611.25 $587,412.91 $582,214.56 $577,016.22 $571,817.87 $566,619.53 $561,421.19 $556,222.84 $551,024.50 $545,826.15 $540,627.81 $535,429.46 $530,231.12 $525,032.78 $519,834.43 $514,636.09 $509,437.74 $504,239.40 $499,041.05 $493,842.71 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $44,488,888.89 $44,177,777.78 $43,866,666.67 $43,555,555.56 $43,244,444.44 $42,933,333.33 $42,622,222.22 $42,311,111.11 $42,000,000.00 $41,688,888.89 $41,377,777.78 $41,066,666.67 $40,755,555.56 $40,444,444.44 $40,133,333.33 $39,822,222.22 $39,511,111.11 $39,200,000.00 $38,888,888.89 $38,577,777.78 $38,266,666.67 $37,955,555.56 $37,644,444.44 $37,333,333.33 $37,022,222.22 $36,711,111.11 $36,400,000.00 $36,088,888.89 $35,777,777.78 $35,466,666.67 $35,155,555.56 $34,844,444.44 $34,533,333.33 $34,222,222.22 $33,911,111.11 $33,600,000.00 $33,288,888.89 $32,977,777.78 $32,666,666.67 $32,355,555.56 $32,044,444.44 $31,733,333.33 $31,422,222.22 $31,111,111.11 $30,800,000.00 $30,488,888.89 $30,177,777.78 $29,866,666.67 $29,555,555.56 $29,244,444.44</p> <p>6</p> <p>Matemticas Financieras Andrs Mora Universidad EAFIT87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 $799,755.48 $794,557.13 $789,358.79 $784,160.44 $778,962.10 $773,763.76 $768,565.41 $763,367.07 $758,168.72 $752,970.38 $747,772.03 $742,573.69 $737,375.35 $732,177.00 $726,978.66 $721,780.31 $716,581.97 $711,383.62 $706,185.28 $700,986.93 $695,788.59 $690,590.25 $685,391.90 $680,193.56 $674,995.21 $669,796.87 $664,598.52 $659,400.18 $654,201.84 $649,003.49 $643,805.15 $638,606.80 $633,408.46 $628,210.11 $623,011.77 $617,813.43 $612,615.08 $607,416.74 $602,218.39 $597,020.05 $591,821.70 $586,623.36 $581,425.02 $576,226.67 $571,028.33 $565,829.98 $560,631.64 $555,433.29 $550,234.95 $545,036.61 $488,644.37 $483,446.02 $478,247.68 $473,049.33 $467,850.99 $462,652.64 $457,454.30 $452,255.96 $447,057.61 $441,859.27 $436,660.92 $431,462.58 $426,264.23 $421,065.89 $415,867.55 $410,669.20 $405,470.86 $400,272.51 $395,074.17 $389,875.82 $384,677.48 $379,479.14 $374,280.79 $369,082.45 $363,884.10 $358,685.76 $353,487.41 $348,289.07 $343,090.72 $337,892.38 $332,694.04 $327,495.69 $322,297.35 $317,099.00 $311,900.66 $306,702.31 $301,503.97 $296,305.63 $291,107.28 $285,908.94 $280,710.59 $275,512.25 $270,313.90 $265,115.56 $259,917.22 $254,718.87 $249,520.53 $244,322.18 $239,123.84 $233,925.49 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $311,111.11 $28,933,333.33 $28,622,222.22 $28,311,111.11 $28,000,000.00 $27,688,888.89 $27,377,777.78 $27,066,666.67 $26,755,555.56 $26,444,444.44 $26,133,333.33 $25,822,222.22 $25,511,111.11 $25,200,000.00 $24,888,888.89 $24,577,777.78 $24,266,666.67 $23,955,555.56 $23,644,444.44 $23,333,333.33 $23,022,222.22 $22,711,111.11 $22,400,000.00 $22,088,888.89 $21,777,777.78 $21,466,666.67 $21,155,555.56 $20,844,444.44 $20,533,333.33 $20,222,222.22 $19,911,111.11 $19,600,000.00 $19,288,888.89 $18,977,777.78 $18,666,666.67 $18,355,555.56 $18,044,444.44 $17,733,333.33 $17,422,222.22 $17,111,111.11 $16,800,000.00 $16,488,888.89 $16,177,777.78 $15,866,666.67 $15,555,555.56 $15,244,444.44 $14,933,333.33 $14,622,222.22 $14,311,111.11 $14,000,000.00 $13,688,888.89</p> <p>7</p> <p>Matemticas Financieras Andrs Mora Universidad EAFIT137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 $539,838.26 $534,639.92 $529,441.57 $524,243.23 $519,044.88 $513,846.54 $508,648.20 $503,449.85 $498,251.51 $493,053.16 $487,854.82 $482,656.47 $477,458.13 $472,259.78 $467,061.44 $461,863.10 $456,664.75 $451,466.41 $446,268.06 $441,069.72 $435,871.37 $430,673.03 $42...</p>