MATEMATICAS FINANCIERA

10
Diplomado en Evaluación Financiera de Proyectos Módulo I - Nivelación en Matemática Financiera Conferencista: Luis Fernando óme! Pá"ina # de #$ TABLA DE AMORTIZACION Esta ta%la pertenece a la corporacion &' 'ILL&( Valor del prestamo 240,000,000 Tasa de interes E.A 28.82% Tada nominal M.V 2.13% Duracion en (Aos! 5 "recuencia de pa#o Mensual Numeros de pa#os 60 Cuota se#uro de $ida 21,515 tasa de inter)s mensual %.&' periodos )aldo inicial inter*s Amorti+acion cuota $ *+,$ $$$ $$$.$$ # *+/0 122 30#.#0 *4 ##+ $$$.$$ *+ $## /+2.2/ *0 #+/ /+2.2/ *0 #,, 2,/.2/ + *+/4 1/, 4$#.$, *4 $31 #42.0$ *+ $4, #0$.#/ *0 #+/ /+2.2/ *0 #,, 2,/.2/ / *+// 2/3 400.$2 *4 $+4 ,$,.20 *+ $10 1+/.13 *0 #+/ /+2.2/ *0 #,, 2,/.2/ , *+/# 31/ 130./4 *, 12$ 0#1.$1 *+ #,+ 3$1.0, *0 #+/ /+2.2/ *0 #,, 2,/.2/ 4 *++1 4$4 0+$.$+ *, 1/4 $2#.4$ *+ #22 +,0./+ *0 #+/ /+2.2/ *0 #,, 2,/.2/ 3 *++0 +0$ 23/.$/ *, 222 ,0#.2, *+ +/, 243.11 *0 #+/ /+2.2/ *0 #,, 2,/.2/ 0 *++, 122 ,$/.41 *, 2,$ 231./2 *+ +2+ ,41.,4 *0 #+/ /+2.2/ *0 #,, 2,/.2/ 2 *+++ 340 /+0.03 *, 01+ +4/.$$ *+ //# $04.2/ *0 #+/ /+2.2/ *0 #,, 2,/.2/ 1 *++$ +03 3$$.$# *, 0,+ 3$#.$2 *+ /2$ 0+0.04 *0 #+/ /+2.2/ *0 #,, 2,/.2/ #$ *+#0 2,4 #3+.03 *, 31# 21#.42 *+ ,/# ,/0.+4 *0 #+/ /+2.2/ *0 #,, 2,/.2/ ## *+#4 /3# 1/4.1$ *, 3,$ #$#.10 *+ ,2/ ++3.23 *0 #+/ /+2.2/ *0 #,, 2,/.2/ #+ *+#+ 2+4 2#3./# *, 420 +$1.+/ *+ 4/3 ##1.41 *0 #+/ /+2.2/ *0 #,, 2,/.2/ #/ *+#$ +/4 300./0 *, 4// #21.21 *+ 41$ #/2.1, *0 #+/ /+2.2/ *0 #,, 2,/.2/ #, *+$0 41$ /32.,0 *, ,02 $#1.1/ *+ 3,4 /$2.1$ *0 #+/ /+2.2/ *0 #,, 2,/.2/ #4 *+$, 222 0#,.,1 *, ,+# 30,.24 *+ 0$# 34/.12 *0 #+/ /+2.2/ *0 #,, 2,/.2/ #3 *+$+ #+1 4#4.+2 *, /3, #+1.3+ *+ 041 #11.+# *0 #+/ /+2.2/ *0 #,, 2,/.2/ #0 *#11 /## 4,4.#/ *, /$4 /42.32 *+ 2#0 10$.#4 *0 #+/ /+2.2/ *0 #,, 2,/.2/ #2 *#13 ,// 44+.+# *, +,4 //4.1# *+ 200 11+.1+ *0 #+/ /+2.2/ *0 #,, 2,/.2/ #1 *#1/ ,1, +42.$, *, #2, $/,.33 *+ 1/1 +1,.#0 *0 #+/ /+2.2/ *0 #,, 2,/.2/ +$ *#1$ ,1+ /43.1# *, #+# ,+0.0$ */ $$# 1$#.#/ *0 #+/ /+2.2/ *0 #,, 2,/.2/ +# *#20 ,+3 4#4.+1 *, $40 ,20.+$ */ $34 2,#.3/ *0 #+/ /+2.2/ *0 #,, 2,/.2/ ++ *#2, +14 /0#.+/ */ 11+ #2,.02 */ #/# #,,.$4 *0 #+/ /+2.2/ *0 #,, 2,/.2/ +/ *#2# $10 4//.2# */ 1+4 ,1#.,# */ #10 2/0.,+ *0 #+/ /+2.2/ *0 #,, 2,/.2/ +, *#00 2/# 42+.,4 */ 240 /00.,0 */ +34 14#./3 *0 #+/ /+2.2/ *0 #,, 2,/.2/ +4 *#0, ,13 $33.// */ 020 2#+.0# */ //4 4#3.#+ *0 #+/ /+2.2/ *0 #,, 2,/.2/ +3 *#0# $21 4$/.0+ */ 0#3 033.+# */ ,$3 43+.3+ *0 #+/ /+2.2/ *0 #,, 2,/.2/ +0 *#30 3#$ /2#./+ */ 3,, +$3.,/ */ ,01 #++.,$ *0 #+/ /+2.2/ *0 #,, 2,/.2/ +2 *#3, $40 #4/.3# */ 40$ #$#.#+ */ 44/ ++0.0# *0 #+/ /+2.2/ *0 #,, 2,/.2/ +1 *#3$ ,+2 +,+.#3 */ ,1, ,#0./0 */ 3+2 1##.,3 *0 #+/ /+2.2/ *0 #,, 2,/.2/ /$ *#43 0++ $/,.21 */ ,#0 #+#.43 */ 0$3 +$0.+0 *0 #+/ /+2.2/ *0 #,, 2,/.2/ Cuota con )e#uro de Vida

