Pro Forma

The pro forma is where all of the individual metrics and assumptions come together into a comprehensive financial model. A well-built pro forma projects annual income (gross potential rent, vacancy, other income, effective gross income), operating expenses (by line item with individual growth assumptions), net operating income, capital expenditures, debt service, and after-tax cash flow for each year of the projected hold period. It concludes with a reversion (projected sale), calculating total equity returns, IRR, and equity multiple.

Building an accurate pro forma requires realistic assumptions grounded in market data and property-specific analysis. Key assumptions include rent growth rates (by unit type or tenant), expense growth rates (by line item), vacancy factors, tenant improvement and leasing commission costs on rollovers, capital expenditure timing and amounts, financing terms, and exit cap rate. Each assumption should be supportable with market comparables, historical trends, or specific property data. Sensitivity analysis across key variables (particularly exit cap rate and rent growth) is essential for understanding the range of possible outcomes.

The most common pro forma mistakes include: using the seller's optimistic assumptions without independent verification, underestimating capital expenditures, applying uniform growth rates to all expense categories (when property taxes and insurance may grow much faster than other expenses), assuming aggressive lease-up timelines for vacant space, and using a lower exit cap rate than the going-in cap rate without a compelling justification. A conservative pro forma that still shows attractive returns is far more valuable than an optimistic one that only works if everything goes right.