房地产开发项目投资估算表.xls

1、建建筑筑规规模模估估算算表表项项目目户户型型单单套套面面积积 一一梯梯户户数数楼楼层层单单元元栋栋数数建建筑筑面面积积住宅多层一房0两房852730小三房0三房1202730四房1452730复式0小小计计0小高层一房0两房9021111121780小三房10021211024000三房13021211031200四房0复式0小小计计76980高层一房0两房0小三房0三房0四房0复式0小小计计0洋房第一层0第二层0第三层0第四层0第五层0第六层0小小计计0别墅独栋200100联排180100双拼160100叠加1101000写字楼0酒店宾馆0商业180012111600公建配套0合计78580

2、占地面积（亩）占地面积(平方米)容积率建筑密度建筑面积(平方米)基座面积(平方米)40.1229531295312.82.825%25%826868268673837383项目建筑面积(平方米)基座面积(平方米)容积率建筑密度规划标准8268673832.825%拟定规模7858073802.725%基基座座面面积积户户数数000000000000000019802422000240260024000006580722000000000000000000000000000000000000000080007380基座面积(平方米)738373831 12 23 34 4销销售售价价格格(元元/

3、平平方方米米)均价 项目1（住宅）项目2（小高层）400050006000 项目3（高层）项目4（商业）项目5（地下车位）销销售售计计划划(平平方方米米)78580 项目1（住宅）0.0050.0010.0010.0010.001 项目2（小高层）76980200003000026980 项目3（高层）0.0050.0010.0010.0010.001 项目4（商业）16001600 项目5（地下车位）0.0050.0010.0010.0010.001开开发发计计划划(平平方方米米)78580 项目1（多层）土建0 项目1（多层）安装0 项目2（小高层）土建769802000030000269

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

5、0出出租租率率(%)(%)项目1（地上车位）项目2 项目3土地费用序号项目合计12341土地出让金379837982交易服务费19193土地权属调查及地籍测绘004%交易契税152152000共计39693969000前期工程费用序号项目合计12341可行性研究费20202规划设计费44443水文地质勘测费10105三通一平44443%其他26660969020共计384178969020基础设施建设费用序号项目合计12341供电工程02供水工程03供气工程04排污工程05道路工程06通讯工程07绿化工程08照明工程09环卫设施010其他400400共计400400000公共配套设施建设费序号

6、项目合计12341会所02社区医院03幼儿园04中小学05公共厕所06停车场07垃圾中转站08水电机房09其他400100200共计40000100200建筑安装工程费用序号项目合计12341 项项目目1 1（住住宅宅）0 000001.1 土建工程费0 00000 建筑面积(平方米)0000 单价(元/平方米)6006006006006001.2 安装工程费0 00000 建筑面积(平方米)0000 单价(元/平方米)50505050502 项项目目2 2（小小高高层层）846884682000320029982702.1 土建工程费769876982000300026980 建筑面积(平方

7、米)2000030000269800 单价(元/平方米)100010001000100010002.2 安装工程费7707700200300270 建筑面积(平方米)0200003000026980 单价(元/平方米)1001001001001003 项项目目3 3（高高层层）0 000003.1 土建工程费0 00000 建筑面积(平方米)0000 单价(元/平方米)120012001200120012003.2 安装工程费0 00000 建筑面积(平方米)0000 单价(元/平方米)2002002002002004 项项目目4 4（商商业业）4004000004004.1 土建工程费240

8、240000240 建筑面积(平方米)0001600 单价(元/平方米)150015001500150015004.2 安装工程费160160000160 建筑面积(平方米)0001600 单价(元/平方米)100010001000100010005 项项目目5 5（地地下下车车位位）0 000005.1 土建工程费0 00000 建筑面积(平方米)0000 单价(元/平方米)00005.2 安装工程费0 00000 建筑面积(平方米)0000 单价(元/平方米)0000共计8868200032002998670开发间接费序号项目合计12341教育附加费1311312防空地下室易地建设费137

9、313733新型墙体材料专项费70704散装水泥专项基金13135工程定额测定费16166施工管理费34347建筑工程监督费20208安全监督费17179白蚁防治费131310房屋面积测量费121211交易手续费525212登记手续费6614其他费用100100共计18571857000销售费用序号项目合计12345.0%销售代理费用195904007508090.0%广告宣传及推广费用000000.0%其他销售费用00000共计 19590400750809销售费用投入计划100%20%30%30%15%1959392588588294项目总投资估算表序号项目合计1234一开发建设投资196

