Why It Matters
Here's the core insight NPV gives you: a deal with positive NPV creates wealth above your required return; a deal with negative NPV destroys it. The number doesn't just tell you whether a deal is profitable — it tells you whether it's profitable enough to justify the risk, the time, and what you could have earned elsewhere.
The formula runs through every projected cash flow — rent minus expenses, loan paydowns, eventual sale proceeds — and discounts each one back to today using your required rate of return (the discount rate). Sum those discounted cash flows, subtract your initial investment, and you have the NPV. Positive means you're ahead. Negative means the deal underdelivers versus your alternatives. Zero means you're breaking exactly even on your return requirement.
NPV is especially powerful when comparing multiple deals: a $40,000 NPV beats a $15,000 NPV every time, all else equal. It converts complex multi-year projections into a single, comparable dollar figure.
At a Glance
- What it is: The present value of all future cash flows minus your initial investment, in today's dollars
- Formula: NPV = Σ [Cash Flow / (1 + Discount Rate)^n] − Initial Investment
- Positive NPV: Deal exceeds your return requirement — wealth is created above the hurdle rate
- Negative NPV: Deal falls short — you'd do better deploying capital elsewhere
- Discount rate: Your required rate of return, typically 8–15% for real estate deals
- Key inputs: Purchase price, annual cash flows, holding period, exit value, discount rate
- Best for: Comparing deals with different hold periods, cash flow timing, or exit values
NPV = Σ [Cash Flow / (1 + Discount Rate)^n] − Initial Investment
How It Works
The discount rate is your benchmark. This is the minimum return you require to justify the investment — your hurdle rate. It might be 10% because that's what comparable deals return, or 12% because that's your cost of capital. Everything gets measured against it. Pick it too low and marginal deals look attractive. Pick it too high and you screen out solid opportunities.
Each year's cash flow gets discounted separately. Year 1 cash flow is divided by (1 + discount rate)^1. Year 2 by (1 + discount rate)^2. Year 5 by (1 + discount rate)^5. The further out the cash flow, the more it shrinks when discounted. A $20,000 cash flow five years from now is worth roughly $12,418 today at a 10% discount rate — nearly 38% less. This math is why a cash flow statement showing strong later-year distributions isn't always as valuable as it looks on paper.
The terminal value dominates. In a typical 5–7 year hold, the projected sale proceeds at exit often represent 60–80% of total NPV. Run the model with different exit cap rates — 0.5% higher or lower — to see how sensitive your NPV is to that assumption. A deal that shows positive NPV only under optimistic exit assumptions is riskier than one that stays positive across a range of scenarios.
NPV doesn't include what it can't measure. It won't capture the tax shelter value of depreciation unless you model after-tax cash flows. It won't account for forced equity through renovations unless you include it in your exit value. Review your balance sheet and income statement to make sure the inputs feeding your NPV model are grounded in actual numbers, not optimistic projections.
Real-World Example
Lakshmi is evaluating a small apartment building listed at $485,000. She projects a 7-year hold with the following cash flows:
- Years 1–2: $28,000/year net cash flow (stabilizing tenants)
- Years 3–5: $36,000/year net cash flow (fully occupied)
- Years 6–7: $41,000/year net cash flow (rents increased)
- Year 7 exit: She projects selling at a 6.5% cap rate on $58,000 NOI = $892,308 sale price, less 6% selling costs = $838,369 net proceeds
Her discount rate is 11% — the return she can reliably earn through real-estate-wholesaling fees and other deals she has lined up.
Discounting each cash flow:
- Year 1: $28,000 / 1.11^1 = $25,225
- Year 2: $28,000 / 1.11^2 = $22,725
- Year 3: $36,000 / 1.11^3 = $26,334
- Year 4: $36,000 / 1.11^4 = $23,724
- Year 5: $36,000 / 1.11^5 = $21,373
- Year 6: $41,000 / 1.11^6 = $21,966
- Year 7 (cash flow + proceeds): ($41,000 + $838,369) / 1.11^7 = $424,118
Sum of discounted cash flows: $565,465 Initial investment: $485,000 NPV = $565,465 − $485,000 = +$80,465
Positive NPV of $80,465 means this deal clears Lakshmi's 11% hurdle by a meaningful margin — she's creating $80,465 in wealth above and beyond her return requirement. She runs the same model with a 7% exit cap rate (more conservative exit) and gets NPV of +$21,900 — still positive, still worth pursuing.
Pros & Cons
- Single-number deal verdict — Converts a 7-year projection into one comparable dollar figure
- Accounts for time value of money — Weights near-term cash flows higher than distant ones automatically
- Enables apples-to-apples comparison — NPV standardizes deals with different hold periods and cash flow profiles
- Incorporates your actual return requirement — The discount rate makes the hurdle rate explicit, not assumed
- Survives sensitivity analysis — Run it under multiple scenarios to see how fragile the positive result is
- Garbage in, garbage out — NPV is only as good as your cash flow projections; overestimate rents or underestimate expenses and the number is meaningless
- Discount rate is subjective — Change it from 10% to 12% and a deal that looked great can turn negative
- Ignores liquidity — Two deals with the same NPV aren't equivalent if one ties up capital for 10 years and the other for 3
- Terminal value sensitivity — Small changes in exit cap rate assumptions swing NPV dramatically
- Complexity obscures judgment — New investors sometimes use NPV as a false precision tool, treating a modeled output as certainty
Watch Out
Don't confuse IRR with NPV. Internal rate of return (IRR) tells you the percentage return a deal produces. NPV tells you the dollar amount of value created. A small deal with 25% IRR might have lower NPV than a larger deal with 14% IRR if the capital deployed is much larger. You need both metrics for a complete picture.
Model after-tax cash flows when possible. A property with strong depreciation benefits produces meaningfully different after-tax cash flows than pre-tax projections suggest. Feeding pre-tax numbers into your NPV while your actual alternatives are compared on an after-tax basis understates the deal's value. Connect your NPV model to your income statement and account for the tax shelter impact.
Anchor your discount rate to real alternatives. If you can consistently earn 9% elsewhere, use 9%. Using 6% because "that's what the market does" while you have better options available produces misleading positive NPVs. The discount rate is the honest answer to: "What would I earn if I didn't do this deal?"
Ask an Investor
The Takeaway
NPV is the most complete single-number answer to the question every investor is actually asking: does this deal make me wealthier than my next best option? Build the cash flow model from a solid cash flow statement, anchor the exit value to real market data, and set the discount rate to your actual opportunity cost. A positive NPV means the deal beats your alternatives in dollar terms. A negative NPV means something better is available — even if the deal looks profitable on the surface. Run NPV on every deal before you make an offer.