房地产开发项目财务估算表.xls

1、123456销销售售价价格格(元元/平平方方米米)均价 项目1（住宅）30003100 项目2（小高层）340035003600 项目3（高层）41004200 项目4（商业）11700 项目5（地下车位）销销售售计计划划(平平方方米米)144000 项目1（住宅）619203456027360 项目2（小高层）4464012960244807200 项目3（高层）25920201605760 项目4（商业）1152011520 项目5（地下车位）0开开发发计计划划(平平方方米米)144000 项目1（多层）土建576004000017600 项目1（多层）安装576003000027600

2、项目2（小高层）土建4320020000200003200 项目2（小高层）安装43200150001500013200 项目3（高层）土建288001000018800 项目3（高层）安装2880028800 项目4（商业）土建1440014400 项目4（商业）安装1440014400 项目5（地下车位）土建0 项目5（地下车位）安装0回回款款计计划划 项目1（住宅）100%100%项目2（小高层）100%100%100%项目3（高层）100%100%项目4（商业）100%100%项目5（地下车位）出出租租价价格格(元元/平平方方米米)项目1（地上车位）项目2 项目3出出租租计计划划(平平

3、方方米米)项目1（地上车位）项目2 项目3出出租租率率(%)(%)项目1（地上车位）项目2 项目3土地费用序号项目合计1234561土地出让金10800108002征地费用03拆迁安置补偿费04土地转让费05土地租用费06土地投资折价07交易服务费18184%交易契税43243200000共计112501125000000前期工程费用序号项目合计1234561规划设计研究费4004002水文地质勘测费03道路费04供水费05供电费05三通一平03%其他4847710010120700共计88447710010120700前期工程费用投入计划100%20%30%30%15%5%884177265

4、265133440基础设施建设费用序号项目合计1234561供电工程02供水工程03供气工程04排污工程05道路工程06通讯工程07绿化工程08照明工程09环卫设施03%其他4847710010120700共计4847710010120700基础设施建设费用投入计划100%20%30%30%15%5%4849714514573240公共配套设施建设费序号项目合计1234561居委会02派出所03托儿所04幼儿园05公共厕所06停车场03%其他4847710010120700共计4847710010120700公共配套设施建设费投入计划100%20%30%30%15%5%484971451457

5、3240建筑安装工程费用序号项目合计1234561 项项目目1 1（住住宅宅）374437442550119400001.1 土建工程费34563456240010560000 建筑面积(平方米)40000176000000 单价(元/平方米)6006006006006006006001.2 安装工程费2882881501380000 建筑面积(平方米)30000276000000 单价(元/平方米)505050505050502 项项目目2 2（小小高高层层）47524752021502150452002.1 土建工程费4320432002000200032000 建筑面积(平方米)0200

6、0020000320000 单价(元/平方米)10001000100010001000100010002.2 安装工程费432432015015013200 建筑面积(平方米)015000150001320000 单价(元/平方米)1001001001001001001003 项项目目3 3（高高层层）403240320012002832003.1 土建工程费34563456001200225600 建筑面积(平方米)00100001880000 单价(元/平方米)12001200120012001200120012003.2 安装工程费57657600057600 建筑面积(平方米)0002

7、880000 单价(元/平方米)2002002002002002002004 项项目目4 4（商商业业）360036000003600004.1 土建工程费21602160000216000 建筑面积(平方米)0001440000 单价(元/平方米)15001500150015001500150015004.2 安装工程费14401440000144000 建筑面积(平方米)0001440000 单价(元/平方米)10001000100010001000100010005 项项目目5 5（地地下下车车位位）0 00000005.1 土建工程费0 0000000 建筑面积(平方米)000000

8、单价(元/平方米)0000005.2 安装工程费0 0000000 建筑面积(平方米)000000 单价(元/平方米)000000共计16128255033443350688400开发间接费序号项目合计1234561土地使用税02市政支管线分摊费03供电贴费04用电权费05分散建设市政公用设施建设费06绿化建设费07临时用地08临建费09施工图预算或标底编制费010工程合同预算或标底审查费011招标管理费012总承包管理费013合同公证费014施工执照费015工程质量监督费016工程监理费017竣工图编制费018工程保险费03%其他费用4847710010120700共计48477100101

9、20700开发间接费投入计划100%20%30%30%15%5%4849714514573240销售费用序号项目合计1234565.0%销售代理费用292951864442854379500.0%广告宣传及推广费用00000000.0%其他销售费用0000000共计 29295186444285437950销售费用投入计划100%20%30%30%15%5%29295868798794391460项目总投资估算表序号项目合计123456一开发建设投资339871534848944901853630701房地产开发成本3025314601385538627935001.1土地费用11250112

10、50000001.2前期工程费884477100101207001.3基础设施建设费48477100101207001.4建筑安装工程费161282550334433506884001.5公共配套设施建设费48477100101207001.6开发间接费48477100101207001.7不可预见费53995109110225002房地产开发费用37347471040104060030702.1销售费用292958687987943914602.2管理费用80516116116116116102.3财务费用0000000二经营资金0三项目总投资额33987153484894490185363

11、0701开发产品投资339871534848944901853630702固定资产投资03经营资金0000000项目回款进度表序号项目合计1234561项目1（多层）1885010368848200002项目2（小高层）155660440685682592003项目3（高层）106850008266241904项目4（商业）1347800001347805项目5（地下车位）0000000小计585795857910368128888568108581589802006项目1（多层）1036810368103680 0项目2（小高层）00 00 0项目3（高层）00 00 0项目4（商业）00

12、00 0项目5（地下车位）00 00 02007项目1（多层）8482848284820 0项目2（小高层）4406440644060 0项目3（高层）00 00 0项目4（商业）00 00 0项目5（地下车位）00 00 02008项目1（多层）00 00 0项目2（小高层）8568856885680 0项目3（高层）00 00 0项目4（商业）00 00 0项目5（地下车位）00 00 02009项目1（多层）00 00 0项目2（小高层）2592259225920 0项目3（高层）8266826682660 0项目4（商业）00 00 0项目5（地下车位）00 00 02010项目1（多

13、层）00 00 0项目2（小高层）00 00 0项目3（高层）2419241924190 0项目4（商业）1347813478134780 0项目5（地下车位）00 00 02011项目1（多层）00 0项目2（小高层）00 0项目3（高层）00 0项目4（商业）00 0项目5（地下车位）00 0小计58579585791036812888856810858158980投资使用计划与资金筹措表序号项目合计1234561总投资33987339871534848944901853630701.1经营资金00000001.2固定资产投资00000001.3开发产品投资3398715348489449

14、0185363070 其中：不含财务费用33987153484894490185363070 财务费用00000002资金筹措33986339861534848944901853630702.1权益资金1534815348000002.1.1 资本金500050002.1.2 股票融资02.1.3 股东投资10348103482.1.4 政府投资02.2债务资金40000400000002.2.1 长期贷款400040002.2.2 短期贷款02.2.3 企业债券02.2.4 融资租赁02.3收入资金1463808944901853630702.3.1 预售收入1463889449018536

