ExcelFlux

PV function

the present value of an investment.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Find the present value of a periodic payment. At a zero rate the result is payments times payment amount.

A worked example from the workbook

RowABC
6Periodic ratePeriodsAmount
7012100
806100
903100
Record 1
=PV(A7,B7,-C7)

Expected result1200

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=PV(0,12,-100)
Turkish Excel · tr-TR
=BD(0;12;-100)

Expected result

1200

Worked examples

Find the present value of a periodic payment. At a zero rate the result is payments times payment amount.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Periodic rate Periods Amount
7 0 12 100
8 0 6 100
9 0 3 100
Case Formula Expected result
Record 1 =PV(A7,B7,-C7) 1200
Record 2 =PV(A8,B8,-C8) 600
Record 3 =PV(A9,B9,-C9) 300
Microsoft Excel reference