房地产项目投资动态测算表.xlsx

1、版本号201811061填写说明234561 土地指标和成本78 7 税率表9 9 土增表10 一、投决表11 二、核心指标12 三、报告表13 六、现金流量表14 附2请使用OFFICE软件打开，不要用WPS打开为了避免过多占用电脑内存，请在打开时选择“文件-选项-公式-除模拟运算表外，自动计算”由于选择了“除模拟运算表外，自动计算”，所以需更新完所有假设后，手动按F9进行模拟运算(六、敏感性分析表）的计算（否则敏感性分析不能更新）橙色工作表上涉及填写数字；橙色工作表中的橙色单元格需要输入，其他为公式自动计算除投模附带填写说明外，可参阅投模使用指引.doc（介绍更加明细）主要更新：1、增加分

2、期2、表格架构调整3、销售现金流需手动填写重要提示：如果做IRR和回收期敏感性分析，土地节点款项、单独投入款项应该和土地出让金价格（表1-D61）、土地转让价格挂钩（公式）重要提示：“1土地指标和成本”中“股权转让总价（万元）”请填写领地对应股比的股权交易价；“已支付有票成本（万元）”请填写项目公司全部已支付的有票成本（不乘以领地对应股比）请根据当地情况填写“7 税率表”中预征率，请区域财务确认，总部财务复核若涉及其他税费，需在土增表中手动填列投决表中大部分数据已和投模其他表格关联，需手动填写周边竞品、周边土拍等市场信息项目可研报告PPT应摘录“核心指标”表中的全部内容项目可研报告PPT应摘录

3、“报告表”表中的全部内容重要提示：回收期公式自动计算最后一次现金流回正的月份数。如果累计现金流回正后又变负数，需要进行手动进行判断和调整（如需手动填写，则回收期敏感性分析不再适用）填写完成后，请检查附2 勾稽关系表，原则上所有检验判定应为0，如遇不平衡的情况，请返回检查勾稽关系表 勾稽检验加总-1.05指标勾稽检验土地指标和成本规划指标基础数据总控计划表占地面积-11,33311,333计容面积-28,33328,33328,333总建筑面积-37,85437,854销售面积-31,918含税销售收入0.0047,255项目公司土地成本-19,113领地单独投入-前期工程费-0.00246基础

4、设施费-建安及装修工程费-14,635配套设施费-不可预见费-财务费用-一期开盘时间（月）-6二期开盘时间（月）-三期开盘时间（月）-四期开盘时间（月）-五期开盘时间（月）-六期开盘时间（月）-七期开盘时间（月）-八期开盘时间（月）-表格内部核验-1.05-返回目录销售现金流融资计划增值税土地增值税所得税土地成本现金流工程成本现金流成本利润31,91847,25547,25547,25519,11319,113-217246-13,15814,635-1,0401,0406-现金流量表47,255-1,040-1.05 目 录编号表名总部复核部门手动输入一、 投决表总部各职能部门周边竞品/地价

5、等二、 核心指标投管/财务三、 报告表投管/财务四、 成本利润投管/财务领地超额/固定管理费收益五、 现金流量表投管/财务领地超额/固定管理费收益现金流六、 敏感性分析投管/财务地价变动1土地指标和成本投管/财务规划指标、土地成本、支付节点等2规划指标产研强排数据3基础数据营销/成本/财务分期面积/销售比/均价/成本等4总控计划运营/营销开工/开盘/交房节点等5销售现金流量营销各细分业态个月销售面积和均价等6融资计划融资融资金额、还款计划、利息支出等7税率表财务各税种税率、计税方式8增值税财务9土增税财务其他税费10所得税财务11土地成本现金流投管/财务12工程成本现金流投管/财务/成本附1

6、填写说明投管附2 勾稽关系投管主要输出投决指标关键指标分析报告表成本利润表项目公司现金流、领地现金流、动态指标敏感性分析表土地成本及支出节点强排指标分期数据总控时间表销售现金流量表利息费用、融资现金流税率各期增值税金额各期土增税金额各期所得税金额土地成本现金流工程成本现金流填写说明勾稽关系判定结果密级：机密立项编号：【】【】项目投资动态测算执行总裁投资发展中心财务管理中心融资管理中心产品研发中心营销管理中心项目管理中心领地集团股份有限公司2020/9/3立项编号：【】项目投资动态测算领地集团股份有限公司2020/9/3领领地地集集团团投投资资决决策策意意见见表表【】项项目目 第第【】区区域域

7、负负责责人人【】一一、基基本本信信息息可售总货值（万元）47,25547,255占地面积（平米）11,33311,333容积率2.502.50计容面积（平米）28,33328,333总建面（平米）37,85437,854IRR(不含融资）120%120%领地土地总对价（万）19,11319,113对价组成按实际情况填写资金峰值（万,不含融资）21,45621,456资金峰值（万,含融资）19,58119,581IRR（含融资）#NUM!#NUM!我方权益比例100%100%项目公司利润（万）4,6464,646归属我方利润额-单向含自持（万）4,8284,828归属我方利润率-单向含自持10.

8、22%10.22%领地对应股比自持物业（万）1,0151,015归属我方利润率-单向现金8.07%8.07%折有票楼面价(元/方)6,7466,746并购楼面价(元/方)6,7466,746保证金及保证金预计退回时间按实际情况填写土地获利倍数2.52.5倍倍不含融资现金流回正月数8.8个月含融资现金流回正月数7.4个月起拍楼面价(元/方)6,546建议授权楼面价(元/方)土土地地/ /对对价价款款支支付付节节奏奏按实际情况填写开开发发进进度度净地获取日2018/12/31首期开工日2019/1/31示范区开放日2019/5/31首期开盘日2019/5/312019/5/31拿地-首期开盘周期6

9、 6个个月月融融资资方方案案按实际情况填写意向资金方按实际情况填写预计放款额度80008000预计融资成本二二、外外部部市市场场情情况况周周边边地地价价土地信息（类型/占地面积（亩）/容积率）竞得时间竞得企业竞得楼面价(元/方)溢价率与本项目车距整整体体市市场场情情况况业态全市年成交量(万平）全市年成交额（亿）区域年成交量(万平）区域年成交额（亿）不不得得为为空空不不得得为为空空不不得得为为空空不不得得为为空空不不得得为为空空不不得得为为空空竞竞品品情情况况竞品名称容积率6个月成交均价(元/方)目前成交均价(元/方)与本项目车距首次开盘时间月均去化情况最新开盘时间最新一期去化情况不不得得为为空

10、空不不得得为为空空不不得得为为空空三三、产产品品及及效效益益产产品品情情况况产品类型售价起价（元）售价均价（元）销售面积货值（万元）货值比例（%）首月销售面积月均销售面积销售比（%）单方计容建造成本（元）成本合计（元）类型产品描述高高层层16,00016,00016,00016,00026,58026,58042,52942,52990.0%90.0%20,00020,0005,3165,316手手动动链链接接手手动动链链接接手手动动链链接接商商业业30,00030,00030,00030,0008508502,5502,5505.4%5.4%213213213213手手动动链链接接手手动动链

11、链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接手手动动链链接接非人防地库地下车位(产权）4,8484,8484,8484,8484,4884,4882,1762,1764.6%4.6%374374374374手手动动链链接接手手动动链链接接手手动动链链接接人防地库地下车位(人防）0 00 00 00.0%0.0%手手动动链链接接手手动动链链接接手手动动链链接接总体情况持有物业货货量量（不不含含车车位位，）当年签约面积- -次年签约面积27,43

12、027,430第三年签约面积- -第四年签约面积- -第五年及后续签约面积- -货货值值（全全业业态态，万万元元）当年签约额- -次年签约额45,07945,079第三年签约额- -第四年签约额363363第五年及后续签约额1,8131,813当年回款额- -次年回款额44,28244,282第三年回款额797797第四年回款额181181第五年及后续回款额1,9951,995四四、开开发发运运营营进进度度信信息息首期开工时间2019/1/31开放工期（自拿地，含集团规定的春节、冬歇期）6个月计划开放时间（自拿地起点计算）2019/5/31首期开盘工期（自拿地，含集团规定的春节、冬歇期）6个月

13、首期开盘时间（自拿地起点计算）2019/5/31开开发发条条件件报建总费用具体构成说明市政配套车位配比地下车位比例冬歇期土方费用说明抗震设防烈度道路通达程度预计桩基础类型特特殊殊规规划划条条件件限高配建安置房情况其他预预售售条条件件预售保证金监管情况地地块块特特征征有利因素请请区区域域按按照照实实际际情情况况，如如实实填填写写，如如没没有有，请请填填写写“无无”不利因素请请区区域域按按照照实实际际情情况况，如如实实填填写写，如如没没有有，请请填填写写“无无”五五、风风险险事事项项及及应应对对措措施施请请区区域域按按照照实实际际情情况况，如如实实填填写写，如如没没有有，请请填填写写“无无”六六、

14、区区域域意意见见 具具体体意意见见区区域域投投资资负负责责人人区区域域总总签字： 日期：签字： 日期：七七、上上报报总总部部各各部部门门意意见见部部门门营营销销运运营营财财务务具具体体意意见见签字： 日期：签字： 日期：签字： 日期：部部门门融融资资成成本本商商管管具具体体意意见见签字： 日期：签字： 日期：签字： 日期：部部门门审审计计监监察察法法务务产产研研具具体体意意见见签字： 日期：签字： 日期：签字： 日期：承责内容：规划指标合理、销售及回款目标可实现、利润目标可实现、产品配置及成本目标可实现、工程及费用付款进度准确、风险事项揭示清晰完整、市场数据准确明确。八八、投投资资意意见见 具

15、具体体意意见见总总部部投投资资意意见见总总部部分分管管投投资资副副总总裁裁意意见见签字： 日期：签字： 日期：九九、最最终终决决策策意意见见（执执行行总总裁裁、董董事事会会）签字：日期：二、核心指标 核心经营指标领地土地投入1.911.91亿亿领地股比项目公司土投1.91亿项目货值开发成本1.49亿期间费用领地现金收益-不计息0.46亿净利率-不计息现金领地现金收益-单向计息0.380.38亿亿净利率-单向现金领地现金收益-双向计息0.56亿净利率-双向现金经营现金流回正周期8.88.8个个月月全投资IRR融资后现金流回正周期7.47.4个个月月自有资金IRR土地基本指标土土地地面面积积( (

16、亩亩) )容积率计容建面限高17亩2.53 3万万100米土地成本（含其他已付）总额/项目公司领领地地100.0%100.0%领地单独投入领地投入合计1.911.91亿亿1.911.91亿亿0.000.00亿亿1.911.91亿亿不含税交易楼面价其中有票折算含税楼面价（含其他已付）6746元/6746元/67466746元元/ /其他成本开发成本总额(万）建安支付节点支付比例前期费用246开盘条件高层1/3清水建安11,446开工-开盘15%装修建安3,190开盘-交付65%其他开发成本0交付后20%全盘计划全盘节点计划周期时间开始2018年11月国土证1个月2018年12月净地交付1个月20

17、18年12月开工2个月2019年1月四证3个月2019年2月亮亮相相6个月2019年5月开盘(首期）6个月20192019年年5 5月月交房(首期)36个月2021年11月售罄(全盘)47个月2022年10月分期计划分期计划开盘周期开盘时间可售货量一期6个月2019年5月3.5万二期三期四期五期六期七期八期分期汇总6个月2019年5月3.5万成本利润计容面积2.74万可售面积3.49万项目公司主要指标金额（万元）计容单价（元/)可售单价（元/)货值47,25517,22713,536土地成本19,1136,9685,475开发成本14,8815,4254,263销售费用1,418517406管

18、理费用1,418517406财务费用1,040379298其他费用1043增值税及增值税附加1,588579455土地增值税560204160营业外支出（收入）-所得税2,582941739项目净利润4,6461,6941,331领地股份占比%100%领地股权投资现金收益4,6461,6941,331我方单独投入(收益）-单向计息834304239领地单向现金3,8131,3901,092项目自持物业价值1,015领地对应股比自持物业价值1,015370291领地单向自持4,8281,7601,383细分业态销售和成本计计容容收收入入/ /计计容容建建面面1591015910元元/ /计计容容

19、成成本本/ /计计容容建建面面细细分分业业态态分分类类总总面面积积( () )销销售售比比(%)(%)合合计计37,85484%高高层层普普通通住住宅宅26,580100%商商业业普普通通住住宅宅850100%配配套套设设施施计计容容配配套套- -不不可可售售9030%地地下下车车库库（产产权权）地地下下车车位位( (产产权权) )7,48060%地地下下车车位位（人人防防）地地下下车车位位( (人人防防)-)-不不可可售售2,0400%-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%返回目录

20、100%货地比2.52.5倍倍4.734.73亿亿项目留存物业0.10亿0.39亿税金0.47亿9.83%净利率-不计息自持11.98%8.07%净利率-单向自持10.22%11.96%净利率-双向自持14.10%119.5%经营现金流资金峰值2.15亿#NUM!自有资金峰值1.96亿建筑密度总建筑面积总可售面积可售比30%4万3万92%支付批次地价支付月份地价支付时间地价支付额地价支付比例10个月2018119556万50%21个月2018129556万100%34567三费融融资资1.001.00年年0.80亿13.00%利息费用1040万营销费比例3%销售费用1418万管理费比例3%管理

21、费用1418万三税土增/增值税及附加2147万所得税2582万核心经营指标土地基本指标土地成本（含其他已付）其他成本领地-经营现金流回正8.88.8个个月月201907领地现金流回正时绝对额占全盘比项目公司累计签约面积2.3万72%项目公司累计签约额3.7亿78%项目公司累计回款额2.5亿54%项目公司累计土投1.9亿100%项目公司累计开发成本0.3亿19%项目公司累累计计其其他他成成本本0.3亿44%项项目目公公司司累累计计现现金金盈盈余余0.0亿领领地地对对应应股股比比盈盈余余0.000.00亿亿领领地地累累计计单单独独投投入入( (收收益益) )0.000.00亿亿货量占比现金货值货值

22、占比自持价值自持占比100.0%4.73亿100.0%0.10亿100.0%100.0%4.73亿100.0%0.10亿100.0%销售面积3.19万销售面积单价（元/)占比备注14,805100.0%5,98840.4%4,66231.5%4443.0%销销售售费费用用率率3.0%3.0%4443.0%管管理理费费用用率率3.0%3.0%3262.2%峰峰值值融融资资0.800.80亿亿30.0%4973.4%1751.2%全盘计划分期计划-0.0%8095.5%1,4569.8%1,4569.8%-0.0%2611.8%1,1948.1%3182.1%1,51310.2%39223922元

23、元/ /车车位位盈盈亏亏-1346-1346万万元元销售起价销销售售均均价价( (元元) )单单方方精精装装(元元)单单方方建建安安(元元)持持有有物物业业折折扣扣(%)销销售售面面积积( () )31,91816,0001,2002,8000%26,58030,000-3,0000%850-2,5000%-4,848-3,70070%4,488-3,7000%-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%-车位盈亏/计容建面-475-475元元/ /销销售售总总价价(万

24、万元元)总成本持持有有物物业业价价值值(万万元元)开售时间首开去化月均去化47,25514,6351,01542,52910,632-20190520,0005,3162,550255-201909213213-226-2,1762,7681,015-755-202111374374-1346-1346万万元元-【】竞得楼面价(元/)6546 执行总裁： _ 投资负责人：_ 项目概况项目可售资源规划指标项目类型公开市场招拍挂类型可售(万)售价(元/)土地面积(亩)17股权比例（%）100%普通住宅2.7416,434土地面积1.1 万起拍楼面价(元/)6,546非普通住宅容积率2.50竞得楼面

25、价(元/)6,546非住宅计容建面2.8 万领地土投（亿）1.9计容配套-可售建筑密度30%交易楼面价6,746地下车位(产权)0.754,848限高(m)100折算楼面价6,746地下商业及其他项目关键指标单位：亿元股比100%4.73亿2.5倍0.381.96亿1.91项目货值-现金货地比LD净回报-现金单向自有资金-峰值LD土地投入0.10亿10.22%8.07%0.46亿项目自持物业LD净利率-单向含自持LD净利率-单向现金LD净现金流领地现金流(万元）领地融资后现金流量表201811201901201903201905201907201909201911202001202003202

26、005202007202009202011202101202103202105202107202109202111202201202203202205202207202209202211202301202303202305202307202309202311202401202403202405202407202409202411202501202503202505202507202509202511202601202603202605202607202609202611202701202703202705202707202709 -25,000 -20,000 -15,000 -10,000

27、-5,000 - 5,000 10,000 15,000 20,000 25,000 净现金流累计现金流领地融资后现金流量表2018112019012019032019052019072019092019112020012020032020052020072020092020112021012021032021052021072021092021112022012022032022052022072022092022112023012023032023052023072023092023112024012024032024052024072024092024112025012025032025

28、05202507202509202511202601202603202605202607202609202611202701202703202705202707202709 -25,000 -20,000 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 25,000 净现金流累计现金流去化(万)销售比2.74100%0.4560%1.04亿#NUM!自有资金-均值IRR(融资后)8.8个月120%回收期(经营)IRR(经营）自有资金-峰值1.96亿自有资金-均值1.04亿IRR(融资后)#NUM!经营回收期8.8个月IRR(经营)120%

29、项目可售资源售价(元/)16,4344,848领地融资后现金流量表201811201901201903201905201907201909201911202001202003202005202007202009202011202101202103202105202107202109202111202201202203202205202207202209202211202301202303202305202307202309202311202401202403202405202407202409202411202501202503202505202507202509202511202601202

30、603202605202607202609202611202701202703202705202707202709 -25,000 -20,000 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 25,000 净现金流累计现金流领地融资后现金流量表2018112019012019032019052019072019092019112020012020032020052020072020092020112021012021032021052021072021092021112022012022032022052022072022092022

31、11202301202303202305202307202309202311202401202403202405202407202409202411202501202503202505202507202509202511202601202603202605202607202609202611202701202703202705202707202709 -25,000 -20,000 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 25,000 净现金流累计现金流四、成本利润表(现金口径）返回目录项目公司现金收益序项目金额（万元）股东方收益

32、序项目金额（万元）一含税收入总额47,255一管理费收益-二成本合计34,0041固定管理费收益1土地成本及其他已付19,1132超额管理费收益2含税开发成本14,881二我方单独投入-3其他费用（注1）101股权收购溢价-三期间费用3,8752居间费-1销售费用1,4183股权转让税费-2管理费用1,4184其他-3财务费用1,040三利息计算五税金及附加2,1471单向计息8341增值税及增值税附加1,5882双向计息-1,0032土地增值税560四收益率六营业外净收入-1.1领地现金净回报额-不计息4,6461营业外收入-1.2净利率-不计息现金9.83%2营业外支出-1.3净利率-不计

33、息自持11.98%税前利润7,2282.1领地现金净回报额-单向3,813所得税2,5822.2净利率-单向现金8.07%项目净利润4,6462.3净利率-单向自持10.22%领地股份占比%100.0%3.1领地现金净回报额-双向5,650领地股权投资现金收益4,6463.2净利率-双向现金11.96%项目公司自持价值项目自持物业价值1,0153.3净利率-双向自持14.10%领地对应股比自持物业价值1,015注1：D9其他费用包括支出的全部物业维修金、产权税费和招商造活费用，不包括可资本化的利息支出（所有利息支出体现在D13财务费用中）五、现金流量表-项目公司所得税预计利润率20.00%增值

34、税预征率3.00%交付时间土增税税负增值税税负项目毛利率全盘2021/11/301.30%3.30%30.71%一、项目公司现金流序号项 目判定锚定数据小计一经营现金流入-47,25547,2551房款收入-47,25547,255二经营现金流出0.3541,56841,5682土地费用及股权款支付-19,11319,1133含税开发成本-14,88114,8814其他费用（注1）-10105税费支出-2,1472,1476所得税0.352,5822,5817管理费用-1,4181,4188销售费用-1,4181,4189营业外收入-10营业外支出-三经营性现金净流量-5,6875,687四融

35、资净流量0.00-1,040-1,0408本期银行借款借入-8,0008,0009归还银行借款-8,0008,00010利息收支及中间费-1,0401,040五现金净流量-4,6474,647累计净现金流-0.354,6464,64711收入结转-47,25547,25512预计利润-4,6034,60313当期所得税计算0.352,5822,58114增值税-1,4181,41815其他税费-730730注1：其他费用包括支出的全部物业维修金、产权税费和招商造活费用，不包括可资本化的利息支出（所有利息支出体现在D93利息收支及中间费中）二、领地现金流我方股权占比100%序号项 目判定锚定数据

36、小计一项目公司对应股比股东现金流-0.354,6464,6471对应股比-经营性现金流-5,6875,6872对应股比-融资净流量-1,040-1,040二领地单独现金流-1领地单独投入现金流-2固定管理费收益-3超额管理费收益-不含融资领地净现金流（不含融资）-0.355,6865,687领地累计现金流（不含融资）-0.355,6865,687含融资领地净现金流（含融资）-0.354,6464,647领地累计现金净流量（含融资）-0.354,6464,647三、指标计算全投资（不含融资）含融资领地IRR119.52%#NUM!回收期（月）8.8个月7.4个月回正时间2019年8月2019年6

37、月峰值资金投入（万元）21,45619,581投入期月均投入（万元）14,07410,422回正月累计签约面积(m2)22,944回正月累计签约额（万元）36,710回正月累计回款额（万元）25,289回正月累计项目公司土投（万元）19,113回正月累计开发成本（万元）2,819回正月累计其他成本（万元）3,357回正月累计领地投入（收益）（万元）-重要提示：回收期公式自动计算最后一次现金流回正的月份数。如果累计现金流回正后又变负数，需要进行手动进行判断和调整（如需手动填写，则回收期敏感性分析不再适用）四、双向计息月利率领地融资后现金流量表201811201903201907201911202

38、003202007202011202103202107202111202203202207202211202303202307202311202403202407202411202503202507202511202603202607202611202703202707 -25,000 -20,000 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 25,000 净现金流累计现金流股东借款利率1.00%集团调用项目公司资金利率0.50%交房时间2021/11/30序号项 目判定锚定数据小计股东借款利息如有缺口自动计息-834-834融资利

39、息自动计息至交房-1,8371,837返回目录土增平均预征率1.30%201811201812201901201902201903201904201905201906-12,8007,453-12,8007,4539,55610,0254694694694691,7021,2539,5569,556-4694694694694693264-543316-389226-384224-384224-9,556-10,025-469-469-469-46911,0986,199-8,000-87-87-87-87-87-8,000-8787878787-9,556-10,0257,531-555-5

40、55-55511,0116,113-9,556-19,581-12,050-12,605-13,160-13,716-2,7053,408-389226-349203-193113注1：其他费用包括支出的全部物业维修金、产权税费和招商造活费用，不包括可资本化的利息支出（所有利息支出体现在D93利息收支及中间费中）201811201812201901201902201903201904201905201906-9,556-10,0257,531-555-555-55511,0116,113-9,556-10,025-469-469-469-46911,0986,199-8,000-87-87-8

41、7-87-87-9,556-10,025-469-469-469-46911,0986,199-9,556-19,581-20,050-20,519-20,987-21,456-10,358-4,159-9,556-10,0257,531-555-555-55511,0116,113-9,556-19,581-12,050-12,605-13,160-13,716-2,7053,408领地融资前现金流量表201811201903201907201911202003202007202011202103202107202111202203202207202211202303202307202311

42、202403202407202411202503202507202511202603202607202611202703202707 -25,000 -20,000 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 净现金流累计现金流重要提示：回收期公式自动计算最后一次现金流回正的月份数。如果累计现金流回正后又变负数，需要进行手动进行判断和调整（如需手动填写，则回收期敏感性分析不再适用）领地融资后现金流量表20181120190320190720191120200320200720201120210320210720211120220320

43、2207202211202303202307202311202403202407202411202503202507202511202603202607202611202703202707 -25,000 -20,000 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 25,000 净现金流累计现金流201811201812201901201902201903201904201905201906-96-196-120-126-132-137-27-1720190720190820190920191020191120191220200120

44、20026,3799,9742,8871,9621,5311,2963832556,3799,9742,8871,9621,5311,2963832551,1111,588647525467436315298-264264264264264264264264-2704231228365551611194303886046391281912998759463911819129987594639118-5,2688,3862,2401,4371,06485968-43-87-87-87-87-87-87-8,087-8,000-87878787878787-5,1828,2992,1531,351

45、977773-8,019-438,59016,88919,04220,39321,37022,14214,12314,080-19430388604639128174272795442351079615144302320642019072019082019092019102019112019122020012020025,1828,2992,1531,351977773-8,019-435,2688,3862,2401,4371,06485968-43-87-87-87-87-87-87-8,087-5,2688,3862,2401,4371,06485968-431,1109,49611,7

46、3513,17314,23615,09615,16315,1205,1828,2992,1531,351977773-8,019-438,59016,88919,04220,39321,37022,14214,12314,080领地融资前现金流量表201811201903201907201911202003202007202011202103202107202111202203202207202211202303202307202311202403202407202411202503202507202511202603202607202611202703202707 -25,000 -20,0

47、00 -15,000 -10,000 -5,000 - 5,000 10,000 15,000 20,000 净现金流累计现金流201907201908201909201910201911201912202001202002-4384951021071117170202003202004202005202006202007202008202009202010202011159-159-285264264264264264264264264-264264264264264264264264264-7-5-5-5-126-264-264-264-264-264-264-264-264-126-26

48、4-264-264-264-264-264-264-26413,95413,69013,42613,16212,89712,63312,36912,10511,841-5-4-2-202003202004202005202006202007202008202009202010202011-126-264-264-264-264-264-264-264-264-126-264-264-264-264-264-264-264-264-126-264-264-264-264-264-264-264-26414,99414,73014,46614,20213,93713,67313,40913,145

49、12,881-126-264-264-264-264-264-264-264-26413,95413,69013,42613,16212,89712,63312,36912,10511,841202003202004202005202006202007202008202009202010202011-706867666463626159202012202101202102202103202104202105202106202107202108-264264264264264589589589589-264264264264264589589589589-264-264-264-264-264-

50、589-589-589-589-264-264-264-264-264-589-589-589-58911,57711,31211,04810,78410,5209,9319,3438,7548,165-202012202101202102202103202104202105202106202107202108-264-264-264-264-264-589-589-589-589-264-264-264-264-264-589-589-589-589-264-264-264-264-264-589-589-589-58912,61712,35212,08811,82411,56010,971

51、10,3839,7949,205-264-264-264-264-264-589-589-589-58911,57711,31211,04810,78410,5209,9319,3438,7548,165202012202101202102202103202104202105202106202107202108-585755545350474441202109202110202111202112202201202202202203202204202205-73109136181181181181-731091361811811811815895891,74150551051751751729-

52、589589488488488488488488-10-141568888-1,0986710101010-2345555-2345555-589-589-1,669-396-374-336-336-336152-589-589-1,669-396-374-336-336-3361527,5766,9885,3194,9234,5494,2143,8783,5433,695-45,151109136181181181181-4,398111318181818-1,0986710101010-125345555-162233332021092021102021112021122022012022

53、02202203202204202205-589-589-1,669-396-374-336-336-336152-589-589-1,669-396-374-336-336-336152-589-589-1,669-396-374-336-336-3361528,6168,0286,3595,9635,5895,2544,9184,5834,735-589-589-1,669-396-374-336-336-3361527,5766,9885,3194,9234,5494,2143,8783,5433,695202109202110202111202112202201202202202203

54、202204202205-383527-2022062022072022082022092022102022112022122023012023022023031811811811811811097345-1811811811811811097345-292929292917127-88888532-1010101010642-55555321-55555321-152152152152152916138-152152152152152916138-3,8473,9994,1524,3044,4564,5484,6094,6474,6474,6471811811811811811097345-

55、18181818181174-1010101010642-55555321-33333211-202206202207202208202209202210202211202212202301202302202303152152152152152916138-152152152152152916138-152152152152152916138-4,8875,0395,1925,3445,4965,5885,6495,6875,6875,687152152152152152916138-3,8473,9994,1524,3044,4564,5484,6094,6474,6474,64720220

56、6202207202208202209202210202211202212202301202302202303-202304202305202306202307202308202309202310202311202312202401-4,6474,6474,6474,6474,6474,6474,6474,6474,6474,647-202304202305202306202307202308202309202310202311202312202401-5,6875,6875,6875,6875,6875,6875,6875,6875,6875,687-4,6474,6474,6474,647

57、4,6474,6474,6474,6474,6474,647202304202305202306202307202308202309202310202311202312202401-202402202403202404202405202406202407202408202409-4,6474,6474,6474,6474,6474,6474,6474,647-202402202403202404202405202406202407202408202409-5,6875,6875,6875,6875,6875,6875,6875,687-4,6474,6474,6474,6474,6474,64

58、74,6474,647202402202403202404202405202406202407202408202409-202410202411202412202501202502202503202504202505202506-4,6474,6474,6474,6474,6474,6474,6474,6474,647-202410202411202412202501202502202503202504202505202506-5,6875,6875,6875,6875,6875,6875,6875,6875,687-4,6474,6474,6474,6474,6474,6474,6474,6

59、474,647202410202411202412202501202502202503202504202505202506-202507202508202509202510202511202512202601202602202603202604-4,6474,6474,6474,6474,6474,6474,6474,6474,6474,647-202507202508202509202510202511202512202601202602202603202604-5,6875,6875,6875,6875,6875,6875,6875,6875,6875,687-4,6474,6474,64

60、74,6474,6474,6474,6474,6474,6474,647202507202508202509202510202511202512202601202602202603202604-202605202606202607202608202609202610202611202612202701202702-4,6474,6474,6474,6474,6474,6474,6474,6474,6474,647-202605202606202607202608202609202610202611202612202701202702-5,6875,6875,6875,6875,6875,687

61、5,6875,6875,6875,687-4,6474,6474,6474,6474,6474,6474,6474,6474,6474,647202605202606202607202608202609202610202611202612202701202702-202703202704202705202706202707202708202709202710-4,6474,6474,6474,6474,6474,6474,6474,647-202703202704202705202706202707202708202709202710-5,6875,6875,6875,6875,6875,68

62、75,6875,687-4,6474,6474,6474,6474,6474,6474,6474,647202703202704202705202706202707202708202709202710-六、敏感性分析重要提示：为减少内存占用，本表（“选项-公式-除了模拟表以外，自动计算”）需要手动计算，请在更改所有假设后，按F9计算返回目录1、地价单因素分析竞拍口径单向计息单向计息单向计息双向计息双向计息序号竞得楼面价(元/)竞得楼面价（元/）竞得亩单价（万元/亩）竞得总价（亿元）溢价率项目总投资(亿元)项目净利润(亿元)领地土地总价(亿元)净利润（亿元）净利率（现金）净利率(含自持）净利率（

63、现金）净利率(含自持）LD净现金流（亿）回收期（融资前）回收期（融资后）IRR(经营）IRR(融资后)辅助判定隐藏6,546654610911.850%3.400.461.910.388.07%10.2%12.0%14.1%0.468.8个月7.4个月120%#NUM!-1.0500016546654610911.850%3.400.51.910.388.1%10.2%12.0%14.1%0.468.797.4月120%251%(1)26746674611241.913%3.460.41.970.337.0%9.2%10.7%12.9%0.428.907.5月107%223%(1)369466

64、94611581.976%3.520.42.030.285.9%8.1%9.5%11.6%0.379.017.6月96%198%(1)47146714611912.029%3.580.32.090.234.9%7.0%8.2%10.4%0.339.087.7月85%175%(1)57346734612242.0812%3.630.32.140.173.5%5.7%6.7%8.9%0.279.157.7月75%172%(78)67546754612582.1415%3.690.22.200.112.2%4.4%5.2%7.4%0.229.227.8月65%150%(198)77746774612

65、912.1918%3.750.12.260.040.9%3.1%3.7%5.9%0.189.297.9月56%129%(319)87946794613242.2521%3.810.12.32-0.02-0.4%1.7%2.2%4.4%0.139.368.0月47%110%(439)98146814613582.3124%3.870.02.38-0.09-1.9%0.2%0.6%2.7%0.079.427.9月38%104%(587)108346834613912.3627%3.93-0.02.44-0.15-3.3%-1.1%-1.0%1.2%0.039.498.0月30%84%(708)11

66、8546854614242.4231%3.98-0.12.50-0.24-5.1%-3.0%-3.0%-0.8%-0.039.56#REF!21%-87%(508)128746874614582.4834%4.04-0.22.55-0.35-7.3%-5.2%-5.4%-3.2%-0.099.63#REF!10%-87%(283)138946894614912.5337%4.10-0.22.61-0.45-9.5%-7.4%-7.8%-5.6%-0.15#REF!#REF!-86%-87%(58)149146914615242.5940%4.16-0.32.67-0.57-12.1%-10.0

67、%-10.5%-8.3%-0.22#REF!#REF!-86%-87%218159346934615582.6543%4.22-0.32.73-0.68-14.4%-12.2%-12.9%-10.7%-0.27#REF!#REF!-86%-87%443169546954615912.7046%4.28-0.42.79-0.78-16.6%-14.5%-15.3%-13.1%-0.33#REF!#REF!-86%-87%668179746974616242.7649%4.33-0.52.85-0.89-18.9%-16.7%-17.7%-15.5%-0.39#REF!#REF!-86%-87%8

68、93189946994616582.8252%4.39-0.52.90-1.02-21.5%-19.4%-20.4%-18.3%-0.46#REF!#REF!-86%-87%117019000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!20000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!21000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!22000

69、.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!23000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!24000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!25000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!26000.00-100%1.491.1-1.1424.2%26.

70、3%33.8%36.0%1.156.216.2月0%0%#DIV/0!27000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!28000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!29000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!30000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%

71、#DIV/0!31000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!32000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!33000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!34000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!35000.00-100%1.491.1-

72、1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!36000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!37000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!38000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!39000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.15

73、6.216.2月0%0%#DIV/0!40000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!41000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!42000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!43000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!44000.00-

74、100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!45000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!46000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!47000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!48000.00-100%1.491.1-1.1424.2%26.3%33

75、.8%36.0%1.156.216.2月0%0%#DIV/0!49000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!50000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!51000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!52000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV

76、/0!53000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!54000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!55000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!56000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!57000.00-100%1.491.1-1.14

77、24.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!58000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!59000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!60000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!61000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.21

78、6.2月0%0%#DIV/0!62000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!63000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!64000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!65000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!66000.00-100%

79、1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!67000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!68000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!69000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!70000.00-100%1.491.1-1.1424.2%26.3%33.8%3

80、6.0%1.156.216.2月0%0%#DIV/0!71000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!72000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!73000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!74000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!7

81、5000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!76000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!77000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!78000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!79000.00-100%1.491.1-1.1424.2

82、%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!80000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!81000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!82000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!83000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月

83、0%0%#DIV/0!84000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!85000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!86000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!87000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!88000.00-100%1.49

84、1.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!89000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!90000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!91000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!92000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%

85、1.156.216.2月0%0%#DIV/0!93000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!94000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!95000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!96000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!97000

86、.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!98000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!99000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!100000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!101000.00-100%1.491.1-1.1424.2%2

87、6.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!102000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!103000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!104000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!105000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.

88、2月0%0%#DIV/0!106000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!107000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!108000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!109000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!110000.00-1

89、00%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!111000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!112000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!113000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!114000.00-100%1.491.1-1.1424.2%26.3

90、%33.8%36.0%1.156.216.2月0%0%#DIV/0!115000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!116000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!117000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!118000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0

91、%0%#DIV/0!119000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!120000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!121000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!122000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!123000.00-100%

92、1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!124000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!125000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!126000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!127000.00-100%1.491.1-1.1424.2%26.3%33

93、.8%36.0%1.156.216.2月0%0%#DIV/0!128000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!129000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!130000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!131000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%

94、#DIV/0!132000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!133000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!134000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!135000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!136000.00-100%1.4

95、91.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!137000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!138000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!139000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!140000.00-100%1.491.1-1.1424.2%26.3%33.8%

96、36.0%1.156.216.2月0%0%#DIV/0!141000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!142000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!143000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!144000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DI

97、V/0!145000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!146000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!147000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!148000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!149000.00-100%1.491.

98、1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!150000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!151000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!152000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!153000.00-100%1.491.1-1.1424.2%26.3%33.8%36.

99、0%1.156.216.2月0%0%#DIV/0!154000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!155000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!156000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!157000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0

100、!158000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!159000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!160000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!161000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!162000.00-100%1.491.1-1

101、.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!163000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!164000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!165000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!166000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1

102、.156.216.2月0%0%#DIV/0!167000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!168000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!169000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!170000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!17

103、1000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!172000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!173000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!174000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!175000.00-100%1.491.1-1.14

104、24.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!176000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!177000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!178000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!179000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.15

105、6.216.2月0%0%#DIV/0!180000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!181000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!182000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!183000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!18400

106、0.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!185000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!186000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!187000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!188000.00-100%1.491.1-1.1424.

107、2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!189000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!190000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!191000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!192000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.2

108、16.2月0%0%#DIV/0!193000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!194000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!195000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!196000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!197000.0

109、0-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!198000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!199000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!200000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!201000.00-100%1.491.1-1.1424.2%2

110、6.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!202000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1.156.216.2月0%0%#DIV/0!203000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!204000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!205000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%11

111、5.0%621.1%6.2月0%0%#DIV/0!206000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!207000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!208000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!209000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.

112、1%6.2月0%0%#DIV/0!210000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!211000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!212000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!213000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%

113、0%#DIV/0!214000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!215000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!216000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!217000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0

114、!218000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!219000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!220000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!221000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!222000.

115、00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!223000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!224000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!225000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!226000.00-100%1

116、.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!227000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!228000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!229000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!230000.00-100%1.491.1-1

117、.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!231000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!232000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!233000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!234000.00-100%1.491.1-1.1424.2%

118、26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!235000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!236000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!237000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!238000.00-100%1.491.1-1.1424.2%26.3%33.

119、8%36.0%115.0%621.1%6.2月0%0%#DIV/0!239000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!240000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!241000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!242000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%1

120、15.0%621.1%6.2月0%0%#DIV/0!243000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!244000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!245000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!246000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621

121、.1%6.2月0%0%#DIV/0!247000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!248000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!249000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!250000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0

122、%0%#DIV/0!251000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!252000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!253000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!254000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/

123、0!255000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!256000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!257000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!258000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!259000

124、.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!260000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!261000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!262000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!263000.00-100%

125、1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!264000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!265000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!266000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!267000.00-100%1.491.1-

126、1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!268000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!269000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!270000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!271000.00-100%1.491.1-1.1424.2

127、%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!272000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!273000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!274000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!275000.00-100%1.491.1-1.1424.2%26.3%33

128、.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!276000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!277000.00-100%1.491.1-1.1424.2%26.3%33.8%36.0%115.0%621.1%6.2月0%0%#DIV/0!2、地价售价双因素分析重要提示：为减少内存占用，本表（“选项-公式-除了模拟表以外，自动计算”）需要手动计算，请在更改所有假设后，按F9计算售价可变说明：请将拟进行敏感性分析单元格=A297，并且销售现金流量表、基础数据表中的价格数据由此

129、变化，否则敏感性分析失效竞得楼面价(元/)6,546净净利利率率- -单单向向现现金金售售价价地地价价8%100001050011000115001200012500130001350014000145001500010024.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%10224.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%10424.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%10624.1%24.1%24.1%

130、24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%10824.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%11024.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%11224.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%11424.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%11624.1%24.1%24.1%24.1%24.1%

131、24.1%24.1%24.1%24.1%24.1%24.1%11824.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%12024.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%12224.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%12424.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%12624.1%24.1%24.1%24.1%24.1%24.1%24.1%

132、24.1%24.1%24.1%24.1%12824.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%13024.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%24.1%13224.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%13424.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%13624.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%

133、24.0%24.0%13824.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%14024.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%14224.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%14424.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%24.0%3、售价单因素分析重要提示：为减少内存占用，本表（“选项-公式-除了模拟表以外，自动计算”）需要手动计算，请在更改所

134、有假设后，按F9计算说明： 请将拟进行敏感性分析单元格=A334，并且销售现金流量表、基础数据表中的价格数据由此变化，否则敏感性分析失效单向计息单向计息单向计息双向计息双向计息序号售价项目总货值(亿元)项目总投资(亿元)项目净利润、(亿元)净利润（亿元）净利率（现金部分）净利率(含自持）净利率（现金部分）净利率(含自持）LD净现金流（亿）回收期（经营）IRR(经营）IRR(融资后)回收期（融资后）辅助判定隐藏100004.73.40.460.388.1%10.22%12.0%14.10%0.460.0月120%#NUM!8.8月(1.05)14.73.400.460.388.1%10.2%12

135、.0%0.140.5月0%120%2.5月9(1)24.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)34.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)44.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)54.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)64.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)74.73.400.460.3

136、88.1%10.2%12.0%0.140.5月0%120%2.5月9(1)84.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)94.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)104.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)114.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)124.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)

137、134.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)144.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)154.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)164.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)174.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)184.73.400.460.388.1%10.2%12.0%0.14

