TABLAS DE AMORTIZACIÓN
Enviado por Jorge9216 • 5 de Junio de 2018 • Trabajo • 2.637 Palabras (11 Páginas) • 164 Visitas
TABLAS DE AMORTIZACIÓN
- El gerente del restaurante del hotel xl desea renovar la cristalería y mantelería con un valor de $156,390.00, mediante 13 pagos bimestrales vencidos, suponiendo un interés del 16% semestral.
- Encuentre Derechos de Deudor y Derechos de Acreedor del noveno periodo
- Considere que los pagos son anticipados, elabore tabla.
- Suponiendo que el primer pago lo realiza en el quinto bimestre después de haber adquirido la deuda, encontrar la renta
- Considere que realiza 3 pagos extraordinarios de $13,000.00 en el 4, 7 y 12 bimestre de la Anualidad vencida.
DATOS | SUSTITUCIÓN |
A= 156,390.00 N= 13bimestres I= 16% semestral | = 0.0507 = 5.07% bimestral[pic 1]
|
TABLAS DE AMORTIZACIÓN | ||||
N | SALDO | RENTA | INTERES | AMORTIZACIÓN |
0 | 156,390.00 | - | - | - |
1 | 147,600.12 | 16,718.85 | 7,928.97 | 8,789.88 |
2 | 138,364.60 | 16,718.85 | 7,483.33 | 9,235.52 |
3 | 128,660.83 | 16,718.85 | 7,015.09 | 9,703.76 |
4 | 118,465.09 | 16,718.85 | 6,523.10 | 10,195.75 |
5 | 107,752.42 | 16,718.85 | 6,006.18 | 10,712.67 |
6 | 96,496.62 | 16,718.85 | 5,463.05 | 11,255.80 |
7 | 84,670.14 | 16,718.85 | 4,892.38 | 11,826.47 |
8 | 72,244.07 | 16,718.85 | 4,292.78 | 12,426.07 |
9 | 59,188.00 | 16,718.85 | 3,662.77 | 13,056.08 |
10 | 45,469.98 | 16,718.85 | 3,000.83 | 13,718.02 |
11 | 31,056.45 | 16,718.85 | 2,305.33 | 14,413.52 |
12 | 15,912.17 | 16,718.85 | 1,574.56 | 15,144.29 |
13 | 0.06 | 16,718.85 | 806.75 | 15,912.10 |
N | SALDO | RENTA | INTERES | AMORTIZACIÓN |
1 | 156,390.00 | 15,912.11 | 0 | 15,912.11 |
2 | 140,477.89 | 15,912.11 | 7,122.23 | 8,789.88 |
3 | 131,688.01 | 15,912.11 | 6,676.58 | 9,235.53 |
4 | 122,452.48 | 15,912.11 | 6,208.34 | 9,703.77 |
5 | 112,748.71 | 15,912.11 | 5,716.36 | 10,195.75 |
6 | 102,552.96 | 15,912.11 | 5,199.44 | 10,712.67 |
7 | 91,840.29 | 15,912.11 | 4,656.30 | 11,255.81 |
8 | 80,584.48 | 15,912.11 | 4,085.63 | 11,826.48 |
9 | 68,758.00 | 15,912.11 | 3,486.03 | 12,426.08 |
10 | 56,331.92 | 15,912.11 | 2,856.03 | 13,056.08 |
11 | 43,275.84 | 15,912.11 | 2,194.09 | 13,718.02 |
12 | 29,557.82 | 15,912.11 | 1,498.58 | 14,413.53 |
13 | 15,144.29 | 15,912.11 | 767.82 | 15,144.29 |
14 | - 0.01 |
|
|
|
N | SALDO | RENTA | INTERES | AMORTIZACIÓN |
1 | 156,390.00 | - | 7,928.97 | 7,928.97 |
2 | 164,318.97 | - | 8,330.97 | 8,330.97 |
3 | 172,649.94 | - | 8,753.35 | 8,753.35 |
4 | 181,403.30 | - | 9,197.15 | 9,197.15 |
5 | 190,600.44 | - | 9,663.44 | 9,663.44 |
6 | 170,224.32 | 20,376.12 | 8,630.37 | 11,745.75 |
7 | 149,848.20 | 20,376.12 | 7,597.30 | 12,778.82 |
8 | 129,472.08 | 20,376.12 | 6,564.23 | 13,811.89 |
9 | 109,095.96 | 20,376.12 | 5,531.17 | 14,844.95 |
10 | 88,719.84 | 20,376.12 | 4,498.10 | 15,878.02 |
11 | 68,343.72 | 20,376.12 | 3,465.03 | 16,911.09 |
12 | 47,967.60 | 20,376.12 | 2,431.96 | 17,944.16 |
13 | 27,590.48 | 20,377.12 | 1,398.84 | 18,978.28 |
N | SALDO | RENTA | INTERES | AMORTIZACIÓN |
0 | 156,390.00 | - | - | - |
1 | 150,491.23 | 13,827.74 | 7,928.97 | 5,898.77 |
2 | 144,293.40 | 13,827.74 | 7,629.91 | 6,197.83 |
3 | 137,781.33 | 13,827.74 | 7,315.68 | 6,512.06 |
4 | 117,939.11 | 13,827.74 | 6,985.51 | 6,842.23 |
5 | 110,090.88 | 13,827.74 | 5,979.51 | 7,848.23 |
6 | 101,844.75 | 13,827.74 | 5,581.61 | 8,246.13 |
7 | 80,180.54 | 13,827.74 | 5,163.53 | 8,664.21 |
8 | 70,417.95 | 13,827.74 | 4,065.15 | 9,762.59 |
9 | 60,160.40 | 13,827.74 | 3,570.19 | 10,257.55 |
10 | 49,382.79 | 13,827.74 | 3,050.13 | 10,777.61 |
11 | 38,058.76 | 13,827.74 | 2,503.71 | 11,324.03 |
12 | 13,160.60 | 13,827.74 | 1,929.58 | 11,898.16 |
13 | 0.10 | 13,827.74 | 667.24 | 13,160.50 |
...