酒店項(xiàng)目投資測(cè)算表-v11.02

xxxx酒店,,,,直營(yíng)項(xiàng)目測(cè)算模型InvestmentAssessmentModel,,,,,,V11.01,,,,,,

,黃色單元格可以修改，其他顏色單元格請(qǐng)勿修改。,,,,,如有物業(yè)管理費(fèi)，請(qǐng)調(diào)整第54行的能源費(fèi)用,,,,,,,,,,

備注：,項(xiàng)目名稱,城市+項(xiàng)目名稱,,,項(xiàng)目經(jīng)理,,日期,15/6/1,簽名,,,,,,,

,客房數(shù),94,建筑面積/間,69.1,租期,15年,租金漲幅,每0年漲0%,0.00%,,,,,,,

,租金/年,"6,720,000",承租面積,"7,000",租金/平米/月,80.00,租金/間/天,195.9,房產(chǎn)證,有,,,,,,

,租金收入/年,,出租面積,,租金/平米/月,#DIV/0!,餐廳出租收入,,餐廳面積,,租金/平米/月,#DIV/0!,,,,

,投資額,"4,700,000",投資/平米,671,投資/間,"50,000",押金,,折舊年限,8,,,,,,

,*開辦費(fèi),"200,000",樓層,15,電梯數(shù)量,1,是否中央空調(diào),是,會(huì)議室面積,500,,,,,,

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

,入住率,86.00%,平均房?jī)r(jià),450,RevPAR1,387,RevPAR2,387,租金/收入,50.6%,,,,,,

,盈虧平衡點(diǎn),74.70%,盈虧平衡RevPAR,336,GOP/間,255,可控成本/間,110.2,可控成本%,28.5%,,,,,,

,凈利潤(rùn)率%,8.2%,所得稅率,25%,GOP%,66.0%,固定成本/間,213.0,固定成本%,55.0%,,,,,,

,員工人數(shù),45,人均工資福利,"3,200",人房比,47.9%,利潤(rùn)/間,42.5,營(yíng)業(yè)稅/間,-21.3,,,,,,

,靜態(tài)回收期,3.48年,IRR,29.5%,是否合格,合格,NPV@15%,"3,595,542",現(xiàn)金凈賺/年,"1,680,993",,,,,,

,,3,,,,,,,,,,,,,,

人民幣千元,年度,第1年,第2年,第3年,第4年,第5年,第6年,第7年,第8年,第9年,第10年,第11年,第12年,第13年,第14年,第15年

,客房數(shù),94,94,94,94,94,94,94,94,94,94,94,94,94,94,94

,營(yíng)業(yè)天數(shù),365,365,365,365,365,365,365,365,365,365,365,365,365,365,365

,入住率,80%,86%,86%,86%,86%,86%,86%,86%,86%,86%,86%,86%,86%,86%,86%

'RMB元,房?jī)r(jià),428,450,450,450,450,450,450,450,450,450,450,450,450,450,450

'RMB元,RevPAR,342,387,387,387,387,387,387,387,387,387,387,387,387,387,387

營(yíng)業(yè)收入,客房收入,"11,734","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278"

,租金收入,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,合計(jì),"11,734","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278","13,278"

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

可控營(yíng)業(yè)成本及費(fèi)用,小計(jì),"4,277","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512","4,512"

,GOP,"7,457","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765","8,765"

,,64%,66%,66%,66%,66%,66%,66%,66%,66%,66%,66%,66%,66%,66%,66%

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

固定成本,租金/月,"6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720","6,720"

,折舊攤銷,588,588,588,588,588,588,588,588,588,588,588,588,588,588,588

,小計(jì),"7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308","7,308"

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

利潤(rùn),稅前,(50),"1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458","1,458"

,稅后,(50),"1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,093","1,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%

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

現(xiàn)金流,"(4,700)",537,"1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681","1,681"

,累計(jì),"(4,163)","(2,482)",(801),880,"2,561","4,242","5,923","7,604","9,285","10,966","12,647","14,328","16,009","17,690","19,371"

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

可控營(yíng)業(yè)成本、費(fèi)用明細(xì),,第1年,第2年,第3年,第4年,第5年,第6年,第7年,第8年,第9年,第10年,第11年,第12年,第13年,第14年,第15年

人工福利,13.01%,"1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0","1,728.0"

能源,3.84%,499.9,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5,509.5

客房成本,2.33%,288.2,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8,309.8

低值易耗品,1.55%,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9,205.9

維修,2.00%,234.7,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6

綜合運(yùn)營(yíng)費(fèi)用,2.00%,234.7,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6,265.6

銷售費(fèi)用,3.00%,352.0,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3,398.3

財(cái)務(wù)費(fèi)用,0.75%,88.0,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6,99.6

營(yíng)業(yè)稅,5.50%,645.4,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3,730.3

合計(jì),33.98%,"4,276.7","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5","4,512.5"

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

人民幣元,,,,,,,,,,,,,,,,

能源,間/天,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50,15.50

能源浮動(dòng)率,30%,14.57,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85,14.85

客房成本,間/天,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.50,10.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

,,單房每天成本假定：中央空調(diào)店能源費(fèi)用70%固定、30%與出租率掛鉤浮動(dòng)；客房成本全浮動(dòng)；低值易耗品全固定；其他按銷售收入比率浮動(dòng),,,,,,,,,,,,,,

,按出租房數(shù)計(jì)算、單房成本,,,,,,,,,,,,,,,

人工福利,間/天,63.0,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6,58.6

能源,間/天,18.2,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3,17.3

客房成本,間/天,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5

低值易耗品,間/天,7.5,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0

維修,間/天,8.6,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0

綜合運(yùn)營(yíng)費(fèi)用,間/天,8.6,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0

銷售費(fèi)用,間/天,12.8,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5,13.5

財(cái)務(wù)費(fèi)用,間/天,3.2,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4,3.4

營(yíng)業(yè)稅,間/天,23.5,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8,24.8

合計(jì),間/天,155.8,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9,152.9

維也納店總考核成本,間/天,112.0,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7,107.7

考核未計(jì)成本,,43.8,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2,45.2

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

,按固定總房數(shù)計(jì)算、單房成本,,,,,,,,,,,,,,,

人工福利,間/天,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4,50.4

能源,間/天,14.6,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8,14.8

客房成本,間/天,8.4,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0

低值易耗品,間/天,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0

維修,間/天,6.8,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7

綜合運(yùn)營(yíng)費(fèi)用,間/天,6.8,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7