[浙江]房地产项目测算表表格自动计算.xls

《[浙江]房地产项目测算表表格自动计算.xls》由会员分享，可在线阅读，更多相关《[浙江]房地产项目测算表表格自动计算.xls（33页珍藏版）》请在沃文网上搜索。

1、浙浙江江舟舟山山定定海海项项目目成成本本利利润润汇汇总总表表序号分项工程金额（元）按总建筑面积单方指标（元/）一、销售收入448320810二、土地费用及契税162424987.92937.59三、建筑安装成本费用1620267592930.392.1前期费用11531127.712.2基础设施配套费用18521494.432.3间接费用3947660.072.4地上建安费用854228802.5地下建安费用42603596.75四、其他费用（财务、管理、营销、不可预见、税金）84748414.771532.75五、利润39120648.41707.53六、利润率8.73%1 1、未未考考虑虑

2、蓝蓝城城的的代代建建费费用用；2 2、建建安安成成本本按按毛毛坯坯房房考考虑虑；3 3、部部分分费费用用的的标标准准暂暂按按河河南南标标准准记记取取按计容面积单方指标（元/）4066.404056.432121.72979.411 1、未未考考虑虑蓝蓝城城的的代代建建费费用用；2 2、建建安安成成本本按按毛毛坯坯房房考考虑虑；3 3、部部分分费费用用的的标标准准暂暂按按河河南南标标准准记记取取浙浙江江舟舟山山定定海海项项目目成成本本测测算算表表序序号号分分项项名名称称单单位位数数量量单单价价合合计计一一、土土地地费费用用162424987.85162424987.851土地费用亩27.2357

3、20896.07155779999.992契税元164073774.494%6562950.983印花税元164073774.50.000582036.89二二、前前期期费费用用11531127.7111531127.711项目可行性研究报告费55291.830.844233.462三通一平55291.8315829377.453地质勘探费18156590780.004文物勘探费18156472624.005规划设计费55291.835276459.156日照分析费39943.2139943.207指标核算费55291.831.582937.758施工图设计费55291.8311608210.

4、139人防工程设计费及图审费6548.6327176813.0111图纸审查费55291.832.5138229.5812防雷检测费55291.83155291.8313地震安全性评价费39943.200.0014室内环境监测39943.21.559914.8015环境评价费用55291.83155291.8316景观施工图设计费1375628385168.0017大门开口费350000150000.0018土地勘界测绘费55291.83155291.8319水土保持方案编制项18000080000.0020水土保持补偿流失费181561.221787.2021规划高程点（标高测绘）个1300

5、03000.0022放线费栋6200012000.0023市政配套费用元55291.831508293774.50三三、基基础础设设施施配配套套费费18521494.4318521494.431电力工程费55291.83904976264.702给水工程费55291.83392156381.373排水工程费55291.83201105836.604燃气工程费户44430001332000.005热力工程费55291.83502764591.506景观绿化费137563504814600.007有线电视工程建设费户444350155400.008智能化工程费55291.8315829377.45

6、9网络管道预埋费55291.832110583.6610室外亮化工程55291.835276459.15四四、间间接接费费用用3947660.073947660.071监理费用55291.837387042.812造价咨询费55291.832.5138229.583基坑、沉降观测费55291.832.5138229.584桩基、土壤氡检测费栋622000132000.005排污费55291.835276459.156测绘费（预测、实测)39943.23119829.607竣工验收规划复核平面及坐标 栋44460002664000.008竣工验收地上建筑面积测绘 39943.21.559914.

7、809房产初始登记费39943.20.831954.56五五、地地上上建建筑筑工工程程费费85422880.0085422880.001独栋住宅0.000.002联排住宅0.000.003叠加住宅0.000.004普通多层住宅0.000.00511层以下洋房住宅0.000.00618层及以下小高层住宅38283.71215082309976.50727层以下高层住宅0.000.00827层以上住宅0.000.009临街商业1000.0018001800000.0010物业管理用房279.602150601140.0011社区便民店/服务站79.892150171763.5012垃圾收集站0.0

8、00.0013幼儿园0.000.0014其它(设备用房)300.001800540000.00六六、地地下下车车库库工工程程42603596.7542603596.751地下车库工程6548.63270017681301.002人防地下车库工程4400.00320014080000.003主楼地下工程4400.0021509460000.004售楼部、样板房工程55291.83251382295.75七七、（一一）（六六）成成本本小小计计324451746.82324451746.82八八、其其他他费费用用84748414.7784748414.771营销费用元4483208102.50%11

