Net Present Value and Internal Rate of Return for Real Estate Investors
Book: Real Estate by the Numbers | Authors: J Scott and Dave Meyer | Chapters: 10-11
← Discounted Cash Flow Analysis Explained | Real Estate Tax Basics for Investors →
DCF analysis tells you what a stream of future income is worth today. That’s useful, but it ignores the most important number: what you paid to get that income stream in the first place.
Chapters 10 and 11 of Real Estate by the Numbers fix that with two tools: net present value (NPV) and internal rate of return (IRR). These are among the most important metrics in real estate deal analysis, and the book does a great job explaining both from scratch.
Chapter 10: Net Present Value
NPV builds directly on DCF. The key difference is that NPV includes your initial investment as part of the calculation.
Net present value looks at the present value of all future cash flows while also accounting for the initial capital investment, to determine whether the investment will be profitable.
NPV answers: after considering what I’m paying today and what I’ll receive in the future, am I actually making money (in today’s dollars)?
A Real Example from the Book
J (the author) had a property he’d invested $77,000 into. A prospective buyer offered to purchase it for $96,000 - but with seller financing: $800/month for 120 months (10 years), no money down.
Is that a good deal?
In raw dollars, $800 × 120 = $96,000. He’d get all his money back plus a $19,000 profit. Sounds fine.
But remember: $9,600 a year for 10 years is not the same as $96,000 today. The payments are spread out over a decade, so each one is worth less in today’s dollars.
To find out exactly how much less, J ran an NPV analysis with a 12% discount rate (what he believed he could earn investing elsewhere).
Here’s what the math looked like:
| Year | Cash Flow | Present Value |
|---|---|---|
| 0 (today) | -$77,000 | -$77,000 |
| 1 | $9,600 | $8,571 |
| 2 | $9,600 | $7,653 |
| 3 | $9,600 | $6,833 |
| 4 | $9,600 | $6,101 |
| 5 | $9,600 | $5,447 |
| 6 | $9,600 | $4,864 |
| 7 | $9,600 | $4,343 |
| 8 | $9,600 | $3,877 |
| 9 | $9,600 | $3,462 |
| 10 | $9,600 | $3,091 |
| NPV | -$22,758 |
The NPV is negative $22,758.
Here’s what that means: the present value of all ten years of payments adds up to about $54,242. J was all in for $77,000. Accepting $54,242 in equivalent today-dollars on a $77,000 investment is a loss of about $22,758. Bad deal.
Notice that Year 0 (today) doesn’t get discounted - because it’s happening right now, it’s already in today’s dollars.
What NPV Tells You
Interpreting NPV is simple:
- Positive NPV: the deal makes money. Your returns beat your discount rate (hurdle).
- Negative NPV: the deal loses money in today’s dollars. Pass, or renegotiate.
- NPV = 0: you break exactly even. Your return equals your hurdle rate.
That’s it. One number tells you whether to pursue a deal.
Using NPV for Financed Deals
NPV is also useful when you’re borrowing to invest. Say you can invest $100,000 in a deal that pays $2,000/year for four years, then $130,000 in year five. You’d finance it with a HELOC at 5% interest.
Should you do it? Use 5% as your discount rate (the cost of your debt):
| Year | Cash Flow | Present Value |
|---|---|---|
| 0 | -$100,000 | -$100,000 |
| 1 | $2,000 | $1,905 |
| 2 | $2,000 | $1,814 |
| 3 | $2,000 | $1,728 |
| 4 | $2,000 | $1,645 |
| 5 | $130,000 | $101,858 |
| NPV | $8,950 |
Positive NPV. The returns exceed the 5% cost of borrowing. The deal is worth pursuing.
The Hurdle Rate
The discount rate in an NPV analysis is sometimes called the “hurdle rate.” It’s the minimum return you need to make a deal worth doing. If NPV is positive, you’ve cleared the hurdle. If it’s negative, you haven’t.
The hurdle rate can be your cost of debt, your alternative investment return, or simply the minimum return you require to justify the time and risk. Picking the right hurdle rate is one of the most important judgment calls in deal analysis.
Chapter 11: Internal Rate of Return (IRR)
NPV tells you whether a deal makes money. IRR tells you how much.
Specifically: IRR is the discount rate that makes NPV = 0 for an investment. It’s the compounded annual rate of return on that investment.
Going back to the $100,000 investment with $2,000/year and $130,000 in year five: we know the NPV is positive at a 5% discount rate. But what is the actual return?
You find it by asking: what discount rate makes NPV exactly zero for this deal?
The answer, worked out by spreadsheet, is 6.87%. Verify it by running the NPV analysis at 6.87% - you get $0.
That means this investment yields a compounded annual return of 6.87%. You borrowed money at 5%. The IRR is 6.87%. You’re earning more than your cost of capital. Good deal.
Why IRR Matters
NPV needs a discount rate to work. You pick it, and the answer depends on what you picked. IRR flips that around - instead of you setting the rate, the investment tells you what rate it earns.
This makes IRR extremely useful for comparing two different deals. If Deal A has an IRR of 14% and Deal B has an IRR of 9%, Deal A generates a higher compounded return (all else being equal). You don’t have to guess at a common discount rate.
IRR is also how the investment’s actual return relates back to TVM. It’s the rate at which the time value of all your inflows and outflows perfectly cancel each other out.
How to Calculate IRR
Doing this by hand is tedious. You’d have to guess at a discount rate, run the NPV, adjust, and repeat until NPV hits zero.
In practice, you use a spreadsheet function. In Excel, it’s =XIRR(values, dates).
values: a range of cells containing your cash flows (negative for money out, positive for money in)dates: the corresponding dates for each cash flow
The function handles the iteration. For the example above, with cash flows in column C and dates in column A, the formula is =XIRR(C2:C7, A2:A7). Excel comes back with 6.88% (rounding difference from the 6.87% estimated above).
The book recommends getting comfortable with XIRR. It’s one of the most useful functions for real estate deal analysis, and there are plenty of tutorials online if you haven’t used it before.
The Relationship Between NPV and IRR
These two metrics work together:
- If the discount rate you’re using is less than the IRR, NPV is positive (good deal)
- If the discount rate equals the IRR, NPV is exactly zero (break even)
- If the discount rate is greater than the IRR, NPV is negative (bad deal)
NPV tells you whether you’ve cleared your hurdle. IRR tells you exactly how high you can jump.
Use both. Use NPV to make a go/no-go decision based on your minimum required return. Use IRR to understand what you’re actually earning and to compare deals against each other.
A Quick Note on IRR’s Limitations
IRR has some quirks. It assumes that all intermediate cash flows (the annual $2,000 payments in our example) get reinvested at the same IRR rate. In reality, you might reinvest at a lower rate. For very high IRR investments, this can make the metric optimistic. Some investors use a modified IRR (MIRR) to address this, but for most real estate analysis, standard IRR is good enough.
Summary
NPV formula:
NPV = CF0 + (CF1 ÷ (1+i)^1) + (CF2 ÷ (1+i)^2) + ... + (CFn ÷ (1+i)^n)
Where CF0 is the initial investment (negative), and i is your discount/hurdle rate.
IRR: the discount rate that makes NPV = 0. Calculate with =XIRR() in Excel.
Quick interpretation guide:
- NPV > 0: deal clears your hurdle rate
- NPV < 0: deal doesn’t clear your hurdle rate
- Higher IRR: higher compounded return
- IRR > your cost of capital: the deal makes sense financially
These are sophisticated tools, but they’re also honest ones. They force you to be specific about what return you need, and they tell you clearly whether you’re likely to get it.
← Discounted Cash Flow Analysis Explained | Real Estate Tax Basics for Investors →