15、3072.3.2 租金收入02.3.3 自营收入02.3.4 贴补收入02.3.5 其他收入0销售收入与经营税金估算表序号项目合计1234561销售收入5857910368128888568108581589801.1可销售面积(平方米)144000345604032024480273601728001.2平均售价元(元/平方米)30003196350039689200#DIV/0!1.3销售比例(%)24%28%17%19%12%0%2经营税金及附加322257070947159787402.1营业税292951864442854379502.2城市维护建设税205364530385602.

16、3教育费附加8816191316240土地增值税预征估算表序号项目合计1234561项项目目1 1（多多层层）1.0%1.0%1.0%1.0%1.0%1.0%销售收入1885010368848200001.0%预征税额1881048500002项项目目2 2（小小高高层层）1.0%1.0%1.0%1.0%1.0%1.0%销售收入155660440685682592001.0%预征税额1560448626003项项目目3 3（高高层层）1.0%1.0%1.0%1.0%1.0%1.0%销售收入106850008266241901.0%预征税额107000832404项项目目4 4（商商业业）1%1

17、%1%1%1%1%销售收入1347800001347801.0%预征税额135000013505预征土地增值税总额586104129861091590累计预征土地增值税104233318427586586土地增值税估算附表序号项目合计1234561销售收入5857910368128888568108581589802累计销售收入1036823256318244268258579585793开发成本302535480698950076586619104累计开发成本548012469174762406230253302535销售比例24%28%17%19%12%0%6累计销售比例24%52%69%

18、88%100%100%土地增值税估算表序号项目合计1234561销售收入10126142682585792扣除项目76180000336284255102.1 开发成本5431624062302532.2 开发费用54322406302502.3 销售税金55692347322202.4 其他扣除额108634812605103增值额00090531602804增值比例#DIV/0!#DIV/0!#DIV/0!27%38%#DIV/0!5增值税率30%30%6速算扣除率0%0%7土地增值税0002716480808已交土地增值税4275869本年应缴土地增值税22891933自营收入及经营税金

19、估算表序号项目合计1234561自营收入02经营税金及附加00000002.1营业税00000002.2城市维护建设税00000002.3教育费附加00000003净转售收入00000003.1转售价格03.2转售成本03.3转售税金0000000租金收入及经营税金估算表序号项目合计1234561租金收入(万元)00000001.1.1 可出租面积(平方米)0000001.1.2 单位租金(元/月/平方米)0000001.1.3 出租率(%)0%0%0%0%0%0%1.2.1 可出租面积(平方米)0000001.2.2 单位租金(元/月/平方米)0000001.2.3 出租率(%)0%0%0%

20、0%0%0%1.3.1 可出租面积(平方米)0000001.3.2 单位租金(元/月/平方米)0000001.3.3 出租率(%)0%0%0%0%0%0%2经营税金及附加00000002.1营业税00000002.2城市维护建设税00000002.3教育费附加00000004净转售收入00000004.1转售价格04.2转售成本04.3转售税金0000000经营成本分摊表序号项目合计1234561 项项目目1 1（住住宅宅）43.00%已销售面积6192034560273600000销售比例56%44%0%0%0%0%开发总成本98185480433800002 项项目目2 2（小小高高层层）

21、31.00%已销售面积4464001296024480720000销售比例0%29%55%16%0%0%开发总成本91310265150071473003 项项目目3 3（高高层层）18.00%已销售面积259200002016057600销售比例0%0%0%78%22%0%开发总成本65750005114146104 项项目目4 4（商商业业）8.00%已销售面积115200000115200销售比例0%0%0%0%100%0%开发总成本47300000473005 项项目目5 5（地地下下车车位位）已销售面积0000000销售比例#DIV/0!#DIV/0!#DIV/0!#DIV/0!#D

22、IV/0!#DIV/0!开发总成本04合计30253548069895007658661910固定资产折旧固定资产3734折旧年限20残值率5%年折旧额177固定资产转售年限15固定资产转售成本1074出租部分转售月租金(元/平方米/月)100出租面积(平方米)1000出租率(%)80%运营费用(万元)20%净租金收益(万元)76.8收益年限(年)50报酬率(%)8%转售价格(万元)940自营部分转售年经营收入(万元)1000年经营成本(万元)20年经营费用(万元)30经营税金及附加(万元)52.25正常利润率(%)10%年净收益(万元)797.75经营年限(年)10报酬率(%)7%转售价格(

23、万元)5603成本费用估算表序号项目合计1234561开开发发成成本本302535490698950076586619101.1 销售部分302535480698950076586619101.2 出租部分010年0001.3 自营部分02开开发发费费用用37347471040104060030702.1 销售费用292958687987943914602.2 管理费用8051611611611611610 折旧0 摊销02.3 财务费用00000003开发成本费用33987623780296047718764980利润与利润分配表序号项目合计1234561经营收入58579103681288

24、88568108581589801.1销售收入5857910368128888568108581589801.2租金收入00000001.3自营收入00000002开发成本费用339976237802960477187649803补贴收入（先征返还）04经营费用（出租和自营产业）05经营税金及附加322257070947159787406土地增值税预征5861041298610915907土地增值税42230002289193308利润总额17137356141502050785659109弥补前年度亏损010应纳税所得额171373561415020507856591011所得税565511

25、751370676259217501%所得税预征171364220866011税后利润114822386278113735264416010%法定盈余公积金114823927813753442012期初未分配利润1933399247054660777113可供分配利润8733821474435522851788635777115应付优先股股利00%任意盈余公积金000000016应付普通股股利017各投资方可分配利润21474435522851788635777118各投资方利润分配574521544452351886377710%A方57452154445235188637770%B方000

26、00000%C方000000018年末未分配利润19333992470546607771699419息税前利润3561415020507856591020息税折旧摊销前利润3561415020507856591021盈余公积1148239278137534420现金流量表（全部投资）序号项目合计1234561 1现现金金流流入入5857910368128888568108581589801.1销售收入5857910368128888568108581589801.2租金收入00000001.3自营收入00000001.4补贴收入（先征返还）00000001.5回收其他资金01.6回收固定资产余

27、值01.7回收经营资金01.8净转售收入00000002 2现现金金流流出出47673171977102613511789544902.1开发产品投资(不含财务费用)339871534848944901853630702.2经营资金00000002.3经营费用（出租和自营产业）00000002.4经营税金及附加322257070947159787402.5土地增值税预征5861041298610915902.6土地增值税42230002289193302.7所得税565511751370676259217503净现金流量10906-682957862433-932104480累计净现金流量-6