138、0.5月0%120%2.5月9(1)194.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)204.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)214.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)224.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)234.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)244.73.400.460.38

139、8.1%10.2%12.0%0.140.5月0%120%2.5月9(1)254.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)264.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)274.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)284.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)294.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1

140、)304.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)314.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)324.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)334.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)344.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)354.73.400.460.388.1%10.2%12.0%0.1

141、40.5月0%120%2.5月9(1)364.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)374.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)384.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)394.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)404.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)414.73.400.460.3

142、88.1%10.2%12.0%0.140.5月0%120%2.5月9(1)424.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)434.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)444.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)454.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)464.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(

143、1)474.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)484.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)494.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)504.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)514.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)524.73.400.460.388.1%10.2%12.0%0.

144、140.5月0%120%2.5月9(1)534.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)544.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)554.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)564.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)574.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)584.73.400.460.

145、388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)594.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)604.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)614.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)624.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)634.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9

146、(1)644.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)654.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)664.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)674.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)684.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)694.73.400.460.388.1%10.2%12.0%0

147、.140.5月0%120%2.5月9(1)704.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)714.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)724.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)734.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)744.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)754.73.400.460

148、.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)764.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)774.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)784.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)794.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)804.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月

149、9(1)814.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)824.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)834.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)844.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)854.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)864.73.400.460.388.1%10.2%12.0%

