Excel Topic

Future Value

Future Value

  1. Rate Required. The interest rate per period
  2. Nper Required. The total number of payment periods in an annuity
  3. Pmt Required. The payment made each period; it cannot change over the life of the annuity
  4. Make sure that you are consistent about the units you use for specifying rate and nper
  5. You will need to enter =FV(rate,nper,pmt)
Big image
Big image