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