introexcel avnzado

Upload: maximopotente

Post on 03-Mar-2016

216 views

Category:

Documents


0 download

DESCRIPTION

a VANESSA SE LA INTRODUCEN

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