# PV function in Excel

> PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate.

Source: https://spreadsheetpractice.com/functions/pv · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate.
- **Syntax:** `=PV(rate, nper, pmt, [fv], [type])`
- **Most common use:** `=PV(B3/12,B4*12,-B2)` returns $22,726 (Most you can borrow for $450 a month over 5 years)
- **Available in:** Every current version
- **Category:** [Financial functions](https://spreadsheetpractice.com/functions/category/finance)
- **Returns:** The value today. Its sign is the opposite of the payments.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate. Use it to find how much you can borrow for a payment you can afford, or how much to invest now to reach a goal. As with all the loan functions, payments out are negative and money received is positive.

## Syntax

`=PV(rate, nper, pmt, [fv], [type])`

| Argument | Required? | What it is |
|---|---|---|
| `rate` | Required | The interest rate per period. |
| `nper` | Required | The number of periods. |
| `pmt` | Required | The payment each period. Enter 0 if there is only a single future amount. |
| `fv` | Optional | A lump sum at the end. Defaults to 0. |
| `type` | Optional | 0 or omitted for payments at the end of each period, 1 for the beginning. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=PV(B3/12,B4*12,-B2)` | $22,726 | Most you can borrow for $450 a month over 5 years |
| D3 | `=PV(B3,B4,0,-B5)` | $35,649 | What $50,000 in 5 years is worth today at 7% |
| D4 | `=PV(B3/12,B4*12,B2)` | -$22,726 | Positive payment, negative result: the sign flips |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  | Result |
| 2 | Monthly payment | $450 |  | $22,726 |
| 3 | Annual rate | 7.0% |  | $35,649 |
| 4 | Years | 5 |  | -$22,726 |
| 5 | Future amount | $50,000 |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| A negative result | PV returns the opposite sign of the payment. Enter the payment as negative to get a positive amount. |
| Using the annual rate with monthly payments | Divide the rate by 12 and multiply the years by 12 so both are monthly. |
| Mixing up PV and NPV | PV assumes equal payments. For cash flows that change from period to period, use NPV. |

## Tips

- PV is the inverse of PMT: PV(rate, n, PMT(rate, n, loan)) returns the loan amount.

## Related functions

- [FV](https://spreadsheetpractice.com/functions/fv): FV calculates what an investment will be worth in the future, given regular deposits, a starting balance and a constant rate of return.
- [PMT](https://spreadsheetpractice.com/functions/pmt): PMT calculates the fixed payment for a loan or a savings plan, based on a constant interest rate and number of payments.
- [NPV](https://spreadsheetpractice.com/functions/npv): NPV discounts a series of future cash flows back to today at a given rate, so you can judge whether an investment beats your cost of capital.
- [RATE](https://spreadsheetpractice.com/functions/rate): RATE works out the interest rate per period from the number of payments, the payment and the amount borrowed or invested.

## Questions

### How much can I borrow for a given monthly payment?

Use =PV(annual_rate/12, years*12, -payment). At 7% over 5 years, $450 a month supports a loan of about $22,726.

### What is the difference between PV and NPV?

PV values equal, regular payments. NPV values a series of cash flows that can differ each period.

### Why is the PV result negative?

The payment was entered as positive. Excel gives money in and money out opposite signs.

## Practice

A graded PV exercise ("Lump sum today") is on [the PV page](https://spreadsheetpractice.com/functions/pv). It is checked instantly, then re-checked on changed data.

Lessons that use PV:

- [Lesson 40: Future & present value](https://spreadsheetpractice.com/learn/future-and-present-value) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
