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

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

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

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

万元序号项目名称投资总额第第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.78435.78321.43339.20330.31321.43339.20330.31142.6835.548.88546.43576.64561.54546.43576.64561.54242.5560.4115.10556.75587.53572.14556.75587.53572.14247.1361.5515.394,788.037,473.696,616.275,164.928,049.119,110.734,123.591,027.01-179.0217,070.8024,544.4931,160.7636,325.6844,374.7953,485.5257,609.1258,636.1358,457.10附附表表5:

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

损损益益及及利利润润表表单位：

万元序序号号项项目目合合计计第第11季季第第22季季第第33季季第第4季季第第5季季第第66季季第第77季季第第88季季第第9季季1销售收入121,357.762,369.014,738.028,919.6710,714.3711,306.622开发成本69,487.041,356.452,712.905,107.236,134.846,473.953销售费用3,640.7371.07142.14267.59321.43339.204财务费用3,502.97437.87437.87437.87437.87437.87437.87437.87437.870.005销售税费6,189.25120.82241.64454.90546.43576.646利润总额38,537.77-437.87-437.87-437.87-437.87382.801,203.472,652.083,273.803,916.847补前期亏损382.801,203.47165.218所得税5,780.670.00373.03491.07587.539税后利润32,757.10-437.87-437.87-437.87-437.870.000.002,113.842,782.733,329.31成本利润率42.7%损损益益及及利利润润表表（续续表表）单位：

万元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季11,010.5010,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.136,304.396,134.846,473.956,304.396,134.846,473.956,304.392,723.17678.22169.56330.31321.43339.20330.31321.43339.20330.31142.6835.548.880.000.000.000.000.000.000.00561.54546.43576.64561.54546.43576.64561.54242.5560.4115.103,814.253,711.673,916.843,814.253,711.673,916.843,814.251,647.56410.34102.58572.14556.75587.53572.14556.75587.53572.14247.1361.5515.393,242.123,154.923,329.313,242.123,154.923,329.313,242.121,400.43348.7987.20附附表表6:

序序号号项项目目1销售收入2开发成本3销售费用4财务费用5销售税费6利润总额7补前期亏损8所得税9税后利润附附表表7:

现现金金流流量量表表（全全部部投投资资）单位：

万元序序号号季季度度项项目目合合计计1234567891现金流入121,357.762,369.014,738.028,919.6710,714.3711,306.621.1销售收入121,357.762,369.014,738.028,919.6710,714.3711,306.621.2出租收入1.3其他收入2现金流出85,097.6929,787.35807.39798.472,494.464,693.622,713.353,589.995,860.663,832.942.1建设期开发成本69,487.0429,787.35807.39798.472,494.464,501.732,329.572,494.464,501.732,329.572.2经营期当期成本2.3销售费用3,640.7371.07142.14267.59321.43339.202.4销售税费6,189.25120.82241.64454.90546.43576.642.5所得税5,780.67373.03491.07587.533净现金流量36,260.07-29,787.35-807.39-798.47-2,494.46-2,324.612,024.665,329.684,853.717,473.694累计净现金流量-29,787.35-30,594.74-31,393.21-33,887.67-36,212.28-34,187.61-28,857.93-24,004.21-16,530.535净现值22,839.10-29,787.35-792.00-768.33-2,354.56-2,152.411,838.964,748.604,242.116,407.486累计净现值-29,787.35-30,579.35-31,347.68-33,702.24-35,854.65-34,015.68-29,267.08-25,024.97-18,617.49计算指标：

财务内部收益率=31.19%财务净现值（I=8%）=22,839动态投资回收期（年）=3.75现现金金流流量量表表（全全部部投投资资）（续续表表）单位：

万元1011121314151617181911,010.5010,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.1311,010.5010,714.3711,306.6211,010.5010,714.3711,306.6211,010.504,755.961,184.50296.134,394.235,926.343,832.944,394.235,549.453,257.511,899.76632.37157.50475.152,930.244,501.732,329.572,930.244,124.841,754.15435.78435.78330.31321.43339.20330.31321.43339.20330.31142.6835.548.88561.54546.43576.64561.54546.43576.64561.54242.5560.4115.10572.14556.75587.53572.14556.75587.53572.14247.1361.5515.396,616.274,788.037,473.696,616.275,164.928,049.119,110.734,123.591,027.01-179.02-9,914.26-5,126.232,347.468,963.7314,128.6522,177.7631,288.4935,412.0936,439.0936,260.075,564.293,950.006,048.115,252.214,021.956,148.446,826.753,030.97740.50-126.62-13,053.20-9,103.19-3,055.082,197.126,219.0712,367.5119,194.2622,225.2322,965.7222,839.10附附表表7:

序序号号季季度度项项目目1现金流入1.1销售收入1.2出租收入1.3其他收入2现金流出2.1建设期开发成本2.2经营期当期成本2.3销售费用2.4销售税费2.5所得税3净现金流量4累计净现金流量5净现值6累计净现值附附表表8：

敏敏感感性性分分析析表表因因素素变变化化情情况况相相关关指指标标变变化化情情况况敏敏感感性性分分析析结结果果总总建建筑筑面面积积（m2）销销售售价价格格（元元/m2）销销售售收收入入（万万元元）总总投投资资（万万元元）税税后后利利润润（万万元元）投投资资利利润润率率财财务务净净现现值值（万万元元）内内部部收收益益率率动动态态投投资资回回收收期期（年年）基基本本方方案案（容容积积率率=4.18）269,205269,205住住宅宅33003300121,358121,35876,63176,63132,75732,75742.7%42.7%22,83922,83931.19%31.19%3.753.75商商业业1000010000销售价格变化价价格格下下降降10%10%220,000住宅2970297068,07655,9707,33913.10%3,33313.57%3.94商业90009000价价格格上上升升10%10%220,000住宅3630363083,20556,42419,15734.00%13,03528.57%3.28商业1100011000工程造价变化工工程程造造价价增增加加10%10%220,000住宅330075,64159,51810,42517.50%5,74317.22%3.81商业10000工工程程造造价价减减少少10%10%220,000住宅330075,64152,87616,07130.40%10,62525.39%3.46商业10000