150、0.140.5月0%120%2.5月9(1)874.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)884.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)894.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)904.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)914.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)924.73.400.46

151、0.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)934.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)944.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)954.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)964.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)974.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5

152、月9(1)984.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)994.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1004.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1014.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1024.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1034.73.400.460.388.1%10.2%

153、12.0%0.140.5月0%120%2.5月9(1)1044.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1054.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1064.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1074.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1084.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)109

154、4.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1104.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1114.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1124.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1134.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1144.73.400.460.388.1%10.2%12.0%0

155、.140.5月0%120%2.5月9(1)1154.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1164.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1174.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1184.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1194.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1204.73.4

156、00.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1214.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1224.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1234.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1244.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1254.73.400.460.388.1%10.2%12.0%0.140.5

157、月0%120%2.5月9(1)1264.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1274.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1284.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1294.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1304.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1314.73.400.460

158、.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1324.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1334.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1344.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1354.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1364.73.400.460.388.1%10.2%12.0%0.140.5月0%120

159、%2.5月9(1)1374.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1384.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1394.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1404.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1414.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1424.73.400.460.388.1

160、%10.2%12.0%0.140.5月0%120%2.5月9(1)1434.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1444.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1454.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1464.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1474.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9

161、(1)1484.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1494.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1504.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1514.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1524.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1534.73.400.460.388.1%10.2%

