Excel PV function💰 Present value
The PV function: Present value. Lump-sum goals. This page shows the syntax, a worked example with its result and how the formula reads.
What does PV do?
Present value. Lump-sum goals
PV syntax
=PV(rate, nper, pmt, [fv], [type])
Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation
PV 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 | Target | 500,000 |
| 2 | Rate per year | 4% |
| 3 | Years | 5 |
| 4 | Deposit now | 410,963.55 |
How it reads: One deposit today, compounding yearly, to reach 500,000 in 5 years
Frequently asked questions about PV
What does PV do?
Present value. Lump-sum goals
What does the PV example return?
The example formula in cell B4 gives 410,963.55.
Which Excel versions have PV?
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