资源描述
项项目目总总投投资资估估算算表表序序号号项项目目名名称称总总额额(万万元元)占占总总投投资资比比例例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序序号号项项目目名名称称计计算算程程式式单单价价(元元/m/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.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:投投资资计计划划表表单位:万元序号 项目名称投资总额第第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八通迅工程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.78191.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%,其它部分在工程建设过程中平均投入。投投资资计计划划表表(续续表表)单位:万元第第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.5016.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.0622.1122.1122.1122.1122.1122.112394.653678.901903.772394.653370.901433.52356.13356.13附附表表3:序号 项目名称一土地成本二前期费用三基础工程费四主体工程费五水电安装六消防工程七电梯工程八通迅工程九煤气工程十对讲系统十一 公用天线十二 室外配套十三 不可预见费十四 管理费十五 其他费用十六 合计附附表表4:项项目目销销售售回回款款计计划划表表项目内容销销售售建建筑筑面面积积(m2)销销售售价价格格(元元/m2)总总价价(万万元元)备备注注住宅203000.003,30066,990.00商业12000.0010,00012,000.00合计215000.0078,990.00住宅销售率95%商铺销售率100%销售收入75,640.50计算期(季度)销销售售比比例例回回款款比比例例回回款款金金额额合合计计住住宅宅商商业业住住宅宅商商业业住住宅宅商商业业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.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%1,116.501,116.50190.42%279.13279.13合计95.00%100%95.00%100%63,640.5012,000.0075,640.50注:剩余5%住宅作为企业留存资产,销售回款计划综合考虑银行按揭放款时间。附附表表5:资资金金来来源源与与运运用用表表单位:万元序序号号 季季度度项项目目1 12 23 34 45 56 67 78 89 9一资金来源19,500.001,000.00900.002,300.004,233.004,466.005,824.256,224.2514,782.501经营活动产生的现金来源2,233.004,466.005,824.256,224.256,782.501.1销售收入2,233.004,466.005,824.256,224.256,782.502 筹资活动产生的现金来源19,500.001,000.00900.001,300.001,000.005,000.002.1自有资金1,000.001,000.00900.001,300.001,000.005,000.002.2银行借款18,500.003其它来源1,000.001,000.003,000.00二资金运用19,419.14939.14931.862,317.864,139.102,544.852,941.614,641.8121,194.321建设期开发成本19,139.81659.81652.522,038.523,678.901,903.772,038.523,678.901,903.772经营期当期发生营业成本3销售费用66.99133.98174.73186.73203.484销售税费113.88227.77297.04317.44345.915所得税151.99179.42241.176盈余公积7应付利润8借款本金偿还18,500.009借款利息支付279.33279.33279.33279.33279.33279.33279.33279.33三盈余资金80.8660.86-31.86-17.8693.901,921.152,882.641,582.44-6,411.82四累计盈余资金80.86141.71109.8692.00185.902,107.054,989.696,572.12160.3010106,503.386,503.386,503.383,152.662,394.65195.10331.67231.243,350.713,511.01附附表表5:序序号号 季季度度项项目目一资金来源1经营活动产生的现金来源1.1销售收入2 筹资活动产生的现金来源2.1自有资金2.2银行借款3其它来源二资金运用1建设期开发成本2经营期当期发生营业成本3销售费用4销售税费5所得税6盈余公积7应付利润8借款本金偿还9借款利息支付三盈余资金四累计盈余资金资资金金来来源源与与运运用用表表(续续表表)单位:万元1111121213131414151516161717181819196,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.136,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.136,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.134,404.382,694.323,152.664,096.382,224.071,114.14371.96130.14388.663,678.901,903.772,394.653,370.901,433.52356.13356.13186.73203.48195.10186.73203.48195.1095.7433.508.37317.44345.91331.67317.44345.91331.67162.7556.9414.24221.32241.17231.24221.32241.17231.24113.4739.709.921,819.874,088.183,350.712,127.874,558.435,389.232,819.29986.36-109.535,330.889,419.0612,769.7714,897.6419,456.0724,845.3027,664.5928,650.9528,541.42附附表表5:序序号号 季季度度项项目目一资金来源1经营活动产生的现金来源1.1销售收入2 筹资活动产生的现金来源2.1自有资金2.2银行借款3其它来源二资金运用1建设期开发成本2经营期当期发生营业成本3销售费用4销售税费5所得税6盈余公积7应付利润8借款本金偿还9借款利息支付三盈余资金四累计盈余资金附附表表6:损损益益及及利利润润表表单位:万元序序号号项项目目合合计计第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季1销售收入75,640.502,233.004,466.005,824.256,224.256,782.502开发成本51,583.181,522.803,045.603,971.864,244.644,625.343销售费用2,269.2266.99133.98174.73186.73203.484财务费用2,234.65279.33279.33279.33279.33279.33279.33279.33279.330.005销售税费3,857.67113.88227.77297.04317.44345.916利润总额15,695.79-279.33-279.33-279.33-279.33250.00779.331,101.301,196.121,607.787补前期亏损250.00779.3388.008所得税2,354.370.00151.99179.42241.179税后利润13,341.42-279.33-279.33-279.33-279.330.000.00861.301,016.701,366.61成本利润率23.8%损损益益及及利利润润表表(续续表表)单位:万元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季6,503.386,224.256,782.506,503.386,224.256,782.506,503.383,191.251,116.50279.134,434.994,244.644,625.344,434.994,244.644,625.344,434.992,176.28761.40190.35195.10186.73203.48195.10186.73203.48195.1095.7433.508.370.000.000.000.000.000.000.00331.67317.44345.91331.67317.44345.91331.67162.7556.9414.241,541.611,475.451,607.781,541.611,475.451,607.781,541.61756.48264.6666.17231.24221.32241.17231.24221.32241.17231.24113.4739.709.921,310.371,254.131,366.611,310.371,254.131,366.611,310.37643.01224.9656.24附附表表6:序序号号项项目目1销售收入2开发成本3销售费用4财务费用5销售税费6利润总额7补前期亏损8所得税9税后利润附附表表7:现现金金流流量量表表(全全部部投投资资)单位:万元序序号号 季季度度项项目目合合计计1234567891现金流入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经营期当期成本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-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现现金金流流量量表表(全全部部投投资资)(续续表表)单位:万元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.24221.32241.17231.24221.32241.17231.24113.4739.709.923,350.711,819.874,088.183,350.712,127.874,558.435,389.232,819.29986.36-109.53-9,454.34-7,634.47-3,546.29-195.581,932.296,490.7211,879.9514,699.2415,685.6115,576.072,817.951,501.353,308.372,659.901,656.983,482.024,038.202,072.26711.19-77.47-11,079.44-9,578.09-6,269.72-3,609.82-1,952.831,529.195,567.397,639.658,350.848,273.37附附表表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)销销售售收收入入(万万元元)总总投投资资(万万元元)税税后后利利润润(万万元元)投投资资利利润润率率财财务务净净现现值值(万万元元)内内部部收收益益率率动动态态投投资资回回收收期期(年年)基基本本方方案案(容容积积率率=2.2)220,000220,000住住宅宅3300330075,64175,64156,08756,08713,34113,34123.8%23.8%8,2738,27321.44%21.44%3.643.64商商业业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
展开阅读全文