房地产项目建设成本测算表(自动计算)

,地块成本汇总表,,,,,,,,,,,,,,

,序号,成本项目,可售面积单位成本,,,,,,总成本（万元）,,,,,,分摊标准说明

,,,16层住宅,类型2,类型3,商业,地下停车场,平均,16层住宅,类型2,类型3,商业,地下停车场,合计,

,,建筑面积,*,*,*,*,,*,20000.00,0.00,0.00,1300.00,4000.00,21300.00,

,,可售面积,*,*,*,*,,*,20000.00,0.00,0.00,1300.00,4000.00,21300.00,

,一,土地获得价款,1569.04,,,1569.04,,1569.04,3138.08,0.00,0.00,203.98,,3342.06,

,1,政府地价及相关费用,1569.04,,,1569.04,,1569.04,3138.08,0.00,0.00,203.98,,3342.06,表中公式把地价按可售面积进行分摊。若按占地面积分摊地价，请修改公式。若地价不是在所有产品类型中分摊亦请修改公式

,2,合作款项,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,3,红线外市政设施,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,4,拆迁补偿费,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,二,开发前期准备费,240.17,,,240.17,,240.17,480.34,0.00,0.00,31.22,,511.57,

,1,勘察设计费,76.06,,,76.06,,76.06,152.11,0.00,0.00,9.89,,162.00,表中公式把该项成本按可售面积在所有产品类型中分摊。若不是在所有产品类型中分摊请修改公式

,2,报批报建增容费,137.85,,,137.85,,137.85,275.70,0.00,0.00,17.92,,293.63,

,3,三通一平费,23.47,,,23.47,,23.47,46.95,0.00,0.00,3.05,,50.00,

,4,临时设施费,2.79,,,2.79,,2.79,5.58,0.00,0.00,0.36,,5.94,

,三,主体建筑工程费,1314.56,,,1999.83,750.00,1497.23,2629.11,0.00,0.00,259.98,300.00,3189.09,

,1,基础工程,19.65,,,153.08,,27.80,39.31,0.00,0.00,19.90,,59.21,按产品类型实发生额计算

,2,结构及粗装修,842.75,,,982.75,750.00,992.14,1685.50,0.00,0.00,127.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,室内装修,130.41,,,0.00,,122.45,260.82,0.00,0.00,0.00,,260.82,

,四,主体安装工程费,268.47,,,162.16,150.00,290.15,536.94,0.00,0.00,21.08,60.00,618.02,

,1,室内水暖气电,128.50,,,128.50,150.00,156.67,257.00,0.00,0.00,16.71,60.00,333.71,按产品类型实发生额计算

,2,设备及安装费,117.00,,,30.00,,111.69,234.00,0.00,0.00,3.90,,237.90,

,3,弱电系统,22.97,,,3.66,,21.79,45.94,0.00,0.00,0.48,,46.42,

,五,社区管网工程费,77.68,,,77.68,,77.68,155.37,0.00,0.00,10.10,,165.47,

,1,室外给排水系统,13.44,,,13.44,,13.44,26.87,0.00,0.00,1.75,,28.62,表中公式把该项成本按可售面积在所有产品类型中分摊。若不是在所有产品类型中分摊请修改公式

,2,室外采暖系统,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,3,室外燃气系统,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,室外智能化系统,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,

,六,园林环境费,56.15,,,56.15,,56.15,112.31,0.00,0.00,7.30,,119.61,

,1,绿化建设费,7.86,,,7.86,,7.86,15.72,0.00,0.00,1.02,,16.74,表中公式把该项成本按可售面积在所有产品类型中分摊。若不是在所有产品类型中分摊请修改公式

,2,建筑小品,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,3,道路广场建造费,26.14,,,26.14,,26.14,52.27,0.00,0.00,3.40,,55.67,

,4,围墙建造费,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.00,0.00,0.00,,0.00,

,七,配套设施费,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,表中公式把该项成本按可售面积在所有产品类型中分摊。若不是在所有产品类型中分摊请修改公式

,1,会所,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,学校,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,5,球场,0.00,,,0.00,,0.00,0.00,0.00,0.00,0.00,,0.00,

,6,地下停车场,112.68,,,112.68,,112.68,225.35,0.00,0.00,14.65,,240.00,

,7,车站建造费,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,

,八,开发间接费,138.33,,,138.33,,138.33,276.65,0.00,0.00,17.98,,294.64,

,1,工程管理费,17.11,,,17.11,,17.11,34.23,0.00,0.00,2.22,,36.45,表中公式把该项成本按可售面积在所有产品类型中分摊。若不是在所有产品类型中分摊请修改公式

,2,资本化利息,19.01,,,19.01,,19.01,38.03,0.00,0.00,2.47,,40.50,

,3,营销设施建造费,46.58,,,46.58,,46.58,93.17,0.00,0.00,6.06,,99.23,

,4,物业完善费,36.60,,,36.60,,36.60,73.20,0.00,0.00,4.76,,77.96,

,5,不可预见费,19.01,,,19.01,,19.01,38.03,0.00,0.00,2.47,,40.50,

,,开发成本单价,3777.08,,,4356.05,900.00,3981.43,7554.16,0.00,0.00,566.29,360.00,8480.45,

,,销售单价（元/m2）,"4,500",,,"6,000","1,800","4,930",,,,,,,

,,销售面积（m2),20000.00,,,1300.00,4000.00,21300.00,,,,,,,

,,营业收入（万元）,"9,000",,,780,720,"10,500","9,951",,,,,,

,,营业税及附加5%（元/m2),450,0,0,39,36,525,560,,,,,,

,,开发成本单价（元/m2）,"3,777",,,"4,356",900,"3,981",,,,,,,

,,开发成本（万元）,"7,554",,,566,360,"8,480","7,910",,,,,,

,,项目利润(万元）,996,,,175,324,"1,495","1,481",,,,,,

,,期间费用（万元）,300,,,20,60,304,320,,,,,,

,,其中：管理费用（万元）,300,0,0,20,60,304,,,,,,,

,,销售费用,,,,,,,,,,,,,

,,财务费用,,,,,,,,,,,,,

,,税前利润（万元）,696,,,155,264,"1,191","1,161",,,,,,

,,所得税（33%）（万元）,230,0,0,51,87,393,778,,,,,,

,,税后利润（万元）,466,,,104,177,798,,,,,,,

,,单位毛利(元/m2),498,,,"1,344",810,702,,,,,,,

,,单位净利(元/m2),233,,,800,442,374,,,,,,,

,,销售毛利率%,11.1