# FV function in Excel

> FV calculates what an investment will be worth in the future, given regular deposits, a starting balance and a constant rate of return.

Source: https://spreadsheetpractice.com/functions/fv · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** FV calculates what an investment will be worth in the future, given regular deposits, a starting balance and a constant rate of return.
- **Syntax:** `=FV(rate, nper, pmt, [pv], [type])`
- **Most common use:** `=FV(B3/12,B4*12,-B2)` returns $49,164 (What $300 a month grows to in 10 years)
- **Available in:** Every current version
- **Category:** [Financial functions](https://spreadsheetpractice.com/functions/category/finance)
- **Returns:** The balance at the end of the last period.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

FV calculates what an investment will be worth in the future, given regular deposits, a starting balance and a constant rate of return. Use it for retirement and savings projections. Deposits you make are money going out of your pocket, so they are entered as negative numbers to get a positive result.

## Syntax

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

| Argument | Required? | What it is |
|---|---|---|
| `rate` | Required | The return per period, such as an annual rate divided by 12 for monthly deposits. |
| `nper` | Required | The number of periods, such as years times 12. |
| `pmt` | Required | The deposit made each period. Enter deposits as negative numbers. |
| `pv` | Optional | The starting balance, also negative if you are putting it in. Defaults to 0. |
| `type` | Optional | 0 or omitted for deposits at the end of each period, 1 for the beginning. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=FV(B3/12,B4*12,-B2)` | $49,164 | What $300 a month grows to in 10 years |
| D3 | `=FV(B3/12,B4*12,-B2,-B5)` | $58,261 | The same plan with the $5,000 starting balance |
| D4 | `=FV(B3,B4,0,-B5)` | $8,954 | The starting balance alone, compounded yearly |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  | Result |
| 2 | Monthly deposit | $300 |  | $49,164 |
| 3 | Annual return | 6.0% |  | $58,261 |
| 4 | Years | 10 |  | $8,954 |
| 5 | Starting balance | $5,000 |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| A negative result | The deposits were entered as positive numbers. Use -B2 for money you put in. |
| A result that is far too large | An annual rate was paired with monthly periods. Divide the rate by 12. |
| Forgetting the starting balance | The pv argument is optional, so leaving it out quietly assumes you start from zero. |

## Tips

- Compare FV with the total of the deposits (B2*B4*12) to see how much of the ending balance is growth.

## Related functions

- [PV](https://spreadsheetpractice.com/functions/pv): PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate.
- [PMT](https://spreadsheetpractice.com/functions/pmt): PMT calculates the fixed payment for a loan or a savings plan, based on a constant interest rate and number of payments.
- [NPER](https://spreadsheetpractice.com/functions/nper): NPER calculates how many payment periods it takes to pay off a loan or reach a savings goal, at a fixed payment and interest rate.
- [RATE](https://spreadsheetpractice.com/functions/rate): RATE works out the interest rate per period from the number of payments, the payment and the amount borrowed or invested.

## Questions

### How do I calculate compound interest on monthly savings in Excel?

Use =FV(annual_rate/12, years*12, -monthly_deposit). Add -starting_balance as the fourth argument if you already have savings.

### Why does FV return a negative number?

The deposits were entered as positive. Excel treats money you pay in and money you get back with opposite signs.

### Does FV account for inflation?

No. To see the result in today's money, use a real return (return minus inflation) as the rate.

## Practice

A graded FV exercise ("Retirement savings") is on [the FV page](https://spreadsheetpractice.com/functions/fv). It is checked instantly, then re-checked on changed data.

Lessons that use FV:

- [Lesson 40: Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
