UVWXYZAAABACADAEAFAGAHAIAJAK
12
13
Palm Beach Gardens Embassy Suites PGA Blvd
14
15
Jan - 25Feb - 25Mar - 25Apr - 25May - 25Jun - 25Jul - 25Aug - 25Sep - 25Oct - 25Nov - 25Dec - 25Twelve MonthYTD_ActualsPY - 24
16
Total Rooms Available 4,960 4,480 4,960 4,800 4,960 4,800 4,960 4,960 4,800 4,960 4,800 4,960 58,400 58,400 58,560
17
Total Rooms Sold/Occupied 2,693 3,547 4,598 4,491 3,944 3,312 3,671 3,616 3,358 3,910 3,848 3,906 44,894 44,894 42,931
18
Occupancy54.29%79.17%92.70%93.56%79.52%69.00%74.01%72.90%69.96%78.83%80.17%78.75%76.87%76.87%73.31%
19
ADR$238.29 $287.79 $298.66 $211.69 $169.45 $160.73 $141.49 $120.15 $125.38 $169.24 $172.38 $190.21 $192.23 $192.23 $192.42
20
Room RevPAR$129.38 $227.86 $276.86 $198.06 $134.74 $110.90 $104.72 $87.59 $87.72 $133.41 $138.19 $149.79 $147.77 $147.77 $141.06
21
Total RevPAR$152.01 $252.49 $299.55 $232.69 $162.60 $134.14 $124.99 $112.23 $106.85 $155.77 $155.18 $170.95 $171.12 $171.12 $163.58
22
23
Department Revenues
24
Rooms 641,723 1,020,804 1,373,228 950,687 668,297 532,326 519,425 434,471 421,034 661,714 663,309 742,964 8,629,981 8,629,981 8,260,727
25
Food and Beverage 73,848 70,274 58,523 104,956 72,252 65,134 47,031 71,290 41,967 53,787 31,973 41,516 732,551 732,551 864,413
26
Guest Communications Revenue 183 277 218 218 238 50 79 144 218 193 153 114 2,084 2,084 2,578
27
Other Operated Departments Revenue 38,217 39,799 53,793 61,074 65,728 46,384 53,419 50,767 49,663 56,945 49,413 63,342 628,546 628,546 451,269
28
Total Revenues 753,971 1,131,155 1,485,761 1,116,935 806,515 643,894 619,954 556,672 512,882 772,639 744,848 847,936 9,993,161 9,993,161 9,578,988
29
30
Department Expenses
31
Rooms Expense W/O Hospitality 135,965 122,220 163,932 203,937 173,401 143,262 165,332 145,846 161,081 134,141 157,884 161,025 1,868,027 1,868,027 1,774,856
32
Food and Beverage 36,533 40,884 43,081 34,910 44,712 12,764 27,579 42,137 30,552 29,903 38,803 32,236 414,094 414,094 442,341
33
Guest Communications Expense 372 371 341 399 379 (1,862) - - - - - - - - 3,998
34
Other Operated Department Expense 2,907 4,023 6,496 6,189 6,256 8,342 240 961 3,771 4,474 4,615 3,541 51,814 51,814 49,194
35
Total Department Expense 175,777 167,498 213,850 245,436 224,748 162,506 193,150 188,944 195,404 168,517 201,302 196,802 2,333,936 2,333,936 2,270,390
36
37
DEPARTMENT PROFIT
38
Rooms Dept Profit 505,758 898,583 1,209,296 746,750 494,896 389,064 354,094 288,625 259,952 527,574 505,424 581,938 6,761,954 6,761,954 6,485,871
39
Dept Profit 37,315 29,390 15,442 70,045 27,540 52,370 19,452 29,153 11,416 23,885 (6,830) 9,280 318,457 318,457 422,072
40
Telephone Dept Profit (189) (93) (123) (181) (142) 1,912 79 144 218 193 153 114 2,084 2,084 (1,420)
41
Other Minor Dept Profit 35,310 35,776 47,297 54,885 59,472 38,042 53,179 49,807 45,892 52,471 44,798 59,802 576,731 576,731 402,075
42
Departmental Profit 578,193 963,656 1,271,912 871,499 581,766 481,388 426,804 367,728 317,478 604,122 543,546 651,134 7,659,226 7,659,226 7,308,598
43
44
Undistributed Operating Expenses
45
Admin. & General 44,496 76,166 96,643 107,671 99,346 87,472 56,739 64,275 27,225 50,280 63,455 97,566 871,332 871,332 1,065,395
46
Information & Telecommunications Systems 15,993 23,080 18,851 25,499 (11,105) 14,487 15,593 18,572 29,634 18,009 13,907 18,480 200,999 200,999 176,332
47
Sales & Marketing 102,575 133,062 186,410 156,997 114,699 107,357 97,868 93,193 73,048 92,973 111,275 116,762 1,386,219 1,386,219 1,367,244
48
Property Operations & Maintenance 41,338 31,950 36,395 35,215 38,277 27,315 37,921 38,392 49,771 33,063 40,417 56,541 466,594 466,594 458,289
49
Utilities 30,608 22,777 27,269 32,714 34,289 32,516 32,513 34,651 30,366 32,318 29,763 28,262 368,047 368,047 376,068
50
Franchise Fees - - - - - - - - - - - - - - -
51
Hospitality Expense 0 - - - 0 7,272 (7,272) (0) - 0 - - 0 0 -
52
Total Undistributed Expense 235,009 287,034 365,567 358,096 275,506 276,418 233,363 249,082 210,044 226,643 258,816 317,613 3,293,191 3,293,191 3,443,328
53
54
House Profit* 343,184 676,623 906,344 513,403 306,261 204,970 193,441 118,646 107,434 377,479 284,730 333,521 4,366,035 4,366,035 3,865,270
55
56
Base Management Fees 22,442 33,770 44,507 33,330 24,017 19,244 18,478 17,320 17,822 23,119 22,279 25,384 301,711 301,711 288,808
57
GOP** 320,742 642,853 861,837 480,073 282,244 185,726 174,963 101,326 89,612 354,360 262,451 308,137 4,064,324 4,064,324 3,576,462
58
59
Non-Operating Income & Expenses
60
Insurance Expense 24,598 24,246 24,551 24,349 24,326 23,432 22,890 24,570 23,069 23,069 23,069 23,831 286,000 286,000 302,870
61
Insurance - Uninsured Loss - - - - - - - - - - - - - - -
62
Property Tax Expense 34,962 34,962 34,962 34,962 34,962 34,962 34,962 51,635 37,046 36,371 36,979 36,978 443,745 443,745 419,546
63
Property Tax Refunds / Adjustments - - - - - - - - - - - - - - (12,939)
64
OtherTaxes - - - - - - - - - - - - - - 17,695
65
Lease Expense - ER - - - - - - - 240 (240) - - - (0) (0) -
66
Incentive Management Fee - ER 7,485 8,607 17,481 (329) 9,253 8,314 7,380 7,099 7,584 8,500 9,067 9,037 99,479 99,479 95,346
67
Ownership Expenses -M 25,680 6,268 20,402 20,720 18,688 18,925 21,028 21,888 14,788 24,041 13,117 13,207 218,753 218,753 252,669
68
Total Non-Operating Income & Expenses 92,725 74,083 97,396 79,703 87,229 85,634 86,259 105,433 82,248 91,981 82,232 83,054 1,047,976 1,047,976 1,075,186
69
70
FFE Reserve 30,159 45,246 59,430 44,677 32,261 25,756 24,798 22,267 20,515 30,906 29,794 33,917 399,726 399,726 383,160
71
Net Operating Income (NOI) w/ FFE (Earnings Release) 197,858 523,524 705,010 355,693 162,755 74,337 63,905 (26,374) (13,151) 231,473 150,425 191,166 2,616,621 2,616,621 2,118,116
72
73
FFE Reserve 30,159 45,246 59,430 44,677 32,261 25,756 24,798 22,267 20,515 30,906 29,794 33,917 399,726 399,726 383,160
74
Hotel Operating Profit (EBITDA) (Earnings Release) 228,017 568,770 764,441 400,370 195,015 100,093 88,703 (4,107) 7,365 262,379 180,219 225,084 3,016,348 3,016,348 2,501,276
75
76
Ownership Expenses Affecting EBITDA (Breakdown):
77
Ownership Expenses -M 25,680 6,268 20,402 20,720 18,688 18,925 21,028 21,888 14,788 24,041 13,117 13,207 218,753 218,753 252,669
78
Capital/Taxes - - - - - - - - - - - - - - -
79
Common Area - Hotel 25,680 6,268 20,402 20,720 18,688 18,925 20,835 22,081 14,788 24,041 13,117 13,207 218,753 218,753 252,669
80
Capital Budget Repairs - - - - - - - - - - - (0) (0) (0) 0
81
Ownership Expenses -Other 0 (0) 0 (0) 0 0 192 (192) 0 (0) 0 (0) (0) (0) 0
82
83
*Gross Operating Profit per USALI
84
**Income Before Non-Operating Income & Expenses per USALI
85
86
 Undistributed Sales & Marketing:
