D076 Module 5 quiz ratedA+
=FV(rate,nper,pmt,[pv],[type]) - Future Value Function, or the cash balance you want toattain after the last payment is made =IRR(values,[guess]) - internal rate of return of a series of future payments =NPER(RATE, PMT, PV, [FV], [type]) - Returns the number of payment periods in an annuity =NPV(rate,value1,[value2],...) - Returns the net present value of a series of future payments with a given rate =PMT(rate,nper,pv,[fv],[type]) - Returns the payment made each period (this has to be an annuity) =PV(RATE, NPER, PMT, [FV], [type]) - Returns the present Value, or lump sum amount that a series of future payments is worth right now =RATE(NPER, PMT, PV, [FV], [type], [guess]) - Returns the interest rate per period fv - future value, or the cash balance you want to attain after the past payment is made Lolo invested $30000 today in an account that gives 3% interest. Starting one year from today, she will be able to pull out little over $3500 a year. What does the $30000 represent - Present Value nper - number of payments in a annuity pmt - payment made each period
Información del documento
- Subido en
- 13 de febrero de 2024
- Número de páginas
- 2
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas