酒店项目投资测算表_v11.02

xxxx酒店直营项目测算模型Investment Assessment Model V11.01

人民币千元年度第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年第11年第12年第13年第14年第15年客房数949494949494949494949494949494

营业天数365365365365365365365365365365365365365365365

入住率80%86%86%86%86%86%86%86%86%86%86%86%86%86%86% 'RMB 元房价428450450450450450450450450450450450450450450 'RMB 元RevPAR342387387387387387387387387387387387387387387营业收入客房收入11,73413,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,278租金收入000000000000000

合计11,73413,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,27813,278

可控营业成本及费用小计4,2774,5124,5124,5124,5124,5124,5124,5124,5124,5124,5124,5124,5124,5124,512 GOP7,4578,7658,7658,7658,7658,7658,7658,7658,7658,7658,7658,7658,7658,7658,765 64%66%66%66%66%66%66%66%66%66%66%66%66%66%66%

固定成本租金/月6,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,720折旧摊销588588588588588588588588588588588588588588588

小计7,3087,3087,3087,3087,3087,3087,3087,3087,3087,3087,3087,3087,3087,3087,308

利润税前(50)1,4581,4581,4581,4581,4581,4581,4581,4581,4581,4581,4581,4581,4581,458税后(50)1,0931,0931,0931,0931,0931,0931,0931,0931,0931,0931,0931,0931,0931,093 -0.4%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%8.2%

现金流(4,700)5371,6811,6811,6811,6811,6811,6811,6811,6811,6811,6811,6811,6811,6811,681累计(4,163)(2,482)(801)8802,5614,2425,9237,6049,28510,96612,64714,32816,00917,69019,371

可控营业成本、费用明细第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年第11年第12年第13年第14年第15年人工福利13.01%1,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.01,728.0能源 3.84%499.9509.5509.5509.5509.5509.5509.5509.5509.5509.5509.5509.5509.5509.5509.5客房成本 2.33%288.2309.8309.8309.8309.8309.8309.8309.8309.8309.8309.8309.8309.8309.8309.8低值易耗品 1.55%205.9205.9205.9205.9205.9205.9205.9205.9205.9205.9205.9205.9205.9205.9205.9维修 2.00%234.7265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6综合运营费用 2.00%234.7265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6265.6销售费用 3.00%352.0398.3398.3398.3398.3398.3398.3398.3398.3398.3398.3398.3398.3398.3398.3财务费用0.75%88.099.699.699.699.699.699.699.699.699.699.699.699.699.699.6营业税 5.50%645.4730.3730.3730.3730.3730.3730.3730.3730.3730.3730.3730.3730.3730.3730.3合计33.98%4,276.74,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.54,512.5

人民币元

能源间/天15.5015.5015.5015.5015.5015.5015.5015.5015.5015.5015.5015.5015.5015.5015.50能源浮动率30%14.5714.8514.8514.8514.8514.8514.8514.8514.8514.8514.8514.8514.8514.8514.85客房成本间/天10.5010.5010.5010.5010.5010.5010.5010.5010.5010.5010.5010.5010.5010.5010.50低值易耗品间/天 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00单房每天成本假定：中央空调店能源费用70%固定、30%与出租率挂钩浮动；客房成本全浮动；低值易耗品全固定；其他按销售收入比率浮动