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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rate | Yes | The interest rate per period (annual rate ÷ 12 for monthly payments). |
| nper | Yes | The total number of payment periods. |
| pmt | Yes | The payment each period (negative for deposits). Use 0 if there are none. |
| pv | No | A starting lump sum (negative if you're depositing it). Omitted = 0. |
| type | No | When 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.
| A | B | |
|---|---|---|
| 1 | Annual rate | 4% |
| 2 | Years | 5 |
| 3 | Monthly deposit | -$500 |
| 4 | ||
| 5 | Balance | $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.
| A | B | |
|---|---|---|
| 1 | Scenario | Balance |
| 2 | End of month | $45,359.46 |
| 3 | Start 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
- Related functions: PV, PMT, NPER, RATE, FVSCHEDULE.

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.