10、4691154360430215071房地产开发成本161798481339532849171.1土地费用396939690001.2前期工程费3841789690201.3基础设施建设费4004000001.4建筑安装工程费88682000320029986701.5公共配套设施建设费400001002001.6开发间接费185718570001.7不可预见费302779996272房地产开发费用346663496510195902.1销售费用19593925885882942.2管理费用8051611611611612.3财务费用70281216270135二经营资金0三项目总投资额196

11、4691154360430215071开发产品投资1964691154360430215072固定资产投资03经营资金00000项目回款进度表序号项目合计12341项目1（多层）000002项目2（小高层）391880800015000161883项目3（高层）000004项目4（商业）000005项目5（地下车位）00000小计39188391880800015000161882006项目1（多层）00 00 0项目2（小高层）00 00 0项目3（高层）00 00 0项目4（商业）00 00 0项目5（地下车位）00 00 02007项目1（多层）00 00 0项目2（小高层）800080

12、0080000 0项目3（高层）00 00 0项目4（商业）00 00 0项目5（地下车位）00 00 02008项目1（多层）00 00 0项目2（小高层）1500015000150000 0项目3（高层）00 00 0项目4（商业）00 00 0项目5（地下车位）00 00 02009项目1（多层）00 0项目2（小高层）161881618816188项目3（高层）00 0项目4（商业）00 0项目5（地下车位）00 02010项目1（多层）0项目2（小高层）0项目3（高层）0项目4（商业）0项目5（地下车位）02011项目1（多层）0项目2（小高层）0项目3（高层）0项目4（商业）0项目

13、5（地下车位）0小计3918839188080001500016188投资使用计划与资金筹措表序号项目合计12341总投资1964619646911591154360436043024302150715071.1经营资金000001.2固定资产投资000001.3开发产品投资196469115436043021507 其中：不含财务费用189449034414440321372 财务费用702812162701352资金筹措35017350171150511505901790171262712627150715072.1权益资金850585050002.1.1 资本金750075002.1.2

14、 股票融资02.1.3 股东投资100510052.1.4 政府投资02.2债务资金500030002000002.2.1 长期贷款5000300020002.2.2 短期贷款02.2.3 企业债券02.2.4 融资租赁02.3收入资金21512070171262715072.3.1 预售收入2151270171262715072.3.2 租金收入02.3.3 自营收入02.3.4 贴补收入02.3.5 其他收入0贷款还本付息计划表序号项目合计12341长期借款偿还1.1年初借款本息累计3000500025001.2本年借款500030002000001.3本年应计利息702812162701

15、351.4本年还本付息57028121627702635 还本5000250025005.40%付息702812162701351.5年末借款本息累计30005000250002短期借款偿还2.1年初借款本息累计0002.2本年借款000002.3本年应计利息000002.4本年还本付息00000 还本7.11%付息02.5年末借款本息累计00003本年还本付息570281216277026353.1 本年还本500000250025003.2 本年付息702812162701354还本资金来源972101548529928744.1摊销000004.2折旧000004.3税后利润972101

16、548529928744.4其他05偿还长期贷款本金能力47210154827993746利息备付率1911127297偿债备付率218218长期借款偿还期(年)4销售收入与经营税金估算表序号项目合计12341销售收入391880800015000161881.1可销售面积(平方米)7858002000030000285801.2平均售价元(元/平方米)498704000500056641.3销售比例(%)0%25%38%36%经营税金及附加215504408258905%营业税195904007508097%城市维护建设税13702853573%教育费附加590122324土地增值税预征估算

17、表序号项目合计12341项项目目1 1（多多层层）1.0%1.0%1.0%1.0%销售收入000001.0%预征税额000002项项目目2 2（小小高高层层）1.0%1.0%1.0%1.0%销售收入391880800015000161881.0%预征税额3920801501623项项目目3 3（高高层层）1.0%1.0%1.0%1.0%销售收入000001.0%预征税额000004项项目目4 4（商商业业）1%1%1%1%销售收入000001.0%预征税额000005预征土地增值税总额392080150162累计预征土地增值税080230392土地增值税估算附表序号项目合计12341销售收入3

