To calculate the present value of future cash flows, divide each future payment by (1 + r) raised to the power of n, where r is your discount rate expressed as a decimal and n is the number of periods until the money arrives. A $100,000 payment five years out, discounted at 7%, is worth about $71,299 today. The $28,701 gap is the cost of waiting instead of having the money now and investing it.
The Formula and What Each Variable Means
One equation carries the whole calculation: PV = FV / (1 + r)^n.
- PV is the present value, the number you’re solving for.
- FV is the future value, the dollar amount you expect to receive.
- r is the discount rate as a decimal (7% becomes 0.07).
- n is the number of compounding periods between now and the payment.
Because n sits in the exponent, small changes to time or rate move the answer more than people expect. A payment 10 years out loses far more of its present worth than one two years out at the same rate. That exponential decay is why long-dated bonds, structured settlements, and pension buyouts trade well below their face value.
Picking a Discount Rate
The discount rate reflects what your money could earn elsewhere at comparable risk. Choosing it is the most subjective step, and it drives your answer more than any other input.
Risk-Free Benchmarks
A U.S. Treasury yield is the standard starting point. The 10-year Treasury sat at roughly 4.1% in early March 2026 and has generally ranged between about 3% and 5% in recent years depending on Federal Reserve policy.1Federal Reserve Bank of St. Louis. Market Yield on U.S. Treasury Securities at 10-Year Constant Maturity Treasury yields fit best when the future payment carries almost no default risk, like a government-backed obligation.
Real Versus Nominal Rates
A nominal rate includes expected inflation; a real rate strips it out. Real rate ≈ nominal rate − inflation rate. With CPI inflation at 2.4% for the 12 months ending January 2026, a nominal 7% rate translates to a real rate of roughly 4.6%.2Bureau of Labor Statistics. Consumer Price Index Summary Use the nominal rate on cash flows stated in future dollars. Use the real rate on cash flows already expressed in today’s dollars. Crossing the wires is one of the most common ways to end up with a badly wrong answer.
Risk Premiums
If the future cash flow is genuinely uncertain, like projected business revenue or equity returns, add a premium on top of the risk-free rate. The historical equity risk premium tends to run about 4% to 5% above Treasury yields, though it moves year to year. Higher risk means a higher discount rate, which means a lower present value.
Statutory Rates in Legal Contexts
Some rates are fixed by law. Federal post-judgment interest, for example, uses the weekly average 1-year Treasury yield from the week before judgment.3Office of the Law Revision Counsel. 28 U.S. Code 1961 – Interest If your future payment is tied to a court proceeding, check for a statutory rate before choosing your own.
Walking Through the Math
Take the $100,000 payment five years out at 7%.
- Convert the rate: 7% becomes 0.07.
- Add 1 to the rate: 1.07.
- Raise to the 5th power: 1.07^5 ≈ 1.4026.
- Divide the future value: $100,000 ÷ 1.4026 = $71,299.
That $71,299 is what the future $100,000 is worth today at a 7% required return. Invest $71,299 today at 7% annually and you’d end up with $100,000 in five years.
Now shift the inputs to see how sensitive the answer is. Drop the discount rate to 4% and the same $100,000 is worth $82,193 today. Push the horizon to 10 years at 7% and it collapses to $50,835. Running two or three scenarios is the fastest way to see whether your answer is stable or hanging on your assumptions.
Adjusting for Monthly or Quarterly Compounding
The basic formula assumes annual compounding. Real-world instruments often compound monthly, quarterly, or semiannually. You don’t change the formula, you change two of its inputs.
First, divide the annual rate by the periods per year. A 7% annual rate becomes 0.005833 per month (0.07 ÷ 12) or 0.0175 per quarter (0.07 ÷ 4). Second, multiply years by periods per year. A five-year horizon becomes 60 monthly periods or 20 quarterly periods.
On the same $100,000 example at 7% over five years, monthly compounding gives PV = $100,000 ÷ (1.005833)^60 = $70,476. That’s about $800 lower than the annual-compounding result of $71,299. The gap widens with higher rates and longer horizons, so compounding frequency matters most on large, long-dated cash flows.
To compare rates quoted at different compounding frequencies on the same footing, convert each to an effective annual rate: (1 + r/m)^m − 1, where m is periods per year. A 7% rate compounded monthly produces an effective annual rate of about 7.23%.
Equal Recurring Payments
When you’re receiving the same amount every period, like a pension, lease payment, or bond coupon, discounting each one separately works but wastes time. The present value of an ordinary annuity (payments at the end of each period) has its own formula: PV = PMT × [(1 − 1/(1 + r)^n) / r].
For $10,000 a year for five years at 7%: PV = $10,000 × [(1 − 1/1.4026) / 0.07] = $10,000 × 4.1002 = $41,002. If payments arrive at the start of each period instead of the end (an annuity due, like rent paid in advance), multiply by (1 + r): $43,872.
Streams of Uneven Cash Flows
Most investments deliver different amounts in different years. Say you spend $200,000 today and receive $60,000 in year one, $75,000 in year two, and $90,000 in year three. Net present value handles this by discounting each cash flow on its own timeline and then combining them.
At an 8% discount rate:
- $60,000 / (1.08)^1 = $55,556
- $75,000 / (1.08)^2 = $64,300
- $90,000 / (1.08)^3 = $71,440
Sum: $191,296. Subtract the $200,000 upfront cost and NPV is −$8,704. The project destroys value at an 8% hurdle rate. Lower the discount rate to 5% and NPV turns positive. The rate at which NPV equals zero is the internal rate of return, effectively the project’s yield.
Positive NPV means the future cash flows more than cover your required return. Negative NPV means they don’t. Forgetting to subtract the initial outlay is the fastest way to talk yourself into a losing project.4Microsoft Support. NPV Function
Doing It in a Spreadsheet
You don’t have to compute exponents by hand. Excel and Google Sheets both have built-in functions.
The PV Function
Excel syntax: =PV(rate, nper, pmt, [fv], [type]).5Microsoft Support. PV Function Google Sheets uses the same structure.6Google. PV – Google Docs Editors Help For a single $100,000 lump sum in five years at 7%: =PV(0.07, 5, 0, 100000). Set pmt to 0 because there are no periodic payments. The function returns −$71,299; the negative sign reflects that this is what you’d pay out today to receive the $100,000 later.
For an annuity, move the payment into pmt and leave fv at 0. =PV(0.07, 5, 10000) returns −$41,002, matching the annuity formula above.
The NPV Function
Syntax: =NPV(rate, value1, value2, …). One trap catches almost everyone: the function assumes the first value arrives one period from now, so the initial investment at time zero is not part of the function’s arguments.4Microsoft Support. NPV Function Add it separately. For the earlier example: =NPV(0.08, 60000, 75000, 90000) + (-200000) returns −$8,704.
Mistakes That Distort the Answer
The math is forgiving. The setup is where results go wrong.
Mixing nominal cash flows with a real discount rate, or the reverse, is the most damaging error. On a 10-year projection it can easily produce a 15% to 20% swing. Match the rate to how the cash flow is stated.
Using the wrong compounding frequency runs a close second. A bond that compounds semiannually and a note that pays quarterly need different period counts and per-period rates, even when their quoted annual rates are identical. Check the terms before defaulting to annual.
Skipping the initial outlay in an NPV calculation turns money-losing projects into paper winners. The NPV of future inflows alone tells you what those inflows are worth today; only after subtracting what you paid do you know whether the deal earns its keep.
Tax Effects That Can Erode the Answer
Present value tells you what a future payment is worth in today’s dollars. It doesn’t tell you what you’ll keep after tax, and two rules commonly reshape the after-tax picture.
The first is original issue discount. When you buy a debt instrument (a zero-coupon bond is the classic case) for less than face value, the IRS treats the discount as interest income accruing each year, and you owe tax on that accrual annually even though no cash arrives until maturity.7Internal Revenue Service. Guide to Original Issue Discount (OID) Instruments This phantom income can create a cash flow mismatch the present value calculation itself won’t show you.
The second is imputed interest on below-market loans. If you lend to family, employees, or others at a rate below the IRS’s applicable federal rate, the IRS treats the forgone interest as though it were paid. For March 2026, the short-term AFR is 3.59%, the mid-term rate is 3.93%, and the long-term rate is 4.72%.8Internal Revenue Service. Revenue Ruling 2026-6 – Applicable Federal Rates for March 2026 Gift loans of $10,000 or less between individuals are exempt unless the borrower buys income-producing assets; between $10,000 and $100,000, imputed interest is capped at the borrower’s net investment income, treated as zero if that income is under $1,000.9Office of the Law Revision Counsel. 26 U.S. Code 7872 – Treatment of Loans With Below-Market Interest Rates Above $100,000, the full imputed interest rules apply with no cap.