28、829-1043139045910907109074所得税前净现金流量16562-565471563110-673126230累计所得税前净现金流量-565415024612393916562165625净现值4698-593943751600-53351950累计净现值-5939-156337-496469946996所得税前净现值8430-491754112045-38562760累计所得税前净现值-49174942539215484308430计算指标所得税前所得税后实际内部收益率(FIRR)4.39%17.01%表面内部收益率(FIRR)14.83%28.71%财务净现值(FNPV)8

29、4304698投资回收期（静态/动态）年3.262.773.493.91通货膨胀率10.00%10.00%15%基准收益率(Ie)15%15%FIRR(税前)87%项目变动幅度123原始值变动值原始值变动值原始值变动值现金流入10%1036811405128881417785689425现金流出15%17197197777102816761357055合计-6829-83725786601024332370基准收益率15%0.86960.75610.6575净现值4698-5939-72804375454416001558累计净现值3256-5939-7280-1563-273637-1178

30、现金流量表（资本金）序号项目合计1234561 1现现金金流流入入5857910368128888568108581589801.1销售收入5857910368128888568108581589801.2租金收入00000001.3自营收入00000001.4补贴收入（先征返还）00000001.5回收其他资金00000001.6回收固定资产余值00000001.7回收经营资金00000001.8净转售收入00000002 2现现金金流流出出47672171977101613411790544902.1权益资金1534815348000002.2债务资金40000400000002.3收入资

31、金1463808944901853630702.4经营费用（出租和自营产业）00000002.5经营税金及附加322257070947159787402.6土地增值税预征5861041298610915902.7土地增值税42230002289193302.8所得税565511751370676259217502.9借款本利偿还00000003净现金流量10908-682957872434-932104490累计净现金流量-6829-1042139145910908109084净现值4699-593843761600-53351950累计净现值-5938-156337-496469946995

32、所得税前净现金流量16563-565471563110-673126240累计所得税前净现金流量-565415024612393916563165636所得税前净现值8431-491654112045-38562760累计所得税前净现值-49164952540215584318431计算指标所得税前所得税后实际内部收益率(FIRR)4.64%12.18%表面内部收益率(FIRR)15.10%23.40%财务净现值(FNPV)84314699投资回收期（静态/动态）年通货膨胀率10.00%10.00%15%基准收益率(Ie)15%15%FIRR(税前)87%财务计划现金流量表序号项目合计1234

33、561 1经经营营活活动动净净现现金金流流量量44894851910681733576041075601.11.1现现金金流流入入5857910368128888568108581589801.1.1 销售收入5857910368128888568108581589801.1.2 租金收入00000001.1.3 自营收入00000001.1.4 补贴收入（先征返还）00000001.1.5 其他流入01.21.2现现金金流流出出136861849220712333254514201.2.1 房地产投资(不含利息)339871534848944901853630701.2.2 经营资金0000

34、0001.2.3 经营费用（出租和自营产业）00000001.2.4 经营税金及附加322257070947159787401.2.5 土地增值税预征5861041298610915901.2.6 土地增值税42230002289193301.2.7 所得税565511751370676259217501.2.8 其他流出02 2投投资资活活动动净净现现金金流流量量00000002.12.1现现金金流流入入00000002.1.1 回收固定资产余值00000002.1.2 回收经营资金00000002.1.3 净转售收入00000002.1.4 回收其他资金00000002.1.5 其他流入0

35、2.22.2现现金金流流出出00000002.2.1 权益投资02.2.2 债权投资02.2.3 购建投资02.2.4 其他投资03 3筹筹资资活活动动净净现现金金流流量量10614151333556-523-518-863-7773.13.1现现金金流流入入1934815348400000003.1.1 权益资金1534815348000003.1.2 债务资金40000400000003.1.6 其他流入03.23.2现现金金流流出出87342154445235188637773.2.1 借款本金偿还00000003.2.2 各种利息支出00000003.2.3 应付利润（股利分配）873

36、42154445235188637773.2.4 其他流出04盈余资金555082365214237681270869892-7775累计盈余资金236523788944701517876167960902贷款还本付息计划表序号项目合计1234561长期借款偿还1.1年初借款本息累计041004305452047461.2本年借款40000400000001.3本年应计利息205801002052152262371.4本年还本付息0000000 还本05.00%付息01.5年末借款本息累计0410043054520474649842短期借款偿还2.1年初借款本息累计000002.2本年借款00

37、000002.3本年应计利息00000002.4本年还本付息0000000 还本7.11%付息02.5年末借款本息累计0000003本年还本付息00000003.1 本年还本00000003.2 本年付息00000004还本资金来源238627811373526441604.1摊销00000004.2折旧00000004.3税后利润11482238627811373526441604.4其他05偿还长期贷款本金能力11482238627811373526441606利息备付率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!7偿债备付率#DIV/

38、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!8长期借款偿还期(年)4资产负债表序号项目1234561资产2965248327533705756061679609021.1流动资产总额2965248327533705756061679609021.1.1 应收帐款0000001.1.2 存货6000104388669577300 其中：在建工程600010438866957731.1.3 货币资金1.1.4 累计盈余资金2365237889447015178761679609021.2长期投资1.3固定资产净值1.4无形及递延资产净值2负债及所有者权益

39、1751923957250122523529014284742.1流动负债总额0000002.1.1 应付帐款2.1.2 短期借款2.1.3 递延税金2.2长期负债总额0410043054520474649842.2.1 经营资金借款2.2.2 开发产品投资借款041004305452047464984负债小计0410043054520474649842.3所有者权益1751919857207072071524268234912.3.1 资本金1534815348153481534815348153482.3.2 资本公积2.3.3 累计盈余公积金239517654707114811482.3

40、.4 累计未分配利润193339924705466077716994比率指标参考指标资产负债率(%)70%0%8%8%8%8%8%流动比率(%)120%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!速动比率(%)65%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!主要经济指标表序号名称单位数据备注项项目目设设计计参参数数projectproject designdesign parameterparameter1房地产开发产品总建筑面积total building area of real estate deveolp

41、ment平方米1440001.1商品住宅销售面积sale area of commercial residential building平方米1324801.2商业用房销售面积sale area of mercantile occupancy平方米115201.3车位销售面积sale area of loading lot平方米1.3出租物业面积rent area of real estate平方米1.4自营资产self-support assets平方米2自营收入self-support income万元0经经济济数数据据economiceconomic datadata1总投资overhe

42、ad expenses万元339872开发产品投资gross investment万元33987 其中：财务费用operation funds万元03单方价格unilateralism price元/平方米23604资金筹措financing万元33986 其中：权益资金equity funds万元15348 债权资金indebtedness funds万元4000 收入资金receipts funds万元146385经营收入万元585796开发成本real estate development costs万元302537开发费用万元37348经营费用（出租和自营产业）万元09应缴税金taxe