18、91880800015000161882累计销售收入0800023000391883开发成本1617904061609160274累计开发成本0406110152161795销售比例0%25%38%36%85%累计销售比例0%25%64%100%25%64%100%土地增值税估算表序号项目合计12341销售收入78376000391882扣除项目46377000231882.1 开发成本32359000161792.2 开发费用323600016182.3 销售税金431100021552.4 其他扣除额647200032363增值额000160004增值比例0%0%0%69%5增值税率0%0

19、%0%40%6速算扣除率0%0%0%5%7土地增值税00052409已交土地增值税0802303929本年应缴土地增值税0004849自营收入及经营税金估算表序号项目合计12341自营收入02经营税金及附加000005%营业税000007%城市维护建设税000003%教育费附加000003净转售收入000003.1转售价格03.2转售成本03.3转售税金00000租金收入及经营税金估算表序号项目合计12341租金收入(万元)000001.1.1 可出租面积(平方米)00001.1.2 单位租金(元/月/平方米)00001.1.3 出租率(%)0%0%0%0%1.2.1 可出租面积(平方米)00

20、001.2.2 单位租金(元/月/平方米)00001.2.3 出租率(%)0%0%0%0%1.3.1 可出租面积(平方米)00001.3.2 单位租金(元/月/平方米)00001.3.3 出租率(%)0%0%0%0%2经营税金及附加000005%营业税000007%城市维护建设税000003%教育费附加000004净转售收入000004.1转售价格04.2转售成本04.3转售税金00000经营成本分摊表序号项目合计12341 项项目目1 1（住住宅宅）0.00%已销售面积00000销售比例20%20%20%20%开发总成本000002 项项目目2 2（小小高高层层）97.96%已销售面积769

21、800200003000026980销售比例0%26%39%35%开发总成本1563004061609154783 项项目目3 3（高高层层）0.00%已销售面积00000销售比例20%20%20%20%开发总成本000004 项项目目4 4（商商业业）2.04%已销售面积16000001600销售比例0%0%0%100%开发总成本5490005495 项项目目5 5（地地下下车车位位）已销售面积00000销售比例20%20%20%20%开发总成本04合计161790406160916027固定资产折旧固定资产3466折旧年限20残值率5%年折旧额165固定资产转售年限15固定资产转售成本99

22、7出租部分转售月租金(元/平方米/月)100出租面积(平方米)1000出租率(%)80%运营费用(万元)20%净租金收益(万元)76.8收益年限(年)50报酬率(%)8%转售价格(万元)940自营部分转售年经营收入(万元)1000年经营成本(万元)20年经营费用(万元)30经营税金及附加(万元)52.25正常利润率(%)10%年净收益(万元)797.75经营年限(年)10报酬率(%)7%转售价格(万元)5603成本费用估算表序号项目合计12341开开发发成成本本16179104061609160271.1 销售部分1617904061609160271.2 出租部分010年01.3 自营部分0

23、2开开发发费费用用346663496510195902.1 销售费用19593925885882942.2 管理费用805161161161161 折旧0 摊销02.3 财务费用702812162701353开发成本费用19646644502671106617利润与利润分配表序号项目合计12341经营收入391880800015000161881.1销售收入391880800015000161881.2租金收入000001.3自营收入000002开发成本费用196566445026711066173补贴收入（先征返还）04经营费用（出租和自营产业）05经营税金及附加21550440825890

24、6土地增值税预征3920801501627土地增值税484900048498利润总额1343102534706538329弥补前年度亏损47047010应纳税所得额12961020647065383225%所得税3240051617669581%所得税预征130021713811净利润（税后利润）9721015485299287412期初未分配利润01254542113可供分配利润75107015486553829510%法定盈余公积金97201555302871212三三项项基基金金00000 储储备备基基金金00000 企企业业发发展展基基金金00000 职职工工奖奖励励及及福福利利基基金

25、金00000可供投资者分配利润013936023800715应付优先股股利00%任意盈余公积金0000016应付普通股股利017各投资方可分配利润013936023800718各投资方利润分配4919013960280110%A方491901396028010%B方000000%C方0000018年末未分配利润012545421720719息税前利润8127507335396720息税折旧摊销前利润8127507335396721盈余公积9720155530287现金流量表（全部投资）序号项目合计12341 1现现金金流流入入391880800015000161881.1销售收入3918808

26、00015000161881.2租金收入000001.3自营收入000001.4补贴收入（先征返还）000001.5回收其他资金01.6回收固定资产余值01.7回收经营资金01.8净转售收入000002 2现现金金流流出出2987390545351684182642.1开发产品投资(不含财务费用)1894490344144403213722.2经营资金000002.3经营费用（出租和自营产业）000002.4经营税金及附加215504408258902.5土地增值税预征3920801501622.6土地增值税4849000484925%调整所得税3533206881834992 职职工工奖奖励

