FV
Returns the future value of an investment
Syntax
FV(rate, nper, pmt, [pv], [type])
Parameters
- rate: Required. The interest rate per period
- nper: Required. The total number of payment periods
- pmt: Required. The payment made each period
- pv: Optional. The present value (default 0)
- type: Optional. When payments are due (0=end of period, 1=beginning)
Example
=FV(0.06/12, 10, -200, -500, 1)