What Is a Pro Forma in Real Estate?
A pro forma in commercial real estate is a projected income and expense statement for a property, built on a specific set of assumptions about rent, vacancy, expenses, and financing. It answers one question: if this property performs the way you expect it to, what will it actually make? Every serious decision in this business runs through some version of that projection first, whether you’re buying, selling, refinancing, or breaking ground on new construction.
The term comes from Latin, roughly “as a matter of form.” In finance it means a forward-looking projection built on stated assumptions, as opposed to a report of what already happened. That distinction matters more in real estate than in most other asset classes, because the gap between a pro forma and a property’s actual trailing performance is where a lot of deals quietly go wrong.
What a Pro Forma Actually Shows
Strip away the spreadsheet and a pro forma is doing one job: converting a property’s operations into a single number, Net Operating Income (NOI), and showing the assumptions that produced it. From there, NOI feeds directly into the numbers everyone in a deal actually cares about: the loan a lender will underwrite, the price a buyer can justify paying, and the return an investor can expect to earn.
A pro forma covers a defined period, almost always one year for straightforward underwriting, though acquisition models often extend it five to ten years to project a future sale. It lists every dollar the property is expected to collect, subtracts every dollar it’s expected to cost to operate, and stops before debt service, capital expenditures, and income tax, since those depend on financing and ownership structure rather than on the property itself.
Why It Matters
Four different people look at the same pro forma and use it for four different purposes:
- Lenders size the loan off it. Most commercial loans are underwritten to a minimum debt service coverage ratio, so the pro forma’s NOI, not the purchase price, sets the real ceiling on how much debt the property can carry.
- Buyers use it to work backward into a maximum purchase price. If comparable properties are trading at a given cap rate, dividing the pro forma NOI by that cap rate gives a defensible offer.
- Appraisers use it as the core input for the income approach to value, one of the three standard valuation methods alongside sales comparison and cost approach.
- Sellers and brokers use it to market the deal, and this is where the document earns its reputation problem. A pro forma is only as honest as the assumptions behind it, and a seller has every incentive to lean optimistic.
That last point is worth sitting with before you build or read your first one.
Types of Pro Formas You’ll Run Into
The same basic structure gets used for a few different jobs, and it’s worth knowing which one you’re looking at, because the assumptions behind each are built differently.
- Acquisition pro forma. Built when underwriting a purchase. Usually a stabilized one-year projection adjusted from the seller’s actual T-12, sometimes extended to a five- or ten-year hold with a projected sale in the final year. Cap rate, DSCR, and cash-on-cash are the headline numbers for year one; IRR becomes the headline number once you’re modeling a full hold period.
- Development pro forma. Built for ground-up construction, so it starts from zero rather than from a T-12. It includes land cost, hard costs (the actual construction), soft costs (architecture, engineering, permitting, financing costs, developer fee), and a lease-up period during which occupancy runs below stabilized levels. The key return metric is yield on cost, stabilized NOI divided by total development cost, compared against the market cap rate for a similar finished asset. The gap between the two is the developer’s reward for taking construction and lease-up risk.
- Refinance pro forma. Built around current in-place performance rather than projected market rent, because the lender is sizing a loan against what the property actually supports today, not what it might support after a renovation program that hasn’t happened yet.
- Multi-year hold pro forma. Extends the single-year model across a projected hold period, applying rent growth and expense growth assumptions year over year, and ending with a reversion, or sale, calculated as exit-year NOI divided by an assumed exit cap rate, less an assumed cost of sale. This version drives levered and unlevered IRR, the metric most institutional buyers underwrite to first.
The Standard Line Items
Every pro forma, regardless of property type, builds toward NOI the same way. Naming conventions shift slightly by firm and market, but the structure below holds for multifamily, retail, office, and industrial alike.
| Line Item | What It Captures |
|---|---|
| Gross Potential Rent (GPR) | Total rent collected if every unit or suite were leased at full asking rent, 100% of the time, with zero turnover loss. |
| Other Income | Parking, storage, laundry, pet fees, application fees, and, for NNN retail and industrial, expense reimbursements from tenants. |
| Gross Potential Income (GPI) | GPR plus Other Income, before any vacancy adjustment. |
| Vacancy & Credit Loss | Income lost to unleased space and to tenants who don’t pay, usually expressed as a percentage of GPI. |
| Effective Gross Income (EGI) | GPI minus Vacancy & Credit Loss. What the property is realistically expected to collect. |
| Operating Expenses | Property taxes, insurance, utilities, repairs and maintenance, property management, and administrative costs, itemized individually below the EGI line. |
| Net Operating Income (NOI) | EGI minus total Operating Expenses. The single most important number in commercial real estate. |
| Debt Service | Principal and interest payments on the mortgage. Sits below NOI, not inside it. |
| Cash Flow Before Tax (CFBT) | NOI minus Debt Service. What actually lands in the owner’s account each year, before income tax. |
| Capital Expenditures | Major, non-recurring improvements: a new roof, a parking lot overlay, unit renovations. Tracked separately from operating expenses. |
One convention worth flagging: appraisal-standard NOI technically excludes a reserve for replacement, treating it as a below-the-line item similar to debt service. In practice, most lenders, and plenty of operators, net a modest reserve into operating expenses anyway, to keep the NOI figure conservative and to avoid a bad surprise the year the roof needs replacing. Neither approach is wrong. What matters is knowing which convention the pro forma in front of you is using, and not comparing two pro formas built on different conventions as if they were apples to apples.
Pro Forma vs. Actual Performance
A pro forma is a projection. A trailing twelve month statement, usually called a T-12, is a record of what the property actually collected and spent over the past year. The two should be close on a stabilized property. On a value-add deal, a distressed asset, or new construction, they can diverge sharply, and that gap is exactly the story the pro forma is telling.
The trouble starts when a seller’s pro forma isn’t telling that story honestly. Common moves worth watching for:
- Market rent instead of in-place rent. The pro forma shows what units could rent for today, not what current tenants are actually paying, with no clear path or timeline to close the gap.
- Vacancy set too low. A 3% vacancy assumption on a property that has run 8-10% actual vacancy for three years running.
- Expenses understated or missing entirely. No reserve line, a management fee below what a third-party manager would actually charge, or a repairs line that hasn’t kept pace with the property’s age.
- One-time income treated as recurring. A single large lease termination fee or insurance settlement folded into “other income” as if it happens every year.
None of this necessarily means the pro forma is dishonest. It usually just means it’s aspirational, and aspirational is fine as long as you can see it and price it. The fix is always the same: pull the T-12 and the current rent roll, rebuild the pro forma from actuals, and only add back items you can independently justify, like a specific unit renovation program with comparable rents already achieved elsewhere in the submarket.
A Worked Example
Here’s a simple pro forma for a 10-unit apartment building, built from the ground up.
Income
| Line Item | Calculation | Annual Amount |
|---|---|---|
| Gross Potential Rent | 10 units x $1,200/mo x 12 | $144,000 |
| Other Income | 10 units x $50/mo x 12 (laundry, pet fees) | $6,000 |
| Gross Potential Income | $144,000 + $6,000 | $150,000 |
| Vacancy & Credit Loss (5%) | $150,000 x 5% | ($7,500) |
| Effective Gross Income | $150,000 – $7,500 | $142,500 |
Operating Expenses
| Line Item | Annual Amount |
|---|---|
| Property Taxes | $17,500 |
| Insurance | $6,500 |
| Utilities (common areas) | $5,000 |
| Repairs & Maintenance | $9,500 |
| Management Fee (8% of EGI) | $11,400 |
| Reserves for Replacement | $2,600 |
| Total Operating Expenses | $52,500 |
Net Operating Income is Effective Gross Income minus Total Operating Expenses: $142,500 – $52,500 = $90,000.
From there, the same NOI produces every metric that actually drives the buy or pass decision:
| Metric | Formula | This Deal |
|---|---|---|
| Cap Rate | NOI ÷ Purchase Price | $90,000 ÷ $1,125,000 = 8.0% |
| Loan Amount (70% LTV) | Purchase Price x 70% | $787,500 |
| Annual Debt Service | 7% rate, 25-year amortization | ≈ $66,800 |
| Debt Service Coverage Ratio | NOI ÷ Debt Service | $90,000 ÷ $66,800 = 1.35 |
| Cash Flow Before Tax | NOI – Debt Service | $90,000 – $66,800 = $23,200 |
| Equity Invested (30% down) | Purchase Price x 30% | $337,500 |
| Cash-on-Cash Return | CFBT ÷ Equity Invested | $23,200 ÷ $337,500 = 6.9% |
That’s the whole exercise. One clean projection produces a purchase price ceiling, a lending decision, and a return estimate, all traceable back to the same seven income and expense lines. Change any one assumption, drop vacancy to 3%, add a $60 monthly rent bump on renewal, use a 6.5% interest rate instead of 7%, and every number downstream moves with it. That sensitivity is exactly why the assumptions matter more than the spreadsheet.
Assumptions Worth Interrogating Before You Trust the Number
- Vacancy rate. Check it against the property’s own trailing occupancy and against submarket vacancy data, not just a round number that happens to look conservative.
- Expense ratio. Total operating expenses as a percentage of EGI should land in a believable range for the property type and age. A number that looks unusually low is usually a missing line item, not a well-run building.
- Cap rate selection. A cap rate needs a comparable sale or a credible broker opinion behind it, not a number picked because it produces the price you want to pay.
- Rent growth assumptions. Multi-year models often default to 3% annual rent growth. Check that against actual rent trends in the submarket over the last few years, not the last few months.
- Exit cap rate. If the model sells the property in year five or ten, the exit cap rate should be equal to or higher than the entry cap rate. Modeling cap rate compression to manufacture a better return is one of the more common ways a pro forma turns into fiction.
- Financing terms. Interest rate, amortization period, and any interest-only period all move cash flow and DSCR meaningfully. Model at least one stress case with a higher rate before you commit to anything.
- Property tax reassessment. Many counties reassess a property’s taxable value at or near the time of sale, often close to the new purchase price. Carrying the seller’s current tax bill forward on a new acquisition is one of the most common, and most avoidable, pro forma errors.
A Few Questions Worth Answering Directly
Is a pro forma the same as a budget? No. A budget is an operating plan for a property you already own, built mostly from known or contracted figures for the upcoming fiscal year. A pro forma is a decision-making tool used to evaluate a purchase, a sale, a refinance, or a new development, and it often has to model figures that don’t exist yet, like a rent roll after a renovation program or stabilized occupancy for a building that hasn’t opened.
How accurate does a pro forma need to be? As accurate as the decision riding on it. A small deal can tolerate looser, rounded assumptions. A larger acquisition deserves a pro forma where every material line, rents, vacancy, each expense category, financing terms, is sourced from actual data and stress tested against at least one worse-than-expected scenario before you sign anything.
What do people build pro formas in? Excel or Google Sheets, almost universally. Purpose-built underwriting software exists, but a spreadsheet remains the standard because every lender, broker, partner, and appraiser you’ll ever work with can open one without a login.
Building Your Own
You don’t need anything more sophisticated than the line items above to build a legitimate pro forma.
- Pull the property’s actual T-12 income statement and current rent roll, not a broker’s marketing summary.
- Line up every unit’s or suite’s actual current rent against comparable asking rents in the submarket, so you know exactly where the upside is and how much of it is real today versus assumed.
- Set vacancy and credit loss from the property’s own trailing occupancy history, adjusted only if you have a specific, evidenced reason to expect it to change.
- Rebuild each expense line from the actual T-12 rather than the seller’s forward guess, and add any line that’s obviously missing, most often a capital reserve.
- Calculate NOI, then divide it by your target purchase price to get an implied cap rate, and compare that against recent comparable sales in the same submarket and property class.
- Layer in your actual financing terms, calculate DSCR and cash-on-cash, and confirm both clear your own minimum thresholds before you go any further.
Adjust only what you can justify with evidence: comparable rents you’ve already seen signed nearby, an expense category you know is underfunded, a vacancy rate the trailing data actually supports. Then run the same NOI through cap rate, DSCR, and cash-on-cash to see whether the deal clears your own bar, not the seller’s.
If you want to run these numbers yourself without building a spreadsheet from scratch, our free CRE calculators cover NOI, cap rate, DSCR, cash-on-cash, and the other metrics in this article, built to the same formulas shown here. For deals that need a fuller model, ground-up development, a multi-year hold with a sale in year five or ten, or a specific property type like NNN retail or self-storage, the Model Library has done-for-you Excel pro forma templates built on the same standards, so you’re not rebuilding the structure from scratch every time.