房地產(chǎn)項(xiàng)目建設(shè)成本測(cè)算表(自動(dòng)計(jì)算)

1、,地塊成本匯總表,序號(hào),成本項(xiàng)目,可售面積單位成本,總成本（萬(wàn)元）,分?jǐn)倶?biāo)準(zhǔn)說(shuō)明,16層住宅,類型2,類型3,商業(yè),地下停車場(chǎng),平均,16層住宅,類型2,類型3,商業(yè),地下停車場(chǎng),合計(jì),建筑面積,*,*,*,*,*,20000.00 ,0.00 ,0.00 ,1300.00 ,4000.00 ,21300.00 ,可售面積,*,*,*,*,*,20000.00 ,0.00 ,0.00 ,1300.00 ,4000.00 ,21300.00 ,一,土地獲得價(jià)款,1569.04 ,1569.04 ,1569.04 ,3138.08 ,0.00 ,0.00 ,203.98 ,3342.06 ,1 ,

2、政府地價(jià)及相關(guān)費(fèi)用,1569.04 ,1569.04 ,1569.04 ,3138.08 ,0.00 ,0.00 ,203.98 ,3342.06 ,表中公式把地價(jià)按可售面積進(jìn)行分?jǐn)?。若按占地面積分?jǐn)偟貎r(jià)，請(qǐng)修改公式。若地價(jià)不是在所有產(chǎn)品類型中分?jǐn)傄嗾?qǐng)修改公式,2 ,合作款項(xiàng),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,3 ,紅線外市政設(shè)施,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,4 ,拆遷補(bǔ)償費(fèi),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.0

3、0 ,二,開(kāi)發(fā)前期準(zhǔn)備費(fèi),240.17 ,240.17 ,240.17 ,480.34 ,0.00 ,0.00 ,31.22 ,511.57 ,1 ,勘察設(shè)計(jì)費(fèi),76.06 ,76.06 ,76.06 ,152.11 ,0.00 ,0.00 ,9.89 ,162.00 ,表中公式把該項(xiàng)成本按可售面積在所有產(chǎn)品類型中分?jǐn)?。若不是在所有產(chǎn)品類型中分?jǐn)傉?qǐng)修改公式,2 ,報(bào)批報(bào)建增容費(fèi),137.85 ,137.85 ,137.85 ,275.70 ,0.00 ,0.00 ,17.92 ,293.63 ,3 ,三通一平費(fèi),23.47 ,23.47 ,23.47 ,46.95 ,0.00 ,0.00 ,3

4、.05 ,50.00 ,4 ,臨時(shí)設(shè)施費(fèi),2.79 ,2.79 ,2.79 ,5.58 ,0.00 ,0.00 ,0.36 ,5.94 ,三,主體建筑工程費(fèi),1314.56 ,1999.83 ,750.00 ,1497.23 ,2629.11 ,0.00 ,0.00 ,259.98 ,300.00 ,3189.09 ,1 ,基礎(chǔ)工程,19.65 ,153.08 ,27.80 ,39.31 ,0.00 ,0.00 ,19.90 ,59.21 ,按產(chǎn)品類型實(shí)發(fā)生額計(jì)算,2 ,結(jié)構(gòu)及粗裝修,842.75 ,982.75 ,750.00 ,992.14 ,1685.50 ,0.00 ,0.00 ,12

5、7.76 ,300.00 ,2113.26 ,3 ,門窗工程,124.45 ,260.00 ,132.72 ,248.90 ,0.00 ,0.00 ,33.80 ,282.70 ,4 ,公共部位裝修 ,197.29 ,604.00 ,222.12 ,394.59 ,0.00 ,0.00 ,78.52 ,473.11 ,5 ,室內(nèi)裝修,130.41 ,0.00 ,122.45 ,260.82 ,0.00 ,0.00 ,0.00 ,260.82 ,四 ,主體安裝工程費(fèi),268.47 ,162.16 ,150.00 ,290.15 ,536.94 ,0.00 ,0.00 ,21.08 ,60.00

6、,618.02 ,1 ,室內(nèi)水暖氣電,128.50 ,128.50 ,150.00 ,156.67 ,257.00 ,0.00 ,0.00 ,16.71 ,60.00 ,333.71 ,按產(chǎn)品類型實(shí)發(fā)生額計(jì)算,2 ,設(shè)備及安裝費(fèi),117.00 ,30.00 ,111.69 ,234.00 ,0.00 ,0.00 ,3.90 ,237.90 ,3 ,弱電系統(tǒng),22.97 ,3.66 ,21.79 ,45.94 ,0.00 ,0.00 ,0.48 ,46.42 ,五 ,社區(qū)管網(wǎng)工程費(fèi),77.68 ,77.68 ,77.68 ,155.37 ,0.00 ,0.00 ,10.10 ,165.47 ,1

7、 ,室外給排水系統(tǒng),13.44 ,13.44 ,13.44 ,26.87 ,0.00 ,0.00 ,1.75 ,28.62 ,表中公式把該項(xiàng)成本按可售面積在所有產(chǎn)品類型中分?jǐn)?。若不是在所有產(chǎn)品類型中分?jǐn)傉?qǐng)修改公式,2 ,室外采暖系統(tǒng),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,3 ,室外燃?xì)庀到y(tǒng),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,4 ,室外高低壓線路,56.98 ,56.98 ,56.98 ,113.97 ,0.00 ,0.00 ,7.41 ,121.38 ,5 ,室外智能化系統(tǒng),

