Use
The FV function (Also known as future value function) calculates the future value of an investment.
Syntax
FV(rate,nper,pmt,[pv],[type])
rate – The interest rate per period. (per month or annum etc.)
nper – The number of payment periods in an annuity/ investment.
pmt – The payment made during each period.
[pv] – [optional] The present value of future payments. If omitted, assumed to be zero. Must be entered as a negative number.
[type] – The optional argument that indicated when payments are due:
Set type equal to |
If payments are due |
0 | At the end of the period |
1 | At the beginning of the period |
Example
Formula:
Function Errors
Error | Occurs |
#VALUE! | If any supplied argument is nonnumeric. |