Reference no: EM133953641
Problem 1
Financial Forecasting for Marina Vista Grand Hotel for 2025-2029
Marina Vista Grand Hotel is a 4-star city-center property (300 rooms) preparing a 5-year operating forecast. After a partial renovation in 2024, management will roll out energy-efficiency measures including solar panels to curb utility inflation from 2026 onward. Get expert-level assignment help in any subject.
Initial Data for 2024 (Base Year):
Hotel Overview:
Number of Rooms: 300 (Main source of Revenue)
Days Open: 300 (The hotel plans to close for 65 days for renovation and staff training)
Occupancy Rate: 75%
Average Daily Rate (ADR): €120
Revenue Streams:
Food and Beverage Revenue: €2,000,000
Spa Revenue: €500,000
Gym Revenue: €300,000
Conference and Event Hosting Revenue: €600,000
Parking Services Revenue: €200,000
Departmental Expenses:
Rooms: €1,200,000
Food and Beverage: €1,000,000
Spa: €250,000
Gym: €150,000
Conference and Events: €300,000
Parking Services: €100,000
Undistributed Operating Expenses:
General and Administrative: €600,000
Marketing: €400,000
Property Operations and Maintenance: €500,000
Energy: €300,000
Assumptions for 2025-2029 Forecasting:
Operational Days Increase:
The hotel plans to increase its operational days by 10 each year, starting from 300 days in 2024, aiming to reach full-year operation (365 days) by the end of the forecast period.
Market and Operational Changes:
The annual occupancy rate increase by 1%, reflecting enhanced marketing and local tourism growth.
ADR increases by €5 annually due to inflation and room upgrades.
Food and Beverage revenue to grow by 2% per year.
Spa and Gym revenues expected to grow by 3% annually.
Conference and Event Hosting Revenue to increase by 4% annually due to improved facilities and marketing.
Parking Services Revenue to increase by 1% annually.
Cost and Expense Adjustments:
Rooms department expenses to increase by 2% annually.
Food and Beverage expenses to grow by 1.5% annually.
Spa and Gym expenses to increase by 1% annually.
Conference and Events expenses to grow by 2% annually, reflecting the increased business.
Parking Services expenses to grow by 1% annually.
General and Administrative expenses to increase by 1% annually.
Marketing expenses to grow by 3% annually, reflecting a strategic push to increase visibility and bookings.
Property Operations and Maintenance expenses to increase by 2% annually.
Energy expenses to see a 5% increase in 2025 and 2026, then +2% per year from 2027 onward due to savings from solar panels installed during 2026.
Required:
Using the provided data, please compute the Gross Operating Profit (GOP) for the years 2024 to 2029.