43、s due万元13686 经营税金及附加management taxes and additional expense 万元3222 土地增值税commercial housing sale net income estimating chart万元4808 所得税commercial housing sale net income estimating chart万元565510利润总额total profit万元1713711税后利润after-tax profit 万元1148212可分配利润distributive profits万元5745财财务务评评价价指指标标financialf

44、inancial evaluationevaluation indexindex1投资利润率earning power of real assets%10.08%年平均2投资净利润率net earning power of real assets%6.76%年平均3投资利税率（不含所得税）%14.81%年平均4资本金利润率profit-cost ratio%22.33%年平均5资本金净利润率net profit-cost ratio%14.96%年平均6全部投资内部收益率（所得税前）total investment internal rate of return%14.83%7全部投资投资回收

45、期（所得税前）年2.778全部投资内部收益率（所得税后）%28.71%9全部投资投资回收期（所得税后）年3.9110项目建设经营期construct and manage period of project年511房地产投资长期借款偿还期period of compensate long term loans of real estate investment年建设期起12自营部分盈亏平衡点（经营达纲率）break-even point of self-support part%789101112131415161718（产权面积）单位：万元78910111213141516171800000

46、0000000000000000000单位：万元78910000000000000000000000000000000000000单位：万元789101112131415161718000000000000000000000000000000000000单位：万元789101112131415161718000000000000000000000000000000000000单位：万元7891011121314151617180000000000000000000000000000000000006006006006006006006006006006006006000000000000000

47、000000000005050505050505050505050500000000000000000000000000000000000001000100010001000100010001000100010001000100010000000000000000000000000001001001001001001001001001001001001000000000000000000000000000000000000001200120012001200120012001200120012001200120012000000000000000000000000002002002002002

48、002002002002002002002000000000000000000000000000000000000001500150015001500150015001500150015001500150015000000000000000000000000001000100010001000100010001000100010001000100010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007891011121314151617180000

49、00000000000000000000000000000000单位：万元78910111213141516171800000000000000000000000000000000000000000000000000000000000078910111213141516171800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

50、00000000000000000000000000000007891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000 00 00 00 00 0000000000000单位：万元789101112131415161718000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000单位：

51、万元78910111213141516171800000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!000000000000000000000000000000000000000000000000单位：万元7891011121314151617181.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000

52、0000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001%1%1%1%1%1%1%1%1%1%1%1%000000000000000000000000000000000000586586586586586586586586586586586586单位：万元7891011121314151617180000000000005857958

53、579585795857958579585795857958579585795857958579585790000000000003025330253302533025330253302533025330253302533025330253302530%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!100%100%100%100%100%100%100%100%100%#DIV/0!#DIV/0!#DIV/0!单位：万元789101112131415161718000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#D

54、IV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000单位：万元789101112131415161718000000000000000000000000000000000000000000000000000000000000000000000000单位：万元7891011121314151617180000000000000000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0

55、%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%000000000000000000000000000000000000000000000000000000000000000000000000单位：万元7891011121314151617180000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%00000000000000000

56、00000000%0%0%0%0%0%0%0%0%0%0%0%000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000单位：万元7891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000单位：万元789101112131415161718000000

57、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000699462955665509945894130371733453011271024392195699462955665509945894130371733453011271024392195000000000000699462955665509945894130371733

58、453011271024392195699629567510459413372335301271244219699629567510459413372335301271244219000000000000000000000000629556655099458941303717334530112710243921951975000000000000000000000000000000000000单位：万元7891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000000

59、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001090710907109071090710907109071090610906109061090610906109060000000000001656216562165621656216562165621656216562165621656216562165620000000000004699469946994698469846984698469846984698469846980000

60、00000000843084308430843084308430843084308430843084308430FIRR(税后)49%456789原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值108581194315898174870000000011789135585449626700000000-932-16141044811221000000000.57180.49720.43230.37590.32690.2843-533-9235195557900000000-496-21014699347846993478469934784699347846993478单

61、位：万元78910111213141516171800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010908109081090810908109081090810908

62、1090810908109081090810908000000000000469946994699469946994699469946994699469946994699000000000000165631656316563165631656316563165631656316563165631656316563000000000000843184318431843184318431843184318431843184318431FIRR(税后)49%单位：万元7891011121314151617180000000000000000000000000000000000000000000000

63、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-699-629-567-510-459-413-372-335-301-271-244-2190000000000000000000000000000000000006996295675

64、10459413372335301271244219000000000000000000000000699629567510459413372335301271244219-699-629-567-510-459-413-372-335-301-271-244-219602035957359007584975803857625572535691956617563465610355883单位：万元78910111213141516171849845233549457696058636066787012736377318118852400000000000024926227528830331833

65、4351368387406426000000000000523354945769605863606678701273637731811885248950000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/

66、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!单位：万元789101112131415161718602035957359007584975803857625572535691956617563465610355883602035957359007584975803857625572535691956617563465610355883000000000000000000000000602035957359007584975803857625

67、572535691956617563465610355883280242765627364271432698726892268542687026937270532721527421000000000000523354945769605863606678701273637731811885248950523354945769605863606678701273637731811885248950523354945769605863606678701273637731811885248950227912216221595210852062620213198421950719206189351869

68、1184721534815348153481534815348153481534815348153481534815348153481148114811481148114811481148114811481148114811486295566550994589413037173345301127102439219519759%9%10%10%11%12%12%13%14%14%15%16%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0

69、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!19201920000000000019200000001920000000192000000060060000005050000000100010000000100100000000120012000000200200000000150015000000100010000000000000000000192000000019200000000000192000000000000000000000000000000000192000000000000000192000

70、00000000000000000019200000#DIV/0!#DIV/0!#DIV/0!#DIV/0!0000000019201.0%1.0%00001.0%1.0%00001.0%1.0%00001%1%0000005865861920005857958579003025330253#DIV/0!#DIV/0!#DIV/0!#DIV/0!19200000#DIV/0!#DIV/0!00192000000000000019200000000%0%00000%0%00000%0%0000000000001920000%0%00000%0%00000%0%00000%0%0000#DIV/0

71、!#DIV/0!00192000000000000000019200000000000000000000000000000197517781975177800197517781981781981780000177816000000001920000000000000000000000000000000109061090600165621656200469846980084308430101112131415原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值00000000000000024502450407040700000-2450-2450-4070-407000.2

72、4720.21490.18690.16250.14130.1229000-530-460-660-5700469834784698342546983379469833134698325646983256192000000000000000000000000000000000000000001090810908004699469900165631656300843184311920000000000000000000000000000000000000000000-198-1780000001981780000198178-198-17855686555081920895093970044747

73、0009397986700000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!1920556865550855686555080000556865550827671279630093979867939798679397986718274180961534815348114811481778160017%18%#DIV/0!#DIV/0!#DIV/0!#DIV/0!1617181920原始值变动值原始值变动值原始值变动值变动值原始值变动值0000000000000000000000000000000.10690.09290.08080.0703

