投行酒店测算模型Projections Model

18.0% 65.0% 50.0% 70.4%
18.0% 65.0% 50.0% 70.4%
11.0% 9.0% 2.8% 3.5% 10.0% 30.1%
10.0% 8.0% 2.8% 3.5% 9.5% 35.2%
10.Leabharlann Baidu% 7.5% 2.8% 3.5% 9.0% 36.9%
10.0% 7.5% 2.8% 4.0% 8.5% 37.6%
10.0% 7.5% 2.8% 4.0% 8.0% 38.1%
10.0% 7.5% 2.8% 4.0% 8.0% 38.1%
10.0% 7.5% 2.8% 4.0% 8.0% 38.1%
10.0% 7.5% 2.8% 4.0% 8.0% 38.1%
10.0% 7.5% 2.8% 4.0% 8.0% 38.1%
51,244 16,145 2,106 702 70,197 9,224 10,495 1,053 49,426 7,020 5,265 1,966 2,808 5,616 26,752 2,140 1,053 2,106 21,453
53,440 16,837 2,196 732 73,205 9,619 10,944 1,098 51,544 7,321 5,490 2,050 2,928 5,856 27,899 2,232 1,098 2,196 22,372
2017
235 365 85,775 734 808 108 119 80.0% 68,620
73.0% 23.0% 3.0% 1.0% 100.0%
2018
235 365 85,775 764 840 112 124 80.0% 68,620
73.0% 23.0% 3.0% 1.0% 100.0%
45,009 14,181 1,850 617 61,656 8,552 9,218 925 42,962 6,166 4,624 1,726 2,158 5,549 22,739 1,819 925 1,850 18,145
49,273 15,524 2,025 675 67,498 8,869 10,091 1,012 47,525 6,750 5,062 1,890 2,700 5,737 25,386 2,031 1,012 2,025 20,318
2015
235 365 85,775 679 747 100 110 80.0% 68,620
73.0% 23.0% 3.0% 1.0% 100.0%
2016
235 366 86,010 706 777 104 114 80.0% 68,808
73.0% 23.0% 3.0% 1.0% 100.0%
19,859 190,229 210,088
36,686 12,229 1,529 510 50,952 7,704 8,560 841 33,848 5,605 4,586 1,427 1,783 5,095 15,352 1,228 764 1,529 11,831
41,113 12,953 1,690 563 56,319 8,223 8,420 845 38,832 5,632 4,505 1,577 1,971 5,350 19,796 1,584 845 1,690 15,678
8.0% 1.5% 3.0% 17.7%
8.0% 1.5% 3.0% 23.2%
8.0% 1.5% 3.0% 27.8%
8.0% 1.5% 3.0% 29.4%
8.0% 1.5% 3.0% 30.1%
8.0% 1.5% 3.0% 30.6%
8.0% 1.5% 3.0% 30.6%
8.0% 1.5% 3.0% 30.6%
酒店10 年营业预算
OPERATING PROJECTIONS Renmenbi (RMB'000)
(USD 1 = RMB6.8) Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
2010
No. of Rooms Days of Year Annual Available Rooms ADR (RMB) NET ADR (RMB) + 10% surcharge* ADR (USD) ADR (USD) + 10% surcharge* Projected Occupancy Total Rooms Rented Revenue Room Revenue (incl. 10% S.C.) F&B Revenue Minor Operating Depts. Rental & Others Total Revenue Departmental Costs & Expenses Rooms F&B Other Operating Depts. Gross Operating Income Deduct G&A Sales & Marketing Basic Management Fee Repair & Maintenance Utilities GOP Incentive Management Fee Property Insurance FF&E Reserve EBITDA (Cash Flow) 5,415 4,513 1,264 1,579 4,964 10,898 872 677 1,354 7,996
55,426 17,463 2,278 759 75,926 9,977 11,351 1,139 53,459 7,593 5,694 2,126 3,037 6,074 28,935 2,315 1,139 2,278 23,204
57,643 18,161 2,369 790 78,963 10,376 11,805 1,184 55,598 7,896 5,922 2,211 3,159 6,317 30,093 2,407 1,184 2,369 24,132
2019
235 365 85,775 794 874 117 128 80.0% 68,620
73.0% 23.0% 3.0% 1.0% 100.0%
235 365 85,775 558 614 82 90 60.0% 51,465 31,589 11,733 1,354 451 45,127 6,950 8,800 745 28,633
8.0% 1.5% 3.0% 30.6%
8.0% 1.5% 3.0% 30.6%
The projected statements are based upon certain assumptions and are inherently subject to uncertainty and variation depending upon evolving events. There can be no assurance that the estimates and assumptions upon which the financial projections are based will remain viable assumptions. There can be no representation or assurance that the property will actually achieve the results of the operations set forth in the financial projections.
12.0% 10.0% 2.8% 3.5% 11.0% 24.2%
2011
235 365 85,775 580 638 85 94 67.0% 57,469
70.0% 26.0% 3.0% 1.0% 100.0%
2012
235 366 86,010 604 664 89 98 72.0% 61,927
21.0% 70.0% 55.0% 66.4%
20.0% 65.0% 50.0% 69.0%
19.0% 65.0% 50.0% 69.7%
18.0% 65.0% 50.0% 70.4%
18.0% 65.0% 50.0% 70.4%
18.0% 65.0% 50.0% 70.4%
18.0% 65.0% 50.0% 70.4%
59,948 18,888 2,464 821 82,121 10,791 12,277 1,232 57,821 8,212 6,159 2,299 3,285 6,570 31,296 2,504 1,232 2,464 25,097
73.0% 23.0% 3.0% 1.0% 100.0%
22.0% 75.0% 55.0% 63.5%
72.0% 24.0% 3.0% 1.0% 100.0%
2013
235 365 85,775 628 690 92 102 76.0% 65,189
73.0% 23.0% 3.0% 1.0% 100.0%
2014
235 365 85,775 653 718 96 106 80.0% 68,620
73.0% 23.0% 3.0% 1.0% 100.0%