description

para hallar las amortizaciones que se piden en banco

Transcript of MATEMATICAS FINANCIERA

Tablas de amortTABLA DE AMORTIZACIONEsta tabla pertenece a la corporacion AV VILLASValor del prestamo240,000,000Tasa de interes E.A28.82%Tada nominal M.V2.13%Duracion en (Aos)5Frecuencia de pagoMensualNumeros de pagos60Cuota seguro de vida21,515tasa de inters mensual2.13%periodosSaldo inicialintersAmortizacioncuotaCuota con Seguro de Vida0$240,000,000.001$237,988,671.17$5,112,000.00$2,011,328.83$7,123,328.83$7,144,843.832$235,934,501.04$5,069,158.70$2,054,170.13$7,123,328.83$7,144,843.833$233,836,577.08$5,025,404.87$2,097,923.96$7,123,328.83$7,144,843.834$231,693,967.35$4,980,719.09$2,142,609.74$7,123,328.83$7,144,843.835$229,505,720.02$4,935,081.50$2,188,247.32$7,123,328.83$7,144,843.836$227,270,863.03$4,888,471.84$2,234,856.99$7,123,328.83$7,144,843.837$224,988,403.59$4,840,869.38$2,282,459.45$7,123,328.83$7,144,843.838$222,657,327.76$4,792,253.00$2,331,075.83$7,123,328.83$7,144,843.839$220,276,600.01$4,742,601.08$2,380,727.75$7,123,328.83$7,144,843.8310$217,845,162.76$4,691,891.58$2,431,437.25$7,123,328.83$7,144,843.8311$215,361,935.90$4,640,101.97$2,483,226.86$7,123,328.83$7,144,843.8312$212,825,816.31$4,587,209.23$2,536,119.59$7,123,328.83$7,144,843.8313$210,235,677.37$4,533,189.89$2,590,138.94$7,123,328.83$7,144,843.8314$207,590,368.47$4,478,019.93$2,645,308.90$7,123,328.83$7,144,843.8315$204,888,714.49$4,421,674.85$2,701,653.98$7,123,328.83$7,144,843.8316$202,129,515.28$4,364,129.62$2,759,199.21$7,123,328.83$7,144,843.8317$199,311,545.13$4,305,358.68$2,817,970.15$7,123,328.83$7,144,843.8318$196,433,552.21$4,245,335.91$2,877,992.92$7,123,328.83$7,144,843.8319$193,494,258.04$4,184,034.66$2,939,294.17$7,123,328.83$7,144,843.8320$190,492,356.91$4,121,427.70$3,001,901.13$7,123,328.83$7,144,843.8321$187,426,515.29$4,057,487.20$3,065,841.63$7,123,328.83$7,144,843.8322$184,295,371.23$3,992,184.78$3,131,144.05$7,123,328.83$7,144,843.8323$181,097,533.81$3,925,491.41$3,197,837.42$7,123,328.83$7,144,843.8324$177,831,582.45$3,857,377.47$3,265,951.36$7,123,328.83$7,144,843.8325$174,496,066.33$3,787,812.71$3,335,516.12$7,123,328.83$7,144,843.8326$171,089,503.72$3,716,766.21$3,406,562.62$7,123,328.83$7,144,843.8327$167,610,381.32$3,644,206.43$3,479,122.40$7,123,328.83$7,144,843.8328$164,057,153.61$3,570,101.12$3,553,227.71$7,123,328.83$7,144,843.8329$160,428,242.16$3,494,417.37$3,628,911.46$7,123,328.83$7,144,843.8330$156,722,034.89$3,417,121.56$3,706,207.27$7,123,328.83$7,144,843.8331$152,936,885.40$3,338,179.34$3,785,149.48$7,123,328.83$7,144,843.8332$149,071,112.23$3,257,555.66$3,865,773.17$7,123,328.83$7,144,843.8333$145,122,998.10$3,175,214.69$3,948,114.14$7,123,328.83$7,144,843.8334$141,090,789.13$3,091,119.86$4,032,208.97$7,123,328.83$7,144,843.8335$136,972,694.11$3,005,233.81$4,118,095.02$7,123,328.83$7,144,843.8336$132,766,883.67$2,917,518.38$4,205,810.44$7,123,328.83$7,144,843.8337$128,471,489.46$2,827,934.62$4,295,394.21$7,123,328.83$7,144,843.8338$124,084,603.36$2,736,442.73$4,386,886.10$7,123,328.83$7,144,843.8339$119,604,276.58$2,643,002.05$4,480,326.78$7,123,328.83$7,144,843.8340$115,028,518.84$2,547,571.09$4,575,757.74$7,123,328.83$7,144,843.8341$110,355,297.47$2,450,107.45$4,673,221.38$7,123,328.83$7,144,843.8342$105,582,536.48$2,350,567.84$4,772,760.99$7,123,328.83$7,144,843.8343$100,708,115.67$2,248,908.03$4,874,420.80$7,123,328.83$7,144,843.8344$95,729,869.71$2,145,082.86$4,978,245.96$7,123,328.83$7,144,843.8345$90,645,587.11$2,039,046.22$5,084,282.60$7,123,328.83$7,144,843.8346$85,453,009.28$1,930,751.01$5,192,577.82$7,123,328.83$7,144,843.8347$80,149,829.55$1,820,149.10$5,303,179.73$7,123,328.83$7,144,843.8348$74,733,692.10$1,707,191.37$5,416,137.46$7,123,328.83$7,144,843.8349$69,202,190.91$1,591,827.64$5,531,501.19$7,123,328.83$7,144,843.8350$63,552,868.75$1,474,006.67$5,649,322.16$7,123,328.83$7,144,843.8351$57,783,216.02$1,353,676.10$5,769,652.72$7,123,328.83$7,144,843.8352$51,890,669.70$1,230,782.50$5,892,546.33$7,123,328.83$7,144,843.8353$45,872,612.13$1,105,271.26$6,018,057.56$7,123,328.83$7,144,843.8354$39,726,369.94$977,086.64$6,146,242.19$7,123,328.83$7,144,843.8355$33,449,212.80$846,171.68$6,277,157.15$7,123,328.83$7,144,843.8356$27,038,352.20$712,468.23$6,410,860.60$7,123,328.83$7,144,843.8357$20,490,940.28$575,916.90$6,547,411.93$7,123,328.83$7,144,843.8358$13,804,068.48$436,457.03$6,686,871.80$7,123,328.83$7,144,843.8359$6,974,766.31$294,026.66$6,829,302.17$7,123,328.83$7,144,843.8360$0.00$148,562.52$6,974,766.31$7,123,328.83$7,144,843.83

&CDiplomado en Evaluacin Financiera de ProyectosMdulo I - Nivelacin en Matemtica FinancieraConferencista: Luis Fernando Gmez&CPgina &P de &N

Hoja1PerodoCuota MensualInteresesCuota amortizacinCapital vivoCapital amortizado0240,000,0001Valor Prestamo240,000,0002Tasa de Inters E.A28.82%3Tasa Nominal M.V2.13%4Duracin (en aos)55Frecuencia de pagoMensual6Nmero de pagos607Cuota Seguro de Vida21,51589101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960