74、0.061100000000004698325646983256469832564698325646983256123456销销售售价价格格(元元/平平方方米米)均价 项目1（多层）30003100 项目2（小高层）340035003600 项目3（高层）41004200 项目4（商铺）11700 项目5（地下车位）销销售售计计划划(平平方方米米)144000（产权面积）项目1（多层）619203456027360 项目2（小高层）4464012960244807200 项目3（高层）25920201605760 项目4（商铺）1152011520 项目5（地下车位）0开开发发计计划划(平平方

75、方米米)144000 项目1（多层）土建576004000017600 项目1（多层）安装576003000027600 项目2（小高层）土建4320020000200003200 项目2（小高层）安装43200150001500013200 项目3（高层）土建288001000018800 项目3（高层）安装2880028800 项目4（商铺）土建1440014400 项目4（商铺）安装1440014400 项目5（地下车位）土建0 项目5（地下车位）安装0回回款款计计划划 项目1（多层）80%80%项目2（小高层）80%80%80%项目3（高层）80%80%项目4（商铺）80%80%项目5

76、（地下车位）出出租租价价格格(元元/平平方方米米)项目1（地上车位）100 项目2 项目3出出租租计计划划(平平方方米米)项目1（地上车位）1440 项目2 项目3出出租租率率(%)(%)项目1（地上车位）80%项目2 项目3土地费用序号项目合计1234561土地出让金10800108002征地费用03拆迁安置补偿费04土地转让费05土地租用费06土地投资折价07交易服务费18184%交易契税43243200000共计112501125000000前期工程费用序号项目合计1234561规划设计研究费4004002水文地质勘测费03道路费04供水费05供电费05三通一平03%其他48477100

77、10120700共计88447710010120700前期工程费用投入计划100%20%30%30%15%5%884177265265133440基础设施建设费用序号项目合计1234561供电工程02供水工程03供气工程04排污工程05道路工程06通讯工程07绿化工程08照明工程09环卫设施03%其他4847710010120700共计4847710010120700基础设施建设费用投入计划100%20%30%30%15%5%4849714514573240公共配套设施建设费序号项目合计1234561居委会02派出所03托儿所04幼儿园05公共厕所06停车场03%其他4847710010120

78、700共计4847710010120700公共配套设施建设费投入计划100%20%30%30%15%5%4849714514573240建筑安装工程费用序号项目合计1234561 项项目目1 1（多多层层）374437442550119400001.1 土建工程费34563456240010560000 建筑面积(平方米)40000176000000 单价(元/平方米)6006006006006006006001.2 安装工程费2882881501380000 建筑面积(平方米)30000276000000 单价(元/平方米)505050505050502 项项目目2 2（小小高高层层）475

79、24752021502150452002.1 土建工程费4320432002000200032000 建筑面积(平方米)02000020000320000 单价(元/平方米)10001000100010001000100010002.2 安装工程费432432015015013200 建筑面积(平方米)015000150001320000 单价(元/平方米)1001001001001001001003 项项目目3 3（高高层层）403240320012002832003.1 土建工程费34563456001200225600 建筑面积(平方米)00100001880000 单价(元/平方米)1

80、2001200120012001200120012003.2 安装工程费57657600057600 建筑面积(平方米)0002880000 单价(元/平方米)2002002002002002002004 项项目目4 4（商商铺铺）360036000003600004.1 土建工程费21602160000216000 建筑面积(平方米)0001440000 单价(元/平方米)15001500150015001500150015004.2 安装工程费14401440000144000 建筑面积(平方米)0001440000 单价(元/平方米)100010001000100010001000100

81、05 项项目目5 5（地地下下车车位位）0 00000005.1 土建工程费0 0000000 建筑面积(平方米)000000 单价(元/平方米)0000005.2 安装工程费0 0000000 建筑面积(平方米)000000 单价(元/平方米)000000共计16128255033443350688400开发间接费序号项目合计1234561土地使用税02市政支管线分摊费03供电贴费04用电权费05分散建设市政公用设施建设费06绿化建设费07临时用地08临建费09施工图预算或标底编制费010工程合同预算或标底审查费011招标管理费012总承包管理费013合同公证费014施工执照费015工程质量

82、监督费016工程监理费017竣工图编制费018工程保险费03%其他费用4847710010120700共计4847710010120700开发间接费投入计划100%20%30%30%15%5%4849714514573240销售费用序号项目合计1234565.0%销售代理费用292951864442854379500.0%广告宣传及推广费用00000000.0%其他销售费用0000000共计 29295186444285437950销售费用投入计划100%20%30%30%15%5%29295868798794391460项目总投资估算表序号项目合计123456一开发建设投资339871534

83、848944901853630701房地产开发成本3025314601385538627935001.1土地费用1125011250000001.2前期工程费884477100101207001.3基础设施建设费48477100101207001.4建筑安装工程费161282550334433506884001.5公共配套设施建设费48477100101207001.6开发间接费48477100101207001.7不可预见费53995109110225002房地产开发费用37347471040104060030702.1销售费用292958687987943914602.2管理费用80516

84、116116116116102.3财务费用0000000二经营资金0三项目总投资额339871534848944901853630701开发产品投资339871534848944901853630702固定资产投资03经营资金0000000项目回款进度表序号项目合计1234561项目1（多层）1885010368848200002项目2（小高层）155660440685682592003项目3（高层）106850008266241904项目4（商铺）1347800001347805项目5（地下车位）0000000小计585795857910368128888568108581589802006

85、项目1（多层）103688294829420742074项目2（小高层）00 00 0项目3（高层）00 00 0项目4（商铺）00 00 0项目5（地下车位）00 00 02007项目1（多层）84826785678516961696项目2（小高层）440635253525881881项目3（高层）00 00 0项目4（商铺）00 00 0项目5（地下车位）00 00 02008项目1（多层）00 00 0项目2（小高层）85686854685417141714项目3（高层）00 00 0项目4（商铺）00 00 0项目5（地下车位）00 00 02009项目1（多层）00 00 0项目2（

86、小高层）259220742074518518项目3（高层）82666612661216531653项目4（商铺）00 00 0项目5（地下车位）00 00 02010项目1（多层）00 00 0项目2（小高层）00 00 0项目3（高层）241919351935484484项目4（商铺）13478107831078326962696项目5（地下车位）00 00 02011项目1（多层）00 0项目2（小高层）00 0项目3（高层）00 0项目4（商铺）00 0项目5（地下车位）00 0小计5857958579829412384943210400148903180投资使用计划与资金筹措表序号项目

87、合计1234561总投资33987339871534848944901853630701.1经营资金00000001.2固定资产投资00000001.3开发产品投资33987153484894490185363070 其中：不含财务费用33987153484894490185363070 财务费用00000002资金筹措15583155832896200327423688425402.1权益资金00000002.1.1 资本金02.1.2 股票融资02.1.3 股东投资02.1.4 政府投资02.2债务资金00000002.2.1 长期贷款02.2.2 短期贷款02.2.3 企业债券02.2.