9、208020.252管理费用元4483208102.50%11208020.253财务费用元4483208102.50%11208020.254综合税率元44832081010.50%47073685.055不可预见费元1620267592.50%4050668.97九九、（五五）（十十一一）小小计计409200161.59409200161.59十、销售收入元448320810十十一一、利利润润元元39120648.4139120648.41十二、利润率按按总总面面积积单单方方造造价价备备注注4066.404066.40208.55208.55334.98334.9871.4071.4015

10、44.951544.95770.52770.525867.995867.991532.751532.75280.60280.60280.601178.52101.417400.737400.73707.53707.538.73%浙浙江江舟舟山山定定海海项项目目规规划划指指标标序号分项指标名称单位数量备注1规划净用地面积18156.002总建筑面积55291.833地上总建筑面积39943.203.1独栋住宅3.2联排住宅3.3叠加住宅3.4普通多层住宅3.511层以下洋房住宅3.618层及以下小高层住宅38283.713.727层以下高层住宅0.003.827层以上住宅0.003.9临街商业1

11、000.003.1物业管理用房279.603.11社区便民店/服务站79.893.12垃圾收集站3.13幼儿园3.14其它(设备用房)300.004地下总建筑面积15348.634.1主楼地下室面积4400.004.2地下车库面积6548.634.3人防面积44005基地占地面积44006景观道路占地面积137568户数户4449楼栋栋610地上停车位辆3111地下停车位辆28812容积率13建筑密度27.23427234浙浙江江舟舟山山定定海海项项目目成成本本测测算算表表销销售售收收入入表表序号可销售项目单位可销售面积销售单价合计1独栋住宅02联排住宅03叠加住宅04普通多层住宅0511层以

12、下洋房住宅0618层及以下小高层住宅38283.7111000421120810727层以下高层住宅000827层以上住宅0009临街商业1000200002000000010地下车位辆28850000720000011地下储藏室合计元448320810备注暂未考虑20212021年年项项目目目目标标成成本本核核对对一一季季度度一一、现现金金流流入入448,320,810403,488,729-1销销售售回回款款（不不含含税税价价）411,303,495370,173,1462销销售售回回款款（销销项项税税）37,017,31529,613,852二二、现现金金流流出出-（一）土土地地款款及及

13、工工程程款款支支付付1土地征用及拆迁费用162,424,9882前期工程费用（价）11,531,1281,729,6693基础设施建设费用（价）18,521,4944建筑安装工程费用（价）-独栋住宅-联排住宅-叠加住宅-普通多层-带电梯多层-高层-A类（18层以下）85,422,880高层-B类（18层-33层）-地下车库42,603,5975公共配套设施建设费用（价）-6进项税（二）期期间间费费用用37,571,721-1管理服务费（价）11,208,020-2开发间接费用（价）3,947,660-3销售费用（价）11,208,020-4财务费用（价）11,208,020-5进项税-（三）税

14、税金金13,819,797-1预缴增值税12,339,105-补缴增值税-2增值税附加税1,480,693-3预缴土地增值税00补缴土地增值税4预缴所得税-补缴所得税三三、净净现现金金流流-四四、累累计计净净现现金金流流-五五、资资金金占占用用费费-资资金金占占用用率率0%MOICIRR6%ROE9%资金峰值-备备注注：1.1.补补缴缴增增值值税税=（销销售售回回款款累累计计数数-土土地地款款允允许许抵抵减减金金额额）/1./1.0909*0.*0.0909-增增值值税税进进项项税税累累计计数数-预预缴缴增增值值税税累累计计数数2.2.增增值值税税附附加加税税及及土土地地增增值值税税须须手手工

15、工录录入入，否否则则会会出出现现循循环环引引用用公公式式链链接接错错误误3.IRR3.IRR为为内内部部收收益益率率，就就是是资资金金流流入入现现值值总总额额与与资资金金流流出出现现值值总总额额相相等等，即即净净现现值值为为零零时时的的折折现现率率。各各项项目目公公司司自自行行计计算算，将将结结果果填填到到3232行行C C列列。2021年一季度净现金流-累计净现金流-20222022年年二二季季度度三三季季度度四四季季度度一一季季度度二二季季度度-44,832,08144,832,081-41,130,35041,130,350-3,701,7313,701,73111,320,512202

16、,252,21714,665,58149,744,125-11,320,512202,252,21714,665,58143,430,616-162,424,988-1,729,6693,459,3382,778,2241,852,1491,852,1493,704,299-8,542,28812,813,43212,813,43221,355,720-23,431,97814,911,259-3,362,4063,441,359-1,120,8021,120,802-78,953-1,120,8021,120,802-1,120,8021,120,802-2,951,1032,951,103