27、励及及福福利利基基金金000003所得税后净现金流量93159315-9054264981597924累计所得税后净现金流量-9054-6406175396774所得税后净现值38453845-7873200353654531累计所得税后净现值-7873-5871-50640255所得税前净现金流量1284912849-9034333699938916累计所得税前净现金流量-9034-56984295132116所得税前净现值61556155-7856252365705098累计所得税前净现值-7856-533312376335计算指标所得税前实际内部收益率(FIRR)37.86%表面内部收益

28、率(FIRR)51.64%财务净现值(FNPV)6155投资回收期（静态/动态）年2.572.81通货膨胀率10.00%15%基准收益率(Ie)15%FIRR(税前)51.64%现金流量表（资本金）序号项目合计12341 1现现金金流流入入391880800015000161881.1销售收入391880800015000161881.2租金收入000001.3自营收入000001.4补贴收入（先征返还）000001.5回收其他资金000001.6回收固定资产余值000001.7回收经营资金000001.8净转售收入000002 2现现金金流流出出51356115861026918138110

29、002.1权益资金850585050002.2债务资金500030002000002.3收入资金2151207017126271506.50082.4经营费用（出租和自营产业）000002.5经营税金及附加215504408258902.6土地增值税预征3920801501622.7土地增值税484900048492.8所得税3240051617669582.9借款本利偿还57028121627702635 职职工工奖奖励励及及福福利利基基金金000003所得税后净现金流量-12168-12168-11586-2269-31385188累计所得税后净现金流量-11586-13855-16993

30、-118064所得税后净现值-11447-11447-10533-1875-23583543累计所得税后净现值-10533-12408-14766-112225所得税前净现金流量-8927-8927-11586-1753-13726146累计所得税前净现金流量-11586-13339-14711-85656所得税前净现值-9039-9039-10533-1449-10314198累计所得税前净现值-10533-11981-13012-8815计算指标所得税前实际内部收益率(FIRR)-37.12%表面内部收益率(FIRR)-30.83%财务净现值(FNPV)-9039投资回收期（静态/动态）年

31、21.0021.00通货膨胀率10.00%10%基准收益率(Ie)10%FIRR(税前)-30.83%财务计划现金流量表序号项目合计12341 1经经营营活活动动净净现现金金流流量量28552069641225993291.11.1现现金金流流入入391880800015000161881.1.1 销售收入391880800015000161881.1.2 租金收入000001.1.3 自营收入000001.1.4 补贴收入（先征返还）000001.1.5 其他流入01.21.2现现金金流流出出1063601036274168591.2.1 房地产投资(不含利息)189449034414440

32、3213721.2.2 经营资金000001.2.3 经营费用（出租和自营产业）000001.2.4 经营税金及附加215504408258901.2.5 土地增值税预征3920801501621.2.6 土地增值税484900048491.2.7 所得税3240051617669581.2.8 职职工工奖奖励励及及福福利利基基金金00001.2.9 其他流出02 2投投资资活活动动净净现现金金流流量量000002.12.1现现金金流流入入000002.1.1 回收固定资产余值000002.1.2 回收经营资金000002.1.3 净转售收入000002.1.4 回收其他资金000002.1.

33、5 其他流入02.22.2现现金金流流出出000002.2.1 权益投资02.2.2 债权投资02.2.3 购建投资02.2.4 其他投资03 3筹筹资资活活动动净净现现金金流流量量390114241645-3372-34363.13.1现现金金流流入入13505115052000003.1.1 权益资金850585050003.1.2 债务资金500030002000003.1.6 其他流入03.23.2现现金金流流出出1311581355337234363.2.1 借款本金偿还500000250025003.2.2 各种利息支出702812162701353.2.3 应付利润（股利分配）7

34、41301396028013.2.4 其他流出04盈余资金28941114248609888758935累计盈余资金11424200332891934813资产负债表序号项目12341资产174243047137588405861.1流动资产总额174243047137588405861.1.1 应收帐款00001.1.2 存货60001043886695773 其中：在建工程600010438866957731.1.3 货币资金1.1.4 累计盈余资金114242003328919348131.2长期投资1.3固定资产净值1.4无形及递延资产净值2负债及所有者权益11505149141711

