DSCR Tracker for Airbnb STR Investors — Debt Service Coverage Ratio Calculator — Refinance Eligibility — Excel

Which properties qualify for refinance. Which need rate-shopping. DSCR (Debt Service Coverage Ratio) tracker for Airbnb / STR portfolios. Per-property + portfolio rollup with sensitivity analysis. Excel + Google Sheets.

DSCR loans don't care about your W-2. They care about whether the property
covers its own debt. Most lenders require DSCR ≥ 1.20 to qualify, and they
rate-shop you DOWN if you're at 1.50+. Most STR portfolio operators don't
know their per-property DSCR off the top of their head — let alone
portfolio-wide.

This workbook computes DSCR per property + portfolio-wide, color-codes by
threshold, and surfaces which properties qualify for refinance, which need
rate-shopping, and which are at-risk if occupancy drops 10%. Plus a
loan-shopping comparison tab when you're ready to refinance.

═══════════════════════════════════════════
WHAT'S INCLUDED
═══════════════════════════════════════════

📋 Per-Property DSCR — color-coded green / yellow / red
📋 Portfolio-Wide DSCR — what your overall lender sees
📋 Refinance-Eligible List — properties at ≥1.25 + 24+ months seasoned
📋 10% Sensitivity — re-runs DSCR with revenue × 0.90; flags exposed properties
📋 Loan-Shopping Comparison — 3 lenders side-by-side: rate, term, points, prepay, 5-yr cost
📋 DSCR Lender Print — single-page summary for your loan officer

═══════════════════════════════════════════
WHY THIS MATTERS
═══════════════════════════════════════════

The single biggest leverage move for STR investors with 2+ properties:
refinance to lower rates as DSCR improves. Saves $300-$1,200/mo per property.
On a $300K loan: $1,000 lower payment × 12 months = $12,000/yr per refi.

The workbook tells you when each property is ready and what rate to expect.

═══════════════════════════════════════════
WHO THIS IS FOR
═══════════════════════════════════════════

· STR investors with 2+ properties on commercial / DSCR loans
· Self-employed buyers who can't qualify for conventional W-2 loans
· Operators looking to scale via portfolio loans
· Hosts considering a refi after rates drop

═══════════════════════════════════════════
FILE COMPATIBILITY
═══════════════════════════════════════════

✅ Excel 2016+ (Windows + Mac) · ✅ Excel 365 · ✅ Google Sheets

═══════════════════════════════════════════
REFUNDS
═══════════════════════════════════════════

14-day refund, no questions asked. hello [!at] thestrledger.com.

═══════════════════════════════════════════

⚠ Digital product. Not financial advice. DSCR thresholds vary by lender.