五星級酒店收入測算f

1、客房數(shù)400員工人數(shù)400員工數(shù)/客房數(shù)1.00年月數(shù)12營業(yè)天數(shù)365稅5.5%開辦費1,000,000 人力3,000能源消耗10%客房消耗7%洗滌2.0%維修3%銷售 1%其它1% 餐飲日營業(yè)業(yè)額-餐飲成本0%管理費(每月)-租金上漲比例建筑面積7,000銀行利率6%特許費用6% 每平方每天租金年租金每間房裝修費總裝修費12,600,000每平方裝修費攤銷年限88年后再裝修3,780,000 11277000.0012,600,0004,900,00023,100,000 地地點點：五五星星酒酒店店收收入入測測算算第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年第

2、第七七年年第第八八年年第第九九年年第第十十年年第第十十一一年年第第十十二二年年 收收入入 入住率70%85%85%85%85%85%85%85%85%85%85%85% 平均房價198228238248258268268268268268268268 RevPAR139194202211219228228228228228228228 客房每日營業(yè)額55,44077,52080,92084,32087,72091,12091,12091,12091,12091,12091,12091,120 每間客房年營業(yè)額50,58970,73773,84076,94280,04583,14783,1478

3、3,14783,14783,14783,14783,147 客客房房營營業(yè)業(yè)收收入入20,235,60028,294,80029,535,80030,776,80032,017,80033,258,80033,258,80033,258,80033,258,80033,258,80033,258,80033,258,800 餐餐飲飲營營業(yè)業(yè)收收入入/ /其其他他收收入入500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000700,000700,000 年年營營業(yè)業(yè)收收入入總總額額20,735,60028,79

4、4,80030,035,80031,276,80032,517,80033,758,80033,758,80033,758,80033,758,80033,758,80033,958,80033,958,800 成成本本 經(jīng)營成本人工成本 18,720,0003,167,4283,303,9383,440,4483,576,9583,713,4683,713,4683,713,4683,713,4683,713,4683,735,4683,735,468 能源消耗2,073,5602,879,4803,003,5803,127,6803,251,7803,375,8803,375,8803,3

5、75,8803,375,8803,375,8803,395,8803,395,880 消耗品物品報損1,451,4922,015,6362,102,5062,189,3762,276,2462,363,1162,363,1162,363,1162,363,1162,363,1162,377,1162,377,116 洗滌414,712575,896600,716625,536650,356675,176675,176675,176675,176675,176679,176679,176 維修622,068863,844901,074938,304975,5341,012,7641,012,76

6、41,012,7641,012,7641,012,7641,018,7641,018,764 銷售207,356287,948300,358312,768325,178337,588337,588337,588337,588337,588339,588339,588 管理費（特許費用）1,244,1361,727,6881,802,1481,876,6081,951,0682,025,5282,025,5282,025,5282,025,5282,025,5282,037,5282,037,528 其他207,356287,948300,358312,768325,178337,588337,

7、588337,588337,588337,588339,588339,588 營業(yè)稅1,140,4581,583,7141,651,9691,720,2241,788,4791,856,7341,856,7341,856,7341,856,7341,856,7341,867,7341,867,734 餐飲成本000000000000 經(jīng)經(jīng)營營成成本本合合計計26,081,13813,389,58213,966,64714,543,71215,120,77715,697,84215,697,84215,697,84215,697,84215,697,84215,790,84215,790,842

8、 非經(jīng)營成本 建筑物折舊281,925281,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,500472,500 機電設(shè)備攤銷612,500612,500612,500612,500612,500612,500612,500612,500183,750183,750183,750183,750 無形資

9、產(chǎn)（土地成本）攤銷577,500577,500577,500577,500577,500577,500577,500577,500577,500577,500577,500577,500 投資財務(wù)成本3,172,6203,434,9212,893,3862,303,3911,662,988970,151222,771-554,653-1,363,330-2,174,197 非非經(jīng)經(jīng)營營成成本本合合計計7,219,5456,481,8465,940,3115,350,3164,709,9134,017,0763,269,6962,492,272152,345-658,5221,515,6751,