35、0166842.1流动负债总额00002.1.1 应付帐款2.1.2 短期借款2.1.3 递延税金2.2长期负债总额30005000250002.2.1 经营资金借款2.2.2 开发产品投资借款3000500025000负债小计30005000250002.3所有者权益8505991414610166842.3.1 资本金85058505850585052.3.2 资本公积2.3.3 累计盈余公积金01556859722.3.4 累计未分配利润0125454217207比率指标参考指标资产负债率(%)70%17%16%7%0%流动比率(%)120%#DIV/0!#DIV/0!#DIV/0!#D

36、IV/0!速动比率(%)65%#DIV/0!#DIV/0!#DIV/0!#DIV/0!主要经济指标表序号名称单位数据项项目目设设计计参参数数projectproject designdesign parameterparameter1房地产开发产品总建筑面积total building area of real estate deveolpment平方米785801.1商品住宅销售面积sale area of commercial residential building平方米769801.2商业用房销售面积sale area of mercantile occupancy平方米16001.3

37、车位销售面积sale area of loading lot平方米1.3出租物业面积rent area of real estate平方米1.4自营资产self-support assets平方米2自营收入self-support income万元0经经济济数数据据economiceconomic datadata1总投资overhead expenses万元196462开发产品投资gross investment万元19646 其中：财务费用operation funds万元7023单位成本unilateralism price元/平方米25004资金筹措financing万元35017 其

38、中：权益资金equity funds万元8505 债权资金indebtedness funds万元5000 收入资金receipts funds万元215125经营收入万元391886开发成本real estate development costs万元16179 其中：固定成本fund cost万元85177开发费用万元34668经营费用（出租和自营产业）万元09应缴税金taxes due万元10636 经营税金及附加management taxes and additional expense 万元2155 土地增值税commercial housing sale net income e

39、stimating chart万元5240 所得税commercial housing sale net income estimating chart万元324010利润总额total profit万元1343111税后利润after-tax profit 万元972112可分配利润distributive profits万元4919财财务务评评价价指指标标financialfinancial evaluationevaluation indexindex1总投资收益率（ROI）%71.94%2投资利润率earning power of real assets%13.67%3投资净利润率ne

40、t earning power of real assets%9.90%4投资利税率（不含所得税）%21.20%5资本金利润率profit-cost ratio%31.58%6资本金净利润率（ROE）net profit-cost ratio%22.86%7全部投资内部收益率（所得税前）total investment internal rate of return%51.64%8全部投资投资回收期（所得税前）年2.819全部投资内部收益率（所得税后）%38.47%10全部投资投资回收期（所得税后）年3.1211项目建设经营期construct and manage period of pro

41、ject年511房地产投资长期借款偿还期period of compensate long term loans of real estate investment年12自营部分盈亏平衡点（经营达纲率）break-even point of self-support part%5 56 67 78 89 91010111112121313（产权面积）0.0010.0010.001100%100%100%100%100%100%100%100%单位：万元5678910111213000000000000000000单位：万元5678910111213000000000000000000单位：万元

42、5678910111213000000000单位：万元567891011121310010000000000单位：万元5678910111213000000000000000000000000000600600600600600600600600600000000000000000000505050505050505050000000000000000000000000000100010001000100010001000100010001000000000000000000000100100100100100100100100100000000000000000000000000000120

43、0120012001200120012001200120012000000000000000000002002002002002002002002002000000000000000000000000000001500150015001500150015001500150015000000000000000000001000100010001000100010001000100010000000000000000000000000000000000000000000000000000000000000000000000000005678910111213000000000单位：万元567891

44、01112130000000000000000000000000000000000005%9800000000567891011121336200000000103000000000000000000000000000000000000000000001000000000000000000030000000025900000000980000000016100000000000000000362000000003620000000000000000056789101112130000000000000000000000000000000000000000000000000000000 00 0

45、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0000000000单位：万元56789101112133623620 00 00 00 00 00 00 00 000000000000000000036200000000362000000000000000003623620 00 00 00 00 00 00 00 0000000000000000000362000000003620单位：万元567891011121300000000000000000000000000000000000000000000

46、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000单位：万元5678910111213000000000000000000#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%000000000000000000000000000000000000单位：万元56789101112131.0%1.0%1.0%1.0%1.

