HOTEL NAME Indicative Trading Projections All figures in US$ Year One 2010 Full Year Rooms Available per Day No. of Days per Period No. of Available Rooms Room Rate Escallation Projected Average Room Rates Projected Occupancy Room Occupancy Escallation Rooms Sold Guest Density Ave. Food & Bev per guest Other Dept income per guest Total Daily Spend per Room Revenues Room revenue Food & Beverage revenue Other Departments Total Revenue Department Costs Rooms Food & Beverage Other Departments Costs Department Payroll Rooms Food & Beverage Other Departments 20 365 7,300 $ 150 55.0% 4,015 2.00 40.00 40.00 310.00 % 65% 25% 10% 100% $ Year Two 2011 Full Year 20 365 7,300 10.0% 165 63.3% 15.0% 4,617 2.00 44.00 42.00 337.00 % 63% 26% 11% 100% Year Three 2012 Full Year 20 365 7,300 8.0% 178 69.6% 10.0% 5,079 2.00 46.20 44.00 358.60 % 61% 28% 11% 100% Year Four 2013 Full Year 20 365 7,300 5.0% 187 75.1% 8.0% 5,485 2.00 48.51 46.00 376.13 % 59% 29% 12% 100% Year Five 2014 Full Year 20 365 7,300 3.0% 193 78.9% 5.0% 5,760 2.00 50.94 48.00 390.59 % 57% 30% 12% 100%
$
$
$
$ $ $
$ $ $
$ $ $
$ $ $
$ $ $
602,250 231,635 92,654 926,538
761,846 316,181 126,473 1,204,500
905,073 406,205 162,482 1,473,761
1,026,353 499,357 199,743 1,725,453
1,110,001 587,051 234,820 1,931,872
104,236 32,429 136,664
0% 45% 35% 15%
142,282 44,265 186,547
0% 45% 35% 15%
182,792 56,869 239,661
0% 45% 35% 16%
224,711 69,910 294,621
0% 45% 35% 17%
264,173 82,187 346,360
0% 45% 35% 18%
30,000 30,000 20,000 80,000
5% 13% 22% 9%
34,500 34,500 23,000 92,000
5% 11% 18% 8%
39,675 39,675 26,450 105,800
4% 10% 16% 7%
43,643 43,643 29,095 116,380
4% 9% 15% 7%
45,825 45,825 30,550 122,199
4% 8% 13% 6%
Department Expenses Rooms Food & Beverage Other Departments Department Income Rooms Food & Beverage Other Departments Gross Operating Income Deductions Administrative & General Sales & Marketing Repairs & Maintenance Heat Light & Power Other Expenses Gross Operating Profit Property tax & insurance Management Fees- 5% Incentive Fee-5% GP>$250,000 F.F & E Reserve Other Earning before depreciation, interest and tax
60,225 34,745 13,898 108,868 512,025 62,654 26,327 601,006
10% 15% 15% 12% 85% 27% 28% 65%
68,566 44,265 17,706 130,538 658,780 95,134 41,501 795,415
9% 14% 14% 11% 86% 30% 33% 66%
72,406 52,807 21,123 146,335 792,992 130,931 58,041 981,964
8% 13% 13% 10% 88% 32% 36% 67%
82,108 64,916 25,967 172,991 900,602 166,087 74,771 1,141,461
8% 13% 13% 10% 88% 33% 37% 66%
88,800 76,317 30,527 195,643 975,376 200,737 91,557 1,267,670
8% 13% 13% 10% 88% 34% 39% 66%
60,000 50,000 40,000 46,327 196,327 404,679 35,000 46,327 7,734 89,061
6% 5% 4% 5% 21% 44% 4% 5% 5% 0% 10%
65,000 55,000 45,000 50,000 215,000 580,415 36,400 60,225 16,521 18,068 131,213
5% 5% 4% 5% 18% 48% 3% 5% 5% 1.5% 11%
68,250 57,750 47,250 73,688 246,938 735,026 37,856 73,688 24,251 29,475 165,271
5% 4% 3% 5% 17% 50% 3% 5% 5% 2% 11%
71,663 60,638 49,613 86,273 268,185 873,276 39,370 86,273 31,164 51,764 208,570
4% 4% 3% 5% 16% 51% 2% 5% 5% 3% 12%
75,246 63,669 52,093 96,594 287,602 980,068 40,945 96,594 36,503 57,956 231,998
4% 3% 3% 5% 15% 51% 2% 5% 5% 3% 12%
315,618
34%
449,202
37%
569,756
39%
664,706
39%
748,070
39%