FV Function

Calculates what an investment or savings plan will be worth in the future.

Category

Financial

Available in

All versions, Microsoft 365

Returns

A future value

Want to practice FV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

FV grows regular payments, a starting lump sum, or both at a fixed interest rate and returns the balance at the end.

Deposits are money going out of your pocket, so enter them as negatives to get a positive future value.

Syntax

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

Arguments

ArgumentRequired?What it does
rateYesThe interest rate per period (annual rate ÷ 12 for monthly payments).
nperYesThe total number of payment periods.
pmtYesThe payment each period (negative for deposits). Use 0 if there are none.
pvNoA starting lump sum (negative if you're depositing it). Omitted = 0.
typeNoWhen payments fall: 0 or omitted = end of each period, 1 = start of each period.

Examples

Example 1 — Growing a reserve fund

Northstar puts $500 a month into a reserve earning 4% a year for five years.

B5fx=FV(B1/12,B2*12,B3)
AB
1Annual rate4%
2Years5
3Monthly deposit-$500
4
5Balance$33,149.49

That's $30,000 deposited plus $3,149.49 interest.

Example 2 — Starting balance and timing

Add a $10,000 opening deposit, then try deposits at the start of each month.

B2fx=FV(4%/12,60,-500,-10000)
AB
1ScenarioBalance
2End of month$45,359.46
3Start of month$45,469.95

Common mistakes

  • The answer is negative. Your deposits were entered as positive numbers. Make pmt and pv negative.
  • Rate and periods in different units. Keep them matched: for monthly payments divide the annual rate by 12 and multiply the years by 12. Mixing an annual rate with monthly periods gives wildly wrong answers.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.