房地产项目投资估算及财务分析模型6p812

1、项项目目总总投投资资估估算算表表序序号号项项目目名名称称总总额额（万万元元）占占总总投投资资比比例例1地 价18,480.0032.9%2前期工程费1,540.002.7%3建安工程28,490.0050.8%4不可预见费1,501.502.7%5管理费900.901.6%6其他费用670.781.2%8财务费用2,234.654.0%7销售费用2,269.224.0%9合 计56,087.05100.0%附附表表2：项项目目开开发发总总成成本本估估算算表表容积率=2.2计入容积率建筑面积(m2)220000序序号号项项目目名名称称计计算算程程式式单单价价（元元/m2）金金额额(万万元元）备备

2、注注一土地成本84018,480.00二前期工程费2.1勘察测量费20440.002.2规划设计费30660.002.3临时供水供电10220.002.4场地平整及道路10220.00前期工程小计2.12.4701,540三建筑安装工程费3.1基础工程费901,980.003.2土建工程费75016,500.003.3安装工程费45510,0103.3.1 水电安装1002,200.003.3.2 电梯工程801,760.003.3.3 空调工程3.3.4 消防工程601,320.003.3.5 通讯工程15330.003.3.6 室外配套1603,520.003.3.7 煤气管道20440.

3、003.3.8 对讲系统15330.003.3.9 公用天线5110.003.4地下室3.5建安工程小计3.13.51,29528,490.00四不可预见费681,501.50五管理费用41900.90六其他费用6.1工程监理费15330.006.2市交通管理局0.122.646.3市道桥管理局0.378.146.4市建设局(散装水泥)6.5墙改基金5110.006.6白蚁防治10220.00其他费用小计6.16.730670.78七合计(二)(六)1,50533,103.18八总开发成本(一)+(七)2,34551,583.18附附表表3：投投资资计计划划表表单位：万元序号 项目名称投资总额

4、第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季一土地成本18480.0018480.00二前期费用1540.00308.00308.00308.00308.00三基础工程费1980.00470.25470.25470.25四主体工程费16500.001856.252062.501856.252062.50五水电安装2200.00247.50275.00247.50275.00六消防工程1320.00148.50165.00148.50165.00七电梯工程1760.00198.00220.00198.00220.00八通迅工程

5、330.0037.1341.2537.1341.25九煤气工程440.0049.5055.0049.5055.00十对讲系统330.0037.1341.2537.1341.25十一 公用天线110.0012.3813.7512.3813.75十二 室外配套3520.00396.00440.00396.00440.00十三 不可预见费1501.50100.10100.10100.10100.10100.10100.10100.10100.10100.10十四 管理费900.9060.0660.0660.0660.0660.0660.0660.0660.0660.06十五 其他费用670.7819

6、1.65191.6522.1122.1122.1122.1122.1122.1122.11十六 合计51583.1819139.81659.81652.522038.523678.901903.772038.523678.901903.77注：1.土地成本按计算初期一次性投入计。 2.按照通常情况,工程费用中5%留取保修金及滞留金，竣工验收后一年付出。 3.工程款的支付与工程进度表相对应，不考虑工程队大额垫资，按工程进度付款， 竣工验收后支付率达95%，其它部分在工程建设过程中平均投入。附附表表3：序号 项目名称一土地成本二前期费用三基础工程费四主体工程费五水电安装六消防工程七电梯工程八通迅工

7、程九煤气工程十对讲系统十一 公用天线十二 室外配套十三 不可预见费十四 管理费十五 其他费用十六 合计投投资资计计划划表表（续续表表）单位：万元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季308.0024.75470.2524.7524.7524.752062.502062.502062.502062.50206.25206.2527.50247.50275.0027.50247.50275.0027.5027.5016.50148.50165.0016.50148.50165.0016.501

8、6.5022.00198.00220.0022.00198.00220.0022.0022.004.1337.1341.254.1337.1341.254.134.135.5049.5055.005.5049.5055.005.505.504.1337.1341.254.1337.1341.254.134.131.3812.3813.751.3812.3813.751.381.3844.00396.00440.0044.00396.00440.0044.0044.00100.10100.10100.10100.10100.10100.1060.0660.0660.0660.0660.0660.

9、0622.1122.1122.1122.1122.1122.112394.653678.901903.772394.653370.901433.52356.13356.13附附表表4：项项目目销销售售回回款款计计划划表表项目内容销销售售建建筑筑面面积积(m2）销销售售价价格格（元元/m2）总总价价（万万元元）备备注注住宅203000.003,30066,990.00商业12000.0010,00012,000.00合计215000.0078,990.00住宅销售率95%商铺销售率100%销售收入75,640.50计算期（季度）销销售售比比例例回回款款比比例例回回款款金金额额合合计计住住宅宅商商

10、业业住住宅宅商商业业住住宅宅商商业业123455.00%3.33%2,233.002,233.0067.50%6.67%4,466.004,466.0077.50%10.00%7.50%6.67%5,024.25800.005,824.2587.50%10.00%7.50%10.00%5,024.251,200.006,224.2598.75%10.00%8.33%10.00%5,582.501,200.006,782.50107.50%10.00%7.92%10.00%5,303.381,200.006,503.38117.50%10.00%7.50%10.00%5,024.251,200.

11、006,224.25128.75%10.00%8.33%10.00%5,582.501,200.006,782.50137.50%10.00%7.92%10.00%5,303.381,200.006,503.38147.50%10.00%7.50%10.00%5,024.251,200.006,224.25158.75%10.00%8.33%10.00%5,582.501,200.006,782.50167.50%10.00%7.92%10.00%5,303.381,200.006,503.38172.50%4.17%3.33%2,791.25400.003,191.25181.25%1.67

12、%1,116.501,116.50190.42%279.13279.13合计95.00%100%95.00%100%63,640.5012,000.0075,640.50注：剩余5%住宅作为企业留存资产，销售回款计划综合考虑银行按揭放款时间。附表5:资资金金来来源源与与运运用用表表单单位位：万万元元序号 季度项目12345678910一一资资金金来来源源19,500.0019,500.001,000.001,000.00900.00900.002,300.002,300.004,233.004,233.004,466.004,466.005,824.255,824.256,224.256,22

13、4.2514,782.5014,782.506,503.386,503.381 1经经营营活活动动产产生生的的现现金金来来源源2,233.002,233.004,466.004,466.005,824.255,824.256,224.256,224.256,782.506,782.506,503.386,503.381.11.1销销售售收收入入2,233.002,233.004,466.004,466.005,824.255,824.256,224.256,224.256,782.506,782.506,503.386,503.382 2 筹筹资资活活动动产产生生的的现现金金来来源源19,50

14、0.0019,500.001,000.001,000.00900.00900.001,300.001,300.001,000.001,000.005,000.005,000.002.12.1自自有有资资金金1,000.001,000.001,000.001,000.00900.00900.001,300.001,300.001,000.001,000.005,000.005,000.002.22.2银银行行借借款款18,500.0018,500.003 3其其它它来来源源1,000.001,000.001,000.001,000.003,000.003,000.00二二资资金金运运用用19,4

15、19.1419,419.14939.14939.14931.86931.862,317.862,317.864,139.104,139.102,544.852,544.852,941.612,941.614,641.814,641.8121,194.3221,194.323,152.663,152.661 1建建设设期期开开发发成成本本19,139.8119,139.81659.81659.81652.52652.522,038.522,038.523,678.903,678.901,903.771,903.772,038.522,038.523,678.903,678.901,903.771

16、,903.772,394.652,394.652 2经经营营期期当当期期发发生生营营业业成成本本3 3销销售售费费用用66.9966.99133.98133.98174.73174.73186.73186.73203.48203.48195.10195.104 4销销售售税税费费113.88113.88227.77227.77297.04297.04317.44317.44345.91345.91331.67331.675 5所所得得税税151.99151.99179.42179.42241.17241.17231.24231.246 6盈盈余余公公积积7 7应应付付利利润润8 8借借款款本本

17、金金偿偿还还18,500.0018,500.009 9借借款款利利息息支支付付279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33279.33三三盈盈余余资资金金80.8680.8660.8660.86-31.86-31.86-17.86-17.8693.9093.901,921.151,921.152,882.642,882.641,582.441,582.44-6,411.82-6,411.823,350.713,350.71四四累累计计盈盈余余资资金金80.86

18、80.86141.71141.71109.86109.8692.0092.00185.90185.902,107.052,107.054,989.694,989.696,572.126,572.12160.30160.303,511.013,511.01附表5:序号 季度项目一一资资金金来来源源1 1经经营营活活动动产产生生的的现现金金来来源源1.11.1销销售售收收入入2 2 筹筹资资活活动动产产生生的的现现金金来来源源2.12.1自自有有资资金金2.22.2银银行行借借款款3 3其其它它来来源源二二资资金金运运用用1 1建建设设期期开开发发成成本本2 2经经营营期期当当期期发发生生营营业业

19、成成本本3 3销销售售费费用用4 4销销售售税税费费5 5所所得得税税6 6盈盈余余公公积积7 7应应付付利利润润8 8借借款款本本金金偿偿还还9 9借借款款利利息息支支付付三三盈盈余余资资金金四四累累计计盈盈余余资资金金资资金金来来源源与与运运用用表表（续续表表）单单位位：万万元元1112131415161718196,224.256,224.256,782.506,782.506,503.386,503.386,224.256,224.256,782.506,782.506,503.386,503.383,191.253,191.251,116.501,116.50279.13279.13

20、6,224.256,224.256,782.506,782.506,503.386,503.386,224.256,224.256,782.506,782.506,503.386,503.383,191.253,191.251,116.501,116.50279.13279.136,224.256,224.256,782.506,782.506,503.386,503.386,224.256,224.256,782.506,782.506,503.386,503.383,191.253,191.251,116.501,116.50279.13279.134,404.384,404.382,69

21、4.322,694.323,152.663,152.664,096.384,096.382,224.072,224.071,114.141,114.14371.96371.96130.14130.14388.66388.663,678.903,678.901,903.771,903.772,394.652,394.653,370.903,370.901,433.521,433.52356.13356.13356.13356.13186.73186.73203.48203.48195.10195.10186.73186.73203.48203.48195.10195.1095.7495.7433

22、.5033.508.378.37317.44317.44345.91345.91331.67331.67317.44317.44345.91345.91331.67331.67162.75162.7556.9456.9414.2414.24221.32221.32241.17241.17231.24231.24221.32221.32241.17241.17231.24231.24113.47113.4739.7039.709.929.921,819.871,819.874,088.184,088.183,350.713,350.712,127.872,127.874,558.434,558.

23、435,389.235,389.232,819.292,819.29986.36986.36-109.53-109.535,330.885,330.889,419.069,419.0612,769.7712,769.7714,897.6414,897.6419,456.0719,456.0724,845.3024,845.3027,664.5927,664.5928,650.9528,650.9528,541.4228,541.42附附表表6:损损益益及及利利润润表表单位：万元序序号号项项目目合合计计第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第

24、8 8季季第第9季季第第10季季1销售收入75,640.502,233.004,466.005,824.256,224.256,782.506,503.382开发成本51,583.181,522.803,045.603,971.864,244.644,625.344,434.993销售费用2,269.2266.99133.98174.73186.73203.48195.104财务费用2,234.65279.33279.33279.33279.33279.33279.33279.33279.330.000.005销售税费3,857.67113.88227.77297.04317.44345.91

25、331.676利润总额15,695.79-279.33-279.33-279.33-279.33250.00779.331,101.301,196.121,607.781,541.617补前期亏损250.00779.3388.008所得税2,354.370.00151.99179.42241.17231.249税后利润13,341.42-279.33-279.33-279.33-279.330.000.00861.301,016.701,366.611,310.37成本利润率23.8%附附表表6:序序号号项项目目1销售收入2开发成本3销售费用4财务费用5销售税费6利润总额7补前期亏损8所得税9

26、税后利润损损益益及及利利润润表表（续续表表）单位：万元第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季6,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.134,244.644,625.344,434.994,244.644,625.344,434.992,176.28761.40190.35186.73203.48195.10186.73203.48195.1095.7433.508.370.000.000.000.000.0

27、00.00317.44345.91331.67317.44345.91331.67162.7556.9414.241,475.451,607.781,541.611,475.451,607.781,541.61756.48264.6666.17221.32241.17231.24221.32241.17231.24113.4739.709.921,254.131,366.611,310.371,254.131,366.611,310.37643.01224.9656.24附附表表7:现现金金流流量量表表（全全部部投投资资）单位：万元序序号号 季季度度项项目目合合计计1234567891现金流入

28、75,640.502,233.004,466.005,824.256,224.256,782.501.1销售收入75,640.502,233.004,466.005,824.256,224.256,782.501.2出租收入1.3 其他收入2现金流出60,064.4319,139.81659.81652.522,038.523,859.772,265.522,662.284,362.482,694.322.1建设期开发成本51,583.1819,139.81659.81652.522,038.523,678.901,903.772,038.523,678.901,903.772.2经营期当期成

29、本2.3销售费用2,269.2266.99133.98174.73186.73203.482.4销售税费3,857.67113.88227.77297.04317.44345.912.5所得税2,354.37151.99179.42241.173净现金流量15,576.07-19,139.81-659.81-652.52-2,038.52-1,626.772,200.483,161.971,861.774,088.184累计净现金流量-19,139.81-19,799.62-20,452.15-22,490.67-24,117.44-21,916.96-18,754.99-16,893.22-

30、12,805.055净现值8,273.37-19,139.81-647.24-627.89-1,924.19-1,506.271,998.652,817.231,627.183,504.956累计净现值-19,139.81-19,787.05-20,414.94-22,339.13-23,845.40-21,846.75-19,029.52-17,402.34-13,897.39计算指标：财务内部收益率=21.44%财务净现值（I=8%)=8,273动态投资回收期（年）=3.64附附表表7:序序号号 季季度度项项目目1现金流入1.1销售收入1.2出租收入1.3 其他收入2现金流出2.1建设期开

31、发成本2.2经营期当期成本2.3销售费用2.4销售税费2.5所得税3净现金流量4累计净现金流量5净现值6累计净现值现现金金流流量量表表（全全部部投投资资）（续续表表）单位：万元101112131415161718196,503.386,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.136,503.386,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.133,152.664,404.382,694.323,152.664,096.382,224.071,114.14371.96130.14388.662,394.653,678.901,903.772,394.653,370.901,433.52356.13356.13195.10186.73203.48195.10186.73203.48195.1095.7433.508.37331.67317.44345.91331.67317.44345.91331.67162.7556.9414.24231