To find the present value of a single future lump sum, divide that amount by one plus your discount rate, raised to the number of years: PV = FV ÷ (1 + r)n. For example, $50,000 you will receive in 10 years, discounted at 7%, is worth about $25,417 today. That is the entire idea — you are rewinding one future amount back to what it is worth in today's dollars.
This applies whenever you have one future amount, not a stream of payments. A maturing bond, a promised buyout, a balloon payment, an inheritance with a fixed date, or a savings goal you want to fund all fit this single-sum pattern. You can get the answer instantly in the Present Value Calculator; below is how the math works so you can trust the number and replicate it in a spreadsheet.
The three inputs you need
- FV — the future value, the single amount you will receive or owe on a specific date.
- r — the discount rate per period, written as a decimal. A 7% annual rate is 0.07.
- n — the number of periods until the amount is paid. For an annual rate, that is the number of years.
The output, PV, is what that future amount is worth right now. Because the rate compounds, the further away the amount is, the less it is worth today.
A worked example, step by step
Suppose you are owed $10,000 in 5 years and your discount rate is 6%.
- Add 1 to the rate: 1 + 0.06 = 1.06.
- Raise it to the number of years: 1.065 = 1.33823.
- Divide the future amount by that factor: $10,000 ÷ 1.33823 = $7,472.58.
So $10,000 arriving in 5 years is worth $7,472.58 to you today at a 6% opportunity cost. Put differently: if you invested $7,472.58 today at 6%, it would grow to exactly $10,000 in 5 years — the inverse of the Future Value Calculator, which grows a sum forward instead of pulling it back.
How the answer moves with rate and time
Present value falls as either the discount rate or the waiting time rises. Here is the same $50,000 future amount valued across different rates and horizons:
| Years until paid | At 5% | At 7% | At 10% |
|---|---|---|---|
| 5 years | $39,176 | $35,653 | $31,046 |
| 10 years | $30,696 | $25,417 | $19,277 |
| 20 years | $18,844 | $12,921 | $7,432 |
Read down any column and you see time eating value; read across any row and you see the discount rate doing the same. A $50,000 promise 20 years out at 10% is worth just $7,432 today — about 15 cents on the dollar. That is why distant, uncertain promises should be treated with healthy skepticism.
The exact Excel =PV() formula
Spreadsheets have a built-in function for this: =PV(rate, nper, pmt, [fv], [type]). For a single lump sum there are no recurring payments, so set pmt to 0 and put your amount in the fv slot. For the $10,000-in-5-years example at 6%:
| Argument | Value | Meaning |
|---|---|---|
| rate | 0.06 | discount rate per period |
| nper | 5 | number of periods |
| pmt | 0 | no recurring payment |
| fv | 10000 | the future lump sum |
So you type =PV(0.06, 5, 0, 10000) and Excel returns -$7,472.58. The result is negative on purpose: Excel uses a cash-flow sign convention where money you would pay out today shows as negative and money you receive later is positive. Just read the absolute value, or put a minus sign in front: =-PV(0.06, 5, 0, 10000) returns a clean $7,472.58. Microsoft documents the full argument list in its PV function reference.
Match the period to the rate. For monthly compounding, divide the annual rate by 12 and multiply the years by 12 — for example, 6% over 5 years monthly becomes =PV(0.06/12, 60, 0, 10000).
Single sum vs a stream of payments
This guide covers one future amount. If instead you receive equal payments every year — like a pension or a structured payout — you are valuing an annuity, which sums the present value of many cash flows. The =PV() function handles that too, by putting the recurring amount in the pmt slot. And if the cash flows are uneven, you are into net present value (NPV) territory, a separate calculation. Keep the single-sum and multi-payment cases mentally separate so you do not mix the inputs.
Where a single-sum present value helps you decide
The most useful real-world use is comparing a guaranteed amount today against a larger amount later. If someone offers you $20,000 now or $30,000 in 6 years, discount the $30,000 to today and compare. It also tells you how much to set aside now to hit a future target — the same logic, run in reverse, that powers the Savings Goal Calculator. For a refresher on how money grows the other direction, the Simple Interest Calculator and Compound Interest Calculator show the forward path, while the Present Value Calculator brings any future figure back to today.
Try it yourself
Run your own numbers in the free Present Value Calculator — instant, private, no sign-up.
Open the Present Value Calculator →Frequently asked questions
- How do you calculate the present value of a future lump sum?
- Divide the future amount by (1 + r) raised to the number of periods: PV = FV / (1 + r)^n. For $10,000 in 5 years at 6%, that is $10,000 / 1.06^5 = $10,000 / 1.33823 = $7,472.58. The result is what the future amount is worth in today's dollars.
- What is the Excel formula for present value of a lump sum?
- Use =PV(rate, nper, 0, fv). Set the payment argument to 0 because there are no recurring payments, and put your lump sum in the fv slot. For $10,000 in 5 years at 6%, =PV(0.06, 5, 0, 10000) returns -$7,472.58 — the negative sign is Excel's cash-flow convention, so read the absolute value.
- Why does Excel's PV function return a negative number?
- Excel uses a sign convention where cash you pay out is negative and cash you receive is positive. Since investing the present value today is an outflow, =PV() shows it as negative. To display a positive figure, put a minus in front: =-PV(rate, nper, 0, fv).
- What is the difference between present value and future value?
- They are inverse operations. Future value grows a sum forward using FV = PV x (1 + r)^n, while present value discounts a future sum back to today using PV = FV / (1 + r)^n. Invest $7,472.58 today at 6% and it grows to $10,000 in 5 years; discount that $10,000 back and you return to $7,472.58.
- How do I find present value with monthly compounding?
- Convert the rate and periods to months. Divide the annual rate by 12 and multiply the years by 12, then apply the formula. In Excel, that is =PV(annual_rate/12, years*12, 0, fv) — for example =PV(0.06/12, 60, 0, 10000) for $10,000 in 5 years at 6% compounded monthly.
- Does the present value formula work for multiple payments?
- No, the single-sum formula PV = FV / (1 + r)^n values exactly one future amount. For a stream of equal payments you value an annuity by summing each payment's present value, which Excel's =PV() handles via its payment argument. Uneven cash flows require a net present value (NPV) calculation instead.
Related guides
What Is Compound Interest? A Simple Explanation · How much to save per month to reach your goal: formula, examples, and shortcut · How to build a 6-month emergency fund: the complete step-by-step plan · How to calculate CD interest: APY, the formula, and what banks rarely tell you