The FV function (Also known as future value function) calculates the future value of an investment.
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|
|#VALUE!||If any supplied argument is nonnumeric.|