47、0%1.0%1.0%1.0%1.0%0000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000001%1%1%1%1%1%1%1%1%000000000000000000000000000000000000单位：万元5678910111213000000000391883918839188391883918839188391883918839188000000000161791617916179161791

48、6179161791617916179161790%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%单位：万元5678910111213391880023188001617900161800215500323600160000069%40%5%52400000000单位：万元5678910111213000000000000000000000000000000000000000000000000000000单位：万元56789101112130000000000000000000000000000%

49、0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%000000000000000000000000000000000000000000000000000000单位：万元567891011121300000000020%0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%00000000000000000020%0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%000

50、00000000000000020%0%0%0%0%0%0%0%0%000000000单位：万元567891011121300000000000000000000000002590000000098000000001610000000000000000025900000000单位：万元5678910111213000000000000000000000000000000000000259000000000000000000000000000000000000000000000000000000000000000000000000000000007207648658375254472842553

51、830344731027207648658375254472842553830344731020000000000000000000000000000000000000000000007207648658375254472842553830344731020000000007207648658375254472842553830344731027216495845254734263833453107216495845254734263833453100000000000000000006486583752544728425538303447310227920000000000000000000

52、00000000单位：万元56789101112130000000000000000000000000000000000000000000000000000003620000000036200000000000000000000000000000000000000000000000000000000000000000000000-36200000000931593159315931593159315931593159315-18000000000384538453845384538453845384538453845-36200000000128491284912849128491284912

53、849128491284912849-18000000000615561556155615561556155615561556155所得税后25.88%38.47%38452.793.1210.00%15%FIRR(税后)38.47%单位：万元567891011121300000000000000000000000000000000000000000000000000000000000000000000000000000000036200000000000000000000000000361.970000000000000000000000000000000000000000000000000

54、0000000000000000000000-36200000000-12168-12168-12168-12168-12168-12168-12168-12168-12168-22500000000-11447-11447-11447-11447-11447-11447-11447-11447-11447-3620000000051.64%-8927-8927-8927-8927-8927-8927-8927-8927-8927-22500000000-9039-9039-9039-9039-9039-9039-9039-9039-9039所得税后-48.87%-43.76%-1144721

55、.0021.0010.00%10%FIRR(税后)-43.76%单位：万元567891011121300000000000000000000000000000000000000000000000000000000000000036200000000000000000000000000000000000000000000000000000000000000000000000-30.83%000000000000000000000000000000000000000000000000000000000000000-721-649-584-525-473-426-383-345-3100000000

56、00000000000000000000721649584525473426383345310000000000000000000721649584525473426383345310-721-649-584-525-473-426-383-345-310340923344332860323343186131436310533070830398单位：万元56789101112133409233443328603233431861314363105330708303983409233443328603233431861314363105330708303980000000000000000003

57、409233443328603233431861314363105330708303981596315314147311420513732133071292412579122690000000000000000000000000000000000001596315314147311420513732133071292412579122698505850585058505850585058505850585059729729729729729729729729726486583752544728425538303447310227920%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0

58、!#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!备注24.29%14.28%61.43%包括：土地、前期、基础、公共、间接、财务、管理年平均年平均年平均年平均年平均建设期起14141515161617171818191920201415161718192000000000000000141516171819200000000000000014151617181920000000014151617181920000000

59、014151617181920000000000000000000000600600600600600600600000000000000005050505050505000000000000000000000010001000100010001000100010000000000000000010010010010010010010000000000000000000000012001200120012001200120012000000000000000020020020020020020020000000000000000000000015001500150015001500150015

60、000000000000000010001000100010001000100010000000000000000000000000000000000000000000000000000000000014151617181920000000014151617181920000000000000000000000000000000000001415161718192000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001415

61、16171819200000000000000000000000000000000000000000000000000141516171819200 00 00 00 00 00 00 0000000000000000000000000000000000000 00 00 00 00 00 00 0000000000000000000000141516171819200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001415161

62、718192000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0000000000000000000000000000141516171819201.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000000001%1%1%1%1%1%1%000000000

63、0000000000000000000141516171819200000000391883918839188391883918839188391880000000161791617916179161791617916179161790%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!100%100%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!14151617181920141516171819200000000000000000000000000000000000

64、00000000141516171819200000000000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%0000000000000000000000000000000000000000001415161718192000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%

65、0%0000000141516171819200000000000000000000000000000000000000000000000000000141516171819200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000279225132261203518321649148427922513226120351832164914840000000000000000000000000000000000027922513226120351832164914840