10、515,675 利利潤潤0 客客房房經(jīng)經(jīng)營營利利潤潤（GOP）-5,345,53815,405,21816,069,15316,733,08817,397,02318,060,95818,060,95818,060,95818,060,95818,060,95818,167,95818,167,958 客客房房經(jīng)經(jīng)營營利利潤潤（百百分分比比）-26%54%54%54%54%54%54%54%54%54%54%54% 稅稅前前利利潤潤-12,565,0838,923,37210,128,84211,382,77212,687,11014,043,88214,791,26215,568,68617

11、,908,61318,719,48016,652,28316,652,283 稅稅前前利利潤潤（百百分分比比）-62%32%34%37%40%42%44%47%54%56%50%50% 所所得得稅稅(33%)-4,146,4772,944,7133,342,5183,756,3154,186,7464,634,4814,881,1165,137,6665,909,8426,177,4285,495,2535,495,253 稅稅后后利利潤潤-8,418,6065,978,6596,786,3247,626,4578,500,3649,409,4019,910,14610,431,02011,9

12、98,77112,542,05111,157,03011,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,61797,078,647 第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年第第七七年年第第八八年年第第九九年年第第十十年年第第十十一一年年第第十十二二年年 現(xiàn)現(xiàn)金金流流量量表表 現(xiàn)金流-57,248,6819,025,5849,833,24910,673,38211,54

13、7,28912,456,32612,957,07113,477,94513,514,44614,057,72612,672,70512,672,705 累計現(xiàn)金流-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,04275,639,747 財財務(wù)務(wù)指指標標表表 正常年份利潤(元)11,157,030 投資回收期(年)6.42 投資利潤率18.40% RevPAR是Revenue Per Available Room的縮寫，是

14、指每間可借出客房產(chǎn)生的平均實際營業(yè)收入 第第十十三三年年第第十十四四年年第第十十五五年年第第十十六六年年第第十十七七年年第第十十八八年年第第十十九九年年第第二二十十年年 85%85%85%85%85%85%85%85% 268268268268268268268268 228228228228228228228228 91,12091,12091,12091,12091,12091,12091,12091,120 83,14783,14783,14783,14783,14783,14783,14783,147 33,258,80033,258,80033,258,80033,258,80033

15、,258,80033,258,80033,258,80033,258,800 700,000700,000700,000700,000700,000700,000700,000700,000 33,958,80033,958,80033,958,80033,958,80033,958,80033,958,80033,958,80033,958,800 3,735,4683,735,4683,735,4683,735,4683,735,4683,735,4683,735,4683,735,468 3,395,8803,395,8803,395,8803,395,8803,395,8803,395

16、,8803,395,8803,395,880 2,377,1162,377,1162,377,1162,377,1162,377,1162,377,1162,377,1162,377,116 679,176679,176679,176679,176679,176679,176679,176679,176 1,018,7641,018,7641,018,7641,018,7641,018,7641,018,7641,018,7641,018,764 339,588339,588339,588339,588339,588339,588339,588339,588 2,037,5282,037,52

17、82,037,5282,037,5282,037,5282,037,5282,037,5282,037,528 339,588339,588339,588339,588339,588339,588339,588339,588 1,867,7341,867,7341,867,7341,867,7341,867,7341,867,7341,867,7341,867,734 00000000 15,790,84215,790,84215,790,84215,790,84215,790,84215,790,84215,790,84215,790,842 281,925281,925281,925281

18、,925281,925281,925281,925281,925 472,500472,500472,500472,500472,500472,500472,500472,500 183,750183,750183,750183,750183,750183,750183,750183,750 577,500577,500577,500577,500577,500577,500577,500577,500 1,515,6751,515,6751,515,6751,515,6751,515,6751,515,6751,515,6751,515,675 18,167,95818,167,95818,167,95818,167,95818,167,95818,167,95818,167,95818,167,958 54%54%54%54%54%54%54%54% 16,652,28316,652,28316,652,28316,652,28316,652,28316,652,28316,652,28316,652,283 50%50%50%50%50%50%50%50% 5,495,25