Real Estate Pro Forma: What It Includes

A real estate pro forma is a projected income statement for a property acquisition, detailing every revenue and cost line item to forecast cash flow and returns. It is the universal underwriting tool: lenders, equity investors, and appraisers all rely on pro forma analysis to evaluate whether an acquisition makes sense, whether it meets debt service requirements, and what returns the equity holder can expect.

The Five-Line Pro Forma Stack

A basic pro forma flows from top to bottom:

1. Potential Gross Revenue (PGR). Total rent if the property were fully occupied at market rates. For an apartment building with 100 units at $1,500/month, PGR = 100 × $1,500 × 12 = $1.8M annually.

2. Vacancy Loss. Market experience says not every unit rents every month. A typical office building assumes 7–10% vacancy; a Class A apartment in a strong market might assume 4–5%. Vacancy loss reduces PGR.

If PGR is $1.8M and vacancy is 5%, vacancy loss is $90K; effective gross income (EGI) = $1.71M.

3. Operating Expenses (OpEx). Costs to run the property day-to-day:

• Property taxes: Often the largest line item. A $20M office building with a 1.2% effective tax rate costs $240K annually.
• Insurance: Property insurance, liability, flood. Varies by location and property type.
• Maintenance and repairs: Seasonal HVAC, roof repairs, parking lot sealcoat, plumbing.
• Utilities: If the landlord pays (common in office), water, electricity, gas.
• Management: Salary for onsite staff, or third-party management fee (4–8% of gross revenue).
• Leasing commissions: Fee paid to brokers for tenant acquisition, often 4–6% of annual rent per new lease.
• Capital reserves (CapEx reserves): A monthly accrual for anticipated major repairs. Lenders often require 5–10% of NOI set aside.

OpEx is usually expressed as a ratio to revenue; 30–40% of EGI is typical for apartments; office can run 35–50%.

Subtracting OpEx from EGI yields Net Operating Income (NOI). If EGI is $1.71M and OpEx is $540K, NOI = $1.17M. NOI is what’s left before debt service.

4. Debt Service. Principal and interest payments on the mortgage. If the property is financed with a $12M loan at 5% for 25 years, annual debt service is roughly $700K.

NOI minus debt service equals cash flow to equity (or cash available for distribution). In this example, $1.17M − $700K = $470K. Equity holders receive this (net of taxes).

5. Equity Returns. The pro forma calculates cash-on-cash return (annual cash flow ÷ equity invested) and, over the holding period, internal rate of return (IRR) and multiple on invested capital.

If the equity investment is $5M and annual cash flow is $470K, cash-on-cash return is 9.4%. If the property appreciates and is sold after five years, total IRR typically compounds the cash flow plus sale proceeds.

The Underwriting Lens: Debt Service Coverage Ratio

Lenders care most about the debt service coverage ratio (DSCR): NOI ÷ annual debt service. In the example above, DSCR = $1.17M ÷ $700K = 1.67x.

Lenders typically require DSCR ≥ 1.25x. This means NOI must be at least 25% larger than debt service, providing a cushion against revenue shortfalls or cost spikes. A DSCR below 1.2x signals weak debt coverage and is a red flag for financing.

Stress Testing and Sensitivity

Prudent underwriting stress-tests the pro forma:

• Occupancy stress. What if occupancy drops to 85% or 80%? The investor models NOI under each scenario to understand downside.
• Expense inflation. Property taxes and insurance rise over time. Pro formas typically assume 2–3% annual increases.
• Rent growth. Revenue might increase with inflation or market recovery. Some acquisitions assume 2–3% annual rent growth; others assume flat rents (more conservative).
• Cap rate reversion. On exit, the property is typically valued at exit NOI divided by an assumed exit cap rate. If entry cap rate is 5% but exit is 6% (yield expansion), value decreases.

A full sensitivity analysis shows IRR and equity return under multiple occupancy, rent growth, and exit cap rate scenarios, revealing the investment’s resilience.

Pro Forma for Different Property Types

While the framework is universal, assumptions vary:

Multifamily (apartments). Typically modeled unit-by-unit. A 200-unit complex might include 50 one-bedrooms at $1,200, 100 two-bedrooms at $1,600, 50 three-bedrooms at $2,000. Turnover costs and leasing commissions are higher.

Office. Often modeled by tenant and lease expiration date. A lease rollover from $30/sf to $28/sf drives a revenue decline in the pro forma.

Retail. Highly tenant-specific. A single anchor tenant loss materially changes the pro forma. Common area maintenance and vacancy can spike if anchors leave.

Industrial. Usually long-term, triple-net leases where tenants pay most expenses. The pro forma is simpler—rent less a small management fee.

Hotel. Modeled by room type and occupancy + average daily rate (ADR). Revenue is rooms available × occupancy % × ADR. OpEx is much higher (housekeeping, front desk, food and beverage).

Sensitivity to Input Assumptions

The pro forma’s output—IRR, cash-on-cash, equity return—is highly sensitive to four inputs:

1. Occupancy assumption. A 1% variance (from 90% to 91%) can shift NOI by 3–5%.
2. Rental rate. New lease at $2/sf lower than assumed cuts NOI materially.
3. Exit cap rate. If you exit at 6% instead of 5%, the sale price falls 17%; IRR compresses.
4. Debt terms. Higher interest rate or shorter amortization increases debt service and reduces equity return.

Sophisticated investors model distributions of these inputs (Monte Carlo simulation) to quantify the likelihood of achieving target returns.

Pro Forma vs. Actuals

Post-acquisition, property managers track actual revenues and expenses against the pro forma. Variance of 10–15% is normal; large deviations flag operational or market issues. A persistent shortfall in NOI may trigger discussions with lenders about covenant waivers or restructuring.

See also