DealSheet

Short-Term vs Long-Term Rental Vacancy & Break-Even Occupancy

Higher gross revenue on furnished stays carries higher turnover vacancy, utilities, and management fees. Testing 0% to 20% vacancy in one grid keeps underwriting honest.

Break-Even Occupancy
Break-Even Occupancy (%) = (Operating Expenses + Annual Debt Service) / Gross Scheduled Income
Calibration Deals:
DSCR Coverage
1.20x
Below 1.25x
Monthly Cash Flow
+$322
+$3,865/yr
Cap Rate
7.63%
NOI $23,664/yr
70% Flip MAO
$212,500
$97,500 over
Cash-on-Cash
4.48%
Cash In $86,300
1% Rule / GRM
1.08%
GRM 7.7x

Deal Assumptions

$
$
$
$

7x7 Interest Rate vs Vacancy Stress Matrix

21/49 cells pass DSCR >= 1.25x

Click any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.

Rate \ Vac0%3%5%8%10%15%20%
5.50%
6.00%
6.50%
7.00%
7.50%
8.00%
8.50%

Annual Operating Statement & Debt Service

Gross Scheduled Income
$40,200
Effective Gross Income
$36,180
Operating Expenses
-$12,516
Net Operating Income
$23,664
Monthly Debt (P&I)
$1,649.95
Total Cash Required
$86,300

Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.

Reference Scenario Benchmarks

Scenario Inputs Result Underwriting Note
12-Month Long-Term Lease 5% Vacancy / 8% Mgmt Predictable NOI Lowest turnover wear and utility risk
Mid-Term Furnished (90d) 10%-12% Vacancy / Utils Incl. Moderate Spread Underwrite long-term rent as downside floor
Seasonal High-Turnover 20%+ Vacancy / 18% Mgmt High Volatility Verify 7x7 grid survives 20% vacancy shock

Field Verification Checklist

  • 1 Always verify that a furnished or mid-term rental at least breaks even as a standard 12-month lease.
  • 2 Add internet, water, power, and furnishing replacement reserves when modeling non-annual leases.
  • 3 Use the 15% and 20% columns of the 7x7 stress grid to inspect downside reserve requirements.

Related Underwriting Guides