66、000000279225132261203518321649148427925122620418316514827925122620418316514800000000000000251322612035183216491484133500000000000000000000014151617181920000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000093159315931593159315931593150000000

67、38453845384538453845384538450000000128491284912849128491284912849128490000000615561556155615561556155615514151617181920000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-12168-12168-12168-12168-12168-121

68、68-121680000000-11447-11447-11447-11447-11447-11447-114470000000-8927-8927-8927-8927-8927-8927-89270000000-9039-9039-9039-9039-9039-9039-9039141516171819200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

69、000000000-279-251-226-204-183-165-14800000000000000000000027925122620418316514800000000000000279251226204183165148-279-251-226-204-183-165-14830119298682964129438292552909028941141516171819203011929868296412943829255290902894130119298682964129438292552909028941000000000000003011929868296412943829255

70、290902894111990117391151211309111261096110812000000000000000000000000000011990117391151211309111261096110812850585058505850585058505850597297297297297297297225132261203518321649148413350%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!#DIV/0!#DIV/0!#DIV/0!#DIV/0!1 1

71、2 23 3销销售售价价格格(元元/平平方方米米)均价 项目1（住宅）10%000 项目2（小高层）10%040005000 项目3（高层）10%000 项目4（商业）0%000 项目5（地下车位）0%000销销售售计计划划(平平方方米米)项目1（住宅）0%0.0010.0010.001 项目2（小高层）0%02000030000 项目3（高层）0%0.0010.0010.001 项目4（商业）0%000 项目5（地下车位）0%0.0010.0010.001销销售售金金额额（万万元元）项目1（住宅）0000 项目2（小高层）43106.80880016500 项目3（高层）0000 项目4（商

72、业）0000 项目5（地下车位）0000开开发发计计划划(平平方方米米)土建面积合计12000%200003000026980安装面积合计1000%02000030000出出租租价价格格(元元/平平方方米米/月月)项目1（地上车位）000 项目2000 项目3000出出租租计计划划(平平方方米米)项目1（地上车位）000 项目2000 项目3000出出租租率率(%)(%)项目1（地上车位）0%0%0%项目20%0%0%项目30%0%0%现金流量表（全部投资）序号项目合计1231 1现现金金流流入入4310708800165001.1销售收入4310708800165001.2租金收入00001

73、.3自营收入00001.4补贴收入00001.5回收其他资金00001.6回收固定资产余值00001.7回收经营资金00001.8净转售收入00002 2现现金金流流出出276559123613275542.1固定成本881967235727172.2可变成本102152400380035382.3经营资金00002.4经营费用（出租和自营产业）000020.0%经营税金及附加86210176033005 5所所得得税税前前净净现现金金流流量量15452-912326688946调整项目调整幅度FIRR土建成本0%53.66%安装成本0%住宅价格10%小高层价格10%高层价格10%商业价格0%

74、车位价格-30%-25%-20%-15%-10%基准方案56.10%56.10%56.10%56.10%56.10%土建成本72.00%69.00%66.00%64.00%61.00%安装成本住宅价格小高层价格21.19%27.35%33.35%39.21%44.95%高层价格商业价格56.10%56.10%56.10%56.10%56.10%车位价格-30%-25%-20%-15%-10%-5%0%5%10%15%20%25%30%0.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%100.00%基准方案土建成本安装成本住宅价

75、格小高层价格高层价格商业价格车位价格4 45 56 67 78 89 9101011111212000000000600000000000000000000000000000000000000（产权面积）0.0010.001000000026980000000000.0010.00100000001600000000000.0010.001000000000000000017806.80000000000000000000000000000000000016000000000028580000000000000000000000000000000000000000000000000000000

76、000000000%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%单位：万元456789101112178070000000017807000000000000000000000000000000000000000000000000000000000000000000000004582264000000054326400000004780000000000000000000000000035610000000013225-2640000000-5%0%5%10%15%20%25%30%56.10%56.10%56.10%56.10%56

77、.10%56.10%56.10%56.10%58.52%56.10%53.75%51.45%49.22%47.04%44.92%42.85%56.10%55.97%55.85%55.72%55.59%55.46%55.33%56.10%50.57%56.10%61.54%66.90%72.19%77.41%82.56%87.66%56.10%56.10%56.10%56.10%56.10%56.10%56.10%56.10%56.10%56.10%-30%-25%-20%-15%-10%-5%0%5%10%15%20%25%30%0.00%10.00%20.00%30.00%40.00%50.

