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

AB
1Save per month2,000
2Rate per year3%
3Years10
4You will have279,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.

Source: support.microsoft.com

Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning

🤖
Posting...
Please wait a moment
Social VIP Classroom
Home
Thai Smiles Profile