Easy Explanation Notes with Examples

Future Value (FV) function in Excel


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




Function Errors

Error Occurs
 #VALUE! If any supplied argument is nonnumeric.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved