Airbnb Rental Revenue Model

I need a robust Excel model that focuses on revenue projections for a short-term rental / Airbnb portfolio. The spreadsheet should let me plug in nightly rates, expected occupancy, and seasonal adjustments so I can see monthly and annual revenue at a glance.

Key elements to build in
• Seasonal variations – automatic high, shoulder, and low-season multipliers
• Occupancy rates – editable assumptions down to individual property, with a summary dashboard
• Pricing strategies – side-by-side scenarios for static, dynamic, and minimum-stay pricing

Please structure the workbook so I can easily add properties, change assumptions, and export clean PDF reports for investors. Charts that visualise ADR, RevPAR, and total income over time will be helpful, but the core priority is clear, accurate formulas.

Submit a detailed project proposal outlining:
1. Your approach to modelling seasonal, occupancy, and pricing inputs
2. The layout you plan for assumptions, calculations, and outputs
3. Timeline and any milestone checkpoints

I’ll supply historical booking data once we start, and I’m happy to clarify further metrics if required.