What a Real Estate Pro Forma Actually Does

A pro forma is a structured projection of a property's income and expenses, built in a fixed order that appraisers, lenders, and brokers all recognize. You begin with gross potential income, subtract vacancy and credit loss to reach effective gross income, subtract operating expenses to reach net operating income, and only then subtract debt service to arrive at cash flow. The order matters because each intermediate figure answers a different question, and mixing them together is how bad deals get mistaken for good ones.

Why NOI Ignores Your Mortgage

Net operating income is deliberately calculated before financing. Two buyers can pay the same price for the same building and end up with completely different cash flow depending on down payment and interest rate, but the property's NOI is identical in both cases. That independence is what makes NOI the foundation of value: divide it by the purchase price and you get the cap rate, the market's shorthand for what a stream of property income is worth. It also means a low cap rate cannot be fixed with clever financing, only disguised by it.

The Ratios Lenders and Investors Watch

Four numbers carry most of the decision. Cap rate measures unleveraged yield. Cash-on-cash return measures first-year cash flow against the cash you actually put in, including closing costs. Debt service coverage ratio, NOI divided by annual debt service, is usually the binding lending constraint, with 1.25 the common floor. Break-even occupancy tells you what share of gross potential income you must collect just to cover expenses and the mortgage, which translates leverage into the practical question of how much vacancy you can absorb before the property stops paying for itself.

Projecting Forward and the Exit Assumption

Single-year metrics miss most of the return on a leveraged asset, because appreciation and loan amortization accumulate quietly. Professional Mode above projects income and expenses forward at separate growth rates, computes the reversion value by applying an exit cap rate to final-year NOI, deducts selling costs and the remaining loan balance, and solves for internal rate of return and equity multiple across the full hold. Be disciplined about the exit cap: underwriting it equal to or slightly above your entry cap is the conservative convention, because assuming cap rate compression is the most common way an optimistic pro forma manufactures returns that never actually materialize.