What Is Discounted Cash Flow in Commercial Real Estate?
Article Summary
- DCF values a property by discounting all future cash flows, including the eventual sale, back to what they're worth today.
- The formula relies on three inputs: projected cash flows, a discount rate, and a terminal value, which typically accounts for 60-80% of total DCF value.
- A positive cash flow does not guarantee a positive net present value (NPV). Timing and return requirements both determine whether a deal clears your threshold.
- Direct capitalization and DCF are complementary tools, not competing ones. Knowing when to use each one strengthens your decision-making.
What Is Discounted Cash Flow?
Discounted cash flow (DCF) is the method investors use to determine what a property's future income is worth in today's dollars.
Overpaying for a property is one of the most common and costly mistakes a first-time investor makes. DCF is the tool that helps you avoid it.
When you buy commercial property, you're buying a stream of future income. DCF answers one question: What is all that money worth right now? It rests on the principle that a dollar received in three years is worth less than a dollar today, because money in hand can be invested in the meantime.
In practical terms, DCF lets you compare what you'd pay for a property against what it's genuinely expected to generate over your holding period. If the discounted value of future cash flows exceeds the purchase price, the deal clears your return threshold.
Capitalization rate is a useful shortcut for steady-income properties, but it only captures a single moment in time. It can't account for a lease expiring in year two or a capital expenditure you know is coming. DCF is the more reliable method when you expect cash flows to change, and it's widely regarded as the most rigorous valuation approach available to real estate professionals.
How Do You Calculate DCF?
The formula discounts each year of future cash flow back to today's dollars, then adds them all up.
The formula looks like this:
DCF = CF₁ / (1+r)¹ + CF₂ / (1+r)² + ... + CFₙ / (1+r)ⁿ
Where:
- CF = cash flow in each year
- r = discount rate (your required return)
- n = the year of the cash flow
While the discount rate is the return you require as an investor, the discount factor is the mathematical result of applying that rate to each year. It appears as a separate column in the table below.
In practice, investors run the DCF calculation using the net present value (NPV) function in Excel. For example, if you were evaluating a retail strip for sale with a planned five-year hold at an 8% discount rate, your calculations might look like this:
| Year | Cash Flow (CAD) | Discount Factor (8%) | Present Value (CAD) |
|---|---|---|---|
| 1 | $80,000 | 0.926 | $74,080 |
| 2 | $83,000 | 0.857 | $71,131 |
| 3 | $86,000 | 0.794 | $68,284 |
| 4 | $89,000 | 0.735 | $65,415 |
| 5 | $92,000 + $1,150,000 sale | 0.681 | $845,570 |
| Total DCF | $1,124,480 |
If you can acquire this property for less than $1,124,480, the investment clears your 8% return target. Raise the discount rate to 10% and the value drops. Lower it to 6% and it rises. That sensitivity is both DCF's greatest strength and one of its key limitations.
What Are the Key Components of a DCF Analysis?
Every DCF model rests on three inputs: projected cash flows, a discount rate, and a terminal value.
| Component | What It Represents | Where It Comes From |
|---|---|---|
| Projected Cash Flows | Annual net income after operating costs | Lease agreements, market rents, expense history |
| Discount Rate | Your required annual return, adjusted for risk | Cost of capital, property type, market conditions |
| Terminal Value | Projected sale proceeds at end of hold period | Exit cap rate applied to final year NOI |
Projected cash flows start with your leases. Lease structure will vary between types of commercial leases, and that structure will determine how operating costs are divided between owner and tenant, which directly affects your net income.
The discount rate is your personal return benchmark: riskier assets get higher rates, while more predictable ones get lower rates. A property's debt service coverage ratio (DSCR) is one signal worth factoring in, since it reflects how much financial pressure the asset carries relative to its income.
Terminal value is often the largest number in the model. Because it represents the projected sale proceeds at the end of your hold, the assumption you choose here deserves more scrutiny than almost any other input in your analysis.
How Does NPV Help You Make an Investment Decision?
NPV is the difference between a property's total discounted value and what you're being asked to pay for it.
Positive means you're paying less than the cash flows justify. Negative means you're paying more. Zero means you're hitting your target return exactly.
A property can generate positive cash flow and still show a negative NPV. If cash flow doesn't grow quickly enough to clear your required return once discounted, the investment doesn't meet your hurdle, regardless of the raw income number. Internal rate of return helps you get a fuller picture of how these metrics relate, since IRR is effectively the discount rate at which NPV equals zero.
How Do You Choose the Right Discount Rate?
There is no universal rate. The one you choose should reflect both the risk of the investment and your cost of capital.
Start with the yield on Government of Canada bonds as your risk-free baseline, then layer in premiums for property type, location, tenant quality, lease term, and condition. A stabilized industrial property for sale with a national-credit tenant warrants a lower rate than if you were evaluating a partially vacant retail centre for sale in a secondary market. When the Bank of Canada adjusts its policy rate, your discount rate should move accordingly.
What Are the Limitations of DCF Analysis?
DCF is only as reliable as the assumptions behind it.
Every input is an estimate, and small changes to the discount rate, vacancy assumption, or exit cap rate can shift the valuation significantly. A five-year projection is more defensible than a ten-year one, for example.
The best defence is scenario analysis: run a base case, an upside, and a downside. If all three produce an acceptable outcome, the investment is on solid ground.
The graph below shows how DCF value shifts across upside, base, and downside scenarios at discount rates of 6%, 8%, and 10%. The gap between the best and worst case widens as the discount rate rises, which is exactly the kind of sensitivity a well-built DCF should reveal.
Illustrative example based on a hypothetical Canadian commercial property with $80,000-$92,000 NOI over a five-year hold and a projected sale at year five.
Pair your DCF with direct capitalization and then compare with other listings in your target market for a further check.
Commercial Properties For Sale
How Does DCF Compare to Direct Capitalization?
Direct capitalization gives you a quick snapshot of value. DCF gives you the full picture across time.
Direct capitalization divides a single year's net operating income (NOI) by a cap rate. It's fast and useful for stable, fully leased properties.
DCF models every year individually and is the better fit when you expect income to change. Knowing where each method excels helps you choose the right tool for each deal and ensures your DCF assumptions are grounded in market reality rather than built in isolation.
| Scenario | Better Method |
|---|---|
| Fully leased, stable long-term tenants | Direct capitalization |
| Upcoming lease expiries | DCF |
| Renovation or repositioning planned | DCF |
| Comparing multiple properties quickly | Direct capitalization |
| Significant CapEx expected | DCF |
| Verifying a DCF result | Direct capitalization |
When both methods produce similar results, you can move forward with more confidence. When they diverge, that's a signal to examine your assumptions more closely.
How Do Vacancy Rates, Lease Structures, and CapEx Affect Your DCF?
These three variables shape your projected cash flows more than anything else.
A property that is 95% occupied today may have two anchor tenants expiring in year two. DCF models that income dip explicitly. A long-term net lease with a creditworthy tenant produces consistent cash flows, while a short-term gross lease with a small retailer introduces considerably more uncertainty. CapEx costs like roof replacements and tenant fit-outs fall in specific years and reduce the cash flow available to you in those periods.
Before building your DCF, know the rent roll. Understand when leases expire, what renewal probability looks like, and what capital costs are likely. Optimistic assumptions on any of these three variables will produce a present value that flatters the investment rather than mirrors it.
What Is Terminal Value, and How Do You Calculate It?
Terminal value is your estimate of what the property will sell for at the end of your holding period, discounted back to today.
In most DCF models, terminal value represents 60-80% of total present value, making it the most consequential assumption in your analysis. The standard method is cap rate reversion: divide the projected NOI in the year after your hold ends by your chosen exit cap rate to get the estimated sale price, then discount it back to today.
If your year-six NOI is $95,000 and you apply a 6.5% exit cap rate, the implied sale price is approximately $1,460,000. Most investors set the exit cap rate somewhat higher than the going-in rate, reflecting property age and the possibility that market conditions shift. Run your model at multiple exit cap rate assumptions to understand how sensitive your returns are to this one variable.
Frequently Asked Questions
How do I determine the appropriate discount rate?
Start with Government of Canada bond yields as your baseline and layer in premiums for property type, location, tenant quality, and lease terms. A mortgage broker or accountant can help you arrive at a rate that reflects your actual cost of capital.
Why does my property show positive cash flow but a negative NPV?
A negative NPV means the property's IRR falls below your discount rate. The cash flow isn't arriving quickly or reliably enough to clear your required return once discounted. Check whether your discount rate accurately reflects your cost of capital before walking away.
How reliable are terminal value calculations?
They're the least certain figure in the model. Treat terminal value as a range, run multiple exit cap rate scenarios, and cross-check against direct capitalization to validate your assumptions.
How should I model vacancy and tenant turnover costs?
Model them against actual lease expiration dates rather than averaging across the hold. For each expiry, estimate downtime, leasing commissions, tenant improvement allowances, and any free-rent periods. Local market data will give you more defensible input than industry rules of thumb.
