Hotel Business P&L Pro Forma Analysis
Budget: $30 – $250 USD
I'm in need of a financial model to determine if I should take over an existing property management company in zanzibar which manages about 18 luxury villas using various channels like booking.com, airbnb and direct bookings. This needs to be a quick e ver use to help me prepare an excel template for a P&L pro forma based on 2-3 months of data, which I will provide alongside revenue forecasts. I also want to look at the cash generation potential of the business so a cash flow template is also needed.
Key Responsibilities:
- Analyze historic data which I will provide and provide insights and profitability / business viability
- Update various cost optimization sensitivities based on input received by me, particularly in staffing and other operational expenses, into the P&L model
- Forecast profitability potential of the business with the ability to modify output based on changing assumptions like average daily rental rates per villa by month, occupancy rates by month, adjustments to staffing levels in line with seasonality.
Deliverables:
- An Excel model detailing the P&L pro forma plus a cash flow template
- Key metrics related to the forecast
Ideal Skills and Experience:
- Background in the hospitality industry would be a plus but not necessary
- Strong financial modeling and Excel skills
- Experience in detailed cost analysis with a focus on cost optimisation required to achieve desired business performance
- Understanding of various taxes in Zanzibar like withholding taxes that may / may not be applicable, corporate taxes, dividend taxes, PAYE, VAT, and others. Line by line analysis of running costs in the business to deliver a property management service to multiple luxury villa owners
- Ability to provide in-depth analysis with actionable recommendations.
Key Responsibilities:
- Analyze historic data which I will provide and provide insights and profitability / business viability
- Update various cost optimization sensitivities based on input received by me, particularly in staffing and other operational expenses, into the P&L model
- Forecast profitability potential of the business with the ability to modify output based on changing assumptions like average daily rental rates per villa by month, occupancy rates by month, adjustments to staffing levels in line with seasonality.
Deliverables:
- An Excel model detailing the P&L pro forma plus a cash flow template
- Key metrics related to the forecast
Ideal Skills and Experience:
- Background in the hospitality industry would be a plus but not necessary
- Strong financial modeling and Excel skills
- Experience in detailed cost analysis with a focus on cost optimisation required to achieve desired business performance
- Understanding of various taxes in Zanzibar like withholding taxes that may / may not be applicable, corporate taxes, dividend taxes, PAYE, VAT, and others. Line by line analysis of running costs in the business to deliver a property management service to multiple luxury villa owners
- Ability to provide in-depth analysis with actionable recommendations.