88、4 融资租赁02.3收入资金155832896200327423688425402.3.1 预售收入15583289620032742368842542.3.2 租金收入02.3.3 自营收入02.3.4 贴补收入02.3.5 其他收入0销售收入与经营税金估算表序号项目合计1234561销售收入5857910368128888568108581589801.1可销售面积(平方米)144000345604032024480273601728001.2平均售价元(元/平方米)30003196350039689200#DIV/0!1.3销售比例(%)24%28%17%19%12%0%2经营税金及附加

89、322257070947159787402.1营业税292951864442854379502.2城市维护建设税205364530385602.3教育费附加8816191316240土地增值税预征估算表序号项目合计1234561项项目目1 1（多多层层）1.0%1.0%1.0%1.0%1.0%1.0%销售收入1885010368848200001.0%预征税额1881048500002项项目目2 2（小小高高层层）1.0%1.0%1.0%1.0%1.0%1.0%销售收入155660440685682592001.0%预征税额1560448626003项项目目3 3（高高层层）1.0%1.0%1

90、.0%1.0%1.0%1.0%销售收入106850008266241901.0%预征税额107000832404项项目目4 4（商商业业）1%1%1%1%1%1%销售收入1347800001347801.0%预征税额135000013505预征土地增值税总额586104129861091590累计预征土地增值税104233318427586586土地增值税估算附表序号项目合计1234561销售收入5857910368128888568108581589802累计销售收入1036823256318244268258579585793开发成本302535480698950076586619104累

91、计开发成本548012469174762406230253302535销售比例24%28%17%19%12%0%6累计销售比例24%52%69%88%100%100%土地增值税估算表序号项目合计1234561销售收入10126142682585792扣除项目76180000336284255102.1 开发成本5431624062302532.2 开发费用54322406302502.3 销售税金55692347322202.4 其他扣除额108634812605103增值额00090531602804增值比例#DIV/0!#DIV/0!#DIV/0!27%38%#DIV/0!5增值税率30%

92、30%6速算扣除率0%0%7土地增值税0002716480808已交土地增值税4275869本年应缴土地增值税22891933自营收入及经营税金估算表序号项目合计1234561自营收入3001002经营税金及附加170000062.1营业税150000052.2城市维护建设税10000002.3教育费附加00000003净转售收入00000003.1转售价格03.2转售成本03.3转售税金0000000租金收入及经营税金估算表序号项目合计1234561租金收入(万元)467000001381.1.1可出租面积(平方米)0000014401.1.2单位租金(元/月/平方米)000001001.1

93、.3出租率(%)0%0%0%0%0%80%1.2.1可出租面积(平方米)0000001.2.2单位租金(元/月/平方米)0000001.2.3出租率(%)0%0%0%0%0%0%1.3.1可出租面积(平方米)0000001.3.2单位租金(元/月/平方米)0000001.3.3出租率(%)0%0%0%0%0%0%2经营税金及附加260000082.1营业税230000072.2城市维护建设税20000002.3教育费附加10000004净转售收入00000004.1转售价格04.2转售成本04.3转售税金0000000经营成本分摊表序号项目合计1234561 项项目目1 1（多多层层）43.0

94、0%已销售面积6192034560273600000销售比例56%44%0%0%0%0%开发总成本98185480433800002 项项目目2 2（小小高高层层）31.00%已销售面积4464001296024480720000销售比例0%29%55%16%0%0%开发总成本91310265150071473003 项项目目3 3（高高层层）18.00%已销售面积259200002016057600销售比例0%0%0%78%22%0%开发总成本65750005114146104 项项目目4 4（商商铺铺）8.00%已销售面积115200000115200销售比例0%0%0%0%100%0%开

95、发总成本47300000473005 项项目目5 5（地地下下车车位位）已销售面积0000000销售比例#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!开发总成本04合计30253548069895007658661910固定资产折旧固定资产3734折旧年限20残值率5%年折旧额177固定资产转售年限15固定资产转售成本1074出租部分转售月租金(元/平方米/月)100出租面积(平方米)1000出租率(%)80%运营费用(万元)20%净租金收益(万元)76.8收益年限(年)50报酬率(%)8%转售价格(万元)940自营部分转售年经营收入(万元)1000年经营

96、成本(万元)20年经营费用(万元)30经营税金及附加(万元)52.25正常利润率(%)10%年净收益(万元)797.75经营年限(年)10报酬率(%)7%转售价格(万元)5603.062成本费用估算表序号项目合计1234561开开发发成成本本302535490698950076586619101.1 销售部分302535480698950076586619101.2 出租部分010年0001.3 自营部分02开开发发费费用用37347471040104060030702.1 销售费用292958687987943914602.2 管理费用8051611611611611610 折旧0 摊销02

97、.3 财务费用00000003开发成本费用33987623780296047718764980利润与利润分配表序号项目合计1234561经营收入593461036812888856810858158982381.1销售收入5857910368128888568108581589801.2租金收入467000001381.3自营收入300000001002开发成本费用339976237802960477187649803补贴收入（先征返还）04经营费用（出租和自营产业）60205经营税金及附加3264570709471597874136土地增值税预征5861041298610915907土地增值

98、税42230002289193308利润总额1780235614150205078565912059弥补前年度亏损010应纳税所得额17802356141502050785659120511所得税5875117513706762592175681%所得税预征178364220866211税后利润11927238627811373526441613712三项基金178935841720679662215%储备基金596119139692622175%企业发展基金596119139692622175%职工奖励及福利基金5961191396926221713利润归还投资50014应付优先股股利15应

99、付普通股股利16期初未分配利润10701655817313262817可供投资者分配利润9638152823641167447375411718各投资方利润分配289145870935013411263510%A方964153236117453751210%B方964153236117453751210%C方964153236117453751219年末未分配利润1070165581731326288220息税前利润356141502050785659120521息税折旧摊销前利润35613561415020507856591205现金流量表（全部投资）序号项目合计1234561 1现现金金流

100、流入入593468294123849432104001489034181.1销售收入585798294123849432104001489031801.2租金收入467000001381.3自营收入300000001001.4补贴收入（先征返还）00000001.5回收其他资金01.6回收固定资产余值01.7回收经营资金01.8净转售收入00000002 2现现金金流流出出4799417197710261351178954491012.1开发产品投资(不含财务费用)339871534848944901853630702.2经营资金00000002.3经营费用（出租和自营产业）600000020

101、2.4经营税金及附加3264570709471597874132.5土地增值税预征5861041298610915902.6土地增值税42230002289193302.7所得税5875117513706762592175682.8职工奖励及福利基金596119139692622173净现金流量11351-890352823297-139094403317累计净现金流量-8903-3621-323-17137727110444所得税前净现金流量17822-760867914042-1104118363391累计所得税前净现金流量-7608-8173225212113957173485净现值56

