value functions are exactly analogous. The table below shows the equivalency 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…
Words 6517 - Pages 27