How to Build a Rental Property Pro Forma (Line by Line)

How to Build a Rental Property Pro Forma

To build a rental property pro forma, you project a property's income and expenses over a multi-year hold — typically 5 to 10 years — starting with gross rent, subtracting vacancy and operating expenses to get net operating income (NOI), then subtracting debt service to arrive at annual cash flow and your key returns. The quality of the pro forma depends entirely on the accuracy of your inputs, so the real work is sourcing defensible numbers, not formatting a spreadsheet.

Below is the exact structure a seasoned investor uses, built one line at a time, with the rules of thumb and traps to avoid.

Why a Pro Forma Matters More Than the Listing Numbers

A listing "proforma" from a broker is a sales document. It almost always shows best-case rent, understated vacancy, and zero capital reserves. Your job is to rebuild it from scratch with conservative, verifiable assumptions so the deal survives contact with reality.

A good pro forma does three things:

• Forces you to quantify every assumption instead of "feeling" the deal.
• Produces apples-to-apples return metrics so you can compare properties.
• Stress-tests the downside before you wire earnest money.

Step 1: Project Gross Scheduled Income

Start at the top line: total rent if the property were 100% occupied all year.

• Pull market rent from recent, comparable leases — not asking rents or the seller's number. See how to estimate rent for a single-family rental for the comp approach.
• Add other income if it exists: pet rent, storage, laundry, parking, utility reimbursements.
• Example: a single-family home renting at $2,000/month = $24,000 gross scheduled income.

Avoid the rookie mistake of plugging in the current tenant's rent when it's $300 below market — or worse, the aspirational post-renovation rent you haven't earned yet.

Step 2: Subtract Vacancy and Credit Loss

No property stays rented 100% of the time. Build in a vacancy allowance based on the actual market, not a flat 5%.

• Tight markets may support 4–5%; softer or higher-turnover markets warrant 8–10%.
• Check local data rather than guessing — here's how to estimate a vacancy rate for a market.
• Example: 7% vacancy on $24,000 = $1,680. Effective gross income = $22,320.

Step 3: Itemize Operating Expenses

This is where pro formas live or die. Do not use a single lumped percentage. List each expense:

• Property taxes — use the reassessed value after your purchase, not the seller's assessment. Taxes frequently jump at sale. Read will my property taxes go up after I buy.
• Insurance — get a real quote for landlord coverage, not a homeowner's estimate.
• Property management — budget 8–10% of collected rent even if you self-manage, so the deal stands on its own.
• Repairs and maintenance — 5–10% of rent, higher on older properties.
• CapEx reserves — set aside for the roof, HVAC, and water heater. Learn how to budget CapEx reserves.
• Utilities, lawn, snow, HOA — only what the owner actually pays.

Sample operating expense block

• Property taxes: $3,600
• Insurance: $1,400
• Management (9%): $2,009
• Repairs/maintenance (7%): $1,562
• CapEx reserve: $1,500
• Lawn/misc: $600
• Total operating expenses: $10,671

Step 4: Calculate Net Operating Income

NOI = effective gross income − operating expenses. Debt is not included here.

• $22,320 − $10,671 = $11,649 NOI.

NOI drives your cap rate and your valuation. If you're fuzzy on the mechanics, review what NOI is and how to calculate it on a rental.

Step 5: Add Debt Service

Now layer in financing. Model the actual loan terms you expect to get.

• Example: $240,000 purchase, 25% down ($60,000), $180,000 loan at 7.25% over 30 years ≈ $14,730 annual debt service (~$1,228/month).
• Cash flow before taxes = NOI − debt service = $11,649 − $14,730 = −$3,081.

That negative number is exactly why you build the pro forma: at these terms, the deal bleeds cash. You now know to negotiate price, increase the down payment, or walk. For the full monthly breakdown, see how to calculate rental property cash flow.

Step 6: Compute Your Return Metrics

Roll the numbers up into metrics you can compare across deals:

• Cap rate = NOI ÷ price = $11,649 ÷ $240,000 = 4.85%.
• Cash-on-cash return = annual cash flow ÷ total cash invested. With negative cash flow, this is negative — a clear fail.
• DSCR = NOI ÷ debt service = $11,649 ÷ $14,730 = 0.79 — below the 1.20–1.25 most lenders want.

Know which metric to lean on for which purpose; cap rate vs cash-on-cash return explains when each matters.

Step 7: Project Forward 5–10 Years

A one-year snapshot hides the real story. Extend each line with growth assumptions:

• Grow rent and expenses at a realistic inflation rate for expense growth — often 2–3%.
• Apply a conservative appreciation rate to value, not a boom-year figure.
• Add principal paydown and a sale at the end to compute total return and IRR.

This multi-year view separates a thin cash-flow deal that builds real equity from one that just looks good in year one.

Common Pro Forma Mistakes

• Expense-ratio shortcuts. Assuming "50% of rent covers expenses" can be wildly off on a specific property.
• Forgetting CapEx. Positive cash flow vanishes when the roof fails.
• Using seller numbers. Reassessed taxes and real insurance quotes change the math.
• Optimistic rent and appreciation. Model base case and a downside.

Replace Guesses With Real Data

A pro forma is only as honest as its inputs — garbage in, garbage out. Instead of hunting down taxes, rent comps, insurance, and vacancy by hand, platforms like PropertyWiz AI pull live, verified market data and pre-populate every input the moment you load a property, then stress-test the deal in real time — so you skip the research and go straight to the decision.

Build it line by line, challenge every assumption, and let the numbers — not the listing — tell you whether to offer.