## How to use the FV function

*Article updated on April 14, 2018*

The FV function returns the future value of an investment based on a constant interest rate.

You can use FV with either periodic, constant payments, or a single lump sum payment.

Formula in cell B3:

=FV(0.1,5,,-1000)

The picture above shows a table that calculates the future value of $1000 with 10% interest rate for 5 years.

### Excel Function Syntax

FV(*rate*, *nper*, *pmt*, [*pv*], [*type*])

### Arguments

rate |
Required. The interest rate you want to use. |

nper |
Required. The total number of payments. |

pmt |
Required. The payment made each period. |

[pv] |
Optional. The present value. |

[type] |
Optional. When payments are due. 0 (zero) is the default value. 0 - At the end of the period. 1 - At the beginning of the period. |

### Example 2

The FV function calculates the future value if you save $1000 each year with an interest rate of 10% for five years.

### Functions in 'Financial'

The FV function function is one of many functions in the 'Financial' category.

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. Formula in cell C9: =ACCRINT(C2,C3,C4,C5,C6,C7,C8) Excel […]

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. Formula in cell C7: =ACCRINTM(C2,C3,C4,C5,C6) […]

The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding […]

The FV function returns the future value of an investment based on a constant interest rate. You can use FV […]

The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function […]

The NOMINAL function calculates the nominal annual interest rate based on the effective rate and the number of compounding periods […]

The RATE function returns the interest rate per period of an annuity. Formula in cell E3: =RATE(B3,C3,D3) Excel Function Syntax […]