Note: “rate” is the named range F6. and the ending balance with: So, for each period in the example, we use this formula copied down the table:

With the FV function

The FV function can also be used to calculate future value. The equivalent formula is: The interest rate is used as-is, since we are compounding annually, nper is 1, since there is only one period per year, pmt is zero, since there are no additional payments, and pv is the starting balance, input as a negative value by convention.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.