Excel FV function💰 Future value
The FV function: Future value. Savings plans, education funds. This page shows the syntax, a worked example with its result and how the formula reads.
What does FV do?
Future value. Savings plans, education funds
FV syntax
=FV(rate, nper, pmt, [pv], [type])
Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation
FV example with the result
=********
👑 Ready-to-use example formula for VIP supporters only · Become VIP
Formula in cell B4 Yellow cells = result
| A | B | |
|---|---|---|
| 1 | Save per month | 2,000 |
| 2 | Rate per year | 3% |
| 3 | Years | 10 |
| 4 | You will have | 279,482.84 |
How it reads: Monthly deposits with monthly compounding, total after 10 years
Frequently asked questions about FV
What does FV do?
Future value. Savings plans, education funds
What does the FV example return?
The example formula in cell B4 gives 279,482.84.
Which Excel versions have FV?
It has been in Excel for many versions and works in the versions in common use today, including Excel for Microsoft 365.
🕸️ More finance formulas and related ones
Source: support.microsoft.com
Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning