How to Build a Real Estate Pro Forma From Scratch (Step by Step)

How to Build a Real Estate Pro Forma From Scratch (Step by Step)

A real estate pro forma is a forward-looking financial model of a property: what it will earn, what it will cost to operate and finance, and what an investor will take home over the life of the deal. Every serious acquisition decision — and every conversation with a lender or equity partner — runs through one.

This is a complete pro forma tutorial: we build the model step by step, from the rent roll to the 10-year cash flow to the return metrics, using one illustrative deal carried through every section. By the end you will understand every line of an institutional pro forma and how the lines connect. If you would rather start from a working file than a blank workbook, download our free starter pro forma and follow along inside it.

Two framing points before we start. First, a pro forma is a projection, not a prediction — its job is to make your assumptions explicit and testable, not to guarantee an outcome. Second, the structure below is the standard architecture used across commercial real estate, from a duplex to a 300-unit acquisition. The line items scale; the logic does not change.

The Anatomy of a Pro Forma

Every income-property pro forma, regardless of asset class, is built from the same six blocks, in the same order:

1. Revenue — what the property can collect
2. Operating expenses — what it costs to run, producing NOI
3. Capital costs — reserves and improvements below the NOI line
4. Debt — the loan and its annual service
5. The multi-year projection — assumptions applied over the hold period, ending in a sale
6. Returns — IRR, equity multiple, and cash-on-cash computed from the cash flows

Each block feeds the next. An error upstream — an inflated rent assumption, an omitted expense — flows through every number downstream, which is why the order matters and why we build top to bottom.

Our worked example (illustrative only): a 24-unit apartment building purchased for $2,887,500, with average in-place rents of $1,100 per unit per month. Every figure in this deal is hypothetical, chosen for arithmetic clarity — not market data.

Step 1: Gather the Source Documents

A pro forma is only as good as its inputs, and the inputs come from three documents you should obtain before modeling anything:

• The rent roll — every unit or tenant, its current rent, and its lease status. This is the ground truth for revenue.
• The trailing 12-month operating statement (the "T-12") — actual income and expenses for the last twelve months. This is the ground truth for expenses, and the honest starting point for your projections.
• A financing quote or term sheet — rate, amortization, loan-to-value, and any lender coverage requirements.

Institutional underwriters build a bridge from the T-12 to the pro forma: they start from what the property actually did and adjust line by line to what it will do under new ownership. Skipping the T-12 and inventing operating numbers from scratch is the single most common source of fantasy pro formas.

Step 2: Build the Revenue Stack

Revenue is built as a stack of adjustments, not a single number:

Gross Potential Rent (GPR). Every unit at its scheduled rent, fully occupied, for twelve months. Our 24 units at $1,100/month produce a GPR of $316,800.

Less: vacancy and credit loss. No property runs at 100% forever. Apply a vacancy factor grounded in the property's history and your market knowledge — and resist the temptation to assume away vacancy because the building is full today. At 5%, our deal loses $15,840.

Plus: other income. Laundry, parking, pet fees, storage, utility reimbursements. Our example adds $14,040.

Equals: Effective Gross Income (EGI). The revenue the property will actually collect: $316,800 − $15,840 + $14,040 = $315,000.

In multifamily underwriting, this is also where you model loss to lease — the gap between in-place rents and market rents — because closing that gap is often the entire investment thesis. Our asset-class-specific walkthrough, how to build a multifamily pro forma from scratch, covers the in-place-versus-market mechanics in depth.

Step 3: Operating Expenses and NOI

Below EGI sit the operating expenses — the recurring costs of running the property: real estate taxes, insurance, repairs and maintenance, utilities, property management, payroll, administrative costs, and turnover expenses.

Three discipline rules keep this section honest:

Model line items, not a lump percentage. An expense ratio is a sanity check, not a build method. Enter each category from the T-12, then adjust the ones that change with ownership — taxes typically reset on sale in many jurisdictions, insurance gets re-quoted, and management should be modeled at a market rate even if you plan to self-manage (your time is not free, and your lender will underwrite it anyway).

Include management, always. Omitting the management fee is the classic way sellers inflate NOI in marketing materials.

Check per-unit and percentage benchmarks. Expenses per unit and expenses as a share of EGI are the two cross-checks that catch entry errors and unrealistic assumptions.

Our example carries $141,750 of operating expenses — 45% of EGI, a mid-range expense ratio for illustration.

Net Operating Income (NOI) is EGI minus operating expenses: $315,000 − $141,750 = $173,250. NOI is the most important number in the model. It is the basis of the property's valuation (via the cap rate), the numerator of the lender's coverage test, and the engine of every return downstream. At our $2,887,500 purchase price, the deal's going-in cap rate is $173,250 ÷ $2,887,500 = 6.0%.

