Pro Forma
Key Takeaways
- A pro forma projects revenue, expenses, NOI, cash flow, and return metrics for a potential STR investment
- Accuracy depends on using real market data for revenue and expense assumptions, not optimistic guesses
- Always build three scenarios (conservative, moderate, optimistic) to understand the range of possible outcomes
- Key outputs include cap rate, cash-on-cash return, DSCR, and break-even occupancy
- Never trust a seller's pro forma without independently verifying every assumption
How to Build an STR Pro Forma
Section 1: Purchase and Setup Costs
| Item | Amount |
|---|---|
| Purchase price | $475,000 |
| Closing costs (3%) | $14,250 |
| Renovation/repairs | $15,000 |
| Furnishing and setup | $25,000 |
| Total investment | $529,250 |
| Down payment (20%) | $95,000 |
| Closing costs + renovation + furnishing | $54,250 |
| Total cash invested | $149,250 |
| Loan amount | $380,000 |
Section 2: Revenue Projection
| Season | Months | Avg Nightly Rate | Occupancy | Revenue |
|---|---|---|---|---|
| Peak | Jun-Aug (92 days) | $265 | 82% | $19,987 |
| Shoulder | Mar-May, Sep-Nov (183 days) | $195 | 68% | $24,271 |
| Off-season | Dec-Feb (90 days) | $145 | 48% | $6,264 |
| Annual total | 365 days | $50,522 | ||
| Cleaning fee income (8/month avg) | $7,200 | |||
| Total gross revenue | $57,722 |
Section 3: Operating Expenses
| Expense | Annual Cost | % of Revenue |
|---|---|---|
| Property management (20%) | $11,544 | 20.0% |
| Cleaning costs | $7,680 | 13.3% |
| Platform fees (3%) | $1,732 | 3.0% |
| Property taxes | $5,200 | 9.0% |
| Insurance | $2,400 | 4.2% |
| Utilities | $4,200 | 7.3% |
| Maintenance reserve (8%) | $4,618 | 8.0% |
| Supplies | $1,800 | 3.1% |
| WiFi/streaming | $1,440 | 2.5% |
| Landscaping | $1,200 | 2.1% |
| Total expenses | $41,814 | 72.4% |
Section 4: Key Metrics
| Metric | Value | Formula |
|---|---|---|
| NOI | $15,908 | Revenue - Expenses |
| Annual mortgage payment | $28,800 | $2,400/month x 12 |
| Annual cash flow | -$12,892 | NOI - Mortgage |
| Cap rate | 3.4% | NOI / Purchase Price |
| Cash-on-cash return | -8.6% | Cash Flow / Cash Invested |
| DSCR | 0.55 | NOI / Debt Service |
| Break-even occupancy | 91% | Costs / (Rate x 365) |
Verdict: This property is not viable at current assumptions. The expense ratio is too high, and the property produces negative cash flow. The investor should either negotiate a lower price, plan to self-manage, or pass on this deal.
Why Pro Formas Matter for Airbnb Hosts
- Avoid bad investments: A thorough pro forma reveals whether a property will actually make money before you commit capital
- Compare opportunities: Build pro formas for multiple properties to objectively compare which deal offers the best risk-adjusted returns
- Stress-test assumptions: Scenario analysis shows how sensitive your returns are to changes in occupancy, rates, or expenses
- Secure financing: Lenders and partners expect professional pro formas when evaluating DSCR loan applications or investment proposals
Common Pro Forma Mistakes to Avoid
| Mistake | Impact | Solution |
|---|---|---|
| Using peak-season rates year-round | Overestimates revenue by 20-40% | Model seasonality separately |
| Omitting expense categories | Understates costs by 10-20% | Use comprehensive expense checklist |
| Ignoring platform fees | Missing 3-5% of revenue in costs | Include Airbnb/VRBO fees |
| No maintenance reserve | Unprepared for major repairs | Budget 5-10% of revenue |
| Using seller's revenue claims | Often inflated or cherry-picked | Verify with independent market data |
| Single-scenario analysis | False confidence in one outcome | Run conservative/moderate/optimistic |
Tips for Building Reliable Pro Formas
- Use real comparable data: Base revenue projections on actual performance of 10+ comparable listings in the same market, not general averages or seller claims.
- Build three scenarios: Create conservative (10-15% below expectations), moderate (best estimate), and optimistic (10-15% above) scenarios to understand your range of outcomes.
- Include all startup costs: Closing costs, renovation, furnishing, initial supplies, and pre-launch marketing should all be included in your total cash invested calculation.
- Project 5 years out: Build a multi-year model that accounts for rent growth (2-4%), expense inflation (2-3%), and potential rate increases to evaluate long-term viability.
- Validate with market revenue data: Use tools like AirROI to get data-driven revenue estimates based on actual STR performance in your target market.
- Sensitivity-test key assumptions: Identify which variables (occupancy rate, nightly rate, expense ratio) have the biggest impact on returns and focus your research on validating those inputs.
Frequently Asked Questions
A comprehensive STR pro forma should include projected revenue (nightly rates x occupancy x 365), all operating expenses by category, mortgage payments (principal and interest), net operating income, cash flow, cap rate, cash-on-cash return, ROI, DSCR, and break-even occupancy. It should also include purchase costs (price, closing costs, renovation, furnishing), financing terms, and sensitivity analysis showing outcomes at different occupancy levels.
Pro forma accuracy depends entirely on the quality of input assumptions. Projections based on actual comparable listing data are typically within 10-15% of reality, while those based on guesswork or seller claims can be off by 30-50%. The most common errors are overestimating occupancy, underestimating expenses, and ignoring seasonality. Always stress-test your pro forma with conservative, moderate, and optimistic scenarios to understand the range of possible outcomes.
Treat seller and agent pro formas as a starting point, never as gospel. They frequently overestimate revenue (using peak-season rates year-round), underestimate expenses (omitting categories like platform fees, supplies, or maintenance reserves), and use unrealistic occupancy assumptions. Always rebuild the pro forma using independent market data from tools like AirROI, verified comparable listings, and your own expense research before making any investment decisions.