Commercial Real Estate DCF Analysis: A Complete Guide

Discover how to build a professional Discounted Cash Flow (DCF) model for CRE investments. This comprehensive guide walks you through cash flow projections, discount rates, terminal value calculations, and sensitivity analysis—the essential components that separate seasoned investors from amateurs.

What Is a DCF in Real Estate?

A Discounted Cash Flow (DCF) model is a valuation method that projects a property's future cash flows and discounts them back to present value using a required rate of return. Think of it as answering the question: "What is this property worth to me today, given the cash it will generate over the next decade?"

Unlike simple cap rate valuation, DCF models capture the full economic story of a CRE investment. They account for rent growth, market dynamics, leverage, and risk. This is why institutional investors and underwriters consider DCF analysis the gold standard for CRE valuation.

Why DCF Matters for CRE: Cap rate valuation assumes a single exit yield. DCF models let you stress-test assumptions, model refinancing, capture rent growth, and evaluate downside protection—essential for institutions managing capital with fiduciary duty.

Components of a CRE DCF Model

A complete DCF model stacks multiple layers of cash flow assumptions on top of each other. Understanding each component is critical for building accurate projections.

Revenue Projections

Revenue in CRE isn't just base rent. It includes:

Rent escalations: Annual bumps (1-3% typical) built into existing leases
Market rent reversion: Rollover to market rates as leases expire
Vacancy adjustment: Not all space is leased all the time (typically 5-10% for stabilized assets)
Ancillary revenue: Parking, storage, utility reimbursements, assignment fees

Operating Expenses

Operating expenses are deducted from revenue to calculate NOI:

Management fees: 4-6% of effective revenue (or fixed cost)
Repairs & maintenance: 5-15% depending on asset age and type
Insurance: 0.5-1.5% of property value annually
Taxes: Real estate taxes (highest in NY, TX, CA)
Utilities: If landlord-paid (tenant-paid reduces landlord exposure)

NOI to Levered Cash Flow

Net Operating Income (NOI) is the profit before leverage and extraordinary items:

NOI = Revenue - Operating Expenses
CapEx: Capital expenditures (roof, HVAC replacements)
TI/LC: Tenant improvements and leasing commissions at lease rollover
Reserves: Escrows for future CapEx, leasing, or debt service
Debt service: Principal and interest payments (only in levered cash flow)

Building the Cash Flow Projection

The core of any DCF is a 10-year cash flow projection. Year 1 typically uses conservative "stabilized" assumptions, and years 2-10 layer in growth.

10-Year Projection Framework

Year	Key Assumptions	Focus
Year 1	Lease rollover, new tenant ramp	Stabilized income
Years 2-7	Market rent growth (1-3%), lease expirations	Growth phase
Years 8-10	Major CapEx, final lease rollover	Preparation for exit

The strength of your DCF depends on assumption quality. Underestimating vacancy, overestimating rent growth, or underbudgeting CapEx are common mistakes. Conservative assumptions create downside protection; aggressive assumptions create upside optionality.

Calculating Terminal Value

Terminal value represents the sale proceeds at the end of year 10 and typically comprises 60-80% of total DCF value. Getting this right is critical.

Exit Cap Rate Method (Most Common)

Terminal Value = Year 10 NOI ÷ Exit Cap Rate

Example: Year 10 NOI of $1,000,000 ÷ 5.5% exit cap rate = $18.18M exit value.

Exit cap rates reflect market conditions at sale time. If you're projecting 2035 market rates, assume caps will be 50-150 bps higher than today's rates to account for rising rates and property aging.

Gordon Growth Model (Academic)

TV = Year 10 CF × (1 + g) ÷ (d - g)

Where g = long-term growth rate (typically 2-3%) and d = discount rate. Less common in CRE practice but useful for sensitivity analysis on perpetual hold scenarios.

Choosing the Discount Rate

The discount rate (also called required return or hurdle rate) is your biggest assumption. A 1% error in discount rate can swing valuation by 10-15%.

WACC Approach

WACC (Weighted Average Cost of Capital) blends debt and equity costs:

WACC = (E/V × Re) + (D/V × Rd × (1-Tc))

Where E = equity value, D = debt value, Re = equity return, Rd = debt rate, Tc = tax rate.

Build-Up Approach (Practical)

Start with a risk-free rate and add premiums:

Risk-free rate: 4-5% (10-yr Treasury)
Real estate premium: 2-3% (illiquidity, management intensity)
Asset class premium: 0-2% (office +100bps vs. industrial)
Location premium: 0-1% (secondary markets +50bps)
Leverage premium: 1-3% (more debt = higher return target)