87
 Sales & Marketing 102,575 133,062 186,410 156,997 114,699 107,357 97,868 93,193 73,048 92,973 111,275 116,762 1,386,219 1,386,219 1,367,244
88
 Secretary - - - - - - - - - - - - - - -
89
 Sales Manager - - - - - - - - 683 1,875 - - 2,558 2,558 -
90
 Director Of Sales & Marketing 4,607 5,957 6,627 6,560 5,964 6,542 5,968 6,320 508 6,336 9,064 8,520 72,972 72,972 72,797
91
 Alloc VP / Dos 3,369 4,600 3,077 4,616 5,757 1,774 3,700 3,378 759 (253) - 830 31,607 31,607 30,560
92
 Vice President Sales & Marketing - - - - - - - - - - - - - - -
93
 Sales Manager 3,437 4,403 5,318 4,887 4,629 4,834 5,076 5,681 5,498 5,168 4,215 4,558 57,705 57,705 59,727
94
 Alloc Revenue Mgrs - - - - - - - - - - - - - - -
95
 Alloc Sales Speclst - - - - - - - - - - - - - - -
96
 Secretary 2 - - - - - - - - - - - - - - -
97
 Business Development Manager 3,104 2,806 2,808 3,068 2,742 3,026 2,625 2,715 3,034 3,196 2,583 3,016 34,723 34,723 33,488
