Financial Modeling
Cash Flow Modeling
How institutional CRE cash flows are built from the rent roll up through NOI, below-the-line costs, and levered returns. Five practitioner guides covering the assumptions, benchmarks, and sensitivity tests that separate defensible projections from guesswork.
A real estate cash flow model is only as good as the assumptions underneath it. Revenue projections start with the rent roll and layer on growth, vacancy, credit loss, and concessions. Expense projections require property tax trajectories, insurance markets, utility structures, and management fee scaling. The NOI that emerges is the headline number, but institutional underwriting does not stop there: tenant improvements, leasing commissions, capital expenditures, and replacement reserves sit below the NOI line and routinely compress levered IRR by 200-400 basis points relative to an unlevered NOI yield.
These five articles walk the operating cash flow stack from top to bottom. Start with the operating cash flow projection guide if you are building assumption literacy. Start with lease-by-lease modeling if you are underwriting a multi-tenant acquisition. Each piece includes worked examples, asset-class benchmarks, and the sensitivity tests that investment committees expect to see.
5 articles
-
Operating Cash Flow Projection: Drivers and Assumptions
A structured guide to every revenue and expense driver in an operating cash flow model: rent growth, vacancy, credit loss, concessions, operating expenses, and the NOI bridge. Includes benchmark ranges by asset class and a sensitivity cascade showing how one assumption change compounds over a 10-year hold.
Read article → -
Below-the-Line Items: TI, LC, CapEx, and Reserves
Everything below the NOI line in a single framework: tenant improvement allowances, leasing commissions, capital expenditures, and replacement reserves. How each cost is modeled, how treatment varies by asset class, and how below-the-line assumptions drive the spread between NOI and levered cash flow.
Read article → -
Lease-by-Lease Modeling: Tenant Rollover and Renewal
How to build a lease-by-lease cash flow model that handles individual tenant expirations, renewal probability, downtime, mark-to-market rent adjustments, and TI/LC differentials. Includes a five-tenant worked example and a comparison showing where aggregate vacancy models mislead.
Read article → -
Absorption and Lease-Up: Development and Repositioning Cash Flow Modeling
How to forecast the lease-up trajectory from construction completion to stabilized occupancy: monthly absorption schedules, concession burn-off, operating expense ramp, and the construction-to-permanent loan conversion. Covers both ground-up development and repositioning plays.
Read article → -
Hold Period Analysis: IRR vs Equity Multiple Trade-Offs
How IRR and equity multiple diverge as the hold period lengthens. A single-deal model across 3, 5, 7, and 10-year hold scenarios reveals the crossover dynamics, then layers in exit cap rate sensitivity and leverage effects to show how the optimal hold period shifts.
Read article →