Total: typically 8-15% for institutional CRE investments.

Sensitivity Analysis

Sensitivity analysis answers: "What if I'm wrong?" It tests how changes in key assumptions impact IRR, NPV, and equity multiple. Institutional investors mandate sensitivity tables before any investment decision.

Critical Sensitivity Variables

Exit cap rate: Most sensitive variable. Test ±0.5%, ±1.0%
Rent growth: Varies by market cycle. Test 0%, 1%, 2%, 3%
Vacancy rate: Asset class dependent. Test actual ±2-3 percentage points
Exit year: 8-year vs. 10-year vs. 12-year hold scenarios
Discount rate: Test ±1% around base case
CapEx assumptions: Test high-spend and low-spend scenarios

Sensitivity tables (showing IRR across 2-3 variables) are standard. A typical "Two-Way Table" shows IRR varying by exit cap rate (columns) and rent growth (rows), making it easy to spot which assumptions pose the biggest risk or opportunity.

Key Metrics from a DCF

A DCF outputs multiple metrics. Each tells a different part of the investment story.

Levered IRR (Equity IRR)

The annual return to equity investors after debt service. Typical target: 15-20% for core CRE, 20%+ for value-add, 25%+ for opportunistic.

Unlevered IRR (Asset IRR)

Return without debt service. Useful for comparing properties on equal footing regardless of leverage. Typically 7-12% for stabilized assets.

NPV (Net Present Value)

Sum of all discounted cash flows minus initial investment. Positive NPV = deal creates value. Used by institutional investors for portfolio optimization.

Equity Multiple

Total equity proceeds ÷ initial equity invested. A 2.0x multiple means you get $2 back for every $1 invested. Typical targets: 1.5-2.0x for core, 2.0-3.0x for value-add.

Cash-on-Cash Return

Year 1 cash flow ÷ initial equity. Shows immediate cash return. Less relevant for long-hold value-add deals but important for stabilized yield plays.

DCF Software Options

You have four main paths: AI-powered automation, enterprise platforms, nimble SaaS, or building your own in Excel. Each has tradeoffs in speed, cost, and flexibility.

CRELYTIC Engine

$6.99–$20/mo

AI-Automated DCF from Document Upload

Upload a rent roll, lease abstract, operating statement, or OM—CRELYTIC's AI extracts assumptions and auto-generates a complete DCF in seconds. No manual data entry. Includes:

AI-extracted assumptions from PDFs and Excel files
10-year cash flow projection with market-based defaults
Terminal value (exit cap rate method)
Levered & unlevered IRR, equity multiple, NPV
Two-way sensitivity tables (exit cap rate vs. rent growth)
Downloadable Excel model for further customization

Best for: Rapid underwriting, due diligence, comparison shopping across multiple deals.

Try CRELYTIC Engine

ARGUS Enterprise

$10K+/year

Industry Standard for Institutional Investors

ARGUS is the legacy platform used by most large REITs, pension funds, and institutional managers. Powerful but steep learning curve. Includes acquisition, refinance, and disposition modules.

Best for: Large firms with standardized processes, regulatory reporting, complex leverage structures.

PropertyMetrics

$99/month

Cloud-Based Commercial Underwriting

Browser-based platform with property database integration. Good balance of ease-of-use and depth. Includes pro forma, 1031 exchange analysis, and market comps.

Best for: Mid-market firms and individual investors seeking simplicity with flexibility.

Excel Models (DIY)

Free

Build It Yourself

Custom Excel/Google Sheets models offer complete control but require financial modeling expertise. Error risk is high (circular references, formula bugs, assumption inconsistencies).

Best for: Expert modelers with specific requirements or firms with in-house development bandwidth.

Ready to Build Your First DCF?

Stop wrestling with spreadsheets. CRELYTIC Engine automates DCF modeling in seconds. Upload your property documents, let AI extract assumptions, and download a professional Excel model—complete with sensitivity analysis and risk metrics.

Start Your Free DCF

Key Takeaways

DCF is the institutional gold standard for CRE valuation because it captures leverage, growth, and risk in one coherent model.

Terminal value drives 60-80% of value—exit cap rate assumptions matter enormously. Always stress-test this assumption.

Sensitivity analysis reveals risk. A complete DCF always includes two-way tables testing your most uncertain assumptions.

Software matters. AI automation (CRELYTIC), enterprise platforms (ARGUS), and lightweight SaaS (PropertyMetrics) serve different needs and budgets.