Download - introexcel avnzado
Transcript
-
4000 prestamo int.simple int.compuesto6 meses(nper) 666.666667
45% interes 0.0375 3.1447989134308200%pago(cuota del mes) 25 S/. 741.94
691.704167 S/. 4,000.00
cronograma-linea de tiempo financieraNper(tiempo) capital interes cuota(pago)
1 4000 125.791957 S/. 741.942 S/. 3,383.85 106.415416 S/. 741.943 S/. 2,748.33 86.4295215 S/. 741.944 S/. 2,092.82 65.8151112 S/. 741.945 S/. 1,416.70 44.5524191 S/. 741.946 S/. 719.32 22.6210582 S/. 741.94
451.625482 S/. 4,451.63
-
S/. 2,225.81 S/. 1,774.19
amortizacion saldoS/. 616.15 S/. 3,383.85S/. 635.52 S/. 2,748.33S/. 655.51 S/. 2,092.82S/. 676.12 S/. 1,416.70S/. 697.39 S/. 719.32S/. 719.32 S/. 0.00
S/. 4,000.00
Hoja1