Why It Matters
You build a pro forma before you own the property. Every number in it is a forecast — and that's the point. A seller hands you a property with two years of operating history. Your pro forma takes those numbers, stress-tests the rent assumptions, adjusts vacancy to market rate, and models what the deal actually looks like at your purchase price and financing terms. If the pro forma pencils, you go deeper. If it doesn't, you move on before wasting time on due diligence.
The word "pro forma" is Latin for "as a matter of form" — meaning this is the standard analytical form every deal must pass through. Real estate investors use it to compare what a seller claims a property earns today against what it will realistically earn under your ownership, at your financing costs.
At a Glance
- What it is: A forward-looking financial model projecting income, expenses, and returns before you purchase a property
- How it differs from actuals: Built on assumptions and estimates, not verified historical performance
- Core inputs: Gross potential rent, vacancy rate, operating expenses, debt service, capital reserves
- Core outputs: Net operating income (NOI), cash flow, cash-on-cash return, cap rate
- When you build it: Before making an offer — used to underwrite the deal and set your maximum purchase price
- Primary risk: Garbage-in, garbage-out — optimistic assumptions produce a pro forma that lies
How It Works
Start with gross potential rent (GPR). This is total rent if every unit were occupied at full market rate for 12 months. For a 6-unit building with units renting at $1,400/month, GPR is $100,800/year. This number anchors everything else.
Subtract vacancy and credit loss. No property runs at 100% occupancy. Market vacancy in stabilized markets typically runs 5–8%. If the seller claims 2%, that's an assumption worth challenging. Apply your own vacancy rate to get effective gross income (EGI).
Model operating expenses line by line. Property taxes, insurance, property management (8–10% of EGI is standard), maintenance and repairs, utilities paid by landlord, landscaping, and any common-area costs. Don't accept the seller's expense summary — build your own from current county tax records, insurance quotes, and comparable management fees.
Separate capital expenditures from operating expenses. Roof replacement, HVAC systems, and major appliances are not operating expenses — they're capital expenditures. Most seller pro formas either omit CapEx entirely or bury it in maintenance. Add a CapEx reserve of $100–$200 per unit per month for older properties.
Layer in debt service. Subtract your annual mortgage payments (principal + interest) from NOI to get pre-tax cash flow. The trailing-12-months of actual income is what lenders use to size agency-debt on commercial properties — but your pro forma models what you'll actually experience at your financing terms.
The outputs tell you if the deal works. NOI divided by purchase price gives you cap rate. Annual cash flow divided by total cash invested gives you cash-on-cash return. If those numbers hit your targets, the deal advances.
Real-World Example
Hiro is evaluating a 4-unit building listed at $620,000. The seller's pro forma shows $4,200/month gross rent, 2% vacancy, and $28,000 in annual operating expenses — producing $21,000 NOI and a claimed 3.4% cap rate.
Hiro builds his own pro forma from scratch:
Hiro's Pro Forma (Annual):
- Gross potential rent (4 units × $1,050/mo × 12): $50,400
- Vacancy (6%): -$3,024
- Effective gross income: $47,376
- Property taxes (from county records): -$6,800
- Insurance (current quote): -$2,400
- Property management (9% of EGI): -$4,264
- Repairs and maintenance: -$3,600
- Landscaping and snow removal: -$1,200
- CapEx reserve ($125/unit/month): -$6,000
- Net Operating Income: $23,112
At $620,000, that's a 3.7% cap rate — better than the seller's claim, because Hiro's rent assumption is more conservative and his expenses are more thorough. But now he layers in financing:
- Annual debt service (6.8% on $496,000, 30-year): -$39,108
- Pre-tax cash flow: -$15,996
Negative. The deal doesn't work at $620,000 with today's rates. Hiro uses his pro forma to back-solve: at what price does the deal produce a 7% cash-on-cash return? The answer is $421,000. He submits a lowball offer with his pro forma as justification, knowing the seller will likely decline — but the analysis tells him exactly what the property is worth to him.
Pros & Cons
- Forces disciplined underwriting before emotional attachment — You run the numbers before you tour the property twice and start imagining tenants
- Creates an apples-to-apples comparison framework — Every deal gets modeled with the same vacancy assumption, expense ratio, and CapEx reserve
- Sets your walk-away price before negotiations start — Back-solving from required return gives you a maximum purchase price grounded in math
- Exposes seller spin — Comparing your pro forma to the seller's version reveals where the optimism lives: vacancy, expenses, or rent growth
- Serves as underwriting documentation — Lenders evaluating agency-debt or residential-vs-commercial loan types want to see your projected income model
- Only as good as its assumptions — A 5% vacancy assumption on a property in a declining market is wishful thinking dressed as math
- Does not capture deferred maintenance — The pro forma models steady-state operations, not the $40,000 foundation repair discovered at inspection
- Can be gamed — Sellers routinely present pro formas with 1–2% vacancy, zero CapEx, and below-market management fees to inflate apparent NOI
- Requires market knowledge to stress-test — Without knowing local vacancy rates, insurance costs, and management fees, you can't identify which assumptions are unrealistic
- Future assumptions are inherently uncertain — Rent growth projections embedded in a 5-year pro forma compound small errors into large final valuations
Watch Out
Never use the seller's pro forma as your baseline. Their job is to maximize the sale price. Your job is to model what you'll actually experience. Start from scratch with current county tax data, fresh insurance quotes, and your own vacancy and management fee assumptions.
Vacancy rate is where sellers hide the most optimism. A property showing 2% vacancy likely benefited from a long-term tenant who just renewed. Market vacancy for similar units in that submarket — check with three local property managers — is the number your pro forma should use.
CapEx reserves are not optional. Omitting them makes the cash flow look better on paper while guaranteeing a cash crisis when the roof fails or the HVAC needs replacement. For the unit-count and age of a property, set a reserve that reflects realistic replacement cycles.
Ask an Investor
The Takeaway
A pro forma is the first filter every deal must pass. It won't catch everything — deferred maintenance, difficult tenants, and rising insurance rates don't appear in projected spreadsheets. But a disciplined pro forma built from verified assumptions, realistic vacancy, full operating expenses, and a CapEx reserve will tell you whether a deal is worth pursuing before you spend money on inspections, attorneys, and appraisals. Build your own. Never accept a seller's. The assumptions are where deals get made and money gets lost.