Syndication
The Real Estate Pro Forma: How Sponsors Build a Projection That Holds Up
A real estate pro forma is the forward-looking financial model for a deal: a year-by-year projection of income, expenses, net operating income, debt service, cash flow, and the eventual sale. It's the document that turns a property into an investment thesis — the place where a sponsor's business plan becomes numbers an investor can examine. When an LP says they're "reviewing the deal," they mean they're stress-testing your pro forma.
By One Million Media4 min read
This guide is for sponsors and GPs who need to build a pro forma that survives a sophisticated investor's scrutiny. A pro forma is a set of assumptions wearing a spreadsheet's authority, and experienced LPs know it. The credible sponsor doesn't present the most optimistic model that produces a great IRR — they present the most defensible one and show what happens when their assumptions are wrong.
What a pro forma actually is
A pro forma is a projection, not a record. It differs from a property's historical operating statement (the trailing-12, or T-12) in that it forecasts what the asset will do under your ownership and business plan — your projected rents, your expense structure, your renovation timeline, your exit. The most important discipline in building one is keeping the line between fact and forecast visible: in-place numbers come from the T-12 and rent roll; everything forward is an assumption you must justify.
The trust test
Every number in a pro forma is either a fact (from the rent roll, T-12, lender term sheet) or an assumption (rent growth, exit cap, renovation cost). Investors trust sponsors who clearly label which is which. They distrust polished models where aggressive assumptions are buried as if they were facts.
The line items a pro forma must include
A complete pro forma flows from gross revenue all the way to investor-level returns. Skipping lines — or hiding them — is how thin deals get dressed up:
| Section | Key lines |
|---|---|
| Revenue | Gross potential rent, loss-to-lease, vacancy, concessions, other income |
| Operating expenses | Taxes (reassessed), insurance, utilities, payroll, R&M, management, marketing, G&A |
| NOI | Effective gross income minus operating expenses, by year |
| Capital | Renovation budget, replacement reserves, leasing costs |
| Debt | Loan amount, rate, amortization, interest-only period, debt service |
| Cash flow | NOI minus debt service minus capital, then the distribution split |
| Exit | Stabilized NOI, exit cap rate, sale price, selling costs, loan payoff |
| Returns | Cash-on-cash by year, IRR, equity multiple — at the LP level |
Note the last row: returns must be shown at the LP level, after your fees and promote, not at the property level. A property-level IRR that doesn't subtract the sponsor's economics overstates what investors actually receive. The honest pro forma shows the deal as the investor experiences it.
The assumptions investors stress-test
Sophisticated LPs don't read a pro forma top to bottom — they go straight to the handful of assumptions that drive the outcome and push on them. Be ready to defend each:
- Rent growth: a model assuming 5%+ annual rent growth for five years is betting on a boom. Conservative underwriting uses modest, defensible growth and proves year-one rents with comps.
- Exit cap rate: assuming you sell at a lower cap than you bought (compression) flatters returns and shifts risk onto the market. Prudent models expand the exit cap above the entry cap.
- Renovation cost and timeline: under-budgeting capex or assuming an unrealistically fast turn schedule inflates early cash flow and the whole return.
- Vacancy and bad debt: a too-low economic vacancy assumption quietly lifts NOI across every year.
- Expense growth and taxes: forgetting the post-sale tax reassessment is one of the most common — and most damaging — errors.
How to present a pro forma that earns trust
The goal isn't the highest projected return — it's the most believable one. Operator habits that hold up under scrutiny:
- Show a base case, a downside case, and (optionally) an upside — never a single point estimate. A sponsor who only shows the upside reads as inexperienced.
- Include a sensitivity table: how IRR and the equity multiple move as the exit cap and rent growth change. This shows you understand your own risk.
- Reconcile to reality: tie year-one rents to signed comps, expenses to the T-12, and the loan to an actual term sheet.
- Disclose your fees and promote in the same model, so LP returns are net of your economics.
- State the obvious caveat plainly — projections are not guarantees, and the actual result depends on execution and the market.
A pro forma is a securities document in spirit even when it isn't one in form: the returns you project are part of how you solicit investment, and overstating them is both a trust problem and a compliance risk. The sponsors who raise repeat capital are the ones whose deals come in at or above a pro forma investors believed in the first place — not the ones whose models always looked the best.
Frequently asked questions
What is a real estate pro forma?
It's a forward-looking financial model for a property: a year-by-year projection of income, expenses, net operating income, debt service, cash flow, and the eventual sale, ending in investor-level returns. It turns a property into an investment thesis and is the core document investors examine when evaluating a deal.
What's the difference between a pro forma and a T-12?
A T-12 (trailing-12-month statement) is a record of how the property has actually operated. A pro forma is a projection of how it will operate under your ownership and business plan. Credible underwriting builds the pro forma from the T-12 and rent roll, clearly separating in-place facts from forward assumptions.
Which pro forma assumptions matter most?
Rent growth, the exit cap rate, renovation cost and timeline, vacancy/bad debt, and expense growth — especially the post-sale property tax reassessment. These few inputs drive most of the projected return, which is why sophisticated investors stress-test them first and why sponsors should be ready to defend each.
Should pro forma returns be shown before or after sponsor fees?
After. Returns should be presented at the LP level, net of the sponsor's fees and promote, so investors see what they actually receive. A property-level IRR that ignores the sponsor's economics overstates the investor's return.
How do I make a pro forma more credible?
Show a base and downside case rather than a single estimate, include a sensitivity table for the exit cap and rent growth, tie inputs to signed comps and the actual loan term sheet, disclose your fees in the model, and state plainly that projections are not guarantees. Believability, not the highest IRR, is what raises capital.
Keep reading
This article is for educational purposes only and is not legal, investment, tax, or securities advice. Securities offerings are regulated; always work with your securities attorney to structure and run your offering. One Million Media is a marketing and lead-generation provider — not a broker-dealer, investment adviser, or law firm.
