What Is a DCF Model in Real Estate?
A DCF model real estate investors use is a financial model that projects a property's cash flows year by year over a defined hold period, applies a discount rate to those future cash flows, and calculates net present value (NPV) and internal rate of return (IRR). The discounted cash flow real estate framework is the standard analytical tool for any deal where future performance is expected to differ materially from current performance.
The DCF model answers two fundamental questions: what is this property worth given my return requirements, and does it clear my investment hurdle at the price being asked? It forces you to be explicit about every assumption: how fast rents will grow, what vacancy looks like in the out years, what the property will sell for at exit, and what rate of return your capital demands.
Unlike a simple cap rate analysis, which values a property based on a single year's income, the DCF captures the full investment lifecycle. That distinction matters on any deal with a meaningful value-add component, near-term lease rollovers, or a capital improvement plan that changes the cash flow trajectory over time. For a comparison of these two approaches, see the section on DCF vs. direct capitalization below.
Key Inputs: Where the Numbers Come From
The quality of a DCF model is entirely a function of its inputs. The model structure itself is mechanical. What separates a credible underwriting from an optimistic one is the rigor applied to sourcing and stress-testing each assumption.
NOI Baseline
The starting point is Year 1 NOI, derived from the normalized T12 with adjustments for known changes at close (post-acquisition property tax reassessment, new management fee, any lease-up costs in progress). Do not use the seller's proforma as your NOI baseline. Build it yourself from the T12 with your own normalization assumptions. The difference between a seller's stated NOI and your normalized NOI is typically where the pricing disagreement lives.
Rent Growth Rate
Rent growth is the annual percentage increase applied to scheduled rents. For multifamily, 2-3% annually is a conservative long-term assumption in most markets. Lease-up and value-add deals often model higher growth in Years 1-3 (reflecting the burn-off of loss to lease) before reverting to long-run trend rates in Years 4-7. Use submarket-level rent growth data from CoStar or Yardi Matrix, not national averages. A 4% national rent growth figure means nothing for a specific submarket trending flat.
Vacancy Rate
Model a stabilized vacancy rate consistent with the submarket average, typically 5-8% for multifamily in most markets. For value-add deals, model higher vacancy in Years 1-2 as units are turned and renovated, then a step-down to stabilized vacancy once the renovation program is complete. The transition timeline from elevated to stabilized vacancy is one of the most commonly compressed assumptions in optimistic underwriting.
Expense Growth
Operating expenses should grow at 2-3% annually, with property taxes treated separately given their sensitivity to reassessment. Insurance premiums in coastal and weather-risk markets have been growing at 10-20% annually in recent years. If the property is in a market with elevated insurance exposure, build in a higher insurance growth rate for Years 1-3 before it normalizes. Underwriting flat insurance in Florida or coastal Texas today is not credible.
Capital Expenditure Schedule
CapEx belongs in the model, not hidden below the NOI line. For value-add multifamily, the unit renovation budget is typically $8,000-$25,000 per unit depending on market and scope. Model capex by year based on your renovation pace assumption (e.g., 25 units per year over four years). Common area improvements, deferred maintenance from the physical inspection, and systems replacements (HVAC, roof, plumbing) should all be line items in your capital plan, sourced from the inspection report, not guessed.
Hold Period
The standard underwriting assumption is a 5-7 year hold period. Shorter holds (3-4 years) are common for development and heavy value-add plays with quick stabilization timelines. Longer holds (7-10 years) are typical for core and core-plus strategies where cash yield matters more than near-term appreciation. The hold period affects IRR significantly: a deal that looks adequate at a 10-year hold may look excellent at 5 years if most of the value creation happens early.
Debt Terms
The financing terms drive the split between levered and unlevered returns. Key inputs are LTV (typically 60-75% for CRE acquisitions in a normal lending environment), interest rate (fixed vs. floating, spread to SOFR or Treasury), amortization period (25-30 years for agency multifamily, interest-only periods common in bridge lending), and loan term (3-5 years for bridge, 5-10 years for permanent). The debt service coverage ratio (DSCR) at both entry and under stress scenarios is also a required output, particularly for lender underwriting.
Exit Cap Rate
The exit cap rate is the capitalization rate applied to NOI in the year of sale to calculate the terminal value. It is the single most consequential assumption in the model. See the next section for a detailed treatment. Source exit cap rates from comparable sales in the submarket over the prior 12-24 months, then apply a 25-50 basis point premium to entry cap rate as a conservatism buffer. A model that assumes you will sell at the same cap rate you bought is not stress-tested.
Model Structure: How to Build It Year by Year
A standard CRE DCF model follows a consistent structure across asset classes. The logic flows from revenue to NOI, then from NOI to levered cash flow, then from levered cash flow to return metrics.
Annual Cash Flow Build
| Line Item | Notes |
|---|---|
| Gross Potential Rent | 100% occupancy at scheduled rents, grown by rent growth rate annually |
| Less: Vacancy & Credit Loss | Applied as % of GPR; elevated in early years for value-add |
| Plus: Other Income | Parking, laundry, ancillary fees; grown modestly year over year |
| = Effective Gross Income (EGI) | Total actual revenue after vacancy and concessions |
| Less: Operating Expenses | Grown at 2-3% annually; taxes and insurance modeled separately |
| = Net Operating Income (NOI) | Pre-financing, pre-CapEx income; the basis for cap rate valuation |
| Less: Capital Expenditures | Renovation budget, deferred maintenance, systems replacements |
| Less: Debt Service | Principal + interest based on loan terms; IO periods modeled separately |
| = Cash Flow to Equity | Annual levered cash flow; basis for cash-on-cash return |
Terminal Value
In the exit year, the terminal value equals the projected NOI divided by the exit cap rate. If NOI in Year 5 is $800,000 and you apply a 5.75% exit cap, the gross sale price is $13.9 million. Subtract selling costs (typically 1-2% of gross proceeds) and remaining loan balance to arrive at net equity proceeds at exit. That figure, combined with the annual cash flows to equity during the hold, forms the total return stream.
Levered vs. Unlevered Returns
Unlevered IRR measures the return on the total asset value, ignoring financing. It is a pure measure of asset performance and allows apples-to-apples comparison across deals with different capital structures. Levered IRR measures the return on equity invested, accounting for debt service and loan repayment. Positive leverage (where the unlevered yield exceeds the cost of debt) amplifies levered returns. Negative leverage (increasingly common when debt costs exceed going-in cap rates) compresses them. Report both in your IC materials.
The Assumptions That Drive the Most Value
Exit Cap Rate: The Most Important Number in Your Model
The exit cap rate deserves its own treatment because it is disproportionately powerful. On a deal with a 5-year hold, the terminal value typically represents 60-70% of total return. A 25 basis point difference in exit cap rate applied to $1 million of exit-year NOI is a $870,000 swing in gross sale proceeds at a 5.50% vs. 5.75% cap. On a $3 million equity investment, that single 25 basis point change moves levered IRR by 100-150 basis points.
The practical implication: model your exit cap at a 25-50 basis point premium to the entry cap rate as a minimum. If you are buying at a 5.0% cap in a market where comparable assets have been trading at 4.75-5.25%, an exit cap assumption of 5.0% assumes no cap rate decompression over your entire hold period. That is not a conservative assumption in most market environments. Use 5.25-5.50% and know your IRR at 5.75%.
For a deeper treatment of how cap rates and IRR interact, see the companion article on cap rate vs. IRR in CRE.
Rent Growth Rate
Rent growth compounds. A 3% annual assumption versus a 2% assumption on a $2 million GPR property at Year 1 produces a $126,000 difference in GPR by Year 5. That difference flows through to NOI and then into your terminal value calculation. Conservative underwriting uses market-rate rent growth from third-party data sources, not the broker's assertion that "this market has been growing at 5% annually."
Vacancy Stabilization Timeline for Value-Add Deals
Value-add models almost always underestimate the time required to stabilize from elevated vacancy. The typical pattern assumes renovation completion in 18-24 months and full lease-up within 6 months of completion. The actual pattern often runs 6-12 months longer. Each additional month of elevated vacancy during the stabilization period reduces both cash flow to equity and exit NOI. Model the conservative case explicitly and decide whether the deal still works before committing to an LOI.
How to Stress Test a CRE DCF Model
A single base case scenario is not underwriting. It is hope. Stress testing is the discipline that separates investors who understand their downside from those who discover it after closing.
Build a Three-Scenario Table
Every CRE model should include base, upside, and downside scenarios. The base case reflects your best estimate of realistic performance. The upside case reflects favorable but plausible conditions. The downside case reflects the outcome if two or three things go wrong at the same time. Your downside case should not be "what if everything breaks perfectly." It should be a believable bad outcome that you would not be surprised to live through.
| Assumption | Upside | Base | Downside |
|---|---|---|---|
| Rent Growth (Yrs 1-3) | 4.0% | 2.5% | 1.5% |
| Stabilized Vacancy | 4.0% | 6.0% | 8.0% |
| Stabilization Timeline | 18 months | 24 months | 30 months |
| Exit Cap Rate | 5.25% | 5.50% | 6.00% |
| Levered IRR | 19.4% | 15.2% | 10.8% |
What to Stress and How Much
The highest-impact variables to stress are: exit cap rate (+50 basis points from base), rent growth (-100 basis points from base), and stabilization timeline delayed by 6 months. These are not extreme scenarios. They are plausible deviations that could occur independently or together. Running all three simultaneously in your downside case gives you a realistic floor.
The question to ask before proceeding to LOI: what IRR does the downside scenario produce, and does it clear your minimum return threshold? Most institutional investors have a levered IRR floor of 10-12% for value-add multifamily. If your downside scenario produces an 8% IRR at the asking price, you need either a price reduction or a better entry basis before proceeding. If the downside produces 11%, you have a comfortable margin and can move forward with confidence.
DCF vs. Direct Capitalization: When to Use Each
Direct capitalization divides a single year's NOI by a market cap rate to produce a value. It is fast, simple, and appropriate when the property is stabilized, the cash flow is flat or growing at a steady rate, and there is no near-term event that materially changes the income profile.
A full DCF is required in any of these situations: the deal is a value-add with material renovation and lease-up activity, there are near-term lease rollovers that will change the income profile, you are underwriting material rent growth above inflation, the property has significant capital expenditure requirements, or the hold period is short enough that the exit timing materially affects returns.
In practice, the vast majority of acquisitions in multifamily, office, and retail fall into the "use a DCF" category. Direct capitalization is most appropriate for stabilized NNN retail, industrial with long-term leases, and ground leases where the income is effectively fixed. For everything else, skip the one-year shortcut and build the full model. The additional time is measured in hours. The decision quality improvement is measured in avoided bad deals.
AcquiOS generates complete, fully populated DCF models in your existing Excel template in under 35 minutes, compared to the 3-4 hours it takes an analyst to build one manually. The model pulls directly from your normalized T12 and rent roll analysis, carries your rent growth and vacancy assumptions forward year by year, and calculates IRR, equity multiple, and cash-on-cash in all three scenarios simultaneously. Every input is traceable back to a source document. See the guide to how to underwrite multifamily deals for the full context on where DCF modeling fits in the broader acquisition process.
Frequently Asked Questions
How many years should a CRE DCF model project?
The model should project cash flows for the duration of the intended hold period, plus a terminal value in the exit year. For most value-add and core-plus acquisitions, that means a 5-7 year projection period. Development deals may require longer periods (8-12 years) to capture the full construction, lease-up, and stabilized hold phases. The model should never be shorter than the period you expect to own the asset, and extending it beyond the hold period does not add analytical value.
What discount rate should I use for CRE?
The discount rate in a CRE DCF is typically the investor's required rate of return on equity, which varies by strategy. Core investments (stabilized, low-risk assets) may use a 6-8% equity discount rate. Value-add strategies typically require 12-15%. Opportunistic and development deals demand 18-25% or more to compensate for execution risk. In practice, most CRE investors work backward from IRR: they set a minimum IRR threshold (e.g., 15% levered), model the deal, and assess whether it clears that hurdle rather than applying a theoretical discount rate to derive NPV.
What is the difference between levered and unlevered IRR?
Unlevered IRR is the return on the total property value, as if the deal were purchased with all equity and no debt. It measures asset-level performance independent of financing. Levered IRR is the return on the equity invested, after accounting for debt service payments and loan repayment at exit. Leverage amplifies returns in both directions: positive leverage (asset yield exceeds cost of debt) boosts levered IRR above unlevered IRR, while negative leverage (cost of debt exceeds asset yield) compresses it. Reporting both figures in IC materials is standard practice because it separates the quality of the asset from the financing structure.
How does AI build a DCF model?
AI underwriting platforms like AcquiOS extract the key inputs from your deal documents (T12, rent roll, offering memorandum) using document intelligence, normalize the historical data, apply your firm's standard assumptions or market benchmarks, and then populate a complete DCF model directly into your existing Excel template. The model preserves your firm's formatting, formula structure, and scenario layout. What changes is the time required to go from raw documents to a fully populated model: from 3-4 hours manually to under 35 minutes with AI assistance. Every extracted value is cited back to the source document for auditability and review.