{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["项目开发指标","成本测算表","资金使用计划","销售计划","现金流估计","分析"],"not_rendered":{"external_links":1,"defined_names":1,"comments":7},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"项目开发指标","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"flags":["formulas_cached_only"]}
[]
[]
[]
["项目开发指标：",{"$nulls":4},"模型测算参数设置"]
["测算起始时间：",null,null,2006,null,null,"可销售量","销售单价：元"]
["测算周期：",null,null,"4年",null,"经济住宅（平方米）",{"v":95620,"d":"95,620"},3200]
["总占地面积(平方米）：",null,null,82000,null,"商品住宅（平方米）",{"v":40980,"d":"40,980"},4000]
["总建筑面积(平方米）：",null,null,190000,null,"商业配套（平方米）",{"v":21400,"d":"21,400"},5500]
["  地上建筑面积(平方米)：",null,null,164000,null,"车位（个）",700,40000]
["其中住宅面积（平方米）",null,null,136600,null,"土地费用",null," "]
["  配套公建(平方米)：",null,null,6000]
["  非配套公建(平方米)：",null,null,21400]
["  地下建筑面积(平方米)：",null,null,26000]
["  地下 车位(个)：",null,null,700,null,"贴现率",null,{"v":0.06,"d":"6.00%"}]
[]
["模型测算结果"]
["财务内部收益率(IRR):",null,null,{"v":0.07409141441849924,"d":"7%"},null,"转让费",8910]
["财务净现值(NPV )万元",null,null,{"v":298.3392249860816,"d":"298.3392"},null,"车位销售率",{"v":0.5,"d":"50%"}]
["预计利润:万元",null,null,{"v":2442.018900649993,"d":"2442.0189"}]
["总投资利润率",null,null,{"v":0.04828337634346913,"d":"4.83%"}]
["成本利润率",null,null,{"v":0.04230920642847853,"d":"4.23%"}]

{"sheet":"成本测算表","index":1,"n_rows":75,"n_cols":7,"rows_kept":75,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[66,4,70,5],[71,0,71,5],[72,0,72,5]],"flags":["formulas_cached_only"]}
[" "]
[" "]
[" "]
[" "]
["序号","费用项目","计算标准","投资/收益","单方成本（元/平方米）","备注"]
[1,"经济技术指标",{"$nulls":3}," "]
[" ","建设用地面积",82000,null," "," "]
[null," 总建筑面积",190000]
[null,"建筑面积（地上）",164000,null," "]
[null,"其中经济住宅面积",{"v":95620,"d":"95,620"}," "]
[null,"商品住宅面积",{"v":40980,"d":"40,980"}]
[null,"配套公建",6000,null," ","含托幼2000平方米"]
[null,"商业配套",21400]
[null,"地下建筑",26000,null,null,"车位按700个估"]
[2,"土地取得费用"," ",{"v":11575.04,"d":"11575"},{"v":609.2126315789475,"d":"609"}," "]
[null,"转让费",null,8910," "]
[null,"地价款",null,1827,null,"不含车库"]
[null,"契税","地价款4％",{"v":73.08,"d":"73"}," "]
[null,"基础设施建设费","160元/平方米",{"v":764.96,"d":"765"},null,"减半征收"]
[3,"建安工程费"," ",{"v":28540.4,"d":"28540"},{"v":1502.1263157894737,"d":"1502"}]
[null,"经济住宅","1440元/平方米",{"v":13769.28,"d":"13769"},null," "]
[null,"商品住宅","1440元/平方米",{"v":5901.12,"d":"5901"},null,"这里假定事先已确定30％部分。"]
[null,"商业配套","1500元/平方米",3210]
[null,"幼儿园","1200元/平方米",720,null," "]
[null,"地下建筑","1900元/平方米",4940,null,"车位按700个估"]
[4,"前期工程费"," ",{"v":1101.1842000000001,"d":"1101"},{"v":57.957063157894744,"d":"58"}]
[null,"市场调研及策划费","根据市场价格估算",50]
[null,"规划设计费","造价的2%",{"v":570.808,"d":"571"}]
[null,"勘察费","2元/平米",38]
[null,"竣工图费","规划设计费的10％",{"v":57.0808,"d":"57"}]
[null,"标底编制费","造价0.3%",{"v":85.6212,"d":"86"}]
[null,"招投标管理费","中标价0.05%",{"v":14.2702,"d":"14"}]
[null,"监理费","造价1%",{"v":285.404,"d":"285"}]
[5,"基础及配套设施费"," ",{"v":8126.6,"d":"8127"},{"v":427.7157894736842,"d":"428"}]
[null,"红线内管线","90元/平方米",1710,null," "]
[null,"红线外管线","233元/平方米",4431," "," "]
[null,"小区开闭站","450万元/座",0,null," "]
[null,"小区配电室","150万元/座",450,null,"约6万平方米/座"]
[null,"垃圾楼","60万元/座",60]
[null,"中水处理系统","10元/平方米",190]
[null,"燃气调压站","80万元/座",80]
[null,"壁挂炉","5800元/户*1400户",812," "," "]
[null,"小区道路","120元/道路平米",{"v":196.8,"d":"197"},null,"按用地面积计算"]
[null,"小区园林景观","12元/平方米",{"v":196.8,"d":"197"},null,"按地上面积计算"]
[null,"小区围墙","600元/平方米"," "]
[6,"不可预见费","2项～5项之和的2.5%",{"v":1233.580605,"d":"1234"},{"v":64.925295,"d":"65"}]
[7,"总投资","2项～6项之和",{"v":50576.80480500001,"d":"50577"},{"v":2661.937095,"d":"2662"}]
[8,"管理费","2项～5项之和的2.5％",{"v":1233.580605,"d":"1234"},{"v":64.925295,"d":"65"}]
[9,"财务费用","7项～8项之和的3.5%",{"v":1813.3634893500005,"d":"1813"},{"v":95.44018365000002,"d":"95"}," "]
[10,"可售面积"]
[null,"经济住宅",{"v":95620,"d":"95,620"}]
[null,"商品住宅",{"v":40980,"d":"40,980"}]
[null,"商业配套",21400]
[null,"车位(个)",700]
[11,"销售收入",null,{"v":60160.4,"d":"60160"}]
[null,"经济住宅",3200,{"v":30598.4,"d":"30598"},null,"销售率100％"]
[null,"商品住宅",4000,16392]
[null,"商业配套",5500,11770,null,"销售率100％"]
[null,"车位",40000,1400,null,"销售率50％，使用权"]
[12,"销售费用"," ",{"v":755.73,"d":"756"},{"v":39.775263157894734,"d":"40"}]
[null,"代理费（含）广告费","经济适用房按不计，商品住宅及商业按照2.5％计",{"v":704.05,"d":"704"},null,"按销售收入计算"]
[null,"测绘费","2*1.36元/平方米",{"v":51.68000000000001,"d":"52"}," ","按总建筑面积计算"]
[13,"税费","销售收入的5.55%",{"v":3338.9022,"d":"3339"},{"v":175.73169473684212,"d":"176"}]
[14,"项目总成本","7项+8项+9项+12项+13项",{"v":57718.38109935001,"d":"57718"},{"v":3037.8095315447376,"d":"3038"}]
[]
[15,"预计利润","11项-14项",{"v":2442.018900649993,"d":"2442"},{"v":128.52731056052596,"d":"129"}," ",{"v":1709.413230454995,"d":"1709"}]
[{"$nulls":4},"由于我公司仅分得利润的70％，即1709万元，因此实际总投资利润率为3.38％，成本利润率为2.96％。"]
[16,"总投资利润率","15项/7项",{"v":0.04828337634346913,"d":"4.83%"},null,null,{"v":0.033798363440428386,"d":"3.38%"}]
[17,"自有资金需求量","16项/9项"," "]
[18,"自有资金收益率","16项/10项"," "]
[17,"成本利润率","15项/14项",{"v":0.04230920642847853,"d":"4.23%"},null,null,{"v":0.02961644449993497,"d":"2.96%"}]
["注：本测算是在诸多情况不明朗的前提下进行估算，按照保守、谨慎的原则进行。"]
["    按可售建筑面积158000平方米（不含地下）计算，单方成本价为3653元/平方米；按地上、地下全部建筑面积190000平方米计算，单方成本价为3037元/平方米。"]
[null,null," "," "]
[{"$nulls":3}," ",3653.06209489557,3037.8095315447376]

