Residential Rental Underwriting

You analyze a residential rental property end-to-end — from listing screen to deal-go/no-go memo. Output is a working financial model (Python or Excel) that an investor can rerun with their own assumptions, plus a one-page deal memo summarizing the math.

============================================================ === PRE-FLIGHT === ============================================================

• [ ] Property basics: address, asset class (SFR / 2-4 unit / condo / TH), bed/bath, sqft, year built, lot size, current condition (turnkey / cosmetic rehab / heavy rehab / teardown).
• [ ] Acquisition: purchase price, closing costs, rehab budget, holding period.
• [ ] Rental: current rent (if leased) or market rent comp. Unit count + per-unit rent for multifamily.
• [ ] Financing: down payment %, interest rate, term, points, lender (conventional / DSCR / FHA / VA / hard money + refi).
• [ ] Operating expenses: property tax (county), insurance, HOA, utilities (LL pays vs tenant), PM fee %, vacancy %, maintenance %, capex reserve %.
• [ ] Strategy: long-term rental (LTR), short-term rental (STR), BRRRR (refi target), Section 8.

Recovery:

• If rent comp is missing, pull from Rentometer / Zillow Rental Manager / RentCast API → fall back to local CMA.
• If property tax unknown, estimate via county assessor's mill rate × assessed value (≈ purchase price × assessment ratio).

============================================================ === PHASE 1: ACQUISITION COSTS === ============================================================

Purchase Price                  $X
+ Closing Costs (2-3% buyer)    $X
+ Initial Rehab Budget          $X
+ Holding Costs (rehab period × $/mo)  $X
+ Lease-up / Reserves           $X
= Total Cash Invested (All-In Basis)    $X

If financed:
  Down Payment                  $X (purchase × DP%)
  Loan Amount                   $X
  Cash to Close = DP + Closing + Points + Initial Rehab + Holding + Reserves

VALIDATION: Cash to close ≤ user's available capital. If not, surface gap.

============================================================ === PHASE 2: STABILIZED OPERATING STATEMENT === ============================================================

Gross Potential Rent              $X (sum of monthly rents × 12)
Less: Vacancy & Credit Loss       ($X)  (5-10% typical, lower for Section 8)
= Effective Gross Income          $X

Operating Expenses:
  Property Tax                    $X
  Insurance                       $X
  HOA / Condo Fee                 $X
  Utilities (LL portion)          $X
  Repairs & Maintenance           $X (8-12% of EGI common rule of thumb)
  Property Management             $X (8-10% of collected rent)
  Lawn / Snow / Pool              $X
  Reserves (CapEx)                $X (5-10% of EGI to fund roofs, HVAC, water heaters)
  Other                           $X
= Total Operating Expenses        $X

Net Operating Income (NOI)        $X
Less: Annual Debt Service         $X
= Cash Flow Before Tax            $X

VALIDATION: Expense ratio plausible (35-50% of EGI for SFR; 40-55% for small multifamily).

============================================================ === PHASE 3: KEY METRICS === ============================================================

Compute and label all of:

Also project 10-year IRR with assumptions: rent growth (default 3% annual), expense growth (3%), appreciation (3-4%), exit cap rate (entry +25-50 bps).

VALIDATION: All metrics computed without div-by-zero. Negative leverage flagged.

============================================================ === PHASE 4: BRRRR REFINANCE MATH === ============================================================

If strategy = BRRRR, compute the refinance event explicitly:

After-Repair Value (ARV)             $X (comp-based)
× LTV (cash-out)                     75-80%
= New Loan Amount                    $X
Less: Existing Loan Payoff           ($X)
Less: Refi Closing Costs             ($X)
= Cash Out at Refi                   $X

Cash Invested After Refi:
  Original Cash Invested             $X
  Less: Cash Out at Refi             ($X)
  = Net Cash Left In                 $X (target ≤ original DP, ideally $0 — "infinite return")

Post-refi monthly cash flow:
  NOI                                 $X
  - New Debt Service                  $X
  = Cash Flow                         $X (must be positive)

VALIDATION: New debt service supportable by NOI (DSCR ≥ 1.20 post-refi). If "net cash left in" > original DP, BRRRR didn't work as designed — surface for user review.

============================================================ === PHASE 5: SECTION 8 SCENARIO === ============================================================

For affordable housing investors, run a side-by-side:

Market Rent Scenario                Section 8 (HCV) Scenario
-----------------                  -----------------------
Rent: $1,800/mo                    HUD Fair Market Rent: $1,650/mo (HCV cap)
Vacancy: 8%                        Vacancy: 3% (waitlist demand)
Late/non-payment: 3%               Late/non-payment: 0.5% (HUD direct deposit)
Turnover cost: $1,500              Turnover cost: $1,200 (longer tenancy)
Inspection cost: $0                Inspection cost: HQS annual + bi-annual
Marketing: $300/turnover           Marketing: PHA waitlist (zero)

Output side-by-side Year-1 cash flow comparison. Section 8 often outperforms despite lower headline rent due to stability + low vacancy.

VALIDATION: HCV FMR pulled from HUD's official table by zip + bedroom count.

============================================================ === PHASE 6: DEAL MEMO === ============================================================

Generate deal_memo.md:

# Deal Memo — {Address}

**Strategy:** {LTR/STR/BRRRR/S8}  
**Purchase Price:** $X  
**All-in Basis:** $X  
**ARV / Stabilized Value:** $X

## Returns

- Cap Rate: X.X% (target {min} for {class})
- Cash-on-Cash: X.X% (target 8-12%)
- DSCR: X.XX (lender minimum 1.25)
- Year-1 Total ROI: XX% (incl. appreciation + paydown)
- 10-yr IRR: XX%

## Strengths

-

## Risks

-

## Recommendation

- [ ] Buy
- [ ] Pass
- [ ] Buy at lower price ($X max)
- [ ] Need more diligence (specify)

VALIDATION: Memo fits on one page. Metrics tie to the proforma.

============================================================ === SELF-REVIEW === ============================================================

• Complete: All 6 phases present? BRRRR + S8 scenarios if strategy matches?
• Robust: Handles div-by-zero? Flags negative leverage? Realistic expense %?
• Clean: Excel model + memo tie out exactly?
• Investor-credible: Would a BiggerPockets-active investor accept the analysis?

Common gap: forgetting reserves (CapEx for roof, HVAC, water heaters). Real numbers, not aspirational.

============================================================ === LEARNINGS CAPTURE === ============================================================

~/.claude/skills/rental-underwriting/LEARNINGS.md — what worked / awkward / patch / verdict.

============================================================ === STRICT RULES === ============================================================

• Never use a vacancy assumption of 0%. Realistic floor is 5%.
• Never skip CapEx reserves. Deferred maintenance kills cash flow long-term.
• Never present the 1% rule as a primary metric in HCOL markets. Use cap rate + CoC.
• Never assume rent grows at expense rate. Expenses (esp. insurance, taxes) often outpace rent growth.
• Always run sensitivity on rent (-10%) and rate (+1%) — that's where deals break.