How to Read a Pro Forma Without Lying to Yourself

The first time someone hands you a pro forma for a rental property, it will look authoritative. Clean rows, a tidy net income at the bottom, maybe a confident return percentage in bold. It feels like a fact sheet. It is not. It is a sales pitch in a spreadsheet costume, and learning to read it the way an investor does — rather than the way a hopeful buyer does — is one of the highest-leverage skills you can build before your first purchase.

The good news is that pro formas lie in predictable ways. Once you know the five places optimism hides, you can rebuild any pro forma in fifteen minutes and see the real deal underneath.

What a pro forma even is

Term check — “pro forma”: a projection of a property’s income and expenses, usually showing what the seller or listing agent expects it to earn under their assumptions. “Pro forma” is Latin for “as a matter of form” — which is a fitting warning. It’s a forecast of what could happen, not a record of what did.

That distinction is everything. A pro forma is the opposite of a property’s actual tax returns or its real twelve months of bank statements. It’s what the seller projects, and the seller is motivated to make the projection look as appealing as legally possible. None of this is necessarily fraud — most pro forma optimism is perfectly legal and even customary. It’s just optimism, and optimism is your job to remove.

Whenever you can, ask for the trailing twelve months of actual income and expenses — sometimes called the “T-12” — and the actual lease agreements. Real history beats projected fantasy every time. When you can’t get history, you rebuild the pro forma yourself with conservative numbers. Here’s where to dig.

Optimism #1: The rent is the “market” rent, not the real rent

The income line is where pro formas reach hardest. A seller will frequently list market rent — what the units could rent for if everything were renovated and re-leased today — rather than what tenants are actually paying right now. If the current tenant is paying $1,100 and the pro forma says $1,400, that $300 gap is an assumption you’re being asked to pay for today.

Always anchor to actual, in-place rent on signed leases. Treat any “upside to market” as a maybe, not a given. Raising rents takes turnover, renovation money, and sometimes a fight — and tenants don’t always cooperate with the spreadsheet.

Optimism #2: Vacancy is assumed at zero (or close to it)

Many pro formas quietly assume the property is rented 100% of the time. No property is. Tenants move out, units sit empty during turnover, and occasionally you carry an unrented home for months.

Term check — “vacancy rate”: the percentage of potential rental income you lose to empty units over a year. A 5% vacancy rate on a property that could earn $18,000 a year means you actually plan on collecting about $17,100. Even great properties rarely run below 5%; many markets run higher.

Rebuild the income with a realistic vacancy allowance for your market — often 5% to 8%, sometimes more. If the original pro forma showed none, you’ve already found money the seller pretended you’d never lose.

Optimism #3: Expenses are too low — or missing entirely

This is the big one. Sellers shave the expense side as eagerly as they inflate the income side. Watch for three classic omissions:

• Property management is left out. Even if you plan to manage the property yourself, budget for it — typically 8% to 10% of rent. One day you’ll want to hire it out, and a deal that only works with your unpaid labor isn’t really profitable.
• Repairs and maintenance are lowballed. A line that says “$50/month” for an aging house is fiction. Older properties eat more.
• Capital expenditures are nowhere to be found. The roof, the HVAC, the water heater — these don’t show up monthly, so pro formas pretend they don’t exist.

Term check — “capital expenditures” (CapEx): the big, infrequent replacements a property needs over its life — roof, furnace, water heater, windows, appliances. They don’t hit every month, but they’re as real as the mortgage. Smart investors set aside money monthly so the cost is funded before the item fails.

A pro forma without a CapEx reserve line is showing you a number that cannot survive contact with reality. Add it back in yourself.

Optimism #4: The expense ratio defies gravity

A fast sanity check: total operating expenses on a typical residential rental — everything except the mortgage — usually land somewhere around 35% to 50% of the rent, depending on age, taxes, and whether you pay any utilities. If a pro forma is showing operating expenses of 20% of rent, that’s not a great deal; it’s an incomplete spreadsheet. The expenses you can’t see are still going to bill you.

Optimism #5: The headline return uses the rosy inputs

Finally, the return percentage at the bottom — the cap rate or cash-on-cash figure — is only as honest as everything above it. Garbage in, impressive-looking garbage out.

Term check — “cap rate”: a property’s annual net operating income divided by its price, expressed as a percentage. It lets you compare properties of different prices on the same footing. But it’s only meaningful if the net income feeding it is real — which is exactly what the seller’s pro forma tends to inflate.

Don’t trust the return on the page. Recalculate it from your rebuilt income and expenses. The number that survives your own conservative inputs is the only one that matters.

How to rebuild a pro forma in fifteen minutes

Here’s the routine. Open a blank sheet and fill it in yourself:

1. Start with real, in-place rent. Signed leases only. Park “market upside” in a separate note.
2. Subtract realistic vacancy. Use a rate that fits the actual market, not zero.
3. List every operating expense honestly. Taxes (look up the actual assessment, don’t trust the seller’s old number — your purchase may reset it), insurance, management at full rate, maintenance, utilities you’ll cover, and any HOA.
4. Add a CapEx reserve. A common starting point is setting aside 5% to 10% of rent for future big-ticket replacements.
5. Then subtract the mortgage to get your actual monthly cash flow.

What’s left is the real deal. It’s almost always less rosy than the page you were handed — and that’s the point. You’re not trying to make the deal look bad; you’re trying to make it look true, so the surprises happen on paper instead of in your bank account.

The number that tells the truth

After all that, look at one thing: what this property cash flows per month under your conservative numbers. Not the seller’s projected return. Not the appreciation story. The honest dollars left over after real income meets real expenses. If that number is positive and you’d be comfortable holding the property through a rough year, you may have a deal. If it only turns positive when you use the seller’s assumptions, you don’t have a deal — you have a sales pitch.

The actionable takeaway: never evaluate a property on the pro forma you’re given. Rebuild it line by line with real rent, real vacancy, full expenses, and a funded CapEx reserve — then judge the deal on the number that survives. A property that still cash flows after you’ve stripped out every optimistic assumption is one you can buy with your eyes open. Everything else is a story you’re being asked to pay for.