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

A seller hands you the numbers: "This 12-unit building does $96,000 a year in rent." Sounds great — until you realize that's gross rent, before vacancies, before property tax, before insurance, before management. A real estate pro forma strips all of that out and tells you the one number that matters: what the property actually returns on your money. Here's how to read (and build) one.

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 — typically 5–8% of gross. The seller's "100% occupied forever" assumption is not an assumption you should share.
• Minus operating expenses — property tax, insurance, maintenance, utilities you pay, and management (8–10% of collected rent is standard).
• = 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. A 6.5% cap on a $450,000 building means NOI of $29,250. Cap rates compare properties across markets — the higher the cap, the higher the risk (and the potential return).

Cash-on-cash return = annual cash flow ÷ cash invested. After your down payment, closing costs and renovation, what does your actual cash earn? This is the number that tells you if the deal beats the stock market.

Debt service coverage (DSCR) = NOI ÷ annual debt payments. Banks want at least 1.25 — meaning the property generates 25% more than it needs to pay the loan.

Financing assumptions matter as much as income

A pro forma without the loan side is incomplete. You need the purchase price, down payment, interest rate and term — then the monthly payment follows. The classic mistake: analyzing the property on a cash basis and only checking financing later. Run the financing first; a deal that cash-flows at 100% down often loses money at 20% down.

Common seller tricks to watch for

• Vacancy set to zero. Real vacancy on a 12-unit building over 10 years is never zero.
• Management fee omitted. If you're not managing it yourself, 8–10% comes off the top.
• Below-market tax base. Property tax can jump after a sale reassessment — ask what the new owner will actually pay.
• Maintenance deferred. If the roof is 20 years old, the pro forma needs a reserve line.

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? In most US markets, 4–6% for low-risk stabilized properties, 6–9% for moderate risk, higher for distressed or tertiary markets. It depends entirely on location and asset class.

Do I need a pro forma to buy my first property? For a single-family rental, a one-page version of this analysis is still worth doing. For anything with multiple units, it's non-negotiable.

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.

👉 Run your first analysis: Real Estate Pro Forma template →