Real Estate Pro Forma Explained: How to Analyze a Rental Property

A pro forma organizes projected income, expenses and financing for a property. It can help compare scenarios, but the output is only as useful as the inputs and does not predict actual performance. This guide explains common calculations; it is not investment, tax, legal or financial advice.

The pro forma waterfall, top to bottom

Every pro forma follows the same chain. You plug in the inputs once and every number below is derived:

• Gross income — total rent plus other income (laundry, parking, pet fees).
• Minus vacancy and collection assumptions — estimate them using local evidence and test more than one scenario.
• Minus operating expenses — property tax, insurance, maintenance, utilities you pay, management and other costs. Use property-specific estimates rather than a generic percentage.
• = Net Operating Income (NOI) — the property's profit before financing. This is the number lenders and investors care about most.

The three ratios that decide the deal

Cap rate = NOI ÷ purchase price. It is one comparison measure, not a complete measure of risk or future return; results depend on the NOI definition, asset and market.

Cash-on-cash return = annual cash flow ÷ cash invested. It is sensitive to financing and expense assumptions and does not account for every tax, liquidity, appreciation or risk factor. It is not directly comparable to a stock-market return.

Debt service coverage (DSCR) = NOI ÷ annual debt payments. Lenders set their own underwriting criteria; a displayed ratio does not predict loan approval.

Financing assumptions matter as much as income

Model financing alongside income and costs. Confirm loan terms, rate type, fees, payment assumptions and other borrowing conditions with the lender. Compare multiple financing and operating scenarios before relying on an estimate.

Inputs to verify before relying on a projection

• Vacancy, rent growth and collections should be supported by local data.
• Include management, maintenance, utilities, insurance, taxes and reserves that apply to the property.
• Confirm whether property taxes may change after a sale or reassessment.
• Inspect major systems and account for repairs, capital work, transaction costs and financing fees.

Build your own in minutes

The Real Estate Pro Forma template walks through acquisition, financing, income and operating costs in the order real analysis happens — fill in the asking price, your down payment, the loan terms and the income assumptions, and the key metrics line up automatically. For the loan side, pair it with an amortization schedule to see principal vs. interest over the full term.

Frequently asked questions

What is a good cap rate? There is no universal benchmark. Compare similar assets in the same market and review the underlying income, costs, condition and risks.

Does a pro forma show what a property will earn? No. It calculates a scenario from entered assumptions; actual results can differ.

What's the difference between pro forma and actuals? Pro forma is projected (your assumptions); actuals are what really happened. The best investors compare both monthly.

The linked calculator is for scenario analysis only. It is not an offer, appraisal, forecast, or investment, legal, tax or financial advice. Independently verify assumptions and consult qualified professionals before making a decision.

👉 Run a scenario: Real Estate Pro Forma template →