102、84-809443662477-94958621872累计净现值-8094-3728-1251-2200366255346所得税前净现值10474-691756123037-75473491914累计所得税前净现值-6917-13041733978832810242计算指标所得税前所得税后实际内部收益率(FIRR)56.33%30.34%表面内部收益率(FIRR)61.02%34.25%财务净现值(FNPV)104745684投资回收期（静态/动态）年3.262.773.493.91通货膨胀率3.00%3.00%10%基准收益率(Ie)10%10%FIRR(税前)61%项目变动幅度123原始值

103、变动值原始值变动值原始值变动值现金流入10%829491241238413622943210375现金流出15%17197197777102816761357055合计-8903-106535282545532973320基准收益率15%0.86960.75610.6575净现值3861-7742-92643994412521682183累计净现值2327-7742-9264-3748-5138-1579-2955现金流量表（资本金）序号项目合计1234561 1现现金金流流入入593468294123849432104001489034181.1销售收入5857982941238494321

104、04001489031801.2租金收入467000001381.3自营收入300000001001.4补贴收入（先征返还）00000001.5回收其他资金00000001.6回收固定资产余值00000001.7回收经营资金00000001.8净转售收入00000002 2现现金金流流出出29590474542103975694293961012.1权益资金00000002.2债务资金00000002.3收入资金155832896200327423688425402.4经营费用（出租和自营产业）6000000202.5经营税金及附加3264570709471597874132.6土地增值税预征

105、5861041298610915902.7土地增值税42230002289193302.8所得税5875117513706762592175682.9借款本利偿还00000002.10职工奖励及福利基金596119139692622173净现金流量29756354981745457345854943317累计净现金流量354911723171802063726131294484净现值19105308661803588197727311434累计净现值30869267128551483217563189975所得税前净现金流量36227484496826202374378903392累计所得税前

106、净现金流量484414526207282447132361357526所得税前净现值23306421273214078214039231466累计所得税前净现值42121153315611177512167423140计算指标所得税前所得税后实际内部收益率(FIRR)4.64%12.18%表面内部收益率(FIRR)15.10%23.40%财务净现值(FNPV)2330619105投资回收期（静态/动态）年通货膨胀率10.00%10.00%15%基准收益率(Ie)15%15%FIRR(税前)#NUM!财务计划现金流量表序号项目合计1234561 1经经营营活活动动净净现现金金流流量量453396

107、4451017781997146974833171.11.1现现金金流流入入593468294123849432104001489034181.1.1销售收入585798294123849432104001489031801.1.2租金收入467000001381.1.3自营收入300000001001.1.4补贴收入（先征返还）00000001.1.5其他流入01.21.2现现金金流流出出14007184922071233325451421011.2.1房地产投资(不含利息)339871534848944901853630701.2.2经营资金00000001.2.3经营费用（出租和自营产业

108、）6000000201.2.4经营税金及附加3264570709471597874131.2.5土地增值税预征5861041298610915901.2.6土地增值税42230002289193301.2.7所得税5875117513706762592175681.2.8职工奖励及福利基金596119139692622171.2.9其他流出02 2投投资资活活动动净净现现金金流流量量00000002.12.1现现金金流流入入00000002.1.1回收固定资产余值00000002.1.2回收经营资金00000002.1.3净转售收入00000002.1.4回收其他资金00000002.1.5其

109、他流入02.22.2现现金金流流出出00000002.2.1权益投资02.2.2债权投资02.2.3购建投资02.2.4其他投资03 3筹筹资资活活动动净净现现金金流流量量-2891-458-709-350-134-1126-353.13.1现现金金流流入入00000003.1.1权益资金00000003.1.2债务资金00000003.1.6其他流入03.23.2现现金金流流出出28914587093501341126353.2.1借款本金偿还00000003.2.2各种利息支出00000003.2.3应付利润（股利分配）28914587093501341126353.2.4利润归还投资50

110、0500000003.2.5其他流出04盈余资金424475987946878487012862232825累计盈余资金59871545423303303153893642218贷款还本付息计划表序号项目合计1234561长期借款偿还1.1年初借款本息累计000001.2本年借款00000001.3本年应计利息00000001.4本年还本付息0000000 还本05.00%付息01.5年末借款本息累计0000002短期借款偿还2.1年初借款本息累计000002.2本年借款00000002.3本年应计利息00000002.4本年还本付息0000000 还本7.00%付息02.5年末借款本息累计0

111、000003本年还本付息00000003.1 本年还本00000003.2 本年付息00000004还本资金来源23862781137352644161374.1摊销00000004.2折旧00000004.3税后利润1192723862781137352644161374.4其他05偿还长期贷款本金能力1192723862781137352644161376利息备付率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!7偿债备付率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!8长期借款偿还期(年

112、)4资产负债表序号项目1234561资产1406028470336853825942116422181.1流动资产总额1406028470336853825942116422181.1.1 应收帐款2074257817142172318001.1.2 存货6000104388669577300 其中：在建工程600010438866957731.1.3 货币资金1.1.4 累计盈余资金598715454233033031538936422181.2长期投资1.3固定资产净值1.4无形及递延资产净值2负债及所有者权益14282072102339232901022.1流动负债总额0000002.1

113、.1 应付帐款2.1.2 短期借款2.1.3 递延税金2.2长期负债总额0000002.2.1 经营资金借款2.2.2 开发产品投资借款000000负债小计0000002.3所有者权益14282072102339232901022.3.1 资本金0000002.3.2 资本公积2.3.3 累计盈余公积金35841720679662212.3.4 累计未分配利润10701655817313262882比率指标参考指标资产负债率(%)70%0%0%0%0%0%0%流动比率(%)120%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!速动比率(%)65%#DIV/

114、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!主要经济指标表序号名称单位数据备注项项目目设设计计参参数数projectproject designdesign parameterparameter1房地产开发产品总建筑面积total building area of real estate deveolpment平方米1440001.1商品住宅销售面积sale area of commercial residential building平方米1324801.2商业用房销售面积sale area of mercantile occupancy平方米115201.3车

115、位销售面积sale area of loading lot平方米1.3出租物业面积rent area of real estate平方米1.4自营资产self-support assets平方米2自营收入self-support income万元300经经济济数数据据economiceconomic datadata1总投资total investment for the project万元339872开发产品投资development investment万元33987 其中：财务费用thereinto:free of financial cost万元03单方价格unilateralism

116、price元/平方米23604资金筹措financing万元15583 其中：权益资金equity funds万元0 债权资金indebtedness funds万元0 收入资金receipts funds万元155835经营收入万元593466开发成本real estate development costs万元302537开发费用万元37348经营费用（出租和自营产业）万元609应缴税金taxes due万元13947 经营税金及附加Tax and additional expense万元3264 土地增值税万元4808 所得税Income tax万元587510利润总额total amo

