D076 Module 5 EVALUATION REVIEW

=FV(rate,nper,pmt,[pv],[type]) - Returns the future value, or the cash balance you want to attain after the last payment is made =IRR(values,[guess]) - Returns the 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 the 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 annuity - A stream of cash flows of an equal amount paid every consecutive period annuity due - a series of equal payments made at the beginning of consecutive periods compounding - finding a future value given a present value discounting - finding a present value given a future value