How to Analyze a Rental Property Step-by-Step (Pittsburgh Single-Family Walk-Through) | DealScanner

How to analyze a rental property step-by-step

A Pittsburgh single-family walked through end-to-end - 8 steps from listing to go/no-go decision

Analyze a rental property in 8 steps: (1) verify the rent estimate, (2) build the operating expense stack from Pittsburgh-specific inputs, (3) calculate NOI, (4) calculate cap rate at asking and at your offer, (5) layer in financing assumptions, (6) calculate cash-on-cash return, (7) run DSCR for financing approval, (8) project 5-year total return including paydown and appreciation. Skipping any step (especially the operating expense stack and DSCR) is how investors end up holding cash-negative properties they thought were going to cash flow. The whole workflow takes 20-30 minutes per property once you have the inputs - and DealScanner pre-fills most of them for any Allegheny County address.

The example property

The example walked through this article: a 3-bedroom 1.5-bath single-family in Brighton Heights, listed at $129,000. Built 1924, 1,180 sqft, full basement, gas heat, recently updated electrical panel, original galvanized supply plumbing, asphalt shingle roof estimated at 8 years old. We will treat this as a representative B-class Pittsburgh single-family rental.

Step 1: Verify the rent estimate

Listing pro formas and seller-supplied rents are not trustworthy. Pull rent comps from at least 3 sources:

For our Brighton Heights example: 5 active comps in $1,350-$1,550 range, 4 recent leases at $1,400-$1,475. Conservative rent estimate: $1,425/month.

For a deeper rent comping methodology, see how to estimate rent in Pittsburgh.

Step 2: Build the operating expense stack

This is where most beginner pro formas break - they use national rules of thumb rather than Pittsburgh-specific inputs. The full stack:

Line itemSourceAnnual
Property taxesAllegheny County assessment x school district millage$2,650
InsuranceQuote from local agent$1,150
Property management 9%Local PM standard$1,539
Maintenance reserve 8%Older home, B-class neighborhood$1,368
Capex reserve 6%Roof, HVAC, plumbing replacement reserve$1,026
Vacancy 6%Brighton Heights B-class$1,026
Lawn / snowSeasonal contractor$300
Annualized leasing fee0.5 mo rent every 18 months$475
Total OpEx$9,534

Cross-check this against the realistic OER for Pittsburgh rentals: $9,534 / $17,100 GPR = 55.8% OER. Slightly above the B-class benchmark - reasonable for an older home with original plumbing.

Step 3: Calculate NOI

NOI = Effective Gross Income - Operating Expenses (excluding debt service)

EGI = $1,425 x 12 - vacancy = $17,100 - $1,026 = $16,074

OpEx excluding vacancy (we already deducted it) = $9,534 - $1,026 = $8,508

NOI = $16,074 - $8,508 = $7,566/year

Step 4: Cap rate at asking and at offer

Cap rate at asking ($129,000): $7,566 / $129,000 = 5.86% - below B-class Pittsburgh benchmark of 7-9%. The asking price does not work as a rental.

What price would yield 7.5% cap (mid-B-class)? $7,566 / 0.075 = $100,880. That is your maximum offer for a 7.5% cap target.

For more on cap rate benchmarks, see what is a good cap rate in Pittsburgh.

Step 5: Layer in financing

Assume DSCR loan: 25% down on $100,880 offer = $25,220 down, $75,660 loan at 7.5% 30yr.

Monthly P&I = ~$529 → Annual debt service = $6,348

Step 6: Cash-on-cash return

Annual pre-tax cash flow = NOI - debt service = $7,566 - $6,348 = $1,218

Cash invested = down payment + closing costs + initial reserves = $25,220 + $3,500 + $2,500 = $31,220

Cash-on-cash = $1,218 / $31,220 = 3.9%

That's thin. Below B-class target of 6-10%. See cash-on-cash return for Pittsburgh rentals for benchmarks.

Step 7: DSCR check

DSCR = NOI / annual debt service = $7,566 / $6,348 = 1.19x

This is right at the lender minimum (typically 1.20-1.25x). Borderline. Either offer lower or raise the down payment to reduce debt service. See DSCR explained for Pittsburgh rental investors.

Step 8: 5-year total return

Cash-on-cash is only one component of total return. Full 5-year picture:

Component5-year total
Cumulative cash flow ($1,218/yr, modest rent growth)~$6,800
Principal paydown (loan amortization)~$6,500
Appreciation (3%/yr on $100,880)~$16,100
Total 5-year return~$29,400
On invested capital of $31,220~94% over 5 years
Annualized IRR (rough)~14%

This converts a "thin 3.9% cash-on-cash" into a "respectable 14% IRR" - because paydown and appreciation matter as much as cash flow on Pittsburgh B-class. Always layer total return on top of cash flow before passing on a deal that looks thin on year-1 cash-on-cash alone.

The go/no-go decision

At asking ($129,000): no - cash flow is negligible, DSCR fails, total return weakened by purchase premium.

At $100,880: marginal yes - DSCR right at minimum, cash flow thin but positive, 5-year IRR ~14%. Acceptable if you can get this price.

At $95,000: clear yes - cash flow ~$1,650/yr, DSCR 1.27x, 5-year IRR ~16%, with margin for surprises.

Common rental analysis errors

How DealScanner accelerates this

For any Allegheny County address, DealScanner pre-fills:

The 30-minute manual analysis becomes a 3-minute review of a populated underwriting model.

Why this workflow matters more in Pittsburgh

National rental analysis tools assume 40% OER, 5% vacancy, and 7% maintenance/capex combined. Pittsburgh's 1900-1940 housing stock with city-school-district taxes routinely runs 50%+ OER, 6-8% vacancy, and 12-15% maintenance/capex combined. A property that pencils on a national tool's defaults at $130,000 may need to be bought at $100,000 to actually cash flow with Pittsburgh-specific inputs. Workflow discipline - all 8 steps, every time - is the difference.

Run the full 8-step analysis on any active listing

DealScanner pre-fills every input for any Allegheny County property.

Run the 8-step rental analysis on any Pittsburgh address

DealScanner pre-fills the inputs and shows the answer in 3 minutes.

Analyze a property