calculos amortizacion

3
Deuda 15800 tasa 0.156 plazo 2 capitalizaciones 4 pago $ 2,337.06 Período Cuota Interés Amortización Saldo 0 15800 1 $ 2,337.06 616.2 $ 1,720.86 14079.1409 2 $ 2,337.06 549.086494 $ 1,787.97 12291.1682 3 $ 2,337.06 479.355561 $ 1,857.70 10433.4647 4 $ 2,337.06 406.905122 $ 1,930.15 8503.31067 5 $ 2,337.06 331.629116 $ 2,005.43 6497.88065 6 $ 2,337.06 253.417346 $ 2,083.64 4414.23887 7 $ 2,337.06 172.155316 $ 2,164.90 2249.33506 8 $ 2,337.06 87.7240674 $ 2,249.34 0.00 ### 2896.47302 $ 15,800.00

Upload: fabian-cajas

Post on 06-Sep-2015

216 views

Category:

Documents


3 download

DESCRIPTION

Amortización

TRANSCRIPT

Hoja1Deuda15800tasa0.156plazo2$ 1,720.86capitalizaciones4pago$ 2,337.06$ 1,720.86PerodoCuotaIntersAmortizacinSaldo0158001$ 2,337.06616.2$ 1,720.8614079.14087219942$ 2,337.06549.0864940158$ 1,787.9712291.16823841463$ 2,337.06479.3555612982$ 1,857.7010433.46467191224$ 2,337.06406.9051222046$ 1,930.158503.31066631625$ 2,337.06331.6291159863$ 2,005.436497.8806545026$ 2,337.06253.4173455256$ 2,083.644414.2388722277$ 2,337.06172.1553160169$ 2,164.902249.33506044338$ 2,337.0687.7240673573$ 2,249.34-0.00$ 18,696.472896.4730224046$ 15,800.00

Hoja2Deuda800tasa0.03plazo6capitalizaciones1pago$ 147.68

PerodoCuotaIntersAmortizacinSaldo08001$ 147.6824$ 123.68676.32199963992$ 147.6820.2896599892$ 127.39548.93365926893$ 147.6816.4680097781$ 131.21417.72366868684$ 147.6812.5317100606$ 135.15282.57737838735$ 147.688.4773213516$ 139.20143.37669937886$ 147.684.3013009814$ 143.380$ 886.0786.0680021609$ 800.00