STR Pro Forma Template Walkthrough: Modeling Cash Flow
Revenue: ADR × occupancy × available nights, with conservative haircuts | Operating expenses: 35-50% of revenue typical | Debt service: PITI calculated from acquisition financing | Cash flow: Revenue - Operating - PITI = Net cash flow before tax | Cap rate, cash-on-cash, IRR are the headline metrics
A defensible STR pro forma is the foundation of any acquisition decision. The model needs to estimate revenue accurately under conservative assumptions, capture all real operating costs, and produce headline metrics (cap rate, cash-on-cash, IRR) that support the investment thesis. Most rookie STR investors over-estimate revenue and under-estimate expenses, producing pro formas that look attractive but mask economic reality. Professional pro formas are intentionally conservative on revenue, exhaustive on expenses, and stress-tested for downside scenarios.
Revenue modeling
Start with AirDNA Rentalizer or comparable-listing analysis. Take the platform projection and apply a 10-15% conservative haircut to account for property-specific factors (age, finishes, amenities) versus the projection's market median. Model seasonality explicitly: peak-season weeks (15-20 weeks/year typical) at higher ADR; shoulder-season at moderate ADR; off-season at significant discount or vacancy. Total annual revenue = sum of seasonal weekly contributions.
Operating expense components
Total operating expenses for self-managed STR typically run 35-45% of revenue. Property-managed STR runs 50-65% (the PM fee adds 18-30% on top of base ops). Pro formas understating these ranges are typically wrong; verify each line item against actuals from comparable properties.
| Category | Typical % of Revenue | Notes |
|---|---|---|
| Cleaning | 8-12% | Per-stay; budget for 50-80 cleanings/year |
| Property management (if used) | 18-30% | Skip if self-managing |
| Maintenance & repairs | 5-8% | Higher for older properties |
| Utilities (gas, electric, water, internet) | 4-7% | All-in for mid-tier property |
| Insurance | 3-5% | Higher for coastal / pool properties |
| Property tax | 5-12% | Wildly variable by jurisdiction |
| Supplies + consumables | 2-3% | Linens, paper goods, amenities |
| Platform fees (host portion) | 3% (Airbnb split fee) or 14-15% (host-only) | Configuration choice |
| Marketing + tools | 2-3% | PMS + pricing tool subscriptions |
| HOA + permit fees | 1-3% | Where applicable |
Debt service & cap rate
PITI (Principal + Interest + Taxes + Insurance) is calculable from the financing terms. NOI (Net Operating Income) = Revenue - Operating Expenses (excluding mortgage). Cap rate = NOI / Property Value. Cash-on-cash return = (NOI - Annual Debt Service) / Cash Invested. Most STR investors target cap rates 6-9% in stable markets. Properties with strong unique demand drivers can support lower cap rates (5-7% in supply-constrained markets); generic mid-tier should require 8%+ cap rate to be attractive.
Cost-segregation in this strategy
Pro forma cash flows are pre-tax. Cost-segregation deductions add another layer: federal tax savings on rental income that often exceed pre-tax cash flow itself in year one. A property generating $30K pre-tax cash flow with $80K of year-one cost-seg deductions effectively shelters all that cash flow plus offsets W-2 income (with STR loophole or REPS). The complete after-tax IRR analysis must include these tax benefits — pre-tax-only pro formas dramatically understate STR investment ROI for high-bracket investors. See cost segregation for Airbnb properties.
Frequently asked questions
See What Your STR Could Save
Get a free cost-segregation estimate for your property in under 2 minutes. No commitment, no account.
Get My Free Estimate