房地产项目投资估算及财务分析(招保万金模板)-2012版.xls

房地产项目投资估算及财务分析(招保万金模板)-2012版.xls

《房地产项目投资估算及财务分析(招保万金模板)-2012版.xls》由会员分享，可在线阅读，更多相关《房地产项目投资估算及财务分析(招保万金模板)-2012版.xls（13页珍藏版）》请在冰豆网上搜索。

附表1项项目目总总投投资资估估算算表表序序号号项项目目名名称称总总额额（万万元元）占占总总投投资资比比例例1地价28,979.9737.8%2前期工程费1,884.442.5%3建安工程34,862.1145.5%4不可预见费1,837.332.4%5管理费1,102.401.4%6其他费用820.811.1%8财务费用3,502.974.6%7销售费用3,640.734.8%9合计76,630.74100.0%附附表表2：

项项目目开开发发总总成成本本估估算算表表容积率=4.18计入容积率建筑面积（m2）269205.46土地面积64403.22m2（96.6亩）序序号号项项目目名名称称计计算算程程式式单单价价（元元/m2）金金额额（万万元元）备备注注一土地成本1,07728,979.97二前期工程费2.1勘察测量费20538.412.2规划设计费30807.622.3临时供水供电10269.212.4场地平整及道路10269.21前期工程小计2.12.4701,884三建筑安装工程费3.1基础工程费902,422.853.2土建工程费75020,190.413.3安装工程费45512,2493.3.1水电安装1002,692.053.3.2电梯工程802,153.643.3.3空调工程-3.3.4消防工程601,615.233.3.5通讯工程15403.813.3.6室外配套1604,307.293.3.7煤气管道20538.413.3.8对讲系统15403.813.3.9公用天线5134.603.4地下室3.5建安工程小计3.13.51,29534,862.11四不可预见费681,837.33五管理费用411,102.40六其他费用6.1工程监理费15403.816.2市交通管理局0.123.236.3市道桥管理局0.379.966.4市建设局（散装水泥）-6.5墙改基金5134.606.6白蚁防治10269.21其他费用小计6.16.730820.81七合计

（二）（六）1,50540,507.08八总开发成本

（一）+（七）2,58169,487.04附附表表3：

投投资资计计划划表表单位：

万元序号项目名称投资总额第第11季季第第22季季第第33季季第第4季季第第5季季第第66季季第第77季季第第88季季第第9季季一土地成本28979.9728979.97二前期费用1884.44376.89376.89376.89376.89三基础工程费2422.85575.43575.43575.43四主体工程费20190.412271.422523.802271.422523.80五水电安装2692.05302.86336.51302.86336.51六消防工程1615.23181.71201.90181.71201.90七电梯工程2153.64242.28269.21242.28269.21八通迅工程403.8145.4350.4845.4350.48九煤气工程538.4160.5767.3060.5767.30十对讲系统403.8145.4350.4845.4350.48十一公用天线134.6015.1416.8315.1416.83十二室外配套4307.29484.57538.41484.57538.41十三不可预见费1837.33122.49122.49122.49122.49122.49122.49122.49122.49122.49十四管理费1102.4073.4973.4973.4973.4973.4973.4973.4973.4973.49十五其他费用820.81234.52234.5227.0627.0627.0627.0627.0627.0627.06十六合计69487.0429787.35807.39798.472494.464501.732329.572494.464501.732329.57注：

1.土地成本按计算初期一次性投入计。

2.按照通常情况,工程费用中5%留取保修金及滞留金，竣工验收后一年付出。

3.工程款的支付与工程进度表相对应，不考虑工程队大额垫资，按工程进度付款，竣工验收后支付率达95%，其它部分在工程建设过程中平均投入。

投投资资计计划划表表（续续表表）单位：

万元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季376.8930.29575.4330.2930.2930.292523.802523.802523.802523.80252.38252.3833.65302.86336.5133.65302.86336.5133.6533.6520.19181.71201.9020.19181.71201.9020.1920.1926.92242.28269.2126.92242.28269.2126.9226.925.0545.4350.485.0545.4350.485.055.056.7360.5767.306.7360.5767.306.736.735.0545.4350.485.0545.4350.485.055.051.6815.1416.831.6815.1416.831.681.6853.84484.57538.4153.84484.57538.4153.8453.84122.49122.49122.49122.49122.49122.4973.4973.4973.4973.4973.4973.4927.0627.0627.0627.0627.0627.062930.244501.732329.572930.244124.841754.15435.78435.78附附表表3：

