<!-- https://learnsql.cpetoday.com/functions/dax/pv -->
# PV

Language: DAX
Category: Financial
Syntax: PV(<rate>, <nper>, <pmt> [, <fv>] [, <type>])
Summary: Returns the present value of a series of equal payments, or of a future amount, at a fixed rate.
Returns: A number. Cash you pay out is negative, so the present value of payments you make is shown as a positive amount.
Level: Intermediate
Related: FV, PMT, RATE, NPER, XNPV

## 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
- rate: the discount rate per period. Match it to the payment period. Required.
- nper: the number of payments. Required.
- pmt: the payment per period. Cash you receive is positive, and cash you pay is negative. Required.
- fv: a lump sum paid at the end of the last period. Optional, and 0 is the default.
- type: 0 for end-of-period payments (the default), or 1 for start-of-period payments. Optional.

## 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.

```dax
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.

```dax
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
- Keep the rate and the number of periods on the same basis. For monthly payments, use the monthly rate and the number of months.
- The sign convention decides the answer. Payments you pay are negative, and the present value of those payments comes out positive.
- PV assumes equal payments on a regular schedule. For irregular dates, use XNPV.
- For a lease, the accounting standard may require a different discount rate and other adjustments. The result here is a model of the arithmetic, not the final lease figure.

## 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.
