Discounted Cash Flow Analysis Explained for Real Estate Investors
Book: Real Estate by the Numbers | Authors: J Scott and Dave Meyer | Chapter: 9
← Expected Value and Time Value of Money | Net Present Value and Internal Rate of Return →
In the last chapter, we covered how to find the present value of a single future payment. That’s useful, but real estate rarely works that way. When you own a rental property, you’re not just getting one payout at the end. You’re getting rent every month, expenses along the way, and a lump sum when you eventually sell.
Chapter 9 of Real Estate by the Numbers tackles this exact problem. How do you figure out what a whole stream of future income is worth today? That’s what discounted cash flow (DCF) analysis does.
The Problem with Just Adding Up Cash
Here’s the setup the book uses. Say you buy two properties and hold each for four years, collecting rent and then selling. Over four years, both properties generate exactly $150,000 in total cash.
Property 1 cash flows:
- Year 1: $5,000
- Year 2: $8,000
- Year 3: $12,000
- Year 4 (sale): $125,000
Property 2 cash flows:
- Year 1: $15,000
- Year 2: $15,000
- Year 3: $15,000
- Year 4 (sale): $105,000
Same total, different timing. Which is better?
In pure “just add up the numbers” terms, they’re identical. But that’s not how money actually works. Remember time value of money: money received sooner is worth more because you can reinvest it sooner.
Property 2 pays out more money earlier. That’s better.
But how much better? You need DCF to put a number on it.
How Discounted Cash Flow Works
DCF analysis takes each individual cash flow, discounts it back to today’s value using a discount rate, and then adds all those present values together.
The formula:
DCF = (CF1 ÷ (1 + i)^1) + (CF2 ÷ (1 + i)^2) + … + (CFx ÷ (1 + i)^x)
Each piece of that formula is just a present value calculation. You’re finding what each year’s cash flow is worth today, then summing them all up.
The discount rate (i) represents what you could earn if you had the money now and invested it elsewhere. It’s your opportunity cost.
Running the Numbers
The authors use 8% as the discount rate, representing what they might earn in the stock market as an alternative.
Property 1 (discount rate: 8%):
| Year | Cash Flow | Present Value |
|---|---|---|
| 1 | $5,000 | $4,630 |
| 2 | $8,000 | $6,859 |
| 3 | $12,000 | $9,526 |
| 4 | $125,000 | $91,879 |
| Total | $150,000 | $112,893 |
Property 2 (discount rate: 8%):
| Year | Cash Flow | Present Value |
|---|---|---|
| 1 | $15,000 | $13,889 |
| 2 | $15,000 | $12,860 |
| 3 | $15,000 | $11,907 |
| 4 | $105,000 | $77,178 |
| Total | $150,000 | $115,835 |
Same $150,000 in absolute terms. But the present value of Property 2 is $115,835 versus $112,893 for Property 1. Property 2 is worth about $3,000 more in today’s dollars.
Property 2 is the better investment. Not because it generates more money total - it generates the same. It’s better because it delivers more of that money sooner, and sooner money can be reinvested to earn more.
What the DCF Number Actually Means
The DCF result gives you the maximum you should pay in cash today for that stream of future income.
For Property 1: if someone offered to pay you $112,893 right now instead of letting you hold the property for four years, those two options are financially equivalent (assuming 8% as your alternative return rate).
If you paid more than $112,893 for Property 1, you’d be earning less than 8% on your investment. Less than what you could get elsewhere. Pay less, and you’re earning more than 8%.
This is important: the DCF result depends entirely on the discount rate you use. A higher discount rate means future cash flows are worth less today. A lower discount rate means they’re worth more. There’s no objectively “right” discount rate - it’s whatever return you believe you could earn on your money in your best alternative investment.
The “Would You Rather?” Problem
The book includes a fun example of this concept. Imagine someone asks you:
“Would you rather have $2 million in cash right now, or $200,000 per year for the rest of your life?”
Most people argue passionately about this online without actually running the math. DCF analysis settles it.
The $2 million option is easy - its present value is $2 million (you’re getting it now).
For the $200,000 per year option, you need to know three things:
- The amount each year: $200,000 (easy)
- Your discount rate: assume 8% (what you could earn investing the money)
- How many years you’ll receive it: assume 25 years (conservative estimate)
Running a DCF analysis on 25 years of $200,000 payments at an 8% discount rate gives you about $2.14 million.
So in this example, $200,000 per year for 25 years is worth slightly more than $2 million today. The lump sum looks bigger, but the income stream, at reasonable assumptions, wins by a small margin.
Change the assumptions and the answer changes. If you could earn 12% on your money instead of 8%, the income stream becomes less valuable (future payments are more heavily discounted). If you expect to live 40 years instead of 25, the income stream becomes more valuable.
That’s why DCF analysis requires you to think carefully about your discount rate and your time horizon. Garbage in, garbage out.
Practical Notes
Monthly vs. annual cash flows: The examples in the book use annual cash flows to keep the math simpler. In reality, rental income comes in monthly. For a more precise analysis, you’d discount each month’s cash flow individually - more work, but more accurate.
What counts as a cash flow: Include everything - rental income, operating expenses (already factored into NOI), and the eventual sale proceeds. The sale price matters a lot because it’s usually the biggest number and it comes late, so it gets heavily discounted.
Sensitivity to discount rate: Run the DCF at a few different discount rates. If a deal only looks good at a very low discount rate, it’s more fragile. If it looks good at 8%, 10%, and 12%, that’s more reassuring.
DCF Formula
DCF = (CF1 ÷ (1 + i)^1) + (CF2 ÷ (1 + i)^2) + ... + (CFx ÷ (1 + i)^x)
Where:
- CF = each future cash flow
- i = discount rate (per period)
- exponent = number of periods until that cash flow
You can do this in Excel pretty easily. Each row is one period’s cash flow divided by (1 + discount rate) raised to the number of that period. Sum all the rows.
The Limitation of DCF
DCF is powerful for comparing income streams and putting a present value on a property. But it has one big gap: it doesn’t account for the initial investment you make to buy the property.
If Property 1 has a DCF of $112,893 and costs $95,000 to buy, that looks like a good deal. If it costs $130,000, not so much. DCF doesn’t tell you that.
That gap is filled by net present value (NPV), which is exactly what the next chapter covers.
← Expected Value and Time Value of Money | Net Present Value and Internal Rate of Return →