8、7.26 ,7.26 ,7.26 ,14.53 ,0.00 ,0.00 ,0.94 ,15.47 ,6 ,其他,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,六,園林環(huán)境費(fèi),56.15 ,56.15 ,56.15 ,112.31 ,0.00 ,0.00 ,7.30 ,119.61 ,1 ,綠化建設(shè)費(fèi),7.86 ,7.86 ,7.86 ,15.72 ,0.00 ,0.00 ,1.02 ,16.74 ,表中公式把該項(xiàng)成本按可售面積在所有產(chǎn)品類型中分?jǐn)?。若不是在所有產(chǎn)品類型中分?jǐn)傉?qǐng)修改公式,2 ,建筑小品,0.00 ,0.00 ,0.00 ,0.00

9、 ,0.00 ,0.00 ,0.00 ,0.00 ,3 ,道路廣場(chǎng)建造費(fèi),26.14 ,26.14 ,26.14 ,52.27 ,0.00 ,0.00 ,3.40 ,55.67 ,4 ,圍墻建造費(fèi),12.39 ,12.39 ,12.39 ,24.79 ,0.00 ,0.00 ,1.61 ,26.40 ,5 ,室外照明,5.07 ,5.07 ,5.07 ,10.14 ,0.00 ,0.00 ,0.66 ,10.80 ,6 ,室外零星工程,4.69 ,4.69 ,4.69 ,9.39 ,0.00 ,0.00 ,0.61 ,10.00 ,7 ,其他,0.00 ,0.00 ,0.00 ,0.00 ,0

10、.00 ,0.00 ,0.00 ,0.00 ,七,配套設(shè)施費(fèi),112.68 ,112.68 ,112.68 ,225.35 ,0.00 ,0.00 ,14.65 ,240.00 ,1 ,游泳池,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,表中公式把該項(xiàng)成本按可售面積在所有產(chǎn)品類型中分?jǐn)?。若不是在所有產(chǎn)品類型中分?jǐn)傉?qǐng)修改公式,1 ,會(huì)所,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,2 ,幼兒園,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,3

11、,學(xué)校,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,5 ,球場(chǎng),0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,6 ,地下停車場(chǎng),112.68 ,112.68 ,112.68 ,225.35 ,0.00 ,0.00 ,14.65 ,240.00 ,7 ,車站建造費(fèi),0.00 ,0.00 ,0.00 ,0.00 ,8 ,其他,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,八,開(kāi)發(fā)間接費(fèi),138.33 ,138.33 ,138.33 ,276.65

12、,0.00 ,0.00 ,17.98 ,294.64 ,1 ,工程管理費(fèi),17.11 ,17.11 ,17.11 ,34.23 ,0.00 ,0.00 ,2.22 ,36.45 ,表中公式把該項(xiàng)成本按可售面積在所有產(chǎn)品類型中分?jǐn)?。若不是在所有產(chǎn)品類型中分?jǐn)傉?qǐng)修改公式,2 ,資本化利息,19.01 ,19.01 ,19.01 ,38.03 ,0.00 ,0.00 ,2.47 ,40.50 ,3 ,營(yíng)銷設(shè)施建造費(fèi),46.58 ,46.58 ,46.58 ,93.17 ,0.00 ,0.00 ,6.06 ,99.23 ,4 ,物業(yè)完善費(fèi),36.60 ,36.60 ,36.60 ,73.20 ,0.0

13、0 ,0.00 ,4.76 ,77.96 ,5 ,不可預(yù)見(jiàn)費(fèi),19.01 ,19.01 ,19.01 ,38.03 ,0.00 ,0.00 ,2.47 ,40.50 ,開(kāi)發(fā)成本單價(jià),3777.08 ,4356.05 ,900.00 ,3981.43 ,7554.16 ,0.00 ,0.00 ,566.29 ,360.00 ,8480.45 ,銷售單價(jià)（元/m2）,4,500 ,6,000 ,1,800 ,4,930 ,銷售面積（m2),20000.00 ,1300.00 ,4000.00 ,21300.00 ,營(yíng)業(yè)收入（萬(wàn)元）,9,000 ,780 ,720 ,10,500 ,9,951 ,

14、營(yíng)業(yè)稅及附加5%（元/m2),450 ,0 ,0 ,39 ,36 ,525 ,560 , 開(kāi)發(fā)成本單價(jià)（元/m2）,3,777 ,4,356 ,900 ,3,981 ,開(kāi)發(fā)成本（萬(wàn)元）,7,554 ,566 ,360 ,8,480 ,7,910 ,項(xiàng)目利潤(rùn)(萬(wàn)元）,996 ,175 ,324 ,1,495 ,1,481 ,期間費(fèi)用（萬(wàn)元）,300 ,20 ,60 ,304 ,320 , 其中：管理費(fèi)用（萬(wàn)元）,300 ,0 ,0 ,20 ,60 ,304 , 銷售費(fèi)用, 財(cái)務(wù)費(fèi)用, 稅前利潤(rùn)（萬(wàn)元）,696 ,155 ,264 ,1,191 ,1,161 ,所得稅（33%）（萬(wàn)元）,230 ,0 ,0 ,51 ,87 ,393 ,778 ,稅后利潤(rùn)（萬(wàn)元）,466 ,104 ,177 ,798 ,單位毛利(元/m2),498