TABLAS DE AMORTIZACION

 
 
 
 
 
 
 
 
EJERCICIO DE TABLAS DE AMORTIZACION








Tabla de amortización para 12 periodos, con tasa de interés 1.95% mensual con prestamos de $ 10.000.000 de pesos, con cuota fija a travésdel tiempo.











































1.950%
tasa de interés mensual

monto
$10,000,000



N =
12













periodos

inicial

interés
amort
cuota
final


0
 
 
 
 
$10,000,000.001
$10,000,000.00
$195,000.00
$747,694.72
$942,694.72
$9,252,305.28


2
$9,252,305.28
$180,419.95
$762,274.76
$942,694.72
$8,490,030.52


3
$8,490,030.52
$165,555.60
$777,139.12$942,694.72
$7,712,891.40


4
$7,712,891.40
$150,401.38
$792,293.33
$942,694.72
$6,920,598.07


5
$6,920,598.07
$134,951.66
$807,743.05
$942,694.72
$6,112,855.02


6
$6,112,855.02
$119,200.67$823,494.04
$942,694.72
$5,289,360.97


7
$5,289,360.97
$103,142.54
$839,552.18
$942,694.72
$4,449,808.80


8
$4,449,808.80
$86,771.27
$855,923.44
$942,694.72
$3,593,885.35


9$3,593,885.35
$70,080.76
$872,613.95
$942,694.72
$2,721,271.40


10
$2,721,271.40
$53,064.79
$889,629.92
$942,694.72
$1,831,641.48


11
$1,831,641.48
$35,717.01
$906,977.71
$942,694.72
$924,663.7712
$924,663.77
$18,030.94
$924,663.77
$942,694.72
0.00


















 
 
 
 
 
 
 
 








3.00%
tasa de interés mensual

monto
$ 1,000.00


12
numerode periodos













Un préstamo a 12 meses, al 3% efectivo mensual vencido pagadero a 12 meses con cuotas que se duplican cada

mes. Recuerde que para la solución de este ejercicio debeutilizar la función celda objetivo.










periodos
inicial
interés
amort
cuota
final
gradiente

0
 
 
 
 
$1,000.00
 

1
$1,000.00
$30.00
($19.46)
$10.54
$1,019.46
0.00

2
$1,019.46
$30.58($20.04)
$10.54
$1,039.50
0.00

3
$1,039.50
$31.19
($10.10)
$21.08
$1,049.61
1.00

4
$1,049.61
$31.49
($10.41)
$21.08
$1,060.01
0.00

5
$1,060.01
$31.80
$10.36
$42.16
$1,049.65
1.00

6...