between the calculator keys and Excel functions: Purpose Calculator Key Excel Function Solve for Number of Periods N NPer(rate, pmt, pv, fv, type) Solve for periodic interest rate I/Yr Rate(nper,pmt,pv,fv,type,guess) Solve for present value PV PV(rate,nper,pmt,fv,type) Solve for annuity payment PMT PMT(rate,nper,pv,fv,type) Solve for future value FV FV(rate,nper,pmt,pv,type) Just as you have to supply at least three of the variables to solve a TVM problem in a financial calculator…
Words 6517 - Pages 27