Explainry Tutorials to Expert in IT

Future Value (FV) function in Excel

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:

Result:

Function Errors

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




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