# Future & present value (Excel lesson 40 of 45)

> What money grows to, and what future money is worth today.

Source: https://spreadsheetpractice.com/learn/future-and-present-value · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Finance"
- **Time:** about 8 minutes, 2 graded exercises
- **Functions:** `FV`, `PV`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=FV(B3/12,B4*12,-B2)`: Monthly saving for 30 years

## How it works

`FV(rate, nper, pmt, [pv])` answers "what will this grow to?" `PV(rate, nper, pmt, [fv])` answers "what is that future amount worth today?"

The same sign rule as PMT applies: money you put in is negative. Keep rate and periods in the same units.

## Syntax

| Formula | What it does |
|---|---|
| `=FV(B3/12,B4*12,-B2)` | Monthly saving for 30 years |
| `=PV(B3,B6,0,-B5)` | Lump sum needed today |

## Watch out for

- FV with monthly contributions needs a monthly rate and monthly periods.
- Leave pmt as 0 when there are no regular payments.

## The exercises

Solve them in the live grid at [Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Retirement savings.** In B8, calculate what the monthly contribution grows to over the years in B4 at the return in B3.
2. **Lump sum today.** In B9, calculate how much to invest today to reach the goal in B5 after the years in B6, at the annual return in B3 with no added payments.

Previous: [Loan payments with PMT](https://spreadsheetpractice.com/learn/pmt-loan-payments) · Next: [NPV & IRR](https://spreadsheetpractice.com/learn/npv-irr)

---

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