162、12.0%0.140.5月0%120%2.5月9(1)1544.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1554.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1564.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1574.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1584.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)159

163、4.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1604.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1614.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1624.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1634.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1644.73.400.460.388.1%10.2%12.0%0

164、.140.5月0%120%2.5月9(1)1654.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1664.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1674.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1684.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1694.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1704.73.4

165、00.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1714.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1724.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1734.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1744.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1754.73.400.460.388.1%10.2%12.0%0.140.5

166、月0%120%2.5月9(1)1764.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1774.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1784.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1794.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1804.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1814.73.400.460

167、.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1824.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1834.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1844.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1854.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1864.73.400.460.388.1%10.2%12.0%0.140.5月0%120

168、%2.5月9(1)1874.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1884.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1894.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1904.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1914.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1924.73.400.460.388.1

169、%10.2%12.0%0.140.5月0%120%2.5月9(1)1934.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1944.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1954.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1964.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1974.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9

170、(1)1984.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)1994.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)2004.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)2014.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)2024.73.400.460.388.1%10.2%12.0%0.140.5月0%120%2.5月9(1)2034.73.400.460.388.1%10.2%

171、12.0%14.1%0.5月0%120%2.5月9(1)2044.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2054.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2064.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2074.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2084.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9

172、(1)2094.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2104.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2114.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2124.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2134.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2144.73.400.460.388.1%