117、unt of profits万元1780211税后利润net income万元1192712可分配利润distributive profits 万元2891财财务务评评价价指指标标financialfinancial evaluationevaluation indexindex1投资利润率earning power of real assets%10.48%年平均2投资净利润率net earning power of real assets%7.02%年平均3投资利税率（不含所得税）%15.23%年平均4资本金利润率profit-cost ratio%#DIV/0!年平均5资本金净利润率ne

118、t profit-cost ratio%#DIV/0!年平均6全部投资内部收益率（所得税前）total investment internal rate of return%61.02%7全部投资投资回收期（所得税前）年2.778全部投资内部收益率（所得税后）%34.25%9全部投资投资回收期（所得税后）年3.9110项目建设经营期construct and manage period of project年511房地产投资长期借款偿还期period of compensate long term loans of real estate investment年建设期起12自营部分盈亏平衡点（

119、经营达纲率）break-even point of self-support part%789101112131415161718100100（产权面积）1440144090%100%单位：万元789101112131415161718000000000000000000000000单位：万元78910000000000000000000000000000000000000单位：万元789101112131415161718000000000000000000000000000000000000单位：万元789101112131415161718000000000000000000000000

120、000000000000单位：万元7891011121314151617180000000000000000000000000000000000006006006006006006006006006006006006000000000000000000000000005050505050505050505050500000000000000000000000000000000000001000100010001000100010001000100010001000100010000000000000000000000000001001001001001001001001001001001001

121、000000000000000000000000000000000000001200120012001200120012001200120012001200120012000000000000000000000000002002002002002002002002002002002002000000000000000000000000000000000000001500150015001500150015001500150015001500150015000000000000000000000000001000100010001000100010001000100010001000100010

122、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000789101112131415161718000000000000000000000000000000000000单位：万元78910111213141516171800000000000000000000000000000000000000000000000000000000000078910111213141516171800000000000000000000000000000000000000

123、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000 00 00 00 00 0000000000000单位：万元789101112131415161718

124、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000单位：万元78910111213141516171800000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!00000000

125、0000000000000000000000000000000000000000单位：万元7891011121314151617181.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001%1%1%1%1%1%1%1%1%

126、1%1%1%000000000000000000000000000000000000586586586586586586586586586586586586单位：万元7891011121314151617180000000000005857958579585795857958579585795857958579585795857958579585790000000000003025330253302533025330253302533025330253302533025330253302530%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!100%100%100%1

127、00%100%100%100%100%100%#DIV/0!#DIV/0!#DIV/0!单位：万元789101112131415161718000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000单位：万元789101112131415161718100100660000000000550000000000000000000000000000000000000000000000000000000000

128、单位：万元7891011121314151617181561730000000000144014400000000000100100000000000090%100%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%9100000000000890000000000110000000000000000000000000000000000000000000000单位：万元78910111213141516171800

129、00000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000单位

130、：万元7891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000单位：万元789101112131415161718256273000000000000000000000015617300000000001001000000000000000000000000202014150000000000000000000000000000000000221238000000000022123800000000007378000000000

131、02200000000001481590000000000222400000000007800000000007800000000007800000000008288950000000001261350000000000384100000000001314000000000013140000000000131400000000008895000000000022123800000000002212380000000000单位：万元78910111213141516171825627300000000000000000000001561730000000000100100000000000000

132、000000000000000000000010711400000000000000000000000000000000002020000000000014150000000000000000000000000000000000737800000000007800000000001481590000000000111931135211352113521135211352113521135211352113521135211351229246000000000017577178231782317823178231782317823178231782317823178221782276740000

133、0000005610568556845684568456845684568456845684568456841171150000000000103601047410474104741047410474104741047410474104741047410474FIRR(税后)34%456789原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值10400114401489016379341837602562812733000011789135585449626710111610712311413100-1390-2118944010112331736441481581591

134、70000.57180.49720.43230.37590.32690.2843-795-121146935027143415755659525500-2374-4166231986137532436380924963861255138612551单位：万元789101112131415161718256273000000000000000000000015617300000000001001000000000000000000000000000000000000000000000000000000000000000000000000107113000000000000000000000000

135、000000000000000000000020200000000000141500000000000000000000000000000000007378000000000000000000000078000000000014815900000000002959629756297562975629756297562975629756297562975629756297565652000000000019053191051910519105191051910519105191051910519105191051910522924600000000003598136227362273622736

136、2273622736227362273622736227362273622786800000000000232262330623306233062330623306233062330623306233062330623306FIRR(税后)#NUM!单位：万元78910111213141516171814815900000000002562730000000000000000000000156173000000000010010000000000000000000000001071130000000000000000000000000000000000202000000000001415000

137、000000000000000000000000000000073780000000000780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-38-41000000000000000000000000000000000000000000000038410000000000000000000000000000000000384100000000000000000000001111190000000000423294244742447424474244742

138、447424474244742447424474244742447单位：万元789101112131415161718000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000148159000000000000000000000000000000000014815900000000001481590000000000#DIV/0!#DIV/0

139、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!单位：万元78910111213141516171842329424474244742447424474244742447424474244742447424474244742329424474244742447424474244742447424474244742447424474244

140、70000000000000000000000004232942447424474244742447424474244742447424474244742447424471111190000000000000000000000000000000000000000000000000000000000111119000000000000000000000022240000000000889500000000000%0%0%0%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#

141、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!19201920000000000019200000001920000000192000000060060000005050000000100010000000100100000000120012000000200200000000150015000000100010000000000000000000192000000019200000000000192000000000000000000000000

142、00000000019200000000000000019200000000000000000000019200000#DIV/0!#DIV/0!#DIV/0!#DIV/0!0000000019201.0%1.0%00001.0%1.0%00001.0%1.0%00001%1%0000005865861920005857958579003025330253#DIV/0!#DIV/0!#DIV/0!#DIV/0!19200000#DIV/0!#DIV/0!00192000000000000019200000000%0%00000%0%00000%0%0000000000001920000%0%0

143、0000%0%00000%0%00000%0%0000#DIV/0!#DIV/0!0019200000000000000001920000000000000000000000000000000000000000000000000000019200000000000000000000000000000000011351113510017822178220056845684001047410474101112131415原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值原始值变动值00000000000000024502450407040704000-2450-2450-4070-407

144、0-40.24720.21490.18690.16250.14130.1229000-530-460-660-5700386125513861249838612452386123863861232938612328192000000000000000000000000000000000000000000029756297560019105191050036227362270023306233061920000000000000000000000000000000000000000000000000000000000000000042447424471920000000000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!192042447424474244742447000042447424470000000000000000000%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!1617181920原始值变动值原始值变动值原始值变动值变动值原始值变动值000000000004040400000-40-40-400000.10690.09290.08080.07030.061100000000003861232838612328386123273861232738612327