2 vs 3 vs 7 nights, side-by-side. Net revenue, not gross. Minimum-night-stay (MNS) optimizer for Airbnb / STR hosts. Surfaces the truth most hosts miss: 1-night MNS isn’t usually the most profitable. Excel + Google Sheets. Most hosts assume “1-night MNS = max revenue.” It isn’t. A 2-night minimum books fewer total nights but spends 50% less on cleaning costs per night. A 3-night minimum books even fewer but maximizes per-stay revenue. A 7-night minimum loses you most short-trip bookings but wins for cabins / beach houses where 5-7 nights is the natural booking length anyway. This workbook computes net revenue per night under each MNS using YOUR property’s actual cleaning cost, ADR, and demand pattern. Output: a recommendation per property that often surprises operators by $2K-$5K/yr. WHAT’S INCLUDED 📋 Property Inputs — base ADR, current MNS, current occupancy, cleaning cost per turn 📋 Demand Pattern — your market’s typical booking length distribution · Default: 30% 2-night, 40% 3-4-night, 20% 5-7-night, 10% 8+-night 📋 Three-Way Comparison · 2-night MNS — gross revenue, occupancy, turnover cost, NET · 3-night MNS — same metrics · 7-night MNS — same metrics 📋 Seasonal MNS Tab — different MNS per season (off-peak 2-night, peak 3-7-night) 📋 Recommendation Cell — which MNS optimizes net revenue per property
Related
- Cleaning Fee Optimizer
- Dynamic Pricing Calculator
- Year-2 Operator Bundle
- Break-even Occupancy Calculator
- Commission / Split Calculator for Co-Hosts
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.