CRE glossary
Pro Forma
A real estate pro forma is a projected, multi-year financial statement that forecasts a property's income, operating expenses, net operating income (NOI), debt service, and equity returns over the holding period. It is the analytical backbone of underwriting — a forward-looking model of how a deal is expected to perform, not a record of what has already occurred.
Formula
Net Operating Income (NOI) = Effective Gross Income − Operating Expenses; where Effective Gross Income = Gross Potential Rent − Vacancy/Credit Loss + Other Income. Levered Cash Flow = NOI − Debt Service − Capital Expenditures.
What a pro forma includes and how it is used
A pro forma stacks a property's economics into a single forward-looking model, typically projected annually across a 5-to-10-year hold. Analysts use it to test whether a purchase price, financing structure, and business plan produce returns that clear the fund's or sponsor's hurdles before capital is committed. It is the document an investment committee scrutinizes and the framework against which actual performance is later measured. A complete pro forma flows top-to-bottom in a consistent order, each line feeding the next:
- •Gross Potential Rent (GPR) — total rent if every unit or suite were leased at market
- •Less vacancy, credit loss, and concessions; plus other income (parking, laundry, reimbursements) → Effective Gross Income (EGI)
- •Less operating expenses (taxes, insurance, management, repairs, utilities, reserves) → Net Operating Income (NOI)
- •Less capital expenditures and tenant improvements/leasing commissions
- •Less debt service (interest + amortization) → levered cash flow to equity
- •Plus the reversion — projected sale proceeds at exit, based on a terminal cap rate applied to forward NOI, net of selling costs and loan payoff
- •Returns: IRR, equity multiple, cash-on-cash, and the GP/LP split after the equity waterfall
Why it matters and where it goes wrong
The pro forma is where a deal is won or lost on paper — every acquisition decision, loan sizing, and IC vote traces back to its assumptions. Because it is a projection, its output is only as credible as the inputs behind each line. The most common failure mode is the 'hopeful' pro forma: rent growth, exit cap rate compression, and expense ratios all tuned to make the return clear the hurdle. Guard against these recurring pitfalls:
- •Aggressive rent growth — assuming 4-5% annual bumps when the submarket historically supports 2-3%
- •Cap rate compression at exit — underwriting a lower terminal cap than the going-in cap, which manufactures value that may not materialize
- •Understated expenses — using in-place operating costs while ignoring reassessed property taxes after a sale, or omitting replacement reserves
- •Thin vacancy assumptions — modeling stabilized vacancy from day one rather than accounting for lease-up or rollover
- •No stress testing — a single base case with no sensitivity on rent, cap rate, or interest rate leaves the downside invisible. Always pair the pro forma with two-variable sensitivity analysis.
Worked example
Consider a 100-unit multifamily property. Gross Potential Rent is 100 units × $1,500/month × 12 = $1,800,000. Subtract 5% vacancy and credit loss ($90,000) and add $60,000 of other income for Effective Gross Income of $1,770,000. Operating expenses run 40% of EGI, or $708,000, leaving Year 1 NOI of $1,062,000. At a $20,000,000 purchase price, that is a 5.3% going-in cap rate. With a $13,000,000 loan at 6.5% interest-only, annual debt service is $845,000, so levered cash flow is $217,000 — a 3.1% cash-on-cash return on the $7,000,000 of equity. The pro forma then grows NOI ~3% per year and models an exit in Year 5 at a 5.5% terminal cap rate to project the IRR and equity multiple.
Frequently asked questions
- What is the difference between a pro forma and an actual (T-12)?
- A pro forma is forward-looking and projected — it forecasts what a property should earn under a business plan. A T-12 (trailing twelve months) is backward-looking and actual — it reports what the property genuinely collected and spent over the past year. Analysts underwrite by starting from the T-12 actuals and adjusting to a pro forma, then track variance between the two after closing.
- What makes a pro forma credible versus 'pro forma-ing' a deal?
- A credible pro forma ties every assumption to a source: in-place rents from the rent roll, expenses from the T-12, rent growth from third-party market data, and an exit cap rate at or above the going-in cap. 'Pro forma-ing' a deal — a pejorative in the industry — means inflating rent growth and compressing the exit cap until the returns clear the hurdle. The test is whether each number has a defensible basis.
- How many years should a pro forma project?
- Most CRE pro formas project 5 to 10 years, matching the typical hold period and loan term. Five years is standard for value-add multifamily; 10 years is common for stabilized office or industrial with long leases. The projection must run at least one year past any major lease rollover or refinance event so those cash flows are captured before the exit.
Keep exploring