78、00%60.00%70.00%80.00%90.00%100.00%基准方案土建成本安装成本住宅价格小高层价格高层价格商业价格车位价格1313141415151616171718181919202000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000%0%0%0%0%0%0%0%0

79、%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%131415161718192000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000项项目目可可变变参参数数概概率率分分析析项目数值概率值（P）-20%-10%010%20%销售价格（元/）498720%20%50%10%0%销售面积（万）7.85815%80%5%0%0%成本费用（万元）196465%10%60%20%5%营业税及

80、附加税率20%指指标标指指数数说说明明PX098.30%98.30%利润大于0的概率PX=00.00%0.00%利润等于1的概率PX01.70%1.70%利润小于2的概率期望值（EX）66656665方差（DX）1098165810981658标准差()33143314变异系数()0.500.50注注：标标准准差差越越小小，说说明明随随机机变变量量取取值值偏偏离离其其期期望望值值的的离离散散程程度度越越小小，项项目目风风险险就就越越小小。注注：变变异异系系数数排排除除了了不不同同规规模模的的投投资资项项目目由由于于期期望望值值大大小小而而产产生生的的风风险险大大小小的的影影响响；变变异异系系数

81、数越越小小，项项目目风风险险越越小小。发生概率利润额EXDX合计10.0015004348766658052100%0.00300023837666554993100%0.01800041986665702237100%0.006000-1546-966654044860.001500-3511-5666515530220.00800068565566652920.0160004891786665503220.0960002927281666513413870.03200096231666510406250.008000-1003-8666547028330.00050093645666536

82、430.0010007399766655400.006000543533666590770.002000347076665204100.0005001505166651330840.000000118720666500.00000099070666500.00000079430666500.00000059780666500.000000401406665050.00000093640666500.00000073990666500.00000054350666500.00000034700666500.000000150506665060.0015006856106665550.003000

83、489115666594350.01800029275366652515100.006000962666651951170.001500-1003-266658817870.0080009677776665726090.01600077131236665175760.0960005748552666580634注注：标标准准差差越越小小，说说明明随随机机变变量量取取值值偏偏离离其其期期望望值值的的离离散散程程度度越越小小，项项目目风风险险就就越越小小。注注：变变异异系系数数排排除除了了不不同同规规模模的的投投资资项项目目由由于于期期望望值值大大小小而而产产生生的的风风险险大大小小的的影影响响；

84、变变异异系系数数越越小小，项项目目风风险险越越小小。0.032000378412166652656150.008000181915666518784180.0005001249966665170190.00100010534116665149740.0060008570516665217750.002000660513666570.000500464126665204890.000000153200666500.000000133560666500.000000113910666500.00000094270666500.0000007462066650100.0000001814206665

85、00.000000161770666500.000000142130666500.000000122480666500.00000010284066650110.0037509364356665273200.007500739955666540470.04500054352456665680790.01500034705266651530780.00375015056666599812120.0200001249925066656807570.0400001053442166655989600.2400008570205766658710150.080000660552866652830.02

86、0000464193666581939130.001250156342066651005590.002500136693466651226630.0150001170517666653810380.0050009740496665472940.00125077761066651543140.000000187690666500.000000168040666500.000000148400666500.000000128750666500.00000010911066650150.000000219040666500.000000199390666500.000000179750666500.

87、000000160100666500.00000014046066650160.0007501187296665203360.0015009907156665157720.0090007943716665147010.003000597818666514140.0007504014366655271170.004000153206166652996870.0080001335610766653581730.04800011391547666510723510.016000942715166651220600.00400074623066652544180.0002501876956665366

88、280.0005001680486665514070.003000148404566652004980.00100012875136665385710.00025010911366654507190.000000222170666500.000000202530666500.000000182880666500.000000163240666500.00000014359066650200.000000256660666500.000000237010666500.000000217370666500.000000197720666500.00000017808066650210.000000

89、143800666500.000000124150666500.000000104510666500.00000084860666500.0000006522066650220.000000181420666500.000000161770666500.000000142130666500.000000122480666500.00000010284066650230.000000219040666500.000000199390666500.000000179750666500.000000160100666500.00000014046066650240.000000256660666500.000000237010666500.000000217370666500.000000197720666500.00000017808066650250.000000294280666500.000000274630666500.000000254990666500.000000235340666500.000000215700666501.0000001.00000011504115046665666510981658