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

AB
1Target500,000
2Rate per year4%
3Years5
4Deposit now410,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.

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