A DCF model for real estate has five moving parts, and most of the DCFs handed to LPs get at least one of them wrong, usually the one that matters most. For a full breakdown of when DCF is the right tool versus direct capitalization, see when direct capitalization isn’t enough.
This guide covers the four pillars of actually building a DCF model for real estate: the revenue and expense projections, discount rate selection, terminal value, and the specific ways sponsors game the inputs before an LP ever sees the model.
What a DCF Model Does (And When It’s the Right Tool)
A discounted cash flow (DCF) model projects a property’s annual cash flows over a holding period and calculates a terminal value at sale. It then discounts everything back to present value using a required rate of return.
Terminal value typically represents 60% to 80% of total value in a discounted cash flow model. This means the exit assumption carries far more weight than any single year of operating projections, and is also where sponsor underwriting is most often overly optimistic.
DCF Model for Real Estate: The Five Moving Parts
Every real estate DCF reduces to the same five inputs: the holding period, the year-by-year cash flow projections, the discount rate, the terminal value, and the present value summation.
Step 1: Set the Holding Period and Timeline
The holding period defines how many years of cash flow the model projects before a sale is assumed. Most institutional CRE models use a 5-year or 10-year holding period. This window is long enough to capture a full leasing or renovation cycle while staying short enough that terminal value assumptions remain grounded in current market conditions.
A shorter hold reduces reliance on long-range forecasting but compresses more of the total return into the terminal value calculation. A longer hold spreads return across more operating years but stretches the exit assumption further into an unknowable future.
Step 2: Build the Revenue and Expense Projections
This step converts a property’s physical and market characteristics into a year-by-year cash flow stream, the foundation every later step discounts.
Sourcing a Defensible Market Rent Growth Assumption
A defensible rent growth assumption comes from current submarket data, not a round number pulled from memory. As of 2025-2026, stabilized market rent growth assumptions for multifamily and industrial assets commonly cluster in the 2.5% to 3.5% range, per CBRE and Yardi Matrix data. This range should be checked against current reports for the specific submarket before it goes into a model.
Modeling Absorption and Lease-Up for Value-Add or Development Deals
A stabilized asset can reasonably apply a flat vacancy assumption across the hold. A value-add or development deal cannot, since the property is not yet leased at target occupancy on day one. These models need a separate absorption schedule.
Occupancy might open at 60% in year one, climb through partial lease-up in years two and three, and reach a stabilized 93% to 95% by year three or four. Applying a stabilized vacancy rate from Year 1 on an unstabilized asset overstates early cash flow and understates the risk the model is supposed to capture.
Expense Growth and Capital Expenditure Assumptions
Operating expense growth typically runs at or slightly below revenue growth, reflecting a mix of fixed and variable costs. It should be projected on its own line rather than assumed to move in lockstep with rent.
Capital expenditure reserves sit on a separate line entirely, covering major, non-recurring items like roof replacement or mechanical systems rather than day-to-day operating costs. Older assets and later hold years generally warrant a higher capex reserve assumption.
Step 3: Select a Discount Rate
The discount rate must match the type of cash flow being discounted, and mismatching the two is the single most common technical error we see in a real estate DCF.
Match the Rate to the Cash Flow (WACC vs. Cost of Equity)
Discounting the wrong cash flow at the wrong rate makes the valuation inconsistent before growth rate or terminal value assumptions even matter. It is also a specific error that an experienced LP or lender can spot immediately.
The table below shows the matching principle in one place.
| Cash Flow Type | Correct Discount Rate | Why |
| Unlevered free cash flow (before debt service) | Weighted Average Cost of Capital (WACC) | Reflects the required return to all capital providers, debt and equity, since the cash flow belongs to all of them |
| Levered free cash flow (after debt service) | Cost of equity | Reflects the required return to equity holders only, since debt has already been serviced out of the cash flow |
| Either, built from fundamentals | Risk-free rate (Treasury yield) plus risk premium | The build-up method, the same Treasury-plus-risk-premium logic used in exit cap rate derivation, applied here to the required return on cash flow |
The Build-Up Method: Risk-Free Rate Plus Risk Premium
The build-up method constructs a discount rate directly from market fundamentals rather than borrowing an assumption from a prior deal. It combines the current risk-free rate, typically the 10-year Treasury yield, with a real estate risk premium reflecting the asset’s risk profile.
Current CRE discount rates built this way commonly cluster in the high single digits to low double digits, varying by asset class, leverage, and risk profile. Check this range against current Treasury data rather than a fixed historical figure.
The Matching-Principle Error That Invalidates a Model Before Anything Else Matters
Discounting levered cash flow with WACC, or unlevered cash flow with cost of equity, is a mismatch that invalidates the model’s internal logic regardless of how carefully every other input was built. This is the single sharpest, most technical error a reviewer can catch, and it appears with enough frequency in practice to be worth checking first, before scrutinizing any single growth or exit assumption.
Step 4: Calculate Terminal Value
Terminal value converts the property’s projected income in the year after the final hold year into an estimated sale price, and it typically dominates the total result.
Applying an Exit Cap Rate to Final-Year NOI
Terminal value is calculated by applying an assumed exit cap rate to the property’s forward NOI, the projected income for the year immediately following the sale. For the full methodology behind selecting a defensible exit cap rate, see exit cap rate vs. going-in cap rate.
Why Terminal Value Is 60-80% of Total DCF Value
Terminal value represents 60% to 80% of total value in a discounted cash flow model because it captures the entire remaining income stream of the property. That stream is compressed into a single future sale price, rather than one year of operating cash flow like every other line in the model.
This concentration means a small error or manipulation in the exit assumption moves the final result far more than an equivalent error anywhere else in the projection. That is exactly why the terminal value step deserves more scrutiny than any single year of the operating build.
Step 5: Discount Every Cash Flow and Sum to Present Value
The final step discounts each year’s cash flow and the terminal value back to today using the selected discount rate, then sums every discounted figure into a single present value.
The table below builds a complete discounted cash flow model for a 60,000-square-foot industrial warehouse in Denver, Colorado, purchased for $9,000,000 at a 6.3% going-in cap rate. It uses a 9.0% WACC as the discount rate for this unlevered cash flow projection.
| Year | Revenue (GPR) | Vacancy (5%) | EGI | OpEx | NOI (FCF) | Discount Factor (9%) | PV of Cash Flow |
| 0 | ($9,000,000) purchase | 1.00 | ($9,000,000) | ||||
| 1 | $800,000 | ($40,000) | $760,000 | ($190,000) | $570,000 | 0.91 | $522,936 |
| 2 | $824,000 | ($41,200) | $782,800 | ($194,750) | $588,050 | 0.84 | $494,950 |
| 3 | $848,720 | ($42,436) | $806,284 | ($199,619) | $606,665 | 0.77 | $468,457 |
| 4 | $874,182 | ($43,709) | $830,473 | ($204,609) | $625,863 | 0.70 | $443,377 |
| 5 | $900,407 | ($45,020) | $855,387 | ($209,724) | $645,662 | 0.64 | $419,636 |
| Terminal | $927,419 (Yr 6 GPR) | $666,081 (Yr 6 NOI) → TV $9,747,527 | 0.64 | $6,335,224 |
Summing every discounted figure: the five years of operating cash flow contribute $2,349,356 in present value, and the discounted terminal value contributes $6,335,224. Combined, this produces a total discounted cash flow value of approximately $8,684,579.
Terminal value accounts for 72.9% of that total, landing squarely inside the 60% to 80% range cited above. Against the $9,000,000 purchase price, this produces a net present value of approximately negative $315,000. At a 9.0% required return, this specific deal is a marginal buy rather than a clear one, a conclusion a quick direct-cap screen would not have revealed on its own.
Where Sponsors Game the Inputs
Four specific manipulation patterns account for most of the gap between an honest DCF and one built to produce a predetermined answer.
Rent Growth That Outpaces Realistic Market Expectations
A model assuming 5% or 6% annual rent growth when current submarket data supports 2.5% to 3.5% inflates every year of projected cash flow simultaneously. That gap compounds into a materially overstated result by the final year. This is one of the easiest assumptions for an LP to check, since it only requires comparing the stated growth rate against current market data for the specific submarket.
An Exit Cap Rate Set Below the Going-In Rate
Assuming the market will pay a lower cap rate for the same income at exit than the investor paid at entry, without a specific, documented reason, inflates terminal value directly. Since terminal value already carries 60% to 80% of total weight, this single assumption does more damage to model integrity than almost any other input.
A Discount Rate Chosen to Hit a Target Return, Not to Reflect Risk
A discount rate built backward from a target IRR may look rigorous, but it does not reflect the property’s actual risk. The better approach is to build the rate forward from the deal itself, using WACC, cost of equity, or the build-up method.
This is harder to spot than an aggressive rent growth assumption. Revenue assumptions are visible in the model. The discount rate often receives less scrutiny, even though a small change can materially shift the valuation.
A Model That Only Works Under One Scenario
A DCF presented with a single point estimate and no sensitivity range is not evidence the deal works. It is evidence the deal was modeled once and never stress-tested. A model that only clears its return threshold under the exact base-case assumptions presented is fragile by construction, and that fragility is invisible until someone asks to see the range.
How to Stress-Test Your Own DCF Before You Trust It
A single-point DCF output should be treated as one scenario among many, not a conclusion. Running the same model across a range of rent growth, exit cap rate, and discount rate combinations shows how much the final value actually depends on any one assumption.
This is the same sensitivity discipline covered in Bluestar’s exit cap rate and equity multiple guides. BlueStar applies Monte Carlo simulation to full DCF models, producing a distribution of likely outcomes rather than a single number, for sponsors and investors who need a model that holds up under real scrutiny.
Build Your Model with BlueStar’s Pro Forma Calculator
Every step above, the revenue build, the discount rate, and the terminal value, comes together in a multi-year pro forma with a discounting layer applied. Run your own multi-year projection in BlueStar’s Pro Forma Calculator to build these numbers on a specific deal. For a model built and stress-tested against your deal’s actual risk profile, Bluestar’s financial modeling and underwriting team can build and validate the analysis directly.
Frequently Asked Questions
What’s the practical difference between using WACC and cost of equity as your discount rate?
WACC discounts unlevered cash flow, the property’s income before any debt service is subtracted, and reflects the blended required return of both debt and equity capital. Cost of equity discounts levered cash flow, income after debt service, and reflects only the equity holder’s required return. This rate is typically higher than WACC, since equity sits behind debt in the capital stack and carries more risk. Using the wrong one against the wrong cash flow type produces an internally inconsistent model, which is why the matching principle above exists.
Should the discount rate stay the same for every year of the holding period, or can it change?
Most models hold the discount rate constant across the full holding period, since it represents a required return based on the property’s risk profile, generally assumed stable absent a specific reason to think otherwise. It can reasonably change year over year if that risk profile genuinely shifts, such as a value-add property transitioning from lease-up risk in early years to stabilized income later. This added complexity should be justified by a specific change in underlying risk, not used to smooth out an otherwise unfavorable result.
What software do CRE professionals actually use to build a DCF, Excel, Argus, or something else?
Excel remains the most widely used tool for real estate DCF modeling at the individual deal level, offering full flexibility to build a custom line-by-line model like the one above. Argus Enterprise is the institutional standard for larger portfolios and more complex lease-driven assets, particularly office and retail with rollover-heavy rent rolls, and is common at REITs, institutional investors, and larger sponsors. Purpose-built underwriting platforms and financial modeling firms offer a middle path for sponsors who want Argus-level rigor without the software’s cost and learning curve.
How do I sanity-check whether a sponsor’s discount rate is too low?
Compare the stated rate against the current risk-free rate plus a reasonable risk premium for the asset class and strategy, using the build-up method above as a floor. A rate close to or below the current Treasury yield, with no clearly stated justification for a minimal risk premium, signals the number was likely chosen to inflate present value rather than reflect actual risk. This cross-check takes a few minutes and catches one of the more common ways a discounted cash flow model gets dressed up.
Is a higher discount rate always the more conservative choice?
No, and this is a genuine nuance worth understanding rather than assuming. A high discount rate paired with an unrealistically low exit cap rate is not conservative at all. The second assumption can inflate terminal value by more than the first assumption discounts it away, especially given how much weight terminal value already carries in the total result. A truly conservative real estate financial model applies consistent, defensible logic across every input together, not just a high number in the one line an investor is most likely to check first.