Discount a future sum back to today's value: PV = FV ÷ (1 + r)ⁿ. Essential for comparing money across time.
How the Present Value Calculator works
A present value calculator answers one question: what is a future sum of money worth in today's dollars? It does the exact opposite of a future value calculator. Instead of growing a deposit forward, it discounts a single future amount back to the present using the formula PV = FV / (1 + r)n.Each variable does specific work:
- PV = present value, the today's-dollars answer the tool returns.
- FV = future value, the single lump sum you expect to receive (or pay) later.
- r = the discount rate per period, expressed as a decimal. This is your opportunity cost or required return, not a bank rate.
- n = the number of periods until you receive the money (usually years).
Step by step, here is what the calculator does internally:
- It reads your future amount, discount rate, and number of periods.
- It converts the rate to a decimal (7% becomes 0.07) and, if you choose non-annual compounding, divides it by the periods per year while multiplying n to match.
- It raises the growth factor (1 + r) to the power n to build the discount factor.
- It divides the future value by that discount factor to collapse it to today's worth.
- It reports both the present value and the total discount (FV minus PV), so you see how much the waiting "costs."
Edge cases it handles: If r = 0%, there is no time value, so PV simply equals FV. If n = 0, the money is already here and PV again equals FV. The tool accepts fractional years (for example 2.5) and very high discount rates, where the present value shrinks toward zero. It also lets you flip the question: hold PV and solve for the implied rate, which is the same math the CAGR calculator uses in reverse.
]]>Example calculation
Three worked examples show how present value behaves as rate and time change. Every figure below is recomputed with PV = FV / (1 + r)n.Example 1: A $1,000,000 inheritance payable in 20 years. A relative's trust will pay you $1,000,000 in 20 years. You could otherwise earn 6% on that money, so you discount at 6%. The discount factor is (1.06)20 = 3.207135. Present value = $1,000,000 / 3.207135 = $311,804.73. In plain terms, a guaranteed million two decades out is worth only about $311,805 to you today, because $311,805 invested at 6% would itself grow back to $1,000,000 in 20 years.
Example 2: A $25,000 bonus deferred 5 years. Your employer offers a $25,000 retention bonus paid in 5 years instead of today. Your opportunity cost is a 4% return. The factor is (1.04)5 = 1.216653. Present value = $25,000 / 1.216653 = $20,548.18. So that deferred bonus is really worth about $20,548 in today's money, roughly $4,452 less than its sticker number.
Example 3: The same $50,000 at three different discount rates over 10 years. This shows why the rate you pick dominates the answer. Higher discount rates push present value down hard.
| Scenario | Future value | Years (n) | Discount rate (r) | Discount factor | Present value |
|---|---|---|---|---|---|
| Inheritance | $1,000,000 | 20 | 6% | 3.207135 | $311,804.73 |
| Deferred bonus | $25,000 | 5 | 4% | 1.216653 | $20,548.18 |
| Conservative case | $50,000 | 10 | 3% | 1.343916 | $37,204.70 |
| Moderate case | $50,000 | 10 | 7% | 1.967151 | $25,417.46 |
| Aggressive case | $50,000 | 10 | 10% | 2.593742 | $19,277.16 |
The three $50,000 rows are the key lesson: nothing changed except the discount rate, yet present value fell from $37,204.70 at 3% to $19,277.16 at 10%, almost exactly cutting it in half. This is why two people can look at the same future check and rationally place very different values on it. To project a number forward instead, use the future value calculator.
]]>Tips for using the Present Value Calculator
- Choose your discount rate as an opportunity cost, not a wish. The right r is the realistic return you would actually earn on a comparable-risk alternative, often 4% to 7% for diversified investing, not the 15% you hope a stock might do.
- Match the rate's risk to the cash flow's risk. Discount a guaranteed pension or Treasury at a low, safe rate; discount a risky startup payout at a much higher rate. Using one blanket rate for everything quietly mis-prices safe money.
- Always discount a lottery or settlement annuity before accepting the 'lump sum' offer. Buyers quote a cash figure and hope you never compute the present value of the payment stream yourself. Run both and compare.
- Watch the compounding period. If a deal compounds monthly, divide the annual rate by 12 and multiply years by 12. Mixing an annual rate with monthly periods is the single most common present value error.
- Use a higher discount rate to stress-test, not to cheat. Re-run the present value at a rate one or two points higher than your base case. If the decision still holds, it is robust.
- Separate inflation from real-return decisions. If you want today's purchasing power rather than today's investable dollars, discount with a real rate (nominal minus inflation) instead of a nominal investment return.
- Remember that present value is brutal over long horizons. At 7%, a dollar 30 years out is worth about 13 cents today and at 20 years about 26 cents. Distant promises (lifetime warranties, far-off payouts) are worth far less than they sound.
- To find an implied return instead of a value, hold both PV and FV and solve for r with (FV/PV)^(1/n) - 1. That is the same engine as a CAGR calculation and tells you what rate a deal is really offering.
- For multiple future cash flows on different dates, do not use a single present value calc. Discount each payment to today separately and add them, which is the definition of net present value (NPV).
- Sanity-check by reversing the math. Take your PV answer, grow it forward at the same rate and periods, and you should land back on the original future value. If you do not, an input is wrong.
Present value vs future value: the same coin, opposite directions
Present value and future value are inverse operations: future value grows money forward, present value discounts it backward. Future value asks "what will $50,000 become?" Present value asks "what is a future $50,000 worth right now?" They use mirror-image formulas, FV = PV x (1 + r)n versus PV = FV / (1 + r)n, so one always undoes the other.
The table below runs the same $50,000, 7%, and 10-year inputs through both lenses so the symmetry is obvious.
| Question | Formula | Direction | Result | What it means |
|---|---|---|---|---|
| Future value of $50,000 today | 50,000 x (1.07)10 | Forward | $98,357.57 | What today's $50,000 grows into |
| Present value of $50,000 in 10 years | 50,000 / (1.07)10 | Backward | $25,417.46 | What a future $50,000 is worth now |
Notice the answers are not the same number flipped, because growing and discounting start from different bases. Reach for present value when the dollar amount is fixed in the future (a payout, a debt, a settlement) and you need today's equivalent. Reach for the future value calculator when you hold money now and want to project it. For an apples-to-apples annual growth rate between any two points, the CAGR calculator closes the loop.
How to calculate present value by hand and in Excel
By hand, present value takes three steps: add 1 to the rate, raise it to the number of periods, then divide the future amount by that result. For $25,000 in 5 years at 4%: (1 + 0.04) = 1.04, then 1.045 = 1.216653, then 25,000 / 1.216653 = $20,548.18. No financial calculator required, just an exponent key.
In a spreadsheet, the built-in function is faster and matches to the penny. Excel and Google Sheets both use:
- =PV(rate, nper, pmt, [fv], [type]) for the present value.
For a single future lump sum there is no recurring payment, so set pmt to 0 and put the amount in the fv slot. For the example above: =PV(0.04, 5, 0, 25000) returns -$20,548.18. The result is negative because the spreadsheet treats it as the cash you would pay out today to receive that future amount, a sign convention, not an error. Wrap it in ABS or add a minus sign to display it positive: =-PV(0.04,5,0,25000).
Two related functions help you flip the question. Use =FV(rate,nper,pmt,pv) to grow a present amount forward, and =RATE(nper,pmt,pv,fv) to back out the implied discount rate when you already know both PV and FV. For monthly figures, divide the rate by 12 and multiply nper by 12, for example =PV(0.06/12, 5*12, 0, 25000), which discounts monthly rather than annually.
Lump sum vs annuity: pricing a lottery, pension, or settlement
To compare a one-time lump sum against a stream of future payments, discount the payment stream to today and put both numbers in the same units. A lottery, a pension buyout, and a structured-settlement sale all reduce to this single decision. A single present value calc handles one future date; for a stream, discount each payment and add them (or use the annuity present value formula PMT x [1 - (1 + r)-n] / r).
Suppose a pension offers either a $450,000 lump sum today or $35,000 per year for 20 years. The lump sum's value is obvious. The annuity's value depends entirely on the discount rate you bring:
| Option | Discount rate | Present value today | Better choice |
|---|---|---|---|
| Lump sum | n/a | $450,000.00 | baseline |
| $35,000 x 20 years | 4% | $475,661.42 | Annuity wins |
| $35,000 x 20 years | 5% | $436,177.36 | Lump sum wins |
| $35,000 x 20 years | 6% | $401,447.24 | Lump sum wins |
The crossover sits at about 4.6%. If you can confidently earn more than roughly 4.6% on the lump sum, take the cash; if not, the guaranteed payments are worth more. This is exactly why settlement and pension buyers love high discount rates: a higher r shrinks the present value of your future checks, so they can offer you less. Whenever you weigh investing the lump sum instead, sanity-check the assumed return with the investment calculator.
Common mistakes that wreck a present value calculation
The most damaging present value mistake is picking a discount rate out of thin air. Because PV is so sensitive to r, a casual 10% versus a defensible 5% can change the answer by half. The rate must reflect a real, comparable-risk alternative return, not optimism.
- Mixing rate and period units. Entering an annual 6% but counting monthly periods inflates the discount enormously. Keep r and n on the same clock.
- Confusing the discount rate with a bank interest rate. The discount rate is your opportunity cost or required return, which is usually higher than a savings yield. They are different concepts that happen to share the math.
- Treating present value as inflation adjustment. Discounting at an investment return tells you today's investable equivalent, not today's purchasing power. For buying-power questions, run the figure through the inflation calculator first.
- Forgetting the sign convention in Excel. =PV() returns a negative number by design. People assume the formula is broken and abandon it.
- Using one present value for multiple cash flows. A stream of payments on different dates is an NPV problem; discount each one separately, then sum.
Is your discount rate reasonable? Reference benchmarks
A defensible discount rate for a typical US household usually lands between 3% and 8%, depending on how safe the alternative is and whether you measure in nominal or real dollars. Use the safe end for guaranteed cash flows and the high end for risky ones.
- 3% to 4%: Reasonable for very safe, near-term comparisons or when you want a conservative, low-risk benchmark.
- 5% to 7%: A common range for long-run diversified investing, in the neighborhood of historical balanced-portfolio returns.
- 8% or higher: Appropriate only for genuinely risky payouts, or when you have high-interest debt you could pay off instead (your real opportunity cost might be your credit card rate).
The other benchmark worth memorizing is how fast distant money loses value. The present value of $1 collapses with time and rate:
| Years out | at 3% | at 5% | at 7% | at 10% |
|---|---|---|---|---|
| 5 | $0.86 | $0.78 | $0.71 | $0.62 |
| 10 | $0.74 | $0.61 | $0.51 | $0.39 |
| 20 | $0.55 | $0.38 | $0.26 | $0.15 |
| 30 | $0.41 | $0.23 | $0.13 | $0.06 |
Read it as a gut check: at 7%, a dollar promised in 20 years is worth about 26 cents now. If your present value answer implies a distant payout is worth nearly its face value, your discount rate is probably too low.
Advanced uses and variations
Once you can discount a single sum, the same engine powers a surprising number of real decisions.
- Bond and zero-coupon pricing: A zero-coupon bond is pure present value, its price is just the face value discounted at the market yield over the years to maturity.
- Should I prepay or invest? Compare the present value of money saved by prepaying debt against the present value of investing it. The higher PV wins.
- Real (inflation-adjusted) present value: Discount with a real rate (nominal rate minus inflation) when you care about future purchasing power rather than future dollars.
- Solving for the rate: Hold both PV and FV and back out r with (FV/PV)1/n - 1 to learn the return a deal implies, the same logic behind the Rule of 72 calculator for quick doubling estimates.
- Multiple cash flows: Discount each future payment to today and sum them, which is net present value, the standard test for whether a project or purchase creates value.
Tax note: present value is a pre-tax framework. If a future payout is taxable (a deferred bonus, certain settlements, traditional retirement withdrawals), discount the after-tax amount, since taxes can materially change which option wins. Always confirm the tax treatment of your specific payout before deciding.
Present value quick reference: what future amounts are worth today
Present value answers one question: what is a future sum worth in today's money? The formula is PV = FV / (1 + r)n, where r is your discount rate (your opportunity cost) and n is the number of years. The table below recomputes the present value of common future amounts across four discount rates, all assuming annual discounting. Notice how the same future dollar shrinks faster as the rate rises and as the term lengthens.
| Future amount and term | At 3% | At 5% | At 7% | At 10% |
|---|---|---|---|---|
| $10,000 in 15 years | $6,418.62 | $4,810.17 | $3,624.46 | $2,393.92 |
| $50,000 in 10 years | $37,204.70 | $30,695.66 | $25,417.46 | $19,277.16 |
| $100,000 in 20 years | $55,367.58 | $37,688.95 | $25,841.90 | $14,864.36 |
| $100,000 in 30 years | $41,198.68 | $23,137.74 | $13,136.71 | $5,730.86 |
| $1,000,000 in 30 years | $411,986.76 | $231,377.45 | $131,367.12 | $57,308.55 |
Read it this way: at a 7% discount rate, a promised $1,000,000 in 30 years is worth only about $131,367 today, while at 3% it is worth about $411,987. The future amount never changes; only the rate and the time do. Higher rate plus longer wait equals a smaller present value.
Related on this site
future value calculator · compound interest calculator · investment calculator · CAGR calculator · inflation calculator · retirement withdrawal calculator
For a related deep dive, see SEC Investor.gov on time value of money.
Present Value Calculator — frequently asked questions
- What is a discount rate?
- The return you could earn elsewhere — your opportunity cost of money.
- Why does PV matter?
- Money today is worth more than the same amount later because it can be invested.
- Why is future money worth less?
- Money today can be invested, so a future sum is worth less in today's terms.
- What discount rate should I use?
- Often your expected investment return or cost of capital.
- How much is $100,000 in 20 years worth today at a 5% discount rate?
- About $37,689 today. Using PV = FV / (1 + r)<sup>n</sup>, that is $100,000 / (1.05)<sup>20</sup> = $100,000 / 2.6533, which equals roughly $37,688.95. In plain terms, if you can reliably earn 5% per year, you would only need to invest about $37,689 now to have $100,000 in two decades. Run your own numbers in the <a href="/present-value-calculator/">present value calculator</a>.
- What is the present value of $1,000,000 received in 30 years at 6%?
- Roughly $174,110 today. The math is $1,000,000 / (1.06)<sup>30</sup> = $1,000,000 / 5.7435, which is about $174,110.13. A far-off million shrinks dramatically once discounted, because 30 years of 6% compounding works against it. Lower the rate to 4% and the same million is worth about $308,319; raise it to 8% and it drops to roughly $99,377.
- How do I calculate present value in Excel using the =PV() function?
- Use =PV(rate, nper, pmt, fv) and read the result as a negative outflow. For a single $50,000 due in 10 years at 6%, type =PV(0.06, 10, 0, 50000), which returns about -$27,919.74. Excel shows it negative because it treats the amount you would invest today as cash leaving your pocket. Set pmt to 0 for a lump sum; use it only when there are recurring payments.
- Why does a higher discount rate give a lower present value?
- Because a higher rate means your money could grow faster elsewhere, so you need less of it today. Discounting divides by (1 + r)<sup>n</sup>, and a bigger r makes that denominator larger, shrinking the result. For $100,000 in 30 years: at 3% PV is about $41,199, at 5% about $23,138, at 7% about $13,137, and at 10% only about $5,731. The future sum never changes, but its today-value collapses.
- What is the present value of a $30,000,000 lottery paid as 30 annual payments of $1,000,000 versus the lump sum?
- If a jackpot is advertised as 30 payments of $1,000,000 (a $30,000,000 total), its present value at 5% is only about $15,372,451 as an ordinary annuity, or about $16,141,074 if the first payment is immediate. That is why the cash option is always far below the headline number: future installments are worth less today. Compare any payout with the <a href="/present-value-calculator/">present value calculator</a> before deciding.
- Should I take a pension lump sum or $20,000 a year for 25 years?
- Take the lump sum only if it beats the present value of the payments at your honest discount rate. At 5%, $20,000 per year for 25 years has a present value of about $281,879. If the offered lump sum is well above that, the buyout is generous; if it is below, the annuity is the better deal. Use a higher rate if you are confident you can out-invest it, which lowers the breakeven.
- How much is a structured settlement of $2,000 a month for 10 years worth today?
- About $180,147 in today's dollars at a 6% annual discount rate. Settlements pay monthly, so the rate becomes 0.5% per month over 120 months, giving a present value near $180,146.91. Settlement-buyout companies often apply much steeper discount rates (sometimes 9% to 18%), which is exactly why their cash offers can be far lower than this fair-value figure.
- What is the difference between present value and net present value (NPV)?
- Present value discounts one future amount to today; NPV discounts a whole stream of cash flows and subtracts the upfront cost. PV answers "what is $50,000 in 10 years worth now?" (about $25,417 at 7%). NPV answers "is this project worth it?" by summing the present values of every inflow and outflow. NPV is essentially PV applied many times and netted against your initial investment.
- What is the present value of $25,000 needed in 5 years at 4%?
- About $20,548 today. The calculation is $25,000 / (1.04)<sup>5</sup> = $25,000 / 1.2167, which equals roughly $20,548.18. So setting aside about $20,548 now in something that earns 4% per year should grow to your $25,000 target. For a savings-focused version of this, the <a href="/savings-goal-calculator/">savings goal calculator</a> shows the monthly contribution route instead.
- How do I calculate present value by hand without a calculator?
- Divide the future amount by (1 + r) once for every year, where r is the decimal rate. For $5,000 due in 2 years at 6%: $5,000 / 1.06 = $4,716.98, then $4,716.98 / 1.06 = about $4,449.98. For many years, it is easier to compute (1 + r)<sup>n</sup> first, then divide once. The <a href="/present-value-calculator/">present value calculator</a> does the exponent for you instantly.
- Is present value the same as future value reversed?
- Yes, present value is the exact inverse of future value. Future value multiplies by (1 + r)<sup>n</sup> to push money forward; present value divides by it to pull money back. $50,000 today at 5% grows to $81,445 in 10 years; that same $81,445 discounted at 5% returns to $50,000. Use the <a href="/future-value-calculator/">future value calculator</a> for the forward direction.
- Does it matter if I discount monthly instead of annually?
- Yes, more frequent discounting lowers the present value slightly. For $60,000 due in 5 years at 6%, annual discounting gives about $44,835, while monthly discounting (0.5% over 60 periods) gives about $44,482, a difference near $353. The gap widens with higher rates and longer terms. Match the compounding frequency to how the actual payments or returns occur for an accurate answer.
- What discount rate should I use for a personal financial decision?
- Use your realistic opportunity cost: what you could safely earn on that money instead. Many people use 4% to 5% (roughly a Treasury or high-yield savings level) for low-risk choices, and 7% to 10% when comparing against long-term stock returns. There is no single official rate; a higher rate makes future money look less valuable, so pick the rate that reflects your actual alternative, not wishful thinking.
- Is a $500,000 payout in 25 years a good deal today?
- Only about $92,125 of it is real value today at a 7% discount rate, so judge any offer against that. The math is $500,000 / (1.07)<sup>25</sup> = $500,000 / 5.4274, near $92,124.59. A half-million that far out sounds large but is modest in present terms. If someone offers you, say, $120,000 cash now instead, the cash is clearly worth more once you discount the future sum.
- How much would I need to invest today to have $300,000 for college in 18 years?
- About $135,840 today at a 4.5% discount rate. That comes from $300,000 / (1.045)<sup>18</sup> = $300,000 / 2.2085, roughly $135,840.11. This is the lump-sum-now answer; if you would rather contribute over time, the <a href="/college-savings-calculator/">college savings calculator</a> turns the same goal into a monthly savings plan instead of a single deposit.
- What is the present value of $75,000 due in 8 years at 6%?
- About $47,056 today. Using PV = $75,000 / (1.06)<sup>8</sup> = $75,000 / 1.5938, the result is roughly $47,055.93. So $75,000 eight years out is worth slightly less than two-thirds of its face value at 6%. Drop the rate to 4% and it rises to about $54,802; raise it to 9% and it falls to about $37,640, showing how sensitive PV is to the rate you choose.
Guides & articles
- What Discount Rate Should You Use in a Present Value Calculation?
- How to Find the Present Value of a Single Future Lump Sum
Related calculators
Compound Interest Calculator · Simple Interest Calculator · Savings Calculator · CD Calculator · APY Calculator · Investment Calculator