序号项目名称一土地成本二前期费用三基础工程费四主体工程费五水电安装六消防工程七电梯工程八通迅工程九煤气工程十对讲系统十一公用天线十二室外配套十三不可预见费十四管理费十五其他费用十六合计附附表表4：

项项目目销销售售回回款款计计划划表表项目内容销销售售建建筑筑面面积积（m2）销销售售价价格格（元元/m2）总总价价（万万元元）备备注注住宅215364.463,30071,070.27商业53841.0010,00053,841.00合计269205.46124,911.27住宅销售率95%商铺销售率100%销售收入121,357.76计算期（季度）销销售售比比例例回回款款比比例例回回款款金金额额合合计计住住宅宅商商业业住住宅宅商商业业住住宅宅商商业业123455.00%3.33%2,369.012,369.0167.50%6.67%4,738.024,738.0277.50%10.00%7.50%6.67%5,330.273,589.408,919.6787.50%10.00%7.50%10.00%5,330.275,384.1010,714.3798.75%10.00%8.33%10.00%5,922.525,384.1011,306.62107.50%10.00%7.92%10.00%5,626.405,384.1011,010.50117.50%10.00%7.50%10.00%5,330.275,384.1010,714.37128.75%10.00%8.33%10.00%5,922.525,384.1011,306.62137.50%10.00%7.92%10.00%5,626.405,384.1011,010.50147.50%10.00%7.50%10.00%5,330.275,384.1010,714.37158.75%10.00%8.33%10.00%5,922.525,384.1011,306.62167.50%10.00%7.92%10.00%5,626.405,384.1011,010.50172.50%4.17%3.33%2,961.261,794.704,755.96181.25%1.67%1,184.501,184.50190.42%296.13296.13合计95.00%100%95.00%100%67,516.7653,841.00121,357.76注：

剩余5%住宅作为企业留存资产，销售回款计划综合考虑银行按揭放款时间。

附附表表5:

资资金金来来源源与与运运用用表表单位：

万元序序号号季季度度项项目目112233445566778899一资金来源30,000.001,000.00900.002,300.004,369.014,738.028,919.6710,714.3719,306.621经营活动产生的现金来源2,369.014,738.028,919.6710,714.3711,306.621.1销售收入2,369.014,738.028,919.6710,714.3711,306.622筹资活动产生的现金来源30,000.001,000.00900.001,300.001,000.005,000.002.1自有资金1,000.001,000.00900.001,300.001,000.005,000.002.2银行借款29,000.003其它来源1,000.001,000.003,000.00二资金运用30,225.221,245.261,236.342,932.335,131.493,151.224,027.866,298.5322,332.941建设期开发成本29,787.35807.39798.472,494.464,501.732,329.572,494.464,501.732,329.572经营期当期发生营业成本3销售费用71.07142.14267.59321.43339.204销售税费120.82241.64454.90546.43576.645所得税373.03491.07587.536盈余公积7应付利润8借款本金偿还18,500.009借款利息支付437.87437.87437.87437.87437.87437.87437.87437.87三盈余资金-225.22-245.26-336.34-632.33-762.481,586.794,891.814,415.84-3,026.31四累计盈余资金-225.22-470.48-806.82-1,439.15-2,201.63-614.844,276.988,692.825,666.50101011,010.5011,010.5011,010.504,394.232,930.24330.31561.54572.146,616.2712,282.77附附表表5:

序序号号季季度度项项目目一资金来源1经营活动产生的现金来源1.1销售收入2筹资活动产生的现金来源2.1自有资金2.2银行借款3其它来源二资金运用1建设期开发成本2经营期当期发生营业成本3销售费用4销售税费5所得税6盈余公积7应付利润8借款本金偿还9借款利息支付三盈余资金四累计盈余资金资资金金来来源源与与运运用用表表（续续表表）单位：

万元11111212131314141515161617171818191910,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.1310,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.1310,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.135,926.343,832.944,394.235,549.453,257.511,899.76632.37157.50475.154,501.732,329.572,930.244,124.841,754.15435