|
|
| Costa del Sol Hotel in Marbella |
|
|
|
|
| 1 |
|
| Change |
2 |
|
|
| Year |
| 2022 |
|
|
| 2023 |
|
|
| 2024 |
|
|
| 2025 |
|
|
| 2026 |
|
|
| Number of Rooms |
| 205 |
|
|
| 205 |
|
|
| 205 |
|
|
| 205 |
|
|
| 205 |
|
|
| Room Nights Available |
| 74,825 |
|
|
| 74,825 |
|
|
| Room Nights Sold |
| 53,874 |
|
|
| 56,119 |
|
|
| Days Open |
| 365 |
|
|
| 365 |
|
|
| Occupancy |
| 72% |
|
| 3.00% |
75% |
|
|
| Average Rate |
| 110.00 € |
|
| 2.00 € |
112.00 € |
|
|
| RevPAR |
| 79.20 € |
|
|
| 84.00 € |
|
|
| REVENUE |
| 2022 |
Ratios |
Weight |
% Change |
2023 |
Ratios |
Weight |
% Change |
| Ratios |
Weight |
% Change |
| Ratios |
Weight |
% Change |
| Ratios |
Weight |
|
|
| Rooms |
| 5,926,140.00 € |
| 68.68% |
| 6,285,300.00 € |
| 67.75% |
|
|
| Food |
| 1,066,705.00 € |
18.00% |
12.36% |
1.00% |
1,194,206.79 € |
19.00% |
12.87% |
|
|
| Beverage |
| 711,137.00 € |
12.00% |
8.24% |
0.00% |
754,236.21 € |
12.00% |
8.13% |
|
|
| WiFi Films & Other Revenue |
| 213,341.00 € |
3.60% |
2.47% |
0.00% |
226,270.76 € |
3.60% |
2.44% |
|
|
| SPA Revenue |
| 711,137.00 € |
12.00% |
8.24% |
1.00% |
817,089.21 € |
13.00% |
8.81% |
|
|
| Total Revenue |
| 8,628,460.00 € |
|
|
| 9,277,102.97 € |
|
|
| DEPARTMENTAL EXPENSES |
|
| Ratios |
Weight |
% Change |
| Ratios |
Weight |
|
|
| Rooms |
| 1,784,141.00 € |
30.11% |
20.68% |
1.50% |
1,986,550.26 € |
31.61% |
21.41% |
|
|
| Food and Beverage |
| 1,493,387.00 € |
84.00% |
17.31% |
0.50% |
1,646,434.03 € |
84.50% |
17.75% |
|
|
| WiFi Films & Other Revenue |
| 66,520.00 € |
31.18% |
0.77% |
0.20% |
71,004.06 € |
31.38% |
0.77% |
|
|
| SPA Revenue |
| 45,578.00 € |
6.41% |
0.53% |
0.20% |
54,002.84 € |
6.61% |
0.58% |
|
|
| Total Expenses |
| 3,389,626.00 € |
| 39.28% |
| 3,757,991.18 € |
| 40.51% |
|
|
| DEPARTMENTAL INCOME |
| 5,238,834.00 € |
| 60.72% |
| 5,519,111.79 € |
| 59.49% |
|
|
| UNDISTRIBUTED OPERATING EXPENSES |
|
| Ratios |
Weight |
% Change |
| Ratios |
Weight |
|
|
| General and Administrative |
| 525,627.00 € |
8.87% |
6.09% |
-0.30% |
538,627.28 € |
8.57% |
5.81% |
|
|
| Sales & Marketing |
| 166,820.00 € |
2.81% |
1.93% |
0.40% |
202,071.50 € |
3.21% |
2.18% |
|
|
| Property, Operations & Maintenance |
| 391,718.00 € |
6.61% |
4.54% |
-0.10% |
409,173.18 € |
6.51% |
4.41% |
|
|
| Energy |
| 355,568.00 € |
6.00% |
4.12% |
3.00% |
565,676.58 € |
9.00% |
6.10% |
|
|
| Total Expenses |
| 1,439,733.00 € |
| 16.69% |
| 1,715,548.55 € |
| 18.49% |
|
|
| GROSS OPERATING PROFIT |
| 3,799,101.00 € |
| 44.03% |
| 3,803,563.24 € |
| 41.00% |
Faridak3
TemplateforBudgeting.xlsx