17、-1,233,9101,233,910-148,069148,069000896641.62896641.62-672,481672,481-11,320,512-202,252,217-14,665,581-4,912,04444,832,081-11,320,512-213,572,729-228,238,310-233,150,354-188,318,27320212021年年-2022年二季度三季度四季度一季度二季度-11,320,512-202,252,217-14,665,581-4,912,04444,832,081-11,320,512-213,572,729-228,238,

18、310-233,150,354-188,318,273一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度-250,000,000 -200,000,000 -150,000,000 -100,000,000 -50,000,000 -50,000,000 100,000,000 150,000,000 净现金流 累计净现金流 1.1.补补缴缴增增值值税税=（销销售售回回款款累累计计数数-土土地地款款允允许许抵抵减减金金额额）/1./1.0909*0.*0.0909-增增值值税税进进项项税税累累计计数数-预预缴缴增增值值税税累

19、累计计数数3.IRR3.IRR为为内内部部收收益益率率，就就是是资资金金流流入入现现值值总总额额与与资资金金流流出出现现值值总总额额相相等等，即即净净现现值值为为零零时时的的折折现现率率。各各项项目目公公司司自自行行计计算算，将将结结果果填填到到3232行行C C列列。2021年20232023年年三三季季度度四四季季度度一一季季度度二二季季度度三三季季度度44,832,08144,832,08144,832,08144,832,08144,832,08141,130,35041,130,35041,130,35041,130,35041,130,3503,701,7313,701,7313,

20、701,7313,701,7313,701,731-6,392,46216,097,57410,663,60611,589,68123,084,316-9,705,1124,271,1445,197,219-2,306,2261,729,6693,704,2993,704,299926,075-12,813,4324,271,1444,271,1444,271,144-4,260,360-3,441,3593,441,3593,441,3593,441,3593,441,3591,120,8021,120,8021,120,8021,120,8021,120,80278,95378,95378

21、,95378,95378,9531,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,802-2,951,1032,951,1032,951,1032,951,1032,951,1031,233,9101,233,9101,233,9101,233,9101,233,910148,069148,069148,069148,069148,069896641.62896641.62896641.62896641.62896641.62672,481672,481672,48167

22、2,481672,48144,832,08138,439,61928,734,50734,168,47533,242,400-143,486,192-105,046,573-76,312,066-42,143,591-8,901,19020222022年年-2023年三季度四季度一季度二季度三季度44,832,08138,439,61928,734,50734,168,47533,242,400-143,486,192-105,046,573-76,312,066-42,143,591-8,901,1902022年一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二

23、季度三季度四季度一季度二季度三季度四季度-250,000,000 -200,000,000 -150,000,000 -100,000,000 -50,000,000 -50,000,000 100,000,000 150,000,000 净现金流 累计净现金流 20242024年年四四季季度度一一季季度度二二季季度度三三季季度度44,832,08144,832,08144,832,081-41,130,35041,130,35041,130,3503,701,7313,701,7313,701,73111,240,1626,392,4626,392,462157,9064,847,70057

24、6,556-4,271,144-3,441,3593,441,3593,441,359157,9061,120,8021,120,8021,120,802-78,95378,95378,953157,9061,120,8021,120,8021,120,802-1,120,8021,120,8021,120,802-2,951,1032,951,1032,951,103-1,233,9101,233,9101,233,910-148,069148,069148,069-896641.62896641.62896641.620672,481672,481672,481-33,591,91938,

25、439,61938,439,619-157,90624,690,72963,130,348101,569,967101,412,060-#NUM!2024年四季度一季度二季度三季度33,591,91938,439,61938,439,619-157,90624,690,72963,130,348101,569,967101,412,060一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度-250,000,000 -200,000,000 -150,000,000 -100,000,000 -50,000,000 -50,00

26、0,000 100,000,000 150,000,000 净现金流 累计净现金流 20252025年年四四季季度度一一季季度度二二季季度度三三季季度度四四季季度度-157,906157,906157,906157,906157,906-157,906157,906157,906157,906157,906-157,906157,906157,906157,906157,906-00000-157,906-157,906-157,906-157,906-157,906101,254,154101,096,248100,938,341100,780,435100,622,528-2025年四季度一季度二季度三季度四季度-157,906-157,906-157,906-157,906-157,906101,254,154101,096,248100,938,341100,780,435100,622,528-448,320,810-411,303,495-37,017,315-162,424,988-11,531,128-18,521,494-37,571,721-11,208,020-3,947,660-11,208,020-11,208,020-13,819,797-12,339,105-1,480,693-