五星級(jí)酒店收入測(cè)算f

客房數(shù),400,員工人數(shù),400,員工數(shù)/客房數(shù),1.00,年月數(shù),12,營(yíng)業(yè)天數(shù),365,稅,5.5%,開(kāi)辦費(fèi),"1,000,000",,,,,,,,

人力,"3,000",能源消耗,10%,客房消耗,7%,洗滌,2.0%,維修,3%,銷(xiāo)售,1%,其它,1%,,,,,,,,

餐飲日營(yíng)業(yè)業(yè)額,-,餐飲成本,0%,管理費(fèi)(每月),-,租金上漲比例,,建筑面積,"7,000",銀行利率,6%,特許費(fèi)用,6%,,,,,,,,

每平方每天租金,,年租金,,每間房裝修費(fèi),,總裝修費(fèi),"12,600,000",每平方裝修費(fèi),,攤銷(xiāo)年限,8,8年后再裝修,"3,780,000",,,,,,,,

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

地點(diǎn)：五星酒店收入測(cè)算,,第一年,第二年,第三年,第四年,第五年,第六年,第七年,第八年,第九年,第十年,第十一年,第十二年,第十三年,第十四年,第十五年,第十六年,第十七年,第十八年,第十九年,第二十年

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

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

,平均房?jī)r(jià),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

,客房每日營(yíng)業(yè)額,"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"

,每間客房年?duì)I業(yè)額,"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"

,客房營(yíng)業(yè)收入,"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"

,餐飲營(yíng)業(yè)收入/其他收入,"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"

,年?duì)I業(yè)收入總額,"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"

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

經(jīng)營(yíng)成本,人工成本,"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"

,消耗品\物品報(bào)損,"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"

,銷(xiāo)售,"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"

,管理費(fèi)（特許費(fèi)用）,"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"

,營(yíng)業(yè)稅,"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

,經(jīng)營(yíng)成本合計(jì),"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"

非經(jīng)營(yíng)成本,建筑物折舊,"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"

,攤銷(xiāo)裝修及開(kāi)辦費(fèi),"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"

,機(jī)電設(shè)備攤銷(xiāo),"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"

,無(wú)形資產(chǎn)（土地成本）攤銷(xiāo),"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"

,投資財(cái)務(wù)成本,"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",,,,,,,,,,

,非經(jīng)營(yíng)成本合計(jì),"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"

利潤(rùn),,,,,,,,,,,,0,,,,,,,,,

,客房經(jīng)營(yíng)利潤(rùn)（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"

,客房經(jīng)營(yíng)利潤(rùn)（百分比）,-26%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%,54%

,稅前利潤(rùn),"-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"

,稅前利潤(rùn)（百分比）,-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"

,稅后利潤(rùn),"-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"

,累計(jì)利潤(rùn),"-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"

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

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