Downloads
DAXFinancialIntermediate

PV

Returns the present value of a series of equal payments, or of a future amount, at a fixed rate.

Syntax
PV(<rate>, <nper>, <pmt> [, <fv>] [, <type>])

Returns: A number. Cash you pay out is negative, so the present value of payments you make is shown as a positive amount.

What it does

PV answers the question "what is a stream of future payments worth today?" It discounts each payment back to the present at the given rate. Finance teams use it to measure a lease liability at the start of a lease, to value a stream of contract payments, to compare a single payment with a lump sum, and to decide whether a discount offered for early payment is worth taking.

Syntax and arguments

Example

A company signs a 60-month equipment lease with a payment of 500 a month. The lease is paid at the end of each month, and the discount rate is 6% a year. The payments are cash the company pays out, so the payment is entered as -500.

Lease Liability at Start = PV(0.06 / 12, 60, -500)

The result is 25,862.78. That is the amount the company would need to set aside today to make all 60 payments at that rate, and it is the starting liability to record for the lease, before any other lease accounting adjustments.

Example: a second, different use

A single payment of 1,000 due in five years, discounted at 4% a year. The present value is the amount needed today to have that 1,000 in five years.

Value Today of 1000 in 5 Years = PV(0.04, 5, 0, 1000)

The result is -821.93. The minus sign shows that investing 821.93 today produces the 1,000 in five years, so the sign shows cash that would be paid out.

Things to watch

In business terms

PV supports lease liability measurement, the valuation of contract streams such as service agreements, the choice between a discount for early payment and paying on terms, and the impairment test for long-term receivables. It turns future cash into a value that can be compared with today's price.

Related functions

All DAX functions · View as Markdown · DAX fundamentals