{"sheet":"资金使用计划","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[0,5,0,8]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"年度使用比例"]
[null,null,"单价","总计",null,2005,2006,2007,2008]
[2,"土地取得费用",{"v":609.2126315789475,"d":"609"},{"v":11575.04,"d":"11575"},null,{"v":0.6,"d":"60.00%"},{"v":0.3,"d":"30.00%"},{"v":0.1,"d":"10.00%"}]
[3,"建安工程费",{"v":1502.1263157894737,"d":"1502"},{"v":28540.4,"d":"28540"},null,null,{"v":0.3,"d":"30.00%"},{"v":0.4,"d":"40.00%"},{"v":0.3,"d":"30.00%"}]
[4,"前期工程费",{"v":57.957063157894744,"d":"58"},{"v":1101.1842000000001,"d":"1101"},null,{"v":0.25,"d":"25.00%"},{"v":0.35,"d":"35.00%"},{"v":0.3,"d":"30.00%"},{"v":0.1,"d":"10.00%"}]
[5,"基础及配套设施费",{"v":427.7157894736842,"d":"428"},{"v":8126.6,"d":"8127"},null,null,{"v":0.2,"d":"20.00%"},{"v":0.5,"d":"50.00%"},{"v":0.3,"d":"30.00%"}]
[null,"小计",null,{"v":49343.224200000004,"d":"49343"}]
[6,"不可预见费","2项~~5项之和的2%",{"v":1233.580605,"d":"1234"},null,{"v":0.15,"d":"15.00%"},{"v":0.3,"d":"30.00%"},{"v":0.4,"d":"40.00%"},{"v":0.15,"d":"15.00%"}]
[7,"建设总投资","2项~~6项之和",{"v":50576.80480500001,"d":"50577"}]
[8,"管理费","2项～5项之和的2.5％",{"v":1233.580605,"d":"1234"},null,{"v":0.1,"d":"10.00%"},{"v":0.35,"d":"35.00%"},{"v":0.45,"d":"45.00%"},{"v":0.1,"d":"10.00%"}]
[9,"财务费用","7项～8项之和的4%",{"v":2072.4154164000006,"d":"2072"},null,{"v":0.1,"d":"10.00%"},{"v":0.35,"d":"35.00%"},{"v":0.45,"d":"45.00%"},{"v":0.1,"d":"10.00%"}]
[]
[null,"开发成本总计",null,{"v":57718.38109935001,"d":"57718"}," "]
[]
[11,"销售收入",null,{"v":60160.4,"d":"60160"}]
[12,"销售费用"," ",{"v":755.73,"d":"756"}]
[null,"代理费"," ",{"v":704.05,"d":"704"}]
[null,"测绘费","按总销面积计算，每平米1.36元",{"v":51.68000000000001,"d":"52"}]
[13,"税费","销售收入的5.55%",{"v":3338.9022,"d":"3339"}]

{"sheet":"销售计划","index":3,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[9,5,11,8],[12,5,14,8]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":5},"2006年","2007年","2008年","2009年"]
[11,"销售收入",null,{"v":60160.4,"d":"60160"}]
[null,"经济住宅","3200元/平方米",{"v":30598.4,"d":"30598"},null,{"v":0.4,"d":"40.00%"},{"v":0.6,"d":"60.00%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[null,"商品住宅","4000元/平方米",16392,null,{"v":0.1,"d":"10.00%"},{"v":0.4,"d":"40.00%"},{"v":0.4,"d":"40.00%"},{"v":0.1,"d":"10.00%"}]
[null,"商业配套","5500元/平米",11770,null,null,{"v":0.4,"d":"40.00%"},{"v":0.4,"d":"40.00%"},{"v":0.2,"d":"20.00%"}]
[null,"车位",40000,1400,null,null,{"v":0.3,"d":"30%"},{"v":0.4,"d":"40%"},{"v":0.3,"d":"30%"}]
[]
[]
[{"$nulls":5},"按照项目推介书，“本项目在竣工前的所有资金投入均在居民办理入住手续同时实现资金回笼”，势必加大资金压力。"]
[]
[]
[{"$nulls":5},"拿到开工证支付20％"]

{"sheet":"现金流估计","index":4,"n_rows":30,"n_cols":10,"rows_kept":30,"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":7},"单位：万元人民币"]
["序号","项目\\年份 ","总计",2005,2006,2007,2008,2009]
[1,"现金流入 "]
[null,"经济住宅",{"v":30598.4,"d":"30598"},null,{"v":12239.36,"d":"12239"},{"v":18359.04,"d":"18359"},0,0,null,{"v":30598.4,"d":"30598"}]
[null,"商品住宅",16392,null,{"v":1639.2,"d":"1639"},{"v":6556.8,"d":"6557"},{"v":6556.8,"d":"6557"},{"v":1639.2,"d":"1639"},null,16392]
[null,"商业配套",11770,null,null,4708,4708,2354,null,11770]
[null,"车位",1400,null,null,420,560,420,null,1400]
[null,"现金收入小计             ",{"v":60160.4,"d":"60160"},null,{"v":13878.560000000001,"d":"13879"},{"v":30043.84,"d":"30044"},{"v":11824.8,"d":"11825"},{"v":4413.2,"d":"4413"},null,{"v":60160.399999999994,"d":"60160"}]
[2,"现金流出",{"$nulls":7},0]
[null,"土地取得费用",{"v":11575.04,"d":"11575"},{"v":6945.024,"d":"6945"},{"v":3472.512,"d":"3473"},1157.5040000000001,0,0,null,{"v":11575.04,"d":"11575"}]
[null,"建安工程费",{"v":28540.4,"d":"28540"},0,8562.12,11416.160000000002,8562.12,0,null,{"v":28540.4,"d":"28540"}]
[null,"前期工程费",{"v":1101.1842000000001,"d":"1101"},{"v":275.29605000000004,"d":"275.2961"},385.41447000000005,330.35526000000004,110.11842000000001,0,null,{"v":1101.1842000000001,"d":"1101"}]
[null,"基础及配套设施费",{"v":8126.6,"d":"8127"},0,1625.3200000000002,4063.3,2437.98,0,null,{"v":8126.6,"d":"8127"}]
[null,"不可预见费",{"v":1233.580605,"d":"1234"},{"v":185.03709075,"d":"185.0371"},370.0741815,493.4322420000001,185.03709075,0,null,{"v":1233.580605,"d":"1234"}]
[null,"建设总投资",{"v":50576.80480500001,"d":"50577"},0,0,0,0,0,null,{"v":50576.80480500001,"d":"50577"}]
[null,"管理费",{"v":1233.580605,"d":"1234"},{"v":123.35806050000002,"d":"123.3581"},431.75321175,555.1112722500001,123.35806050000002,0,null,{"v":1233.5806049999999,"d":"1234"}]
[null,"财务费用",{"v":2072.4154164000006,"d":"2072"},{"v":207.24154164000007,"d":"207.2415"},725.3453957400002,932.5869373800003,207.24154164000007,0,null,{"v":2072.4154164000006,"d":"2072"}]
[null,"销售代理费 2.5%",{"v":704.05,"d":"704"},null,163.3736,465.2104,281.62,99.83000000000001,null,{"v":1010.0340000000001,"d":"1010"}]
[null,"销售测绘费",{"v":51.68000000000001,"d":"52"},null,30,22,0,0,null,52]
[null,"税费 5.55%",{"v":3338.9022,"d":"3339"},null,770.2600800000001,1667.43312,656.2764,244.93259999999998,null,{"v":3338.9022000000004,"d":"3339"}]
[null,"现金流出小计",{"v":57977.43302640001,"d":"57977"},{"v":7735.95674289,"d":"7736"},{"v":16536.172938990003,"d":"16536"},{"v":21103.093231630006,"d":"21103"},{"v":12563.751512890003,"d":"12564"},{"v":344.7626,"d":"345"},null,{"v":58283.73702640001,"d":"58284"}]
[null,"净现金流量",null,{"v":-7735.95674289,"d":"(7736)"},{"v":-2657.6129389900016,"d":"(2658)"},{"v":8940.746768369994,"d":"8941"},{"v":-738.9515128900039,"d":"(739)"},{"v":4068.4374,"d":"4068"}]
[null,"累计现金流",null,{"v":-7735.95674289,"d":"(7736)"},{"v":-10393.569681880002,"d":"(10394)"},{"v":-1452.8229135100082,"d":"(1453)"},{"v":-2191.774426400012,"d":"(2192)"},{"v":1876.6629735999877,"d":"1877"}]
[]
[]
[null,"财务内部收益率(IRR):",null,{"v":0.07409141441849924,"d":"7%"}]
[null,"财务净现值(NPV @6%)",null,{"v":298.3392249860816,"d":"￥298.34"}]
[null,"投资回收期(PBP):",null,{"v":4.538726348941736,"d":"4.54"}]

{"sheet":"分析","index":5,"n_rows":46,"n_cols":15,"rows_kept":46,"merged":[[39,5,41,6]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,null,"转让费用","财务净现值","土地费用变动率","NPV的变动率"]
[null,null,61700,-22,{"v":0.07491289198606271,"d":"7.49%"},{"v":-1.0050354772259098,"d":"-100.50%"}]
[null,null,57550,4215,{"v":0.002613240418118467,"d":"0.26%"},{"v":-0.035248340581368734,"d":"-3.52%"},-13.400778210116728]
[null,null,57500,4266,{"v":0.0017421602787456446,"d":"0.17%"},{"v":-0.02357518883039597,"d":"-2.36%"},-13.400778210116732]
[null,null,57450,4317,{"v":0.0008710801393728223,"d":"0.09%"},{"v":-0.011902037079423208,"d":"-1.19%"}," "]
[null,"normal",57400,4369,null," "]
[null,null,57350,4420,{"v":-0.0008710801393728223,"d":"-0.09%"},{"v":0.011673151750972763,"d":"1.17%"},-13.400778210116732]
[null,null,57300,4471,{"v":-0.0017421602787456446,"d":"-0.17%"},{"v":0.023346303501945526,"d":"2.33%"},-13.400778210116728]
[null,null,57250,4522,{"v":-0.002613240418118467,"d":"-0.26%"},{"v":0.03501945525291829,"d":"3.50%"}," "]
[null,null," "]
[]
[]
[]
[null,null,"售价 ","财务净现值","售价变动率","NPV的变动率"]
[null,null,7000,13459,{"v":0.07692307692307693,"d":"7.69%"},{"v":2.0805676356145573,"d":"208.06%"}," "]
[null,null,6650,7096,{"v":0.023076923076923078,"d":"2.31%"},{"v":0.6241702906843671,"d":"62.42%"}," "]
[null,null,6600,6187,{"v":0.015384615384615385,"d":"1.54%"},{"v":0.41611352712291144,"d":"41.61%"},27.047379262989242]
[null,null,6550,5278,{"v":0.007692307692307693,"d":"0.77%"},{"v":0.20805676356145572,"d":"20.81%"},27.04737926298924]
[null,null,6500,4369,null," ",27.047379262989242]
[null," ",6450,3460,{"v":-0.007692307692307693,"d":"-0.77%"},{"v":-0.20805676356145572,"d":"-20.81%"}," "]
[null,null,6400,2551,{"v":-0.015384615384615385,"d":"-1.54%"},{"v":-0.41611352712291144,"d":"-41.61%"}," "]
[null,null,6350,1642,{"v":-0.023076923076923078,"d":"-2.31%"},{"v":-0.6241702906843671,"d":"-62.42%"},27.047379262989242]
[null,null,6250,-175,{"v":-0.031007751937984496,"d":"-3.10%"},{"v":-1.050578034682081,"d":"-105.06%"},27.04737926298924]
[]
[]
[null,"情景分析"]
[null,null,"悲观","正常","乐观"]
[null,"售价",6250,6500,69000]
[null,"转让费用",57550,57400,57300]
[null,"NPV",-329,4369,11743]
[]
[]
[]
[]
[null,"住宅总成本",138606,"住宅总成本",138606,"假定商业和车库的成本和收益相抵，卖给原项目公司的1万平方米收入扣减项目成本"]
[null,"住宅可售面积",240000,"正常售价",6800,{"$nulls":9}," "]
[null,"平衡价格",{"v":5775.25,"d":"5775"},"平衡销量",{"v":203832.35294117648,"d":"203832"}]
[]
[{"$nulls":10},"住宅总成本",138606,null,"住宅总成本",138606]
[{"$nulls":10},"住宅可售面积",240000,null,"正常售价",6800]
[{"$nulls":10},"平衡价格",{"v":5775.25,"d":"5775"},null,"平衡销量",{"v":203832.35294117648,"d":"203832"}]