五星级酒店收入测算f表格文件下载.xls

1、客房数400员工人数400员工数/客房数1.00年月数12营业天数365税5.5%开办费人力3,000能源消耗10%客房消耗7%洗涤2.0%维修3%销售 1%其它餐饮日营业业额-餐饮成本0%管理费（每月）-租金上涨比例建筑面积7,000银行利率6%特许费用每平方每天租金年租金每间房装修费总装修费12,600,000每平方装修费摊销年限88年后再装修11277000.0012,600,0004,900,00023,100,000地地点点：#五五星星酒酒店店收收入入测测算算第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年第第七七年年第第八八年年第第九九年年第第十十年年第第十

2、十一一年年收收入入入住率70%85%85%85%85%85%85%85%85%85%85%平均房价198228238248258268268268268268268RevPAR139194202211219228228228228228228客房每日营业额55,44077,52080,92084,32087,72091,12091,12091,12091,12091,12091,120每间客房年营业额50,58970,73773,84076,94280,04583,14783,14783,14783,14783,14783,147客客房房营营业业收收入入20,235,60028,294,800

3、29,535,80030,776,80032,017,80033,258,80033,258,80033,258,80033,258,80033,258,80033,258,800餐餐饮饮营营业业收收入入/其其他他收收入入500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000700,000年年营营业业收收入入总总额额20,735,60028,794,80030,035,80031,276,80032,517,80033,758,80033,758,80033,758,80033,758,80033,758,8

4、0033,958,800成成本本经营成本人工成本18,720,0003,167,4283,303,9383,440,4483,576,9583,713,4683,713,4683,713,4683,713,4683,713,4683,735,468能源消耗2,073,5602,879,4803,003,5803,127,6803,251,7803,375,8803,375,8803,375,8803,375,8803,375,8803,395,880消耗品物品报损1,451,4922,015,6362,102,5062,189,3762,276,2462,363,1162,363,1162,3

5、63,1162,363,1162,363,1162,377,116洗涤414,712575,896600,716625,536650,356675,176675,176675,176675,176675,176679,176维修622,068863,844901,074938,304975,5341,012,7641,012,7641,012,7641,012,7641,012,7641,018,764销售207,356287,948300,358312,768325,178337,588337,588337,588337,588337,588339,588管理费（特许费用）1,244,136

6、1,727,6881,802,1481,876,6081,951,0682,025,5282,025,5282,025,5282,025,5282,025,5282,037,528其他207,356287,948300,358312,768325,178337,588337,588337,588337,588337,588339,588营业税1,140,4581,583,7141,651,9691,720,2241,788,4791,856,7341,856,7341,856,7341,856,7341,856,7341,867,734餐饮成本00000000000经经营营成成本本合合计计26

7、,081,13813,389,58213,966,64714,543,71215,120,77715,697,84215,697,84215,697,84215,697,84215,697,84215,790,842非经营成本建筑物折旧281,925281,925281,925281,925281,925281,925281,925281,925281,925281,925281,925摊销装修及开办费2,575,0001,575,0001,575,0001,575,0001,575,0001,575,0001,575,0001,575,000472,500472,500472,500机电设备

8、摊销612,500612,500612,500612,500612,500612,500612,500612,500183,750183,750183,750无形资产（土地成本）摊销577,500577,500577,500577,500577,500577,500577,500577,500577,500577,500577,500投资财务成本3,172,6203,434,9212,893,3862,303,3911,662,988970,151222,771-554,653-1,363,330-2,174,197非非经经营营成成本本合合计计7,219,5456,481,8465,940,3

9、115,350,3164,709,9134,017,0763,269,6962,492,272152,345-658,5221,515,675利利润润0客客房房经经营营利利润润（GOP）-5,345,53815,405,21816,069,15316,733,08817,397,02318,060,95818,060,95818,060,95818,060,95818,060,95818,167,958客客房房经经营营利利润润（百百分分比比）-26%54%54%54%54%54%54%54%54%54%54%税税前前利利润润-12,565,0838,923,37210,128,84211,38

10、2,77212,687,11014,043,88214,791,26215,568,68617,908,61318,719,48016,652,283税税前前利利润润（百百分分比比）-62%32%34%37%40%42%44%47%54%56%50%所所得得税税（33%）-4,146,4772,944,7133,342,5183,756,3154,186,7464,634,4814,881,1165,137,6665,909,8426,177,4285,495,253税税后后利利润润-8,418,6065,978,6596,786,3247,626,4578,500,3649,409,4019

11、,910,14610,431,02011,998,77112,542,05111,157,030累累计计利利润润-8,418,606-2,439,9464,346,37811,972,83520,473,19929,882,60039,792,74650,223,76662,222,53674,764,58885,921,617第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年第第七七年年第第八八年年第第九九年年第第十十年年第第十十一一年年现现金金流流量量表表现金流-57,248,6819,025,5849,833,24910,673,38211,547,28912,45

12、6,32612,957,07113,477,94513,514,44614,057,72612,672,705累计现金流-57,248,681-48,223,096-38,389,847-27,716,465-16,169,176-3,712,8509,244,22122,722,16636,236,61150,294,33862,967,042财财务务指指标标表表正常年份利润（元）11,157,030投资回收期（年）6.42投资利润率18.40%RevPAR是Revenue Per Available Room的缩写，是指每间可借出客房产生的平均实际营业收入1,000,0001%6%3,78

13、0,000第第十十二二年年第第十十三三年年第第十十四四年年第第十十五五年年第第十十六六年年第第十十七七年年第第十十八八年年第第十十九九年年第第二二十十年年85%85%85%85%85%85%85%85%85%26826826826826826826826826822822822822822822822822822891,12091,12091,12091,12091,12091,12091,12091,12091,12083,14783,14783,14783,14783,14783,14783,14783,14783,14733,258,80033,258,80033,258,80033,2

14、58,80033,258,80033,258,80033,258,80033,258,80033,258,800700,000700,000700,000700,000700,000700,000700,000700,000700,00033,958,80033,958,80033,958,80033,958,80033,958,80033,958,80033,958,80033,958,80033,958,8003,735,4683,735,4683,735,4683,735,4683,735,4683,735,4683,735,4683,735,4683,735,4683,395,8803

15、,395,8803,395,8803,395,8803,395,8803,395,8803,395,8803,395,8803,395,8802,377,1162,377,1162,377,1162,377,1162,377,1162,377,1162,377,1162,377,1162,377,116679,176679,176679,176679,176679,176679,176679,176679,176679,1761,018,7641,018,7641,018,7641,018,7641,018,7641,018,7641,018,7641,018,7641,018,764339,

16、588339,588339,588339,588339,588339,588339,588339,588339,5882,037,5282,037,5282,037,5282,037,5282,037,5282,037,5282,037,5282,037,5282,037,528339,588339,588339,588339,588339,588339,588339,588339,588339,5881,867,7341,867,7341,867,7341,867,7341,867,7341,867,7341,867,7341,867,7341,867,73400000000015,790,84215,790,84215,790,84215,790,84215,790,84215,790,84215,790,84215,790,84215,790,842281,925281,925281,925281,925281,925281,925281,925281,925281,925472,500472,500472,500472,500472,500472,500472,500472,50