Short-Term Rental Scenario Model
Budget: $30 – $250 USD
I need an experienced financial modeler to turn my short-term rental numbers for a portfolio of daily-let apartments in Saudi Arabia into a clean, easy-to-tweak spreadsheet. All core assumptions—average daily rate, expected occupancy, lease terms, operating costs—will be supplied, so no market research is required.
Your task is to build three complete views of performance (Conservative, Base, Optimistic) and layer a sensitivity table that shows how shifting ADR or occupancy moves the bottom line. A clear, well-labeled structure is essential because I’ll be adjusting the inputs regularly.
You may work in either Excel or Google Sheets, but the final workbook must run error-free in both environments, use transparent formulas, and avoid hard-coding. Please highlight any key drivers and briefly walk me through how the logic flows from inputs to outputs.
Deliverables
• One fully linked spreadsheet (Excel or Sheets)
• Three-scenario summary tab with visuals or clear tables
• ADR & occupancy sensitivity analysis
• Concise note explaining assumptions, methodology, and findings
If you’ve modeled STR/Airbnb assets before and can hand this back within three days, I’d like to hear from you.
Your task is to build three complete views of performance (Conservative, Base, Optimistic) and layer a sensitivity table that shows how shifting ADR or occupancy moves the bottom line. A clear, well-labeled structure is essential because I’ll be adjusting the inputs regularly.
You may work in either Excel or Google Sheets, but the final workbook must run error-free in both environments, use transparent formulas, and avoid hard-coding. Please highlight any key drivers and briefly walk me through how the logic flows from inputs to outputs.
Deliverables
• One fully linked spreadsheet (Excel or Sheets)
• Three-scenario summary tab with visuals or clear tables
• ADR & occupancy sensitivity analysis
• Concise note explaining assumptions, methodology, and findings
If you’ve modeled STR/Airbnb assets before and can hand this back within three days, I’d like to hear from you.