房地產項目成本利潤分產品類型成本匯總測算表.xls
下載文檔
上傳人:l**
編號:614092
2022-10-26
4頁
55.54KB
1、分分產產品品類類型型成成本本匯匯總總表表序號成本項目可售面積單位成本總成本(萬元)小高層高層商鋪棉紡市場區公寓酒店地下室平均小高層建筑面積53767.50 66493.1018315.7045733.50 22294.30 31490.40*53,767.50可售面積51079.13 63168.4517583.0743904.16 21402.53 31490.40*51,079.13一一 土土地地獲獲得得價價款款970.63970.63970.63970.63970.63970.63970.634,957.871政府地價及相關費用970.63970.63970.63970.63970.632、970.63970.634,957.87二二 開開發發前前期期準準備備費費121.21121.21121.21121.21121.21121.21121.21619.111勘察設計費40.4040.4040.4040.4040.4040.4040.40206.352市政配套費51.6551.6551.6551.6551.6551.6551.65263.843報批報建增容費20.4120.4120.4120.4120.4120.4120.41104.274三通一平費7.157.157.157.157.157.157.1536.525臨時設施費1.591.591.591.591.591.591.53、98.14三三 主主體體建建筑筑工工程程費費757.89821.05833.331145.83885.421600.00983.573,871.26四四 主主體體安安裝裝工工程程費費126.32157.89187.50229.17208.33176.99174.16645.21五五 基基礎礎設設施施工工程程費費123.01123.01123.01123.01123.01123.01123.01628.341室外給排水系統42.5142.5142.5142.5142.5142.5142.51217.142室外采暖系統0.000.000.000.000.000.000.00-3室外燃氣系統0.004、0.000.000.000.000.000.00-4室外高低壓線路74.3974.3974.3974.3974.3974.3974.39379.995室外智能化系統6.116.116.116.116.116.116.1131.216其他0.000.000.000.000.000.000.00-六六 園園林林環環境境費費54.9654.9654.9654.9654.9654.9654.96280.731綠化建設費7.827.827.827.827.827.827.8239.952建筑小品29.6729.6729.6729.6729.6729.6729.67151.573道路廣場建造費6.076.5、076.076.076.076.076.0731.004圍墻建造費6.616.616.616.616.616.616.6133.785室外照明2.662.662.662.662.662.662.6613.576室外零星工程2.132.132.132.132.132.132.1310.867其他0.000.000.000.000.000.000.00-七七 公公建建配配套套設設施施費費14.6314.6314.6314.6314.6314.6314.6374.741會所6.646.646.646.646.646.646.6433.922設備用房7.997.997.997.997.997.997.6、9940.823其他0.000.000.000.000.000.000.00-八八 開開發發間間接接費費93.0093.0093.0093.0093.0093.0093.00475.061工程管理費5.535.535.535.535.535.535.5328.232資本化利息87.4887.4887.4887.4887.4887.4887.48446.833營銷設施建造費0.000.000.000.000.000.000.00-4物業完善費0.000.000.000.000.000.000.00-5不可預見費0.000.000.000.000.000.000.00-開開發發成成本本2261.67、52356.392398.282752.442471.193154.442535.1711552.33九九 期期間間費費用用198.21198.21198.21198.21198.21198.21198.211,012.461管理費用63.3863.3863.3863.3863.3863.3863.38323.742銷售費用107.95107.95107.95107.95107.95107.95107.95551.403招商費用0.000.000.00140.000.000.0026.88十十 流流轉轉稅稅費費215.89248.60527.94527.94301.6872.64297.1518、,102.73營業稅165.00190.00350.00350.00200.0048.15208.84842.81教育附加稅4.955.7010.5010.506.001.446.2725.28城市建設稅11.5513.3024.5024.5014.003.3714.6259.00土地增值稅33.0038.00140.00140.0080.0019.2665.67168.56印花稅1.391.602.942.941.680.401.757.08十十一一企企業業所所得得稅稅163.35188.10346.50346.50198.0047.67206.76834.38項項目目總總投投資資2839.9、102991.303470.933825.103169.093472.963237.2914,501.89凈凈利利潤潤460.90808.703529.073174.90830.91(2509.87)939.592,354.22分攤標準說明高層商鋪棉紡市場區 公寓酒店地下室合計66,493.1018,315.7045,733.5022,294.3031,490.40238,094.5063,168.4517,583.0743,904.1621,402.5331,490.40228,627.736,131.291,706.664,261.452,077.383,056.5422,191.20表中10、公式把地價按可售面積進行分攤。若按占地面積分攤地價,請修改公式。若地價不是在所有產品類型中分攤亦請修改公式6,131.291,706.664,261.452,077.383,056.5422,191.20765.65213.12532.15259.41381.692,771.13255.1971.03177.3786.46127.22923.62表中公式把該項成本按可售面積在所有產品類型中分攤。若不是在所有產品類型中分攤請修改公式326.2890.82226.78110.55162.661,180.92128.9435.8989.6243.6964.28466.6945.1612.5731.311、915.3022.51163.4510.072.807.003.415.0236.455,186.461,465.265,030.691,895.025,038.4622,487.14997.40329.681,006.14445.89557.363,981.67777.06216.30540.08263.28387.382,812.44268.5374.75186.6490.98133.87971.90表中公式把該項成本按可售面積在所有產品類型中分攤。若不是在所有產品類型中分攤請修改公式-469.93130.81326.62159.22234.271,700.8338.6010.7426.812、313.0819.24139.71-347.1796.64241.29117.63173.071,256.5249.4013.7534.3316.7424.63178.79表中公式把該項成本按可售面積在所有產品類型中分攤。若不是在所有產品類型中分攤請修改公式187.4552.18130.2863.5193.45678.4438.3410.6726.6412.9919.11138.7541.7811.6329.0414.1520.83151.2016.784.6711.665.698.3760.7413.433.749.334.556.6948.60-92.4325.7364.2431.324613、.08334.5441.9511.6829.1614.2120.91151.8450.4814.0535.0817.1025.16182.70-587.50163.53408.33199.05292.882,126.3534.919.7224.2611.8317.40126.35表中公式把該項成本按可售面積在所有產品類型中分攤。若不是在所有產品類型中分攤請修改公式552.59153.81384.07187.23275.472,000.00-14884.954,216.9112,084.375,288.989,933.4557,960.991,252.09348.52870.24424.236214、4.184,531.72總成本(萬元)400.36111.44278.26135.65199.581,449.02表中公式把該項成本按可售面積在所有產品類型中分攤。若不是在所有產品類型中分攤請修改公式681.90189.81473.95231.04339.942,468.04614.66614.661,570.34928.282,317.88645.67228.736,793.631,200.20615.411,536.65428.05151.644,774.75 銷售額5.00%36.0118.4646.1012.844.55143.24 營業稅3.00%84.0143.08107.5729.9610.61334.23 營業稅7.00%240.04246.16614.66171.2260.661,501.30銷售收入1(2%)10.085.1712.913.601.2740.11銷售收入1.4*0.31,188.20609.251,521.28423.77150.124,727.00銷銷售售收收入入1515.00%*3318,895.586,102.9616,793.776,782.6510,936.4974,013.345,108.436,205.1913,939.141,778.36-7,903.6921,481.65