非常详尽的成本利润测算表表格文件下载.xls

非常详尽的成本利润测算表表格文件下载.xls

《非常详尽的成本利润测算表表格文件下载.xls》由会员分享，可在线阅读，更多相关《非常详尽的成本利润测算表表格文件下载.xls（45页珍藏版）》请在冰豆网上搜索。

聚泰花园项目成本利润测算编制人：

@#@林佩生编制时间：

@#@编制说明1、未建项目依据“*项目规划设计方案”；@#@2、参照周边项目工程费用；@#@3、财务费用及税费主要由财务部提供；@#@4、销售均价及销售费用由销售提供；@#@5、前期、规费依据*地区目前情况编制；@#@6、主要项目成本测算详见成本汇总表所示；@#@、整个项目销售总额为12.9亿元，总投资8.7亿元，利润4.2亿元，销售利润率32.56，单方总成本指标4064.3元，净利润2026.06元。

@#@其中：

@#@序号费用名称可售单方指标备注1土地费用1025.312建造费用1774.02含建安、管网、园林、配套3税金费用734.17含流转税费、所得税4其他费用530.8含设计、销售、前期、管理、财务5合计4064.3规规划划指指标标总占地面积113195.68m2建筑用地面积113195.68m2总建筑面积242,975m2建筑物占地面积33619.12m2建筑密度29.70%绿地率35.1%计容积率面积211675.9m2容积率1.87可售单价元/平米道路广场用地合计沥青路面车行道砼路面车行道硬质铺装车行道硬质铺装广场硬质铺装人行道7500绿化用地合计重要公共绿地组团宅间绿化底层私家花园体育（游乐）设施占地水景占地面积39732产产品品构构成成建建筑筑面面积积可可售售面面积积可可售售单单价价可可售售总总额额产产品品比比例例平平均均每每户户面面积积单单元元数数户户数数住宅小高层53767.551,0793,30016,8560.95高层66493.163,1683,80024,0040.95小小计计120260.6114,2487,10040,8600.95公共配套建筑商铺18315.717,5837,00012,308棉纺市场区45733.543,9047,00030,733公寓酒店22294.321,4034,0008,561会所1168辅助用房1660.9成本核算说明需分摊所有八大类费用小小计计89172.482,89051,602成本全部摊入可售部分，不单独保留成本建建筑筑面面积积车车位位数数可可售售单单价价可可售售总总额额成本全部摊入可售部分，不单独保留成本半地下室15201.3成本全部摊入可售部分，不单独保留成本地下自行车库6881.7人防地下室9407.4地地下下室室31490.431490.4停车地下车位44680,0003,033只分摊主体建安成本，或保留定额成本地面车库4000根据是否可售及收入配比原则自行确定屋顶车位4440小小计计1,2903,033合合计计240923.4240923.4197,13795,495分分产产品品类类型型成成本本汇汇总总表表序号成本项目可售面积单位成本总成本（万元）小高层高层商铺棉纺市场区公寓酒店地下室平均小高层高层商铺棉纺市场区公寓酒店地下室合计建筑面积53767.5066493.1018315.7045733.5022294.3031490.40*53,767.5066,493.1018,315.7045,733.5022,294.3031,490.40238,094.50可售面积51079.1363168.4517583.0743904.1621402.5331490.40*51,079.1363,168.4517,583.0743,904.1621,402.5331,490.40228,627.73一一土土地地获获得得价价款款970.63970.63970.63970.63970.63970.63970.634,957.876,131.291,706.664,261.452,077.383,056.5422,191.20二二开开发发前前期期准准备备费费121.21121.21121.21121.21121.21121.21121.21619.11765.65213.12532.15259.41381.692,771.13三三主主体体建建筑筑工工程程费费757.89821.05833.331145.83885.421600.00983.573,871.265,186.461,465.265,030.691,895.025,038.4622,487.14四四主主体体安安装装工工程程费费126.32157.89187.50229.17208.33176.99174.16645.21997.40329.681,006.14445.89557.363,981.67五五基基础础设设施施工工程程费费123.01123.01123.01123.01123.01123.01123.01628.34777.06216.30540.08263.28387.382,812.441室外给排水系统42.5142.5142.5142.5142.5142.5142.51217.14268.5374.75186.6490.98133.87971.902室外采暖系统0.000.000.000.000.000.000.00-3室外燃气系统0.000.000.000.000.000.000.00-4室外高低压线路74.3974.3974.3974.3974.3974.3974.39379.99469.93130.81326.62159.22234.271,700.835室外智能化系统6.116.116.116.116.116.116.1131.2138.6010.7426.8313.0819.24139.716其他0.000.000.000.000.000.000.00-六六园园林林环环境境费费54.9654.9654.9654.9654.9654.9654.96280.73347.1796.64241.29117.63173.071,256.521绿化建设费7.827.827.827.827.827.827.8239.9549.4013.7534.3316.7424.63178.792建筑小品29.6729.6729.6729.6729.6729.6729.67151.57187.4552.18130.2863.5193.45678.443道路广场建造费6.076.076.076.076.076.076.0731.0038.3410.6726.6412.9919.11138.754围墙建造费6.616.616.616.616.616.616.6133.7841.7811.6329.0414.1520.83151.205室外照明2.662.662.662.662.662.662.6613.5716.784.6711.665.698.3760.746室外零星工程2.132.132.132.132.132.132.1310.8613.433.749.334.556.6948.607其他0.000.000.000.000.000.000.00-七七公公建建配配套套设设施施费费14.6314.6314.6314.6314.6314.6314.6374.7492.4325.7364.2431.3246.08334.541会所6.646.646.646.646.646.646.6433.9241.9511.6829.1614.2120.91151.842设备用房7.997.997.997.997.997.997.9940.8250.4814.0535.0817.1025.16182.703其他0.000.000.000.000.000.000.00-八八开开发发间间接接费费93.0093.0093.0093.0093.0093.0093.00475.06587.50163.53408.33199.05292.882,126.351工程管理费5.535.535.535.535.535.535.5328.2334.919.7224.2611.8317.40126.352资本化利息87.4887.4887.4887.4887.4887.4887.48446.83552.59153.81384.07187.23275.472,000.003营销设施建造费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.652356.392398.282752.442471.193154.442535.1711552.3314884.954,216.9112,084.375,288.989,933.4557,960.99九九期期间间费费用用198.21198.21198.21198.21198.21198.21198.211,012.461,252.09348.52870.24424.23624.184,531.721管理费用63.3863.3863.3863.3863.3863.3863.38323.74400.36111.44278.26135.65199.581,449.022销售费用107.95107.95107.95107.95107.95107.95107.95551.40681.90189.81473.95231.04339.942,468.043招商费用0.000.000.00140.000.000.0026.88614.66614.66十十流流转转税税费费215.89248.60527.94527.94301.6872.64297.151,102.731,570.34928.282,317.88645.67228.736,793.63营业税165.00190.00350.00350.00200.0048.15208.84842.811,200.20615.411,536.65428.05151.644,774.75教育附加税4.955.7010.5010.506.001.446.2725.2836.0118.4646.1012.844.55143.24城市建设税11.5513.3024.5024.5014.003.3714.6259.0084.0143.08107.5729.9610.61334.23土地增值税33.0038.00140.00140.0080.0019.2665.67168.56240.04246.16614.66171.2260.661,501.30印花税1.391.602.942.941.680.401.757.0810.085.1712.913.601.2740.11十十一一企企业业所所得得税税163.35188.10346.50346.50198.0047.67206.76834.381,188.20609.251,521.28423.77150.124,727.00项项目目总总投投资资2839.102991.303470.933825.103169.093472.963237.2914,501.8918,895.586,102.9616,793.776,782.6510,936.4974,013.34净净利利润润460.90808.703529.073174.90830.91（2509.87）939.592,354.225,108.436,205.1913,939.141,778.36-7,903.6921,481.65分摊标准说明表中公式把地价按可售面积进行分摊。

@#@若按占地面积分摊地价，请修改公式。

@#@若地价不是在所有产品类型中分摊亦请修改公式表中公式把该项成本按可售面积在所有产品类型中分摊。

@#@若不是在所有产品类型中分摊请修改公式表中公式把该项成本按可售面积在所有产品类型中分摊。

@#@若不是在所有产品类型中分摊请修改公式表中公式把该项成本按可售面积在所有产品类型中分摊。

@#@若不是在所有产品类型中分摊请修改公式表中公式把该项成本按可售面积在所有产品类型中分摊。

@#@若不是在所有产品类型中分摊请修改公式销售额5.00%营业税3.00%营业税7.00%销售收入1（2%）销售收