Note what NOI excludes: debt service, income taxes, depreciation, and capital expenditures. NOI describes the property; everything below it describes the deal.

Step 4: Capital Costs Below the Line

Between NOI and cash flow sit the capital items:

Replacement reserves. An annual set-aside for roofs, HVAC, and other components that wear out on multi-year cycles. Lenders frequently require a per-unit reserve; model one whether required or not.

Capital improvements. If your plan includes renovations — new kitchens to push rents, deferred maintenance to cure — those budgets belong here, in the years you will spend them, alongside the rent premiums they are supposed to produce.

Keeping capital costs below NOI (rather than buried in operating expenses) preserves comparability: your NOI stays consistent with how appraisers, lenders, and buyers define it.

Step 5: Model the Debt

Most real estate is bought with leverage, and the loan reshapes every equity return in the model.

Size the loan. Lenders constrain proceeds two ways: loan-to-value (LTV), a cap as a percentage of the purchase price or appraised value, and the debt service coverage ratio (DSCR), a requirement that NOI exceed annual debt service by a margin — commonly expressed as a minimum like 1.20x or 1.25x. The loan you actually get is sized to the lesser of the two constraints. Our primer on the debt service coverage ratio explained unpacks how lenders apply the test.

Compute annual debt service. From the loan amount, interest rate, and amortization period, calculate the annual payment (Excel's PMT function does this directly).

Our example: at 65% LTV, the loan is $1,876,875. At an illustrative 6.5% rate with 30-year amortization, annual debt service is approximately $142,360. Coverage check: $173,250 ÷ $142,360 = a DSCR of roughly 1.22x — above a typical 1.20x floor, so LTV, not DSCR, is the binding constraint on this deal.

Cash flow after debt service in year one: $173,250 − $142,360 = $30,890 (before reserves). With roughly $1,068,000 of equity in the deal (down payment plus illustrative closing costs), that is a year-one cash-on-cash return near 2.9% — thin, which is exactly the kind of finding a pro forma exists to surface before you wire a deposit. A deal like this only works if the growth story in the next step is real.

Step 6: Project the 10-Year Cash Flow

A single stabilized year tells you what the property is; the multi-year projection tells you what the investment does. The 10-year discounted cash flow is the institutional standard — long enough to capture a full business plan and a refinance-or-sell decision, standardized enough that every counterparty can read it.

Extend the model across ten annual columns by applying growth assumptions:

• Revenue growth — annual rent escalation, applied to the rent lines (not to other income automatically; model it separately).
• Expense growth — expenses rarely grow at the same rate as rents; model them independently. A pro forma where margins silently expand forever because revenue growth outruns expense growth is a red flag.
• Vacancy — hold it steady, or model a lease-up path if the business plan changes occupancy.

Each projection year runs the same waterfall: GPR → vacancy → other income → EGI → operating expenses → NOI → reserves and capital items → debt service → levered cash flow. Consistency across columns is the entire game in Excel: build year one correctly, reference every assumption from a dedicated inputs section, and copy the column across. Hardcoded numbers inside formulas are how models rot.

Step 7: Model the Exit

The hold period ends with a sale — the reversion — and in most deals the reversion is the largest single cash flow in the model.

Terminal value is computed by capitalizing the following year's NOI at an assumed exit cap rate: sale price = forward NOI ÷ exit cap. Two conventions matter:

Use forward NOI. The buyer in year ten is paying for year-eleven income, so the model must project one year beyond the hold.

Be conservative on the exit cap. A common discipline is to assume the exit cap rate is somewhat higher than the going-in cap — expanding it by some margin over the hold — so that the return does not depend on selling at a richer valuation than you paid. A pro forma whose returns require exit-cap compression is making a market-timing bet and should say so out loud.

From the gross sale price, subtract selling costs and the remaining loan balance; the residue is the net reversion to equity, added to the final year's cash flow.

Step 8: Compute the Returns

With ten years of levered cash flows and the reversion in place, the return metrics fall out directly:

IRR (internal rate of return) — the annualized, time-weighted return implied by the full cash flow series, from the initial equity outflow through the final sale proceeds. Compute both unlevered IRR (property cash flows, no debt) and levered IRR (equity cash flows after debt) — the spread between them shows what leverage is contributing, and what it is risking.

Equity multiple — total cash returned divided by total cash invested. The IRR's essential companion: IRR measures speed, the multiple measures magnitude, and a deal can look brilliant on one and mediocre on the other.

Cash-on-cash return — each year's cash flow divided by invested equity. This is the "what does it pay me while I own it" metric, and the one that exposed our example's thin year one.

No single metric is sufficient. Institutional buyers read all three together, plus the DSCR, before forming a view.

Step 9: Stress-Test with Sensitivity Analysis

A pro forma built on single-point assumptions answers only one question: what happens if you are exactly right. The final step is to ask what happens when you are wrong.

The standard tool is a two-variable sensitivity grid — commonly a 5×5 matrix — showing levered IRR across a range of the two assumptions the return is most exposed to. For acquisitions, that is usually the going-in price (entry cap) against the exit cap rate, or rent growth against the exit cap. Excel's Data Table feature generates the grid natively.

Read the grid for two things: how fast the return degrades as assumptions soften, and where the deal breaks even. If the IRR only clears your hurdle in the most optimistic corner of the matrix, the pro forma has done its job — by telling you no.

How the Structure Varies by Asset Class

The six-block architecture is universal, but the revenue block changes shape with the asset:

Multifamily builds revenue from a unit-mix rent roll — many small, similar leases — which is why vacancy behaves like a smooth percentage and why loss to lease is the value-add lever.

Commercial (office, retail, industrial) builds revenue lease by lease: a handful of large tenants with distinct terms, expiry dates, and expense-recovery structures (NNN versus gross). The pro forma gains a rollover module — tenant improvements, leasing commissions, and downtime when leases expire — because a single tenant's departure can move NOI more than a year of rent growth.

Short-term rentals and hotels replace annual leases entirely with a nightly-rate model: average daily rate × occupancy, usually with monthly seasonality.

Development front-loads the model with a construction budget and draw schedule before stabilized operations begin.

Same skeleton, different revenue engines. Learn the structure once and every asset class becomes a variation.

Common Pro Forma Mistakes

The errors that recur across beginner models, in rough order of damage:

1. Ignoring the T-12. Projecting expenses from rules of thumb instead of the property's actual history.
2. No management fee. Self-managing does not make management free.
3. Zero vacancy. Full today is not full for ten years.
4. Exit-cap optimism. Assuming you will sell at a lower cap rate than you bought.
5. Symmetric growth. Letting revenue and expenses grow at one rate, silently expanding margins forever.
6. Hardcoded assumptions. Numbers typed inside formulas instead of referenced from an inputs section — untraceable and unauditable.
7. No capital reserves. Pretending roofs last forever.
8. A single scenario. No sensitivity analysis, so no idea where the deal breaks.

If you are evaluating a pre-built template rather than building your own, these same eight points double as a quality checklist — our guide to what a serious real estate pro forma Excel template includes applies them to the buy-versus-build decision.

Frequently Asked Questions

What is a real estate pro forma, in one sentence? A forward-looking financial model projecting a property's income, expenses, financing, and sale over a hold period, used to estimate the returns to an investor.

How many years should a pro forma project? Ten years is the institutional standard for acquisitions: long enough to capture a full business plan and exit, and the convention lenders and equity partners expect. Shorter horizons are fine for quick screens; the full model should run ten.

What is the difference between a pro forma and an appraisal? An appraisal is a third party's opinion of current value. A pro forma is your projection of future performance. The appraisal prices the property; the pro forma prices the deal.

Can I build a pro forma in Excel without special software? Yes — Excel is the native environment for real estate modeling, and everything in this guide is buildable with standard formulas (PMT, NPV/IRR, Data Tables). The build-versus-buy question is about time and error risk, not capability.

What is a good IRR for a real estate deal? It depends on risk, leverage, asset class, and strategy — a stabilized core deal and a ground-up development should not be judged against the same hurdle. The honest answer is that the pro forma's job is to compute the IRR accurately and stress it; setting the hurdle is an investment decision, not a modeling one.

From Blank Workbook to Working Model

Everything above is buildable from scratch, and building it once is one of the best educations in real estate finance available. Two ways to shortcut the process:

Start free. The YieldSheets starter pro forma is a working single-property model with the full revenue-to-returns chain already wired — download it, drop in your deal, and study how the formulas connect.

Go institutional. The Multifamily Sheet is the full version of the architecture in this guide: unit-by-unit rent roll with in-place versus market rents, a T-12-to-pro-forma NOI bridge, debt sized to the lesser of LTV and DSCR, the 10-year cash flow with reversion, levered and unlevered IRR, a GP/LP waterfall, and the entry-cap × exit-cap sensitivity matrix — fully unlocked, every formula visible, with a documented methodology PDF. The full catalog of models across asset classes is in the store.

This article is for educational purposes only and does not constitute investment, legal, or tax advice. All deal figures are illustrative examples, not market data. Consult qualified professionals before making investment decisions.