五星级酒店收入测算f

客房数,400,员工人数,400,员工数/客房数,1.00,年月数,12,营业天数,365,税,5.5%,开办费,"1,000,000",,,,,,,,

人力,"3,000",能源消耗,10%,客房消耗,7%,洗涤,2.0%,维修,3%,销售,1%,其它,1%,,,,,,,,

餐饮日营业业额,-,餐饮成本,0%,管理费(每月),-,租金上涨比例,,建筑面积,"7,000",银行利率,6%,特许费用,6%,,,,,,,,

每平方每天租金,,年租金,,每间房装修费,,总装修费,"12,600,000",每平方装修费,,摊销年限,8,8年后再装修,"3,780,000",,,,,,,,

,,11277000.00,"12,600,000","4,900,000","23,100,000",,,,,,,,,,,,,,,,

地点：五星酒店收入测算,,第一年,第二年,第三年,第四年,第五年,第六年,第七年,第八年,第九年,第十年,第十一年,第十二年,第十三年,第十四年,第十五年,第十六年,第十七年,第十八年,第十九年,第二十年

收入,,,,,,,,,,,,,,,,,,,,,

,入住率,70%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%,85%

,平均房价,198,228,238,248,258,268,268,268,268,268,268,268,268,268,268,268,268,268,268,268

,RevPAR,139,194,202,211,219,228,228,228,228,228,228,228,228,228,228,228,228,228,228,228

,客房每日营业额,"55,440","77,520","80,920","84,320","87,720","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120","91,120"

,每间客房年营业额,"50,589","70,737","73,840","76,942","80,045","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147","83,147"

,客房营业收入,"20,235,600","28,294,800","29,535,800","30,776,800","32,017,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800","33,258,800"

,餐饮营业收入/其他收入,"500,000","500,000","500,000","500,000","500,000","500,000","500,000","500,000","500,000","500,000","700,000","700,000","700,000","700,000","700,000","700,000","700,000","700,000","700,000","700,000"

,年营业收入总额,"20,735,600","28,794,800","30,035,800","31,276,800","32,517,800","33,758,800","33,758,800","33,758,800","33,758,800","33,758,800","33,958,800","33,958,800","33,958,800","33,958,800","33,958,800","33,958,800","33,958,800","33,958,800","33,958,800","33,958,800"

成本,,,,,,,,,,,,,,,,,,,,,

经营成本,人工成本,"18,720,000","3,167,428","3,303,938","3,440,448","3,576,958","3,713,468","3,713,468","3,713,468","3,713,468","3,713,468","3,735,468","3,735,468","3,735,468","3,735,468","3,735,468","3,735,468","3,735,468","3,735,468","3,735,468","3,735,468"

,能源消耗,"2,073,560","2,879,480","3,003,580","3,127,680","3,251,780","3,375,880","3,375,880","3,375,880","3,375,880","3,375,880","3,395,880","3,395,880","3,395,880","3,395,880","3,395,880","3,395,880","3,395,880","3,395,880","3,395,880","3,395,880"

,消耗品\物品报损,"1,451,492","2,015,636","2,102,506","2,189,376","2,276,246","2,363,116","2,363,116","2,363,116","2,363,116","2,363,116","2,377,116","2,377,116","2,377,116","2,377,116","2,377,116","2,377,116","2,377,116","2,377,116","2,377,116","2,377,116"

,洗涤,"414,712","575,896","600,716","625,536","650,356","675,176","675,176","675,176","675,176","675,176","679,176","679,176","679,176","679,176","679,176","679,176","679,176","679,176","679,176","679,176"

,维修,"622,068","863,844","901,074","938,304","975,534","1,012,764","1,012,764","1,012,764","1,012,764","1,012,764","1,018,764","1,018,764","1,018,764","1,018,764","1,018,764","1,018,764","1,018,764","1,018,764","1,018,764","1,018,764"

,销售,"207,356","287,948","300,358","312,768","325,178","337,588","337,588","337,588","337,588","337,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588"

,管理费（特许费用）,"1,244,136","1,727,688","1,802,148","1,876,608","1,951,068","2,025,528","2,025,528","2,025,528","2,025,528","2,025,528","2,037,528","2,037,528","2,037,528","2,037,528","2,037,528","2,037,528","2,037,528","2,037,528","2,037,528","2,037,528"

