产业园投资估算及财务分析模型

1、项项目目总总投投资资估估算算表表项项目目收收益益估估算算表表序序号号项项目目名名称称总总额额（万万元元）占占总总投投资资比比例例项项目目1地 价82,80019.7%总建筑面积（m2)2前期工程费23,9205.7%销售面积（m2)3建安工程150,32835.8%自持面积（m2)销售收入(万元）4不可预见费8,7122.1%租金收入(万元/年）5管理费8,7122.1%6其他费用30,9127.4%税后利润（万元）7财务费用100,75924.0%投资利润率8销售费用13,2483.2%财务净现值 （万元）9合 计419,392100.0%内部收益率备备注注: :1.1.第第9 9季季度度开

2、开售售，开开盘盘销销售售率率30%30%，项项目目竣竣工工后后一一年年半半销销售售率率达达到到80%80%。（假假定定条条件件）2.2.开开盘盘销销售售时时，收收取取30%30%定定金金，项项目目竣竣工工后后一一年年收收取取销销售售尾尾款款。3.3.以以上上数数据据未未计计算算企企业业所所得得税税。4.4.建建安安工工程程费费用用包包含含土土建建，安安装装，园园林林，配配套套。5.5.项项目目竣竣工工一一年年后后，即即从从收收取取尾尾款款开开始始，将将陆陆续续偿偿还还借借款款本本金金。重要程度变量数值数数额额容积率2368000自持比例0.5184000销售单价3万元/m2184000借款利率

3、10%土地价格300万元/亩441600租金单价3元/m2天16118-9,751-2.3%2555712.11%项项目目收收益益估估算算表表附附表表2：项项目目开开发发总总成成本本估估算算表表计入容积率建筑面积(m2)368000序序号号项项目目名名称称计计算算程程式式单单价价（元元/m2）金金额额(万万元元）备备注注一土地成本2,25082,800.00二前期工程费2.1勘察测量费501,840.002.2规划设计费30011,040.002.3临时供水供电1003,680.002.4场地平整及道路1003,680.002.5其它费用1003,680.00前期工程小计2.12.565023

4、,920三建筑安装工程费3.1基础工程费30011,040.003.2土建工程费1,60058,880.003.3安装工程费1,38550,9683.3.1 水电安装30011,040.003.3.2 电梯工程1204,416.003.3.3 空调工程30011,040.003.3.4 消防工程1806,624.003.3.5 通讯工程1003,680.003.3.6 公共装修32011,776.003.3.7 燃气工程3.3.8 对讲系统501,840.003.3.9 公用天线15552.003.4园林绿化30011,040.003.5室外配套50018,400.00建安工程小计3.13.5

5、4,085150,328.00四不可预见费2378,712.40五管理费用2378,712.40六其它费用6.1工程监理费602,208.006.2热力配套1605,888.006.3电力配套30011,040.006.4代征道路1003,680.006.5墙改基金20736.006.6管网配套2007,360.00其他费用小计6.16.784030,912.00七合计(二)(六)6,049222,584.80八总开发成本(一)+(七)8,299305,384.80附附表表3：投投资资计计划划表表单位：万元序号 项目名称投资总额第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第

6、6 6季季第第7 7季季第第8 8季季第第9季季一土地成本82800.0082800.00二前期费用23920.0011960.0011960.00三基础工程费11040.003312.005520.001656.00四土建工程费58880.0017664.0011776.0011776.008832.00五安装工程费50968.0015290.40六园林绿化11040.003312.00七室外配套18400.005520.00八不可预见费8712.40726.03726.03726.03726.03726.03726.03726.03726.03726.03九管理费8712.40726.03

7、726.03726.03726.03726.03726.03726.03726.03726.03十其它费用30912.003091.203091.203091.203091.203091.203091.203091.20十一 合计305384.8096212.0713412.077855.2710063.2722207.2716319.2716319.2715031.2728665.67注：1.土地成本按计算初期一次性投入计。 2.按照通常情况,工程费用中5%留取保修金及滞留金，竣工验收后一年付出。 3.工程款的支付与工程进度表相对应，不考虑工程队大额垫资，按工程进度付款， 竣工验收后支付率达

8、95%，其它部分在工程建设过程中平均投入。附附表表3：序号 项目名称一土地成本二前期费用三基础工程费四土建工程费五安装工程费六园林绿化七室外配套八不可预见费九管理费十其它费用十一 合计投投资资计计划划表表（续续表表）单位：万元第第10季季第第1111季季第第1212季季第第1313季季第第1414季季第第1515季季第第1616季季552.002944.0010193.6010193.6015290.402548.402208.002208.003312.00552.003680.003680.005520.00920.00726.03726.03726.03726.03726.03726.0

9、33091.203091.203091.2020624.8720624.8732161.674020.40附附表表4：项项目目销销售售回回款款计计划划表表项目内容销销售售建建筑筑面面积积(m2）销销售售价价格格（元元/m2）总总价价（万万元元）备备注注销售184000.0030,000552,000.00自持184000.00合计368000.00552,000.00销售率100%销售收入552,000.00计算期（季度）销销售售比比例例回回款款比比例例回回款款金金额额合合计计销销售售自自持持销销售售自自持持销销售售自自持持12345678930.00%10.00%55,200.0055,20

10、0.00105.00%1.67%9,200.009,200.00115.00%1.67%9,200.009,200.00125.00%1.67%9,200.009,200.00135.00%1.67%9,200.009,200.00145.00%1.67%9,200.009,200.00155.00%1.67%9,200.009,200.00165.00%45.00%248,400.00248,400.00175.00%5.00%27,600.0027,600.00185.00%5.00%27,600.0027,600.00195.00%5.00%27,600.0027,600.00合计80.

11、00%80.00%441,600.00441,600.00注：销售考虑开盘去化可售部分50%，竣工后完成整体物业50T%销售，销售回款计划综合考虑银行按揭放款时间。办公楼出租按每季度10%递增测算，竣工后两年内达到80%入住率。附表5:资资金金来来源源与与运运用用表表单单位位：万万元元序号 季度项目12345678910一一资资金金来来源源120,586.55120,586.5519,710.3919,710.3990,840.1990,840.19147,069.36147,069.369,200.009,200.001 1经经营营活活动动产产生生的的现现金金来来源源55,200.0055,

12、200.009,200.009,200.001.11.1销销售售收收入入55,200.0055,200.009,200.009,200.002 2 筹筹资资活活动动产产生生的的现现金金来来源源120,586.55120,586.5519,710.3919,710.3990,840.1990,840.1991,869.3691,869.362.12.1自自有有资资金金2.22.2银银行行借借款款1205871205871971019710908409084091869918693 3其其它它来来源源二二资资金金运运用用102,241.39102,241.3913,412.0713,412.071

13、4,870.1114,870.1110,063.2710,063.2745,320.9845,320.9816,319.2716,319.2716,319.2716,319.2715,031.2715,031.2765,437.5165,437.5121,600.2521,600.251 1建建设设期期开开发发成成本本96,212.0796,212.0713,412.0713,412.077,855.277,855.2710,063.2710,063.2722,207.2722,207.2716,319.2716,319.2716,319.2716,319.2715,031.2715,031.

14、2728,665.6728,665.6720,624.8720,624.872 2经经营营期期当当期期发发生生营营业业成成本本3 3销销售售费费用用1,656.001,656.00276.00276.004 4销销售售税税费费2,815.202,815.20469.20469.205 5增增值值税税230.19230.196 6盈盈余余公公积积7 7应应付付利利润润8 8借借款款本本金金偿偿还还9 9借借款款利利息息支支付付6,029.336,029.337,014.857,014.8523,113.7123,113.7132,300.6532,300.65三三盈盈余余资资金金18,345.1

15、518,345.15-13,412.07-13,412.074,840.274,840.27-10,063.27-10,063.2745,519.2145,519.21-16,319.27-16,319.27-16,319.27-16,319.27-15,031.27-15,031.2781,631.8581,631.85-12,400.25-12,400.25四四累累计计盈盈余余资资金金18,345.1518,345.154,933.094,933.099,773.369,773.36-289.91-289.9145,229.3045,229.3028,910.0328,910.0312,5

16、90.7712,590.77-2,440.50-2,440.5079,191.3579,191.3566,791.0966,791.09附表5:序号 季度项目一一资资金金来来源源1 1经经营营活活动动产产生生的的现现金金来来源源1.11.1销销售售收收入入2 2 筹筹资资活活动动产产生生的的现现金金来来源源2.12.1自自有有资资金金2.22.2银银行行借借款款3 3其其它它来来源源二二资资金金运运用用1 1建建设设期期开开发发成成本本2 2经经营营期期当当期期发发生生营营业业成成本本3 3销销售售费费用用4 4销销售售税税费费5 5增增值值税税6 6盈盈余余公公积积7 7应应付付利利润润8

17、8借借款款本本金金偿偿还还9 9借借款款利利息息支支付付三三盈盈余余资资金金四四累累计计盈盈余余资资金金资资金金来来源源与与运运用用表表（续续表表）单单位位：万万元元1112131415161718199,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.00248,400.00248,400.0027,600.0027,600.0027,600.0027,600.0027,600.0027,600.009,200.009,200.009,200.009,200.009,200.009,200

18、.009,200.009,200.009,200.009,200.00248,400.00248,400.0027,600.0027,600.0027,600.0027,600.0027,600.0027,600.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.009,200.00248,400.00248,400.0027,600.0027,600.0027,600.0027,600.0027,600.0027,600.0021,600.2521,600.2533,137.0533,137.053

19、3,045.8533,045.85975.39975.39975.39975.39150,942.42150,942.4222,636.5522,636.552,926.162,926.16185,635.71185,635.7120,624.8720,624.8732,161.6732,161.674,020.404,020.40276.00276.00276.00276.00276.00276.00276.00276.00276.00276.007,452.007,452.00828.00828.00828.00828.00828.00828.00469.20469.20469.20469

20、.20469.20469.20469.20469.20469.20469.2012,668.4012,668.401,407.601,407.601,407.601,407.601,407.601,407.60230.19230.19230.19230.19230.19230.19230.19230.196,215.076,215.07690.56690.56690.56690.56690.56690.56120,586.55120,586.5519,710.3919,710.39182,709.55182,709.5532,300.6532,300.65-12,400.25-12,400.2

21、5-23,937.05-23,937.05-23,845.85-23,845.858,224.618,224.618,224.618,224.6197,457.5897,457.584,963.454,963.4524,673.8424,673.84-158,035.71-158,035.7154,390.8454,390.8430,453.7830,453.786,607.936,607.9314,832.5514,832.5523,057.1623,057.16120,514.74120,514.74125,478.19125,478.19150,152.03150,152.03-7,88

22、3.68-7,883.68附附表表6:损损益益及及利利润润表表单位：万元序序号号项项目目合合计计第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季第第10季季1销售收入441,600.000.000.000.000.0055,200.009,200.002开发成本305,384.800.000.000.000.000.000.000.000.0038,173.106,362.183销售费用13,248.000.000.000.000.001,656.00276.004财务费用100,759.186,029.330.007,014.

23、850.0023,113.710.000.000.0032,300.650.005销售税费22,521.602,815.20469.206利润总额-313.58-6,029.330.00-7,014.850.00 -23,113.710.000.000.00-19,744.952,092.627补前期亏损8增值税9,437.700.00230.199税后利润-9,751.28-6,029.330.00-7,014.850.00 -23,113.710.000.000.00-19,744.951,862.43成本利润率-2.3%附附表表6:序序号号项项目目1销售收入2开发成本3销售费用4财务费用

24、5销售税费6利润总额7补前期亏损8增值税9税后利润损损益益及及利利润润表表（续续表表）单位：万元第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季9,200.009,200.009,200.009,200.009,200.00248,400.0027,600.0027,600.0027,600.006,362.186,362.186,362.186,362.186,362.18171,778.9519,086.5519,086.5519,086.55276.00276.00276.00276.00276.007,

25、452.00828.00828.00828.000.000.0032,300.650.000.000.00469.20469.20469.20469.20469.2012,668.401,407.601,407.601,407.602,092.622,092.62-30,208.032,092.622,092.6256,500.656,277.856,277.856,277.85230.19230.190.00230.19230.196,215.07690.56690.56690.561,862.431,862.43-30,208.031,862.431,862.4350,285.585,58

26、7.295,587.295,587.29附附表表7:现现金金流流量量表表（全全部部投投资资）单位：万元序序号号 季季度度项项目目合合计计1234567891现金流入441,600.0055,200.001.1销售收入82,800.0055,200.001.2出租收入358,800.001.3 其他收入2现金流出348,724.5096,212.0713,412.077,855.2710,063.2722,207.2716,319.2716,319.2715,031.2733,136.872.1建设期开发成本303,517.2096,212.0713,412.077,855.2710,063.2

27、722,207.2716,319.2716,319.2715,031.2728,665.672.2经营期当期成本2.3销售费用13,248.001,656.002.4销售税费22,521.602,815.202.5增值税9,437.703净现金流量92,875.50-96,212.07-13,412.07-7,855.27-10,063.27-22,207.27-16,319.27-16,319.27-15,031.2722,063.134累计净现金流量-96,212.07-109,624.13-117,479.40-127,542.67-149,749.93-166,069.20-182,3

28、88.47-197,419.73-175,356.605净现值25,556.69-96,212.07-13,156.48-7,558.73-9,498.85-20,562.28-14,822.48-14,540.02-13,137.2418,915.586累计净现值-96,212.07-109,368.55-116,927.28-126,426.14-146,988.42-161,810.90-176,350.92-189,488.16-170,572.58计算指标：财务内部收益率=12.11%备注：销售税费率5.1%财务净现值（I=8%)=25,557增值税费11%动态投资回收期（年）=3.

29、03附附表表7:序序号号 季季度度项项目目1现金流入1.1销售收入1.2出租收入1.3 其他收入2现金流出2.1建设期开发成本2.2经营期当期成本2.3销售费用2.4销售税费2.5增值税3净现金流量4累计净现金流量5净现值6累计净现值现现金金流流量量表表（全全部部投投资资）（续续表表）单位：万元101112131415161718199,200.009,200.009,200.009,200.009,200.009,200.00248,400.0027,600.0027,600.0027,600.009,200.009,200.009,200.009,200.009,200.009,200.00248,400.0027,600.0027,600.0027,600.0021,600.2521,600.2533,137.05745.20975.39975.3930,355.872,926.162,926.162,926.1620,624.8720,624.8732,161.674