173、10.2%12.0%14.1%0.5月0%120%2.5月9(1)2154.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2164.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2174.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2184.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2194.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%

174、2.5月9(1)2204.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2214.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2224.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2234.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2244.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2254.73.400.460.3

175、88.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2264.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2274.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2284.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2294.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2304.73.400.460.388.1%10.2%12.0%14.1%0.5月0

176、%120%2.5月9(1)2314.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2324.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2334.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2344.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2354.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2364.73.400.

177、460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2374.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2384.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2394.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2404.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2414.73.400.460.388.1%10.2%12.0%14.1%

178、0.5月0%120%2.5月9(1)2424.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2434.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2444.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2454.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2464.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2474.73

179、.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2484.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2494.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2504.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2514.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2524.73.400.460.388.1%10.2%12.0%

180、14.1%0.5月0%120%2.5月9(1)2534.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2544.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2554.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2564.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2574.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)25

181、84.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2594.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2604.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2614.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2624.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2634.73.400.460.388.1%10.2%

182、12.0%14.1%0.5月0%120%2.5月9(1)2644.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2654.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2664.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2674.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2684.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9

183、(1)2694.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2704.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2714.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2724.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2734.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月9(1)2744.73.400.460.388.1%

184、10.2%12.0%14.1%0.5月0%120%2.5月9(1)2754.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月#(1)2764.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月#(1)2774.73.400.460.388.1%10.2%12.0%14.1%0.5月0%120%2.5月#(1)1. 土地基本指标和成本 返回目录一、规划指标二、时间表土地面积(亩)17.0项目开始日期2018/11/30容积率2.5三、交易类型建筑密度30%项目类型公公开开市市场场招招拍拍挂挂限高(m)100股权

185、比例（%）100%四、项目公司土地成本五、领地单独投入起拍楼面价(元/)6,546领地股权转让总价(万元)竞得楼面价(元/)6,546项目公司已付有票合计(万元)- 已付有票土地成本（万元）土地出让金（万元）18,547 已付在建工程契税（万元）566契税率 %3% 已付利息类（含土地滞纳金）拆迁补偿金（万元）指标款（万元）股权收购溢价-耕地占用税（万元）居间费（万元）其他有票土地成本（万元）股权转让税费（万元）交易服务费0调整系数0%股权收购其他（万元）项目公司土地成本合计19,113领地单独投入合计-项目公司已付在建工程-项目公司已付利息类-项目公司土地成本及已付其他合计19,113六、支

186、付节点支付节点距项目开始日（月）支付时间项目公司支付额（万元）LD对应股比支付额（万元）LD单独投入支付额（万元）LD投入合计（万元）备注第1笔-2018年11月9,5569,5569,556第2笔12018年12月9,5569,5569,556第3笔2018年11月-第4笔2018年11月-第5笔2018年11月-第6笔2018年11月-第7笔2018年11月-第8笔2018年11月-第9笔2018年11月-第10笔2018年11月-第11笔2018年11月-第12笔2018年11月-第13笔2018年11月-第14笔2018年11月-第15笔2018年11月-合计19,11319,113-