,其他,"207,356","287,948","300,358","312,768","325,178","337,588","337,588","337,588","337,588","337,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588","339,588"

,营业税,"1,140,458","1,583,714","1,651,969","1,720,224","1,788,479","1,856,734","1,856,734","1,856,734","1,856,734","1,856,734","1,867,734","1,867,734","1,867,734","1,867,734","1,867,734","1,867,734","1,867,734","1,867,734","1,867,734","1,867,734"

,餐饮成本,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,经营成本合计,"26,081,138","13,389,582","13,966,647","14,543,712","15,120,777","15,697,842","15,697,842","15,697,842","15,697,842","15,697,842","15,790,842","15,790,842","15,790,842","15,790,842","15,790,842","15,790,842","15,790,842","15,790,842","15,790,842","15,790,842"

非经营成本,建筑物折旧,"281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925","281,925"

,摊销装修及开办费,"2,575,000","1,575,000","1,575,000","1,575,000","1,575,000","1,575,000","1,575,000","1,575,000","472,500","472,500","472,500","472,500","472,500","472,500","472,500","472,500","472,500","472,500","472,500","472,500"

,机电设备摊销,"612,500","612,500","612,500","612,500","612,500","612,500","612,500","612,500","183,750","183,750","183,750","183,750","183,750","183,750","183,750","183,750","183,750","183,750","183,750","183,750"

,无形资产（土地成本）摊销,"577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500","577,500"

,投资财务成本,"3,172,620","3,434,921","2,893,386","2,303,391","1,662,988","970,151","222,771","-554,653","-1,363,330","-2,174,197",,,,,,,,,,

,非经营成本合计,"7,219,545","6,481,846","5,940,311","5,350,316","4,709,913","4,017,076","3,269,696","2,492,272","152,345","-658,522","1,515,675","1,515,675","1,515,675","1,515,675","1,515,675","1,515,675","1,515,675","1,515,675","1,515,675","1,515,675"

利润,,,,,,,,,,,,0,,,,,,,,,

,客房经营利润（GOP）,"-5,345,538","15,405,218","16,069,153","16,733,088","17,397,023","18,060,958","18,060,958","18,060,958","18,060,958","18,060,958","18,167,958","18,167,958","18,167,958","18,167,958","18,167,958","18,167,958","18,167,958","18,167,958","18,167,958","18,167,958"

,客房经营利润（百分比）,-26%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%

,税前利润,"-12,565,083","8,923,372","10,128,842","11,382,772","12,687,110","14,043,882","14,791,262","15,568,686","17,908,613","18,719,480","16,652,283","16,652,283","16,652,283","16,652,283","16,652,283","16,652,283","16,652,283","16,652,283","16,652,283","16,652,283"

,税前利润（百分比）,-62%,32%,34%,37%,40%,42%,44%,47%,54%,56%,50%,50%,50%,50%,50%,50%,50%,50%,50%,50%

,所得税(33%),"-4,146,477","2,944,713","3,342,518","3,756,315","4,186,746","4,634,481","4,881,116","5,137,666","5,909,842","6,177,428","5,495,253","5,495,253","5,495,253","5,495,253","5,495,253","5,495,253","5,495,253","5,495,253","5,495,253","5,495,253"

,税后利润,"-8,418,606","5,978,659","6,786,324","7,626,457","8,500,364","9,409,401","9,910,146","10,431,020","11,998,771","12,542,051","11,157,030","11,157,030","11,157,030","11,157,030","11,157,030","11,157,030","11,157,030","11,157,030","11,157,030","11,157,030"

,累计利润,"-8,418,606","-2,439,946","4,346,378","11,972,835","20,473,199","29,882,600","39,792,746","50,223,766","62,222,536","74,764,588","85,921,617","97,078,647","108,235,677","119,392,706","130,549,736","141,706,765","152,863,795","164,020,825","175,177,854","186,334,884"

,,,,,,,,,,,,,,,,,,,,,,

,,第一年,第二年,第三年,第四年,第五年,第六年,第七年,第八年,第九年,第十年,第十一年,第十二年,第十三年,第十四年,第十五年,第十六年,第十七年,第十