98
 Assistant Director of Sales & Marketing - - - - - - - - - - - - - - -
99
 Senior Sales Manager - - - - - - - - - - - - - - -
100
 Employee Meals 9 - - - - - - - - - - - - - - -
101
 Payroll Taxes 12 4,374 4,416 5,639 3,617 4,212 4,500 5,144 4,463 7,739 3,666 2,862 4,246 54,877 54,877 52,446
102
 Vacation Accrual 10 1,870 943 706 660 2,433 561 1,906 1,048 464 657 1,572 1,578 14,397 14,397 16,116
103
 Sales Bonus Accrual 838 1,606 1,606 1,606 1,606 1,606 1,606 1,285 (321) (321) - - 11,117 11,117 34,108
104
 Contract Labor 11 - - - - - - - - - - - - - - 915
105
 Printing Stationery 230 18 353 290 94 252 62 470 247 (4) 259 44 2,315 2,315 2,437
106
 Franchise Fees 3 32,008 51,140 68,445 47,220 33,388 26,659 25,933 21,617 20,925 33,067 33,291 37,061 430,755 430,755 412,086
107
 Franchise Promotions 17,579 19,461 38,086 34,957 23,174 19,891 15,436 16,887 14,923 12,636 23,396 25,201 261,628 261,628 249,343
108
 Franchise Adv Assessments 19,205 30,684 41,067 28,332 20,033 15,995 15,560 12,970 12,555 19,840 19,975 22,237 258,453 258,453 249,653
109
 Cluster Services 10 - 416 (416) - - - - - - - - - - - -
110
 Literature - - - - - - - - - - - - - - -
111
 Literature - Rooms - - - - - - - - - - - - - - -