187、19,113判定-重要提示：如果做敏感性分析，土地节点款项、单独投入款项应该和土地出让金价格D61、土地转让价格挂钩（公式）一、基础规划指标土地面积(亩)17土地面积()11,333容积率2.5计容建面()28,333建筑密度30%限高(m)100二、土地成本项目类型公开市场招拍挂起拍楼面价(元/)6,546股份比例（%）100%竞得楼面价(元/)6,546股权转让总价-已支付有票成本-项目公司和领地成本明细我方股权占比100%序号项目金额（万元）类型税率备注1土地出让金18,547有票土地款部分2拍卖服务费0有票3拆迁补偿金（万元）-有票毛地出让才有，净地出让的没有这部分支出。参与一级整理的

188、拆迁支出不包含在内，收支单独核算4指标款（万元）-有票5契税566有票3.1%6耕地占用税及其他-有票项目公司土地成本19,1137股权收购溢价-无票股权溢价部分8居间费（万元）-无票9股权转让税费（万元）-无票10股权收购其他（万元）-无票领地单独投入-对应股比土地成本及领地单独投入总计（不含项目已付其他） 19,113竞得楼面价（元/）6,546竞得亩单价（万元/亩）1,091竞得总价（亿元）1.85三、土地款支付节点1. 项目公司付款进度支付时间支付金额（万元）付款内容备注第1笔2018/11/309,556第2笔2018/12/319,556第3笔2018/11/30-第4笔2018/

189、11/30-第5笔2018/11/30-第6笔2018/11/30-第7笔2018/11/30-第8笔2018/11/30-第9笔2018/11/30-第10笔2018/11/30-第11笔2018/11/30-第12笔2018/11/30-第13笔2018/11/30-第14笔2018/11/30-第15笔2018/11/30-合计19,113校验：-领地单独投入（溢价/居间费/其他）付款进度支付时间支付金额（万元）付款内容备注第1笔2815/3/31-第2笔2815/3/31-第3笔2018/11/30-第4笔2018/11/30-第5笔2018/11/30-第6笔2018/11/30-第

190、7笔2018/11/30-第8笔2018/11/30-第9笔2018/11/30-第10笔2018/11/30-第11笔2018/11/30-第12笔2018/11/30-第13笔#VALUE!-第14笔2018/12/31-第15笔2018/11/30-合计：-校验：-附表：交易服务费计算档次拍卖金额（万元）费率差额金额（万元）11003.50%100425003.00%4001231,0002.50%5001345,0001.50%4,00060510,0001.00%5,000506100,0000.50%8,547437100000以上0.10%-合计1812. 规划指标 返回目录返回

191、目录微信及QQ：1115955733，朋友圈每周送新资料，http:/，仅用于学习交流，请24小时内删除强排综合技术经济指标综合技术经济指标设计方案指标占比备注(填写规定性指标)用地性质:一 总用地用地面积11,333二 代征面积三 规划建设用地面积11,333四 容积率五 建筑密度1.总基底面积其中住宅基底面积非住宅基底面积2.高层基地面积六 规划总建筑面积37,854(一)地上计容建筑面积28,333 1、住宅建筑面积其中高层建筑面积户型面积比洋房建筑面积 2、商业面积(含售楼部) 3、配套设施建筑面积其中社区用房物管用房(二)地下建筑面积及层数（F）9520.05 地下机动车库面积 地下

