D076 Minny's Excel Functions
=FV(rate, nper, pmt, [pv], [type]) - Returns future value, or cash balance you want after last payment is made. =IRR(values,[guess]) - Returns internal rate of return of series of future payments. =NPER(RATE, PMT, PV, [FV], [type]) - Returns number of payments that will be made to pay an annuity =NPV(rate,value1,[value2],...) - Returns net Present Value of a series of future payments with given rates. Used when payments are uneven. =PMT(rate,nper,pv,[fv],[type]) - Returns payment amount made each period =PV(RATE, NPER, PMT, [FV], [type]) - Returns present value, or lump sum amount that a series of future payments is worth NOW. =RATE(NPER, PMT, PV, [FV], [type], [guess]) - Returns the interest rate per period of an annuity Cash Inflow - Positive Cash outflow - Negative
Información del documento
- Subido en
- 13 de febrero de 2024
- Número de páginas
- 1
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas