2013年经济型酒店预算表
项目Item重庆石桥铺速8酒店十年损益表房间125
2009年2010年2011年2012年2013年2014年2015年2016年2017年2018年员工人数33333333333333333333当月天数365365365365365365365365365365房间总数45625456254562545625456254562545625456254562545625可卖房数45625456254562545625456254562545625456254562545625已卖房数31025319383285032850337633467536500378693786937869平均房价170176180185188195198205208215入住率68.00%70.00%72.00%72.00%74.00%76.00%80.00%83.00%83.00%83.00% RevPar116123130133139148158170173178收入
房间 5,274,25096% 5,621,00096% 5,913,00096% 6,077,25096% 6,347,35096% 6,761,62596% 7,227,00097% 7,763,09497% 7,876,70097% 8,141,78197%餐厅93,0752%95,8132%98,5502%98,5502%101,2882%104,0251%109,5001%113,6061%113,6061%113,6061%会议室0%0%0%0%0%0%0%0%0%0%电话费6,0000%6,0000%6,0000%6,0000%6,0000%6,0000%6,0000%6,0000%6,0000%6,0000%租赁0%0%0%0%0%0%0%0%0%0%其他收入105,4852%112,4202%118,2602%121,5452%126,9472%135,2332%144,5402%155,2622%157,5342%162,8362%酒店总收入5,478,810100%5,835,233100%6,135,810100%6,303,345100%6,581,585100%7,006,883100%7,487,040100%8,037,962100%8,153,840100%8,424,223100%支出
运营费用
客房310,25014%319,37514%328,50014%328,50013%337,62513%346,75013%365,00013%378,68813%378,68813%378,68813%餐厅55,8453%57,4883%59,1303%59,1302%60,7732%62,4152%65,7002%68,1642%68,1642%68,1642%工资及福利831,60038%831,60036%831,60035%891,00036%891,00036%891,00034%950,40034%950,40033%950,40033%950,40032%能源791,13836%843,15037%886,95038%911,58837%952,10338%1,014,24439%1,084,05039%1,164,46440%1,181,50541%1,221,26741%维修费54,7882%58,3523%61,3583%63,0333%65,8163%70,0693%74,8703%80,3803%81,5383%84,2423%其他164,3647%175,0578%184,0748%189,1008%197,4488%210,2068%224,6118%241,1398%244,6158%252,7279%
运营费用合计2,207,98597%2,285,02297%2,351,61298%2,442,35198%2,504,76398%2,594,68498%2,764,63298%2,883,23498%2,904,91098%2,955,48798%非运营费用
行政费用60,0003%60,0003%60,0002%60,0002%60,0002%60,0002%60,0002%60,0002%60,0002%60,0002%非运营费用合计60,0003%60,0003%60,0002%60,0002%60,0002%60,0002%60,0002%60,0002%60,0002%60,0002%总支出T2,267,985100%2,345,022100%2,411,612100%2,502,351100%2,564,763100%2,654,684100%2,824,632100%2,943,234100%2,964,910100%3,015,487100%毛利3,210,82559%3,490,21160%3,724,19861%3,800,99460%4,016,82161%4,352,19862%4,662,40862%5,094,72863%5,188,93064%5,408,73664%固定费用
保险8,6250.32%8,6250.30%8,6250.30%8,6250.29%8,6250.28%8,6250.28%8,6250.26%8,6250.26%8,6250.26%8,6250.25%固定资产再投资164,364 6.03%175,057 6.14%184,074 6.37%189,100 6.26%197,448 6.47%210,206 6.78%224,611 6.87%241,1397.22%244,6157.23%252,7277.18%租金2,000,00073.37%2,000,00070.16%2,000,00069.23%2,100,00069.55%2,100,00068.82%2,100,00067.71%2,205,00067.45%2,205,00066.00%2,205,00065.20%2,315,25065.77%特许经营权费用31,167 1.14%31,167 1.09%31,167 1.08%31,167 1.03%31,167 1.02%31,167 1.00%31,1670.95%31,1670.93%31,1670.92%31,1670.89%初使咨询费10,7000.39%10,7000.38%10,7000.37%10,7000.35%10,7000.35%10,7000.34%10,7000.33%10,7000.32%10,7000.32%10,7000.30%特殊合并咨询费214,5007.87%310,72310.90%331,15211.46%348,35411.54%358,03111.73%373,94312.06%398,35012.18%425,76612.74%457,34913.52%464,04213.18%预定系统软件费10,5000.39%10,5000.37%10,5000.36%10,5000.35%10,5000.34%10,5000.34%10,5000.32%10,5000.31%10,5000.31%10,5000.30%前台系统软件费12,0000.44%12,0000.42%6,0000.21%6,0000.20%6,0000.20%6,0000.19%6,0000.18%6,0000.18%6,0000.18%6,0000.17%营业税273,94110.05%291,76210.24%306,79110.62%315,16710.44%329,07910.78%350,34411.30%374,35211.45%401,89812.03%407,69212.06%421,21111.97%固定费用合计2,725,796100.00%2,850,534100.00%2,889,008100.00%3,019,614100.00%3,051,549100.00%3,101,486100.00%3,269,305100.00%3,340,795100.00%3,381,648100.00%3,520,222100.00%税前利润-633,284-478,636-283,123-336,932-93,731191,710334,101694,9301,807,2821,888,514折旧摊销1,118,3131,118,3131,118,3131,118,3131,059,0031,059,0031,059,0031,059,003
利息收入
利息支出
所得税0000047,92783,525173,733451,821472,128净利润-633,284-478,636-283,123-336,932-93,731143,782250,576521,1981,355,4621,416,385净利润率
现金流-8,461,471639,677835,189781,380965,2721,202,7851,309,5791,580,2011,355,4621,416,385累计现金流-8,461,471-7,821,794-6,986,605-6,205,225################-2,727,589-1,147,389208,0731,624,458
注:1,其他收入按总收入的2%计算
2,客房成本(洗涤费和一次性用品按每间/夜10元计算
3,能耗按全年平均为收入的15%
4,餐厅收入按出租房间数的30%计算人数,每份为10元,成本按60,
5,工资按人平均1400元,其他福利按50%计算.3年工资增长100元
十年合计
3650
456250
456250
347206
192
76.10%
147
67,003,06096% 1,041,6191%
-0% 60,0000%
-0% 1,340,0612% 69,444,740100%
3,472,06413%
624,9712% 8,969,40335% 10,050,46139% 694,4483% 2,083,3438% 25,894,69098%
600,0002%
600,0002% 26,494,690100% 42,950,05562%
-
86,2500.28% 2,083,343 6.69% 21,230,25768.15% 311,667 1.00%
107,0000.34% 3,682,21311.82%
105,0000.34%
72,0000.23% 3,472,23811.15% 31,149,967100.00% 3,090,831
8,709,262
-
-
1,229,134
1,861,697
回收期
96个月