192、非机动车库面积 地下物业用房面积(三）地上不计容面积架空层七 户数八 人防面积九 机动车位1.住宅车位2.商业车位3.配套车位其中 地上车位 地下车位十 非机动车位1.住宅非机动车位2.商业非机动车位3.配套非机动车位其中 地上非机动车位 地下非机动车位十一 绿地面积十二 绿地率十三 配建面积配建绿地面积配建道路面积3 基础数据 一、基本规划指标和强排图土地面积(亩)17土地面积()11,333容积率2.5计容建面()28,333限高(m)100建筑密度30%三、分期数据关键假设总计一期二期总计一期二期 三期细分业态分类计容可售总面积()销售比(%)高层普通住宅计容可售26,58026,580

193、#100%商业普通住宅计容可售850850#100%配套设施计容配套-不可售计容不可售9039030%100%地下车库（产权） 地下车位(产权)不计容可售7,4807,48060%60%地下车位（人防）地下车位(人防)-不可售 不计容不可售2,0402,0400%0%-0%合计37,85437,854-84%三、分期数据汇总总计一期二期分分期期汇汇总总面面积积占地面积11,33311,333总建筑面积37,85437,854-计容可售（含计容视同销售）27,43027,430-计容面积28,33328,333-可售面积(含视同销售）34,91134,911-销售面积31,91831,918-销

194、销售售销售收入万元47,25547,255-自自持持自持估值万元1,0151,015-成成本本前期工程费万元246246-基础设施费万元-建安工程费万元11,44611,446-精装修工程费万元3,1903,190-配套设施费万元-不可预见费万元-其中：地下可售及视同可售7,4807,480-四、其他成本和费用关键假设开盘条件高层1/31、前期工程费(元/平米）(按总建筑面积）城市配套费人防异地建设费设计费652、基础设施、配套设施、不可预见费(元/平米）(按总建筑面积）基础设施费配套设施费不可预见费3、其他费用(总额 ,万元）物业维修基金-公司部分产权税费-公司部分招商造活费（支付给商业公司

195、）104、销售费用率销售费用率3.00%选档，低于3%特别说明5、管理费用率管理费用率3.00%锁定3%，低于3%需解锁五、营业外收入（万元）营业外收入如填写请特别说明（不含指定项目返还金)，另需在现金流量表中填写收入节点六、营业外支出（万元）营业外支出如填写请特别说明，另需在现金流量表中填写收入节点附1：分类标准大类编号大类计容性可售性对应细分业态地上（普通）普通住宅计容可售产权70年且户型小于140m2的住宅：如普通高层、洋房、小高层非普通住宅计容可售产权70年且户型大于140m2的住宅：如别墅、140m2以上的洋房、大平层非住宅计容可售40年产权计容配套-可售计容可售如可售的幼儿园计容配

196、套-不可售计容不可售如社区配套用房、要求无偿移交的幼儿园红线外配建不计容不可售如要求配建的红线外道路不计容其他-不可售不计容不可售如架空层地下地下车位(产权)不计容可售地下车位(无产权) 不计容可售如湖南地下车位(人防)-不可售不计容不可售地下车位(人防)-可售 不计容可售地下商业/住宅不计容可售如叠拼-1层/地下商业地下其他不可售不计容不可售无偿还房无偿还房-普通住宅计容不可售还房且无对价，如有对价填写在“地上（普通）”无偿还房-非普通住宅计容不可售还房且无对价，如有对价填写在“地上（普通）”无偿还房-商业计容不可售还房且无对价，如有对价填写在“地上（普通）”无偿还房-地下车位（产权）不计容

197、不可售还房且无对价，如有对价填写在“地下”无偿还房-地下商业不计容不可售还房且无对价，如有对价填写在“地下”附：计税统计表总计一期二期分期汇总可售面积&视同可售面积普通住宅27,43027,430-非普通住宅-非住宅-计容配套-可售-地下商业/住宅-地下车位(产权)7,4807,480-地下车位(无产权)-地下车位(人防)-可售 -分期汇总销售面积&视同销售面积普通住宅27,43027,430-非普通住宅-非住宅-计容配套-可售-地下商业/住宅-地下车位(产权)4,4884,488-地下车位(无产权)-地下车位(人防)-可售 -分期汇总精装修成本-销售&视同销售普通住宅万元3,1903,190

198、-非普通住宅万元-非住宅万元-计容配套-可售万元-地下商业/住宅万元-地下车位(产权)万元-地下车位(无产权)万元-地下车位(人防)-可售 万元-分期汇总精装修成本-其他普通住宅万元-非普通住宅万元-非住宅万元-计容配套-可售万元-地下商业/住宅万元-地下车位(产权)万元-地下车位(无产权)万元-地下车位(人防)-可售 万元-分期汇总 无偿还房-如按市价收入无偿还房-普通住宅万元-无偿还房-非普通住宅万元-无偿还房-商业万元-无偿还房-地下商业万元-无偿还房-地下车位（产权）万元-分期汇总无偿还房-总面积无偿还房-普通住宅-无偿还房-非普通住宅-无偿还房-商业-无偿还房-地下商业-无偿还房-地

199、下车位（产权）-分期汇总含税销售收入普通住宅万元45,07945,079-非普通住宅万元-非住宅万元-计容配套-可售万元-地下商业/住宅万元-地下车位(产权)万元2,1762,176-地下车位(无产权)万元-地下车位(人防)-可售 万元-内部判定可售面积-计容面积-销售面积-销售金额-总成本-汇总表-精装修-销售和视同销售-分期汇总销售面积&视同销售面积总计一期二期总计一期二期总计一期二期总计总计总计销售面积()销售均价(元)销售总价(万元)持有物业估值折扣(%)单方精装成本(元)单方建安成本(元)26,58026,580-16,00016,00042,52942,529-1,2002,800

200、850850-30,00030,0002,5502,550-3,000-2,5004,4884,488-4,8484,8482,1762,176-70%3,700-3,700-31,91831,918-47,25547,255-产权70年且户型大于140m2的住宅：如别墅、140m2以上的洋房、大平层总计一期总计一期二期三期四期五期六期建安（不含装修）(万元)持有物业价值(万元)7,4437,443-255255-226226-2,7682,7681,0151,015-755755-11,44611,4461,0151,015-七期八期总计一期二期三期四期五期精装修成本-销售(含视同销售）-3

201、,1903,190-3,1903,190-六期七期八期总计一期二期三期四期精装修成本-其他(万元)-五期六期七期八期总计一期二期三期无偿还房-如按市场售价收入(万元)-精装修成本-其他(万元)四期五期六期七期八期无偿还房精装修成本合计-无偿还房-如按市场售价收入(万元)4 总控计划表返回目录项目开始日期2018/11/30项目所在地北方或精装开盘-交付30个月序号总控计划距项目开始（月）完成时间备注-付清土地款1个月2018/12/311.0国土证1个月2018/12/312.0净地交付1个月2018/12/313.0首期开工2个月2019/1/314.0首期施工许可证（四证齐全）3个月201

202、9/2/285.0首期开放6个月2019/5/315.1一期开盘6个月2019/5/315.2二期开盘5.3三期开盘5.4四期开盘5.5五期开盘5.6六期开盘5.7七期开盘5.8八期开盘6.1一期集中交付36个月2021/11/306.2二期交付6.3三期交付6.4四期交付6.5五期交付6.6六期交付6.7七期交付6.8八期交付注1：冬休或精装修并客户接受，则首次开盘时间推后，开盘-交付30个月。如没有冬休的毛坯房且客户不接受晚交房，则开盘-交房通常在24个月判定-返回目录注1：冬休或精装修并客户接受，则首次开盘时间推后，开盘-交付30个月。如没有冬休的毛坯房且客户不接受晚交房，则开盘-交房通

203、常在24个月5 销售现金流计划表返回目录48.00一、分期汇总序号业态核验锚定总价合计（万元）销售起价增长率开售月份首月去化月均去化201811201812201901201902201903201904201905201906201907201908201909201910201911201912202001202002202003202004202005202006202007202008202009202010202011202012202101202102202103202104202105202106202107202108202109202110202111202112202201

204、202202202203202204202205202206202207202208202209202210202211202212202301202302202303202304202305202306202307202308202309202310202311202312202401202402202403202404202405202406202407202408202409202410202411202412202501202502202503202504202505202506202507202508202509202510202511202512202601202602202603

205、202604202605202606202607202608202609202610202611202612202701202702202703202704202705202706202707202708202709202710签约面积合计-47,25531,91816,000.020190520,0001,596-20,0001,6451,6451,6451,858213213213-374374374374374374374374374374374374-签约额合计47,255-32,0002,6322,6322,6323,270638638638-18118118118118118118

206、1181181181181181-回款额合计47,255-12,8007,4536,3799,9742,8871,9621,5311,296383255159-731091361811811811811811811811811811097345-1、高层-42,529签约面积26,58020190520,0005,316-20,0001,6451,6451,6451,645-均价16,00016,00016,00016,00016,00016,00016,000签约额42,529-32,0002,6322,6322,6322,632-2、商业-2,550签约面积850201909213213-

207、213213213213-均价30,00030,00030,00030,00030,00030,000签约额2,550-638638638638-3、-签约面积-均价-签约额-4、-签约面积-均价-签约额-5、-签约面积-均价-签约额-6、-签约面积-均价-签约额-13、地下车位(产权）-2,176签约面积4,488202111374374-374374374374374374374374374374374374-均价4,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,84

208、84,8484,848签约额2,176-181181181181181181181181181181181181-14、地下车位(人防）-签约面积-均价-签约额-二、分期签约额签约面积校验锚定合计均价合计期数当期首开1高层-26,58016,00026,580合计-20,0001,6451,6451,6451,645-26,58016,00026,580一期20190520,0001,6451,6451,6451,645-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开2商业-85030,000850合计-213213213213-85030,000850一期2

209、01905212.50213213213-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开3-合计-一期201905-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开4-合计-一期201905-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开5-合计-一期201905-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开6-合计-一期201905-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开13地下车位(产权）-4,4884,8484,

210、488合计-374374374374374374374374374374374374-4,4884,8484,488一期201905374.00374374374374374374374374374374374-二期-三期-四期-五期-六期-七期-八期签约面积校验锚定合计均价合计期数当期首开14地下车位(人防）-合计-一期201905-二期-三期-四期-五期-六期-七期-八期三、分期汇总签约面积校验锚定合计合计期数当期首开汇总-31,91831,918合计-20,0001,6451,6451,6451,858213213213-374374374374374374374374374374374

211、374-31,91831,918一期201905-20,0001,6451,6451,6451,858213213213-374374374374374374374374374374374374-二期-三期-四期-五期-六期-七期-八期-1高层单价-16,00016,00016,00016,00016,000-2商业单价-30,00030,00030,00030,000-3-单价-4-单价-5-单价-6-单价-7细分业态7单价-8细分业态8单价-9细分业态9单价-10细分业态10单价-11细分业态11单价-12细分业态12单价-13地下车位(产权）单价-4,8484,8484,8484,848

212、4,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,8484,848-13地下车位(人防）单价-签约金额锚定合计校验合计期数当期首开汇总47,255-47,255合计-32,0002,6322,6322,6323,270638638638-181181181181181181181181181181181181-47,255-47,255一期201905-32,0002,6322,6322,6323,270638638638-181181181181181181181181181181181181-二期-三期-四期-五期-

213、六期-七期-八期-回款金额锚定合计校验合计期数当期首开-校验-汇总47,255合计-12,8007,4536,3799,9742,8871,9621,5311,296383255159-731091361811811811811811811811811811097345-47,255一期201905-12,8007,4536,3799,9742,8871,9621,5311,296383255159-731091361811811811811811811811811811097345-二期-三期-四期-五期-六期-七期-八期-签约占比锚定合计校验合计期数当期首开占比31,918合计0.0%0.

214、0%0.0%0.0%0.0%0.0%62.7%67.8%73.0%78.1%83.9%84.6%85.3%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%87.1%88.3%89.5%90.6%91.8%93.0%94.1%95.3%96.5%97.7%98.8%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0

215、%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%31,918一期201

216、9050.0%0.0%0.0%0.0%0.0%0.0%62.7%67.8%73.0%78.1%83.9%84.6%85.3%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%85.9%87.1%88.3%89.5%90.6%91.8%93.0%94.1%95.3%96.5%97.7%98.8%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%10

217、0.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%-二

218、期#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!#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/

219、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!#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

220、/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!#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!

221、#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!#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

222、!#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!#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/

223、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!#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!#

224、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!#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!

225、#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!#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!#DI

226、V/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!#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!#D

227、IV/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!#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!#

228、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!#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

229、/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!#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!#DI

230、V/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!#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

231、!#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!#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/

232、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!#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

233、/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!#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!

234、#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!#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

235、!#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!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!四、按年度统计2,0182,0192,0202,021其他年份签约面积（不含车位）-27,430-签约额（全业态）-45,079-3631,813回款额（全业态）-44,2827

236、971811,9956 融资计划项目公司土地成本19,113国土证领地单独投入-首期施工许可证（四证齐全）对应股比土地成本及领地单独投入总计（不含项目已付其他）19,113项目开发贷并购贷其他（前融）对方机构贷款金额（万元）8,000年利率（%）13.00%贷款期限（年）1.00上账时间2019/1/31实际总利息支出-1,040实际平均融资利率13.00%注：融资上账时间和获得国土证、四证齐全等时间节点挂钩类别项目合计201811合计本期银行借款借入8,000-归还银行借款8,000-利息收支及中间费1,040-开发贷本期银行借款借入-归还银行借款-利息收支及中间费-并购贷本期银行借款借入-

237、归还银行借款-利息收支及中间费-其他（前融）本期银行借款借入8,000归还银行借款8,000利息收支及中间费1,040判定判定还款金额-判定至少有一个融资-判定开发贷时间合理性-判定并购贷时间合理性-判定其他（前融）时间合理性-判定利率大于5%且填入利息金额-返回目录2018/12/312019/2/28合计/备注8,00013.00%1.002019/1/311,040 201812201901201902201903201904201905201906201907-8,000-878787878787-8,000878787878787注：融资上账时间和获得国土证、四证齐全等时间节点挂钩返

238、回目录201908201909201910201911201912202001202002202003202004-8,000-878787878787-8,000878787878787202005202006202007202008202009202010202011202012202101-202102202103202104202105202106202107202108202109202110-202111202112202201202202202203202204202205202206202207-20220820220920221020221120221220230120230

239、2202303202304-202305202306202307202308202309202310202311202312202401-202402202403202404202405202406202407202408202409202410-202411202412202501202502202503202504202505202506-202507202508202509202510202511202512202601202602-202603202604202605202606202607202608202609202610-20261120261220270120270220270

240、3202704202705202706-202707202708202709202710-7 税率表序号税种分类计算基数税率1企业所得税所得税税率 利润总额25.00%所得税预计毛利率 当期预收款20.00%2土地增值税土地增值税预征率：普通住宅当期预收款1.00%非普通住宅当期预收款3.00%商业当期预收款5.00%地下商业当期预收款5.00%地下车位当期预收款5.00%人防车位 当期预收款5.00%3增值税增值税税率主营业务收入10.00%增值税预征率当期预收款3.00%4城建税城建税缴纳增值税额7.00%教育费附加教育费附加缴纳增值税额3.00%地方教育附加地方教育附加2.00%5契税契

241、税土地或房产价格3.00%6土增税相关确认土增值税清算类别选择普通住宅/非普通住宅/非住宅地下建筑是否分摊土地费用不分摊土地费用人防清算选择人防车位视作公建配套返回目录说明各地标准不一，根据当地政策各地标准不一，根据当地政策各地标准不一，根据当地政策各地标准不一，根据当地政策各地标准不一，根据当地政策各地标准不一，根据当地政策3%5%各地标准不一，根据当地政策普通住宅/非普通住宅/非住宅8 增值税预测表返回目录序项目项目应纳税额一期二期普通住宅非普通住宅非住宅小计普通住宅1增值税销售收入47,25545,079-2,17647,255- 销售收入47,25545,079-2,17647,255

242、- 拆迁款收入及其他视同销售-2允许扣除的土地价款18,54718,547-18,547-3销项税额2,6102,412-1982,610-4进项税额1,3541,164-1901,354-5应缴增值税额1,4181,352-651,418-6应缴增值税附加170162-8170-7税金及附加合计1,5881,515-731,588-三期四期非普通住宅非住宅小计普通住宅非普通住宅非住宅小计普通住宅非普通住宅-二期五期六期非住宅小计普通住宅非普通住宅非住宅小计普通住宅非普通住宅非住宅-四期七期八期小计普通住宅非普通住宅非住宅小计普通住宅非普通住宅非住宅小计-8 土地增值税测算表返回目录项目行次项

243、目应缴税额一期普通住宅非普通住宅非住宅一、转让房地产收入总额144,64542,667-1,978 销售收入242,95940,981-1,978 拆迁收入及其他视同销售3- 土地价款扣减销售额而減少的销项税金41,6861,686-二、扣除项目金额合计542,03240,162-1,870 1.土地成本619,11319,113- 拆迁还房土地成本7- 2.房地产开发成本813,08911,656-1,433前期工程费9205176-29基础设施费10-建安及装修工程费119,5138,176-1,338配套设施费12-开发间接费13471405-66不可预见费14-装修专属成本-销售152

244、,9002,900- 3.房地产开发费用 163,220.173,076.90-143.27 4.与转让房地产有关的税金等17170162-8增值税附加18170162-8其他税费19- 5.财政部规定的加计20%扣除数206,4406,153.80-286.54三、增值额212,6132,505-108四、增值额与扣除项目金额之比（）226%0%6%五、适用税率（）230%0%30%六、速算扣除系数（）240%0%0%七、应缴土地增值税税额2532-32八、已预缴土地增值税税额26560451-109九、应补（退）土地增值税税额27-527-451-76二期三期小计普通住宅非普通住宅非住宅小

245、计普通住宅非普通住宅非住宅44,645-42,959-1,686-42,032-19,113-13,089-205-9,513-471-2,900-3,220.17-170-170-6,440-2,613-0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%32-560-527-四期五期小计普通住宅非普通住宅非住宅小计普通住宅非普通住宅非住宅-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%0%0%0%0%0%0%0%0%0%0%-八期小计普通住宅非普

246、通住宅非住宅小计-0%0%0%0%0%0%0%0%0%-10 所得税测算表返回目录序项目项目应纳税额一期普通住宅非普通住宅非住宅（一）收入总计44,64542,667-1,9781 销售收入42,95940,981-1,9782 拆迁收入及其他视同销售-3 土地成本抵减销项额1,6861,686-（二）土地成本17,47515,018-2,457（三）拆迁还房土地成本-（四）开发成本13,08911,656-1,4331 前期工程费205176-292 基础设施费-3 建安及装修工程费9,5138,176-1,3384 配套设施费-5 开发间接费471405-666 不可预见费-7 精装修工程

247、费2,9002,900-（五）利息877754-123（六）产权费/造活费109-1（七）其他-（八）税金及附加170162-8（九）期间费用2,1402,041-99（十）土地增值税560451-109（十一） 营业外收入-（十二） 营业外支出-（十三） 税前利润10,32512,576-2,251（十四） 企业所得税2,5823,144-99（十五） 税后利润7,7439,432-2,350二期三期小计普通住宅非普通住宅非住宅小计普通住宅非普通住宅非住宅44,645-42,959-1,686-17,475-13,089-205-9,513-471-2,900-877-10-170-2,14

248、0-560-10,325-2,581-7,744-返回目录四期五期小计普通住宅非普通住宅非住宅小计普通住宅非普通住宅非住宅小计-0-0-六期七期八期普通住宅非普通住宅非住宅小计普通住宅非普通住宅非住宅小计普通住宅-非普通住宅非住宅小计-八期11 土地现金流一、土地款支付节点项目公司付款进度支付时间支付金额（万元）付款内容备注第1笔2018/11/309,556-第2笔2018/12/319,556-第3笔2018/11/30-第4笔2018/11/30-第5笔2018/11/30-第6笔2018/11/30-第7笔2018/11/30-第8笔2018/11/30-第9笔2018/11/30-第

249、10笔2018/11/30-第11笔2018/11/30-第12笔2018/11/30-第13笔2018/11/30-第14笔2018/11/30-第15笔2018/11/30-合计：19,113校验：-二、土地款及领地单独投入现金流项目公司判定总计201811201812201901第1笔-9,5569,556-第2笔-9,556-9,556-第3笔-第4笔-第5笔-第6笔-第7笔-第8笔-第9笔-第10笔-第11笔-第12笔-第13笔-第14笔-第15笔-项目公司土地成本合计-19,1139,5569,556-领地单独投入总计201811201812201901第1笔-第2笔-第3笔-第4

250、笔-第5笔-第6笔-第7笔-第8笔-第9笔-第10笔-第11笔-第12笔-第13笔-第14笔-第15笔-领地单独投入成本合计-三、领地土地总投入现金流我方股权占比100%领地土地总投入总计201811201812201901领地对应股比:土地成本-19,1139,5569,556-领地单独投入成本合计-对应股比土地成本+单独投入合计-19,1139,5569,556-LD土地现金流月份数日期累计支付比合计19,113100%第1笔9,5560个月20181150%第2笔9,5561个月201812100%-返回目录领地单独投入付款进度支付时间支付金额（万元）付款内容备注第1笔2018/11/3

251、0-第2笔2018/12/31-第3笔2018/11/30-第4笔2018/11/30-第5笔2018/11/30-第6笔2018/11/30-第7笔2018/11/30-第8笔2018/11/30-第9笔2018/11/30-第10笔2018/11/30-第11笔2018/11/30-第12笔2018/11/30-第13笔2018/11/30-第14笔2018/11/30-第15笔2018/11/30-合计：-校验：-201902201903201904201905201906201907201908201909-201902201903201904201905201906201907201

252、908201909-201902201903201904201905201906201907201908201909-201910201911201912202001202002202003202004202005-201910201911201912202001202002202003202004202005-201910201911201912202001202002202003202004202005-202006202007202008202009202010202011202012202101-202006202007202008202009202010202011202012202

253、101-202006202007202008202009202010202011202012202101-202102202103202104202105202106202107202108202109-202102202103202104202105202106202107202108202109-202102202103202104202105202106202107202108202109-202110202111202112202201202202202203202204202205-202110202111202112202201202202202203202204202205-20

254、2110202111202112202201202202202203202204202205-202206202207202208202209202210202211202212202301-202206202207202208202209202210202211202212202301-202206202207202208202209202210202211202212202301-202302202303202304202305202306202307202308202309-202302202303202304202305202306202307202308202309-20230220

255、2303202304202305202306202307202308202309-202310202311202312202401202402202403202404202405-202310202311202312202401202402202403202404202405-202310202311202312202401202402202403202404202405-202406202407202408202409202410202411202412202501-202406202407202408202409202410202411202412202501-20240620240720

256、2408202409202410202411202412202501-202502202503202504202505202506202507202508202509-202502202503202504202505202506202507202508202509-202502202503202504202505202506202507202508202509-202510202511202512202601202602202603202604202605-202510202511202512202601202602202603202604202605-20251020251120251220

257、2601202602202603202604202605-202606202607202608202609202610202611202612202701-202606202607202608202609202610202611202612202701-202606202607202608202609202610202611202612202701-202702202703202704202705202706202707202708202709-202702202703202704202705202706202707202708202709-20270220270320270420270520

258、2706202707202708202709-202710-202710-202710-12 工程成本现金流一、成本支付相关总控计划日期距上一节点（月）首期开工前一个月2018/12/31一期开盘2019/5/315一期集中交付2021/11/3029二、成本支付参考值项目开盘条件-建安成本占比（参考值）开工前1个月到开盘开盘到交付交房后交房前6个月-月均成本比高层2/325.0%55.0%20.0%3.5%高层1/220.0%60.0%20.0%3.8%高层1/315.0%65.0%20.0%4.0%正负05.0%75.0%20.0%4.5%根据选择确定-建安成本占比高层1/315.0%65

259、.0%20.0%4.0%其他成本阶段成本占比开工前开工前1个月到开盘开盘到交付交付后阶段代码-123持续月份数153034前期工程费60%40%基础设施费10%90%配套设施费100%工程相关不可预见费100%三、成本现金流判定合计锚定数据201811前期工程费-0.00246246-基础设施费-建安及装修工程费-14,63514,635-配套设施费-不可预见费-合计-14,88114,881-四、分期成本数据总计一期二期三期开盘时间201905201905开盘月份数6个月6个月0个月0个月前期工程费246246-基础设施费-建安及装修工程费14,63514,635-配套设施费-不可预见费-合

260、计14,88114,881-返回目录开盘到交房-其他月份月均成本比交房后X个月付清1.5%6个月1.62%6个月1.8%6个月2.1%6个月1.78%6个月开工当月支出备注12%0%0%0%20181220190120190220190320190420190530303030303-439439439439439-4694694694694693四期五期六期七期八期0个月0个月0个月0个月0个月-2019062019072019082019092019102019112019123333333-261261261261261261261-264264264264264264264202001

261、2020022020032020042020052020062020073333333-261261261261261261261-26426426426426426426420200820200920201020201120201220210120210220210333333333-261261261261261261261261-2642642642642642642642642021042021052021062021072021082021092021102021113333333-261585585585585585585488-26458958958958958958948820

262、2112202201202202202203202204202205202206202207-488488488488488-488488488488488-202208202209202210202211202212202301202302202303-202304202305202306202307202308202309202310202311-202312202401202402202403202404202405202406202407-202408202409202410202411202412202501202502202503-202504202505202506202507202508202509202510202511-202512202601202602202603202604202605202606202607-202608202609202610202611202612202701202702202703-202704202705202706202707202708202709202710-