Real Estate Cash Flow Forecasting Model in Excel (Free Download)

A real estate cash flow model forecasts the cash a property business frees up after tax, CAPEX and debt service — from NOPAT down to levered free cash flow. Download it as a linked Excel forecast, free for 3 years, with peak funding need calculated automatically.

⚡ Build my Real Estate Free Cashflow — free (requires JavaScript)

Key drivers pre-loaded for Real Estate

What you get

An automated, fully formula-linked Excel workbook with the full bridge from NOPAT to unlevered free cash flow (D&A, CAPEX and working-capital movements) and on to levered FCF after debt service, plus cumulative cash, runway and a peak-funding-need figure. Corporate tax is applied with loss carryforward, and every figure traces back to a visible assumption. Free for a 3-year forecast; 5–25 years is $19.98 per model download, no subscription.

The real-estate FCF bridge, line by line

Free cash flow strips a property business down to the cash it actually frees up. The bridge runs: NOPAT (operating profit after tax), plus depreciation because it is a non-cash charge, minus CAPEX, minus any increase in working capital — that is unlevered free cash flow. Subtract interest and principal repayments and you have levered free cash flow, the cash that belongs to equity. Every line of that bridge behaves differently in real estate than in a trading business, which is why a generic FCF template misleads here.

From NOPAT to unlevered free cash flow

Property depreciation is large relative to profit, so the add-back matters: a building depreciating over decades can show modest accounting profit while producing solid cash. Working capital, by contrast, is small — there is no inventory cycle to fund — but tenant deposits and prepaid rent can make it a source of cash rather than a drain. The dominant line is CAPEX, and in a development it dwarfs everything else for the first two years.

From unlevered to levered: debt service

The levered line subtracts interest and principal on the property debt. For an amortising investment loan this is a steady monthly outflow that NOI must cover — the DSCR test below. For a development facility it is mostly accrued interest that capitalises into the balance until sales repay the loan, which is why levered FCF in a development looks nothing like the smooth line a stabilised asset produces.

Why the curve goes negative before it goes right

Months 1–24 of a build are almost all outflow: land completion, construction draws, professional fees, accruing interest. Revenue starts at delivery. So cumulative levered cash falls steadily, bottoms out near practical completion, and only then climbs as units settle or the rent roll stabilises. That trough is not a modelling error — it is the single most important number in the forecast.

Worked example: a 24-month build, month by month

Peak funding need: the number lenders ask for first

The curve peaks at roughly $2.9M in month 14 — more than the $2.0M of equity in the deal, with the difference bridged by the debt facility's drawdown schedule. This is the figure a credit committee reads before anything else, because a project that runs out of committed funding at month 14 does not get to month 24. The model computes it automatically and shows it on the dashboard; stress it by delaying the absorption assumption a quarter and watching the trough deepen.

The stabilised phase: cash flow after delivery

Once the build is done and the units are let, the forecast changes character completely. Revenue becomes a rent roll — units × rent, trimmed by a vacancy allowance of a few percent and grown by annual escalation. Operating costs settle into a predictable ratio of income, CAPEX drops to a maintenance reserve, and NOI emerges as the steady line a cap rate can be applied to. Levered free cash flow in this phase is simply NOI minus debt service, and dividing the annual figure by the equity still in the deal gives the cash-on-cash return — typically mid-to-high single digits for a stabilised asset. Tracked over the whole hold, cumulative levered FCF plus the exit proceeds is what produces the equity multiple investors quote. The model runs this phase for up to 25 years with escalation compounding year on year, which is exactly where flat-rate spreadsheets drift furthest from reality.

DSCR: what lenders actually check

Once a property stabilises, the lender's test switches from loan-to-cost to the debt service coverage ratio: NOI divided by annual debt service. Market practice for senior lending sits around 1.20–1.25x — a $1.0M debt service needs roughly $1.2M–$1.25M of NOI behind it. Bank underwriting standards for commercial real estate move with the cycle, and the shifts are tracked publicly in the Federal Reserve's Senior Loan Officer Opinion Survey, which is worth checking before assuming last year's terms still hold.

Reference: the Federal Reserve Senior Loan Officer Opinion Survey reports quarterly changes in CRE lending standards.

How to download the cash flow model (3 steps)

1. Open the Free Cash Flow tool and pick the Real Estate template — CAPEX, debt and revenue defaults load at development scale.
2. Set your build cost, debt terms, absorption and rent assumptions; choose monthly, quarterly or annual periods.
3. Preview the FCF bridge and download the linked Excel workbook — free up to 3 years, just your email.

For the full pro forma with DCF and IRR, use the real estate financial model. To set the timing drivers from your own ledger, read working capital days and cash forecasting methods.

Frequently asked questions

How does free cash flow behave in a Real Estate business?

For a Real Estate model, land and construction CAPEX front-loads cash out; levered free cash flow only turns positive as sales complete or rent stabilises. The workbook derives unlevered free cash flow line by line (NOPAT + D&A − CAPEX − the increase in working capital) and bridges to levered FCF via the debt schedule, so you can read conversion and runway straight off the linked statements.

How many years should a Real Estate free cash flow forecast cover?

Typically 5–10 years for development, 10–25 for income assets. Three to five years suits operating and fundraising decisions; asset-heavy cases run longer. The free tier covers 3 years; premium extends to 25.

Is the Real Estate free cash flow model free?

Yes — a 3-year Real Estate free cash flow forecast downloads free with no sign-up. Free for a 3-year forecast; 5–25 years is $19.98 per model download, no subscription.

Why is free cash flow negative during construction?

Because CAPEX is front-loaded and income has not started. Land and build costs go out over months 1–24 while sales or rent arrive later, so levered free cash flow runs negative until delivery. The lowest point of the cumulative curve is the peak funding need — the equity plus debt the project must have committed before it starts.

What DSCR do real estate lenders require?

For stabilised income property, senior lenders commonly require a debt service coverage ratio of about 1.20–1.25x — NOI must exceed debt service by 20–25%. Development facilities are sized on loan-to-cost and exit value instead, because there is no income to cover service during the build.

Real Estate across our four models

Real Estate Financial Model · Real Estate Cashflow Forecasting Model · Real Estate DCF Valuation Model

Other industries — Free Cashflow

SaaS · Data Center · Manufacturing · Hotel · E-commerce · Healthcare · Fintech · Energy · Early-Stage Startup · Restaurant · Professional Services · Logistics · Education · Construction · Media · Telecom · Agriculture · Pharma · Fitness · Nonprofit · All free cashflow models