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