首页 可行性研究财务评价计算表

可行性研究财务评价计算表

举报
开通vip

可行性研究财务评价计算表项目规划指标表名称面积(平方米)规划用地面积65519.36规划总建筑面积166419.17其中地上建筑面积住宅建筑面积135206.72138967.72地上公建建筑面积3761.00地下建筑面积地下公建建筑面积1700.0027229.00地下车库建筑面积19800.00人防等建筑面积5729.00道路用地19655.81绿地面积26207.74建筑基地面积19655.81容积率2.54绿化率40.00%建筑密度30.00%总户数882.00总车位550.00项目总投资估算表附表1序号项目名称单位计算数量或基数...

可行性研究财务评价计算表
项目 规划 污水管网监理规划下载职业规划大学生职业规划个人职业规划职业规划论文 指标 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 名称面积(平方米)规划用地面积65519.36规划总建筑面积166419.17其中地上建筑面积住宅建筑面积135206.72138967.72地上公建建筑面积3761.00地下建筑面积地下公建建筑面积1700.0027229.00地下车库建筑面积19800.00人防等建筑面积5729.00道路用地19655.81绿地面积26207.74建筑基地面积19655.81容积率2.54绿化率40.00%建筑密度30.00%总户数882.00总车位550.00项目总投资估算表附表1序号项目名称单位计算数量或基数每计算单位或费率总价(万元)折和单价(元/建筑每平方米)占总投资比例(%)1土地取得费用平方米65519.3649060.492948.0153.17%1.1交政府毛地价款平方米65519.368731.341.1.1土地出让金平方米65519.365236.54住宅建筑面积平方米135206.723504732.24地上公建建筑面积平方米3761.00630236.94地下公建建筑面积平方米1700.0021035.70地下车库建筑面积平方米19800.00117231.661.1.2市政基础设施配套建设费平方米166419.172103494.801.2楼面拆迁费平方米166419.17240039940.601.3有关土地其他税费万元8731.344.45%388.541.3.1招投标服务费万元8731.340.30%26.191.3.2出让地价评估费万元8731.340.20%17.461.3.3契税万元8731.344.00%349.252建筑安装 工程 路基工程安全技术交底工程项目施工成本控制工程量增项单年度零星工程技术标正投影法基本原理 造价平方米166419.1728055.701685.8530.40%2.1主体建筑安装工程造价平方米140935.7222177.332.1.1土建工程平方米140935.7218121.13基础及结构工程平方米140935.7295013388.89内外装修工程平方米135206.723504732.242.1.2设备安装工程平方米135206.723004056.202.2地下车库平方米19800.0025004950.002.3公工配套设施建设费平方米5461.001700928.373配套工程费5501.08330.565.96%3.1供电工程费kva11736.44800938.923.2供电电贴费kva11736.44600704.193.3红线内基础设施建安工程费2522.813.3.1室外工程费万元28055.705.00%1402.793.3.2配电室个3.00700000210.003.3.3景观园林绿化平方米26207.74140366.913.3.4庭院道路工程平方米19655.81200393.123.3.5围墙50.003.3.6路灯等其他100.003.4红线外市政工程1335.173.4.1上水外线工程平方米135206.7220270.413.4.2雨污水外线工程平方米135206.7225338.023.4.3供电外线工程平方米135206.7215202.813.4.4电信外线工程平方米135206.728108.173.4.5天然气外线工程平方米135206.7210135.213.4.6红线外其他工程费用万元28055.701.00%280.564其他费用2763.38166.052.99%4.1临时水、电、路、场地平整费万元33556.782.00%671.144.2前期及建设期其他费用33556.781719.924.2.1前期策划规划费万元33556.780.10%33.564.2.2可行性研究费、评估咨询费、律师费万元33556.780.05%16.784.2.3勘察 设计 领导形象设计圆作业设计ao工艺污水处理厂设计附属工程施工组织设计清扫机器人结构设计 费万元33556.783.00%1006.704.2.4规划许可审批费万元33556.780.10%33.564.2.5编制标底费万元33556.780.15%50.344.2.6招标服务费万元33556.780.06%20.134.2.7公证签证费万元33556.780.01%5.034.2.8工程监理费万元28055.701.50%420.844.2.9质量监督费万元28055.700.18%49.104.2.10工程保险费万元33556.780.25%83.894.3竣工期及租售前期其他费用万元36.754.3.1竣工图编制费万元166419.171.219.974.3.2工程结算审查费万元33556.780.05%16.784.4开发直接经营组织管理费万元33556.781.00%335.575不可预见费万元33556.784.00%1342.2780.661.45%6建设期利息万元8000.005.85%468.0028.120.51%7基本费用小计万元87190.9194.49%8经营费用(市场及销售)万元112625.353.00%3378.76203.033.66%9公司管理费万元85380.642.00%1707.61102.611.85%10财务费用(利息差)万元0.005.85%0.000.000.00%11项目总投资万元92277.295544.87100.00%项目建设施工进度附表2项目时间2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度项目审批勘察、规划设计项目招投标三通一平等基础及结构施工内外装饰设备安装基础设施及小区配套项目推广及销售资金投入计划表附表3项目时间费用(万元)2006年2007年2008年2009年合计第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1土地取得费用49060.491.1交政府毛地价款8731.341.1.1土地出让金5236.5492.00%8.00%100.00%1.1.2市政基础设施配套建设费3494.8010.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%100.00%1.2楼面拆迁费39940.605.00%30.00%25.00%20.00%10.00%10.00%100.00%1.3有关土地其他税费388.5420.00%80.00%100.00%2建筑安装工程造价28055.702.1主体建筑安装工程造价22177.332.1.1土建工程18121.135.00%30.00%25.00%20.00%10.00%10.00%100.00%2.1.2设备安装工程4056.2040.00%30.00%20.00%10.00%100.00%2.2地下车库4950.0010.00%40.00%30.00%10.00%5.00%5.00%100.00%2.3公工配套设施建设费928.3710.00%20.00%20.00%20.00%20.00%10.00%100.00%3配套工程费5501.085.00%5.00%10.00%20.00%20.00%20.00%10.00%10.00%100.00%4其他费用2763.384.1临时水、电、路、场地平整费671.1450.00%50.00%100.00%4.2前期及建设期其他费用1719.9210.00%10.00%10.00%20.00%20.00%10.00%5.00%5.00%5.00%5.00%100.00%4.3竣工期及租售前期其他费用36.7510.00%30.00%50.00%10.00%100.00%4.4开发直接经营组织管理费335.572.50%2.50%2.50%2.50%5.00%10.00%20.00%20.00%20.00%10.00%5.00%100.00%5不可预见费1342.2710.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%100.00%6建设期利息468.00100.00%100.00%7基本费用小计87190.915662.47664.09974.92664.091119.525237.8523365.2719143.6815320.327816.717221.9987190.918占基本费用的比例6.49%0.76%1.12%0.76%1.28%6.01%26.80%21.96%17.57%8.97%8.28%100.00%9累计投入比例6.49%7.26%8.37%9.14%10.42%16.43%43.22%65.18%82.75%91.72%100.00%10经营费用(市场及销售)3378.7610.00%20.00%20.00%20.00%20.00%5.00%5.00%100.00%11公司管理费1707.615.00%5.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%100.00%12财务费用(利息差)0.00100.00%100.00%13期间费用合计5086.3785.3885.38170.76170.76508.64846.51846.51846.51846.51339.70339.705086.3714项目总投资92277.295747.86749.471145.69834.851628.166084.3624211.7819990.1916166.838156.417561.6992277.2915占总投资比例6.23%0.81%1.24%0.90%1.76%6.59%26.24%21.66%17.52%8.84%8.19%100.00%16累计投入比例6.23%7.04%8.28%9.19%10.95%17.55%43.78%65.45%82.97%91.81%100.00%项目总收入测算表附表4-1物业类型总建筑面积(平方米)可售面积(平方米)销售单价(元/平方米)总收入(万元)计算方法说明住宅135206.72135206.727400.00100052.97会所(公建)5461.005461.0012000.006553.20地下车库19800.0018810.003200.006019.20合计160467.72159477.72112625.37项目静态财务评价指标附表4-2指标名称计算说明指标值2.75销售总收入(万元)见项目总收入测算表112625.37利润总额(万元)13027.44税后利润(万元)9310.80项目总投资(万元)92277.29项目自有资金(万元)35000.0037.93%总投资收益率(%)14.12%总投资年平均收益率(%)5.13%总投资净收益率(%)10.09%总投资年均净收益率(%)3.67%自有资金收益率(%)37.22%自有资金年平均收益率(%)13.53%自有资金净收益率(%)26.60%自有资金年均净收益率(%)9.67%销售收入、经营税金及附加测算表单位:万元附表5销售收入及税金销售计划时间2006年2007年2008年2009年合计第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度销售收入住宅销售收入0.000.000.000.000.000.005002.6510005.3045023.8435018.545002.65100052.97百分比0.00%0.00%0.00%0.00%0.00%0.00%5.00%10.00%45.00%35.00%5.00%100.00%会所(公建)销售收入0.000.000.000.000.000.000.000.000.000.006553.206553.20百分比0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%100.00%100.00%地下车库销售收入0.000.000.000.000.000.000.00300.961203.842106.722407.686019.20百分比0.00%0.00%0.00%0.00%0.00%0.00%0.00%5.00%20.00%35.00%40.00%100.00%合计销售收入0.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.53112625.37百分比0.00%0.00%0.00%0.00%0.00%0.00%4.44%9.15%41.05%32.96%12.40%100.00%经营税金营业税销售收入的5%0.000.000.000.000.000.00250.13515.312311.381856.26698.185631.27城市维护建设费营业税的3%0.000.000.000.000.000.0017.5136.07161.80129.9448.87394.19教育附加营业税的7%0.000.000.000.000.000.007.5015.4669.3455.6920.95168.94经营税金及附加合计0.000.000.000.000.000.00275.15566.842542.522041.89767.996194.40土地增值税销售收入的1%0.000.000.000.000.000.0050.03103.06462.28371.25139.641126.25企业所得税销售收入的3.3%0.000.000.000.000.000.00165.09340.111525.511225.13460.803716.64可用于反投资的销售收入0.000.000.000.000.000.004512.399296.2441697.3733486.9812595.10101588.09损益预测表附表6序号项目合计2006200720082009备注1经营收入112625.370.000.0061536.5851088.791.1销售收入112625.370.000.0061536.5851088.792经营成本87190.915662.473422.6363067.1115038.702.1商品房经营成本87190.915662.473422.6363067.1115038.703期间费用5086.3785.38935.543386.05679.403.1经营费用3378.760.00337.882703.01337.883.2管理费用1707.6185.38597.66683.05341.523.3财务费用0.000.000.000.000.004经营税金及附加6194.400.000.003384.512809.88销售收入的5.5%5土地增值税1126.250.000.00615.37510.89销售收入的1%6利润总额13027.44-5747.86-4358.17-8916.4632049.927企业所得税4299.05-1896.79-1438.20-2942.4310576.47销售收入的33%8税后利润8728.38-3851.06-2919.97-5974.0321473.458.1盈余公积金1309.26-577.66-438.00-896.103221.02税后利润的15%8.2应付利润0.000.000.000.000.008.3为分配利润7419.12-3273.40-2481.98-5077.9218252.43资金来源与运用表单位:万元附表7序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1资金来源165625.376000.002000.002000.002000.002000.006000.0026002.6522306.2646227.6837125.2613963.531.1销售收入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.531.2自筹资金35000.006000.002000.002000.002000.002000.006000.0015000.001.3银行贷款18000.006000.0012000.002资金运用121666.865747.86749.471145.69834.851628.166084.3624702.0421000.2039049.4311794.688930.122.1开发建设基本费用87190.915662.47664.09974.92664.091119.525237.8523365.2719143.6815320.327816.717221.992.2预计销售费用3378.760.000.000.000.00337.88675.75675.75675.75675.75168.94168.942.3公司管理费用1707.6185.3885.38170.76170.76170.76170.76170.76170.76170.76170.76170.762.4经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.5土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.6企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.802.7借款本金偿还18000.0018000.002.8借款利息支付352.28352.283盈余资金43958.51252.141250.53854.311165.15371.84-84.361300.601306.067178.2525330.585033.414累计盈余资金252.141502.682356.993522.143893.983809.625110.226416.2813594.5338925.1043958.51借款还本付息测算表单位:万元附表8序号项目年利率2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1借款还本付息5.85%1.1期初借款本息累计0.006000.0018087.751.1.1本金0.006000.0018000.001.1.2利息0.000.0087.751.2本期借款6000.0012000.000.001.3本期应计利息0.0087.75264.531.4本期本金偿还0.000.0018000.001.5本期付息0.000.00352.282偿还借款来源0.000.000.000.000.000.004512.399296.2441697.3733486.9812595.10全部投资现金流量表单位:万元附表9序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1现金流入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.531.1销售收入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.532现金流出103314.575747.86749.471145.69834.851628.166084.3624702.0421000.2020697.1411794.688930.122.1开发建设投资92277.295747.86749.471145.69834.851628.166084.3624211.7819990.1916166.838156.417561.692.2经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.3土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.4企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.803净现金流量9310.80-5747.86-749.47-1145.69-834.85-1628.16-6084.36-19699.40-10693.9425530.5325330.585033.414累计净现金流量-144600.97-5747.86-6497.32-7643.01-8477.86-10106.02-16190.38-35889.78-46583.72-21053.194277.399310.805所得税前净现金流量13027.44-5747.86-749.47-1145.69-834.85-1628.16-6084.36-19534.31-10353.8427056.0526555.715494.216所得税前累计净现金流量-134927.50-5747.86-6497.32-7643.01-8477.86-10106.02-16190.38-35724.69-46078.53-19022.487533.2313027.44计算指标所得税后所得税前FIRR(季度)5.06%6.85%FNPV(季度I=3%)3015.165831.56税后折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.050.950.910.860.820.780.750.710.680.640.610.580.060.940.890.840.790.750.700.670.630.590.560.53FNPV(季度I=3%)3015.16-5580.44-706.45-1048.46-741.75-1404.47-5095.56-16017.41-8441.9019567.0318848.333636.24FNPV(季度I=5%)66.43-5474.15-679.79-989.69-686.83-1275.71-4540.24-13999.99-7238.0816457.2115550.782942.93FNPV(季度I=6%)-1121.89-5422.51-667.03-961.94-661.28-1216.66-4289.23-13101.22-6709.5115111.4814144.462651.54税前折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.060.940.890.840.790.750.700.670.630.590.560.530.070.930.870.820.760.710.670.620.580.540.510.48FNPV(季度I=3%)5831.56-5580.44-706.45-1048.46-741.75-1404.47-5095.56-15883.18-8173.4220736.2119759.943969.13FNPV(季度I=6%)1031.08-5422.51-667.03-961.94-661.28-1216.66-4289.23-12991.43-6496.1316014.4314828.572894.28FNPV(季度I=7%)-178.17-5371.83-654.62-935.22-636.90-1160.86-4054.27-12164.99-6026.0314716.7013499.582610.26自有资金现金流量表单位:万元附表10序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1现金流入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.531.1销售收入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.532现金流出46037.296000.002000.002000.002000.002000.006000.0015490.261010.014530.313638.281368.432.1自有资金35000.006000.002000.002000.002000.002000.006000.0015000.000.000.000.000.002.2借款本金偿还18000.000.000.000.000.000.000.000.000.0018000.000.000.002.3借款利息支付352.280.000.000.000.000.000.000.000.00352.280.000.002.4经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.5土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.6企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.803净现金流量66588.09-6000.00-2000.00-2000.00-2000.00-2000.00-6000.00-10487.619296.2441697.3733486.9812595.104累计净现金流量19408.09-6000.00-8000.00-10000.00-12000.00-14000.00-20000.00-30487.61-21191.3720506.0053992.9866588.095所得税前净现金流量70304.72-6000.00-2000.00-2000.00-2000.00-2000.00-6000.00-10322.529636.3543222.8834712.1213055.906所得税前累计净现金流量29081.56-6000.00-8000.00-10000.00-12000.00-14000.00-20000.00-30322.52-20686.1722536.7157248.8270304.72计算指标所得税后所得税前FIRR(季度)24.11%24.92%FNPV(季度I=3%)46717.3349533.73税后折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.240.810.650.520.420.340.280.220.180.140.120.090.250.800.640.510.410.330.260.210.170.130.110.09FNPV(季度I=3%)46717.33-5825.24-1885.19-1830.28-1776.97-1725.22-5024.91-8527.397338.5431957.5624917.469098.97FNPV(季度I=24%)63.74-4838.71-1300.73-1048.97-845.95-682.22-1650.52-2326.621663.166016.083896.361181.85FNPV(季度I=25%)-517.11-4800.00-1280.00-1024.00-819.20-655.36-1572.86-2199.411559.655596.533595.641081.91税前折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.240.810.650.520.420.340.280.220.180.140.120.090.250.800.640.510.410.330.260.210.170.130.110.09FNPV(季度I=3%)49533.73-5825.24-1885.19-1830.28-1776.97-1725.22-5024.91-8393.167607.0233126.7425829.089431.86FNPV(季度I=24%)567.10-4838.71-1300.73-1048.97-845.95-682.22-1650.52-2289.991724.016236.184038.911225.09FNPV(季度I=25%)-49.55-4800.00-1280.00-1024.00-819.20-655.36-1572.86-2164.791616.715801.283727.191121.49敏感性分析表附表11序号分析指标变化幅度(%)季度财务内部收益率(%)变化率(%)季度财务收益净现值(万元)变化率(%)开发建设投资销售收入0基本 方案 气瓶 现场处置方案 .pdf气瓶 现场处置方案 .doc见习基地管理方案.doc关于群访事件的化解方案建筑工地扬尘治理专项方案下载 6.85%5831.561第一方案8.00%1.80%-73.76%-85.75-101.47%2第二方案10.00%-0.07%-101.02%-1565.08-126.84%3第三方案5.00%8.89%29.80%10098.8273.18%4第四方案-10.00%-2.30%-133.61%-2702.98-146.35%5第五方案4.00%-4.00%1.23%-82.06%-540.91-109.28%注:财务指标均为所得税前。全部投资现金流量表单位:万元附表9序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1现金流入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.531.1销售收入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.532现金流出110696.766207.68809.431237.34901.641758.416571.1126638.9922599.4221990.4912447.209535.052.1开发建设投资99659.476207.68809.431237.34901.641758.416571.1126148.7321589.4017460.188808.928166.632.2经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.3土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.4企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.803净现金流量1928.62-6207.68-809.43-1237.34-901.64-1758.41-6571.11-21636.34-12293.1624237.1924678.064428.484累计净现金流量-177321.69-6207.68-7017.11-8254.45-9156.09-10914.50-17485.62-39121.95-51415.11-27177.93-2499.861928.625所得税前净现金流量5645.25-6207.68-809.43-1237.34-901.64-1758.41-6571.11-21471.25-11953.0525762.7025903.204889.276所得税前累计净现金流量-167648.23-6207.68-7017.11-8254.45-9156.09-10914.50-17485.62-38956.87-50909.92-25147.22755.985645.25计算指标所得税后所得税前FIRR(季度)-0.99%1.80%FNPV(季度I=3%)-2902.15-85.75税后折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.050.950.910.860.820.780.750.710.680.640.610.580.060.940.890.840.790.750.700.670.630.590.560.53FNPV(季度I=3%)-2902.15-6026.88-762.96-1132.34-801.09-1516.82-5503.20-17592.32-9704.3318575.7918362.803199.23FNPV(季度I=5%)-5072.22-5912.08-734.17-1068.86-741.78-1377.76-4903.46-15376.54-8320.4915623.5115150.192589.24FNPV(季度I=6%)-5919.49-5856.31-720.39-1038.90-714.18-1313.99-4632.37-14389.40-7712.8814345.9513780.102332.87税前折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.060.940.890.840.790.750.700.670.630.590.560.530.070.930.870.820.760.710.670.620.580.540.510.48FNPV(季度I=3%)-85.75-6026.88-762.96-1132.34-801.09-1516.82-5503.20-17458.09-9435.8519744.9619274.413532.12FNPV(季度I=6%)-3766.51-5856.31-720.39-1038.90-714.18-1313.99-4632.37-14279.61-7499.4915248.9014464.212575.61FNPV(季度I=7%)-4662.86-5801.57-706.98-1010.04-687.86-1253.73-4378.61-13371.22-6956.7914013.2013167.872322.86全部投资现金流量表单位:万元附表9序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1现金流入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.531.1销售收入112625.370.000.000.000.000.000.005002.6510306.2646227.6837125.2613963.532现金流出112542.306322.64824.421260.25918.341790.986692.8027123.2222999.2222313.8312610.339686.282.1开发建设投资101505.026322.64824.421260.25918.341790.986692.8026632.9621989.2117783.518972.058317.862.2经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.3土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.4企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.803净现金流量83.07-6322.64-824.42-1260.25-918.34-1790.98-6692.80-22120.57-12692.9623913.8524514.934277.244累计净现金流量-185501.88-6322.64-7147.06-8407.31-9325.65-11116.62-17809.42-39930.00-52622.96-28709.11-4194.1783.075所得税前净现金流量3799.71-6322.64-824.42-1260.25-918.34-1790.98-6692.80-21955.49-12352.8625439.3625740.074738.046所得税前累计净现金流量-175828.41-6322.64-7147.06-8407.31-9325.65-11116.62-17809.42-39764.91-52117.77-26678.40-938.333799.71计算指标所得税后所得税前FIRR(季度)-3.34%-0.07%FNPV(季度I=3%)-4381.48-1565.08税后折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.050.950.910.860.820.780.750.710.680.640.610.580.060.940.890.840.790.750.700.670.630.590.560.53FNPV(季度I=3%)-4381.48-6138.49-777.09-1153.31-815.93-1544.91-5605.11-17986.05-10019.9418327.9818241.413089.97FNPV(季度I=5%)-6356.89-6021.56-747.77-1088.66-755.52-1403.28-4994.27-15720.68-8591.1015415.0815050.042500.82FNPV(季度I=6%)-7118.89-5964.76-733.73-1058.13-727.41-1338.32-4718.16-14711.44-7963.7214154.5713689.012253.20税前折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.060.940.890.840.790.750.700.670.630.590.560.530.070.930.870.820.760.710.670.620.580.540.510.48FNPV(季度I=3%)-1565.08-6138.49-777.09-1153.31-815.93-1544.91-5605.11-17851.82-9751.4619497.1519153.033422.86FNPV(季度I=6%)-4965.91-5964.76-733.73-1058.13-727.41-1338.32-4718.16-14601.65-7750.3415057.5214373.122495.94FNPV(季度I=7%)-5784.03-5909.01-720.08-1028.74-700.59-1276.94-4459.69-13672.77-7189.4813837.3313084.952251.01全部投资现金流量表单位:万元附表9序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1现金流入118256.640.000.000.000.000.000.005252.7810821.5748539.0638981.5214661.711.1销售收入118256.640.000.000.000.000.000.005252.7810821.5748539.0638981.5214661.712现金流出103314.575747.86749.471145.69834.851628.166084.3624702.0421000.2020697.1411794.688930.122.1开发建设投资92277.295747.86749.471145.69834.851628.166084.3624211.7819990.1916166.838156.417561.692.2经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.3土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.4企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.803净现金流量14942.07-5747.86-749.47-1145.69-834.85-1628.16-6084.36-19449.26-10178.6327841.9227186.845731.594累计净现金流量-129944.20-5747.86-6497.32-7643.01-8477.86-10106.02-16190.38-35639.65-45818.28-17976.369210.4814942.075所得税前净现金流量18658.70-5747.86-749.47-1145.69-834.85-1628.16-6084.36-19284.18-9838.5329367.4328411.976192.396所得税前累计净现金流量-120270.73-5747.86-6497.32-7643.01-8477.86-10106.02-16190.38-35474.56-45313.08-15945.6512466.3218658.70计算指标所得税后所得税前FIRR(季度)7.44%8.89%FNPV(季度I=3%)7282.4310098.82税后折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.050.950.910.860.820.780.750.710.680.640.610.580.060.940.890.840.790.750.700.670.630.590.560.53FNPV(季度I=3%)7282.43-5580.44-706.45-1048.46-741.75-1404.47-5095.56-15814.03-8035.1121338.5120229.564140.62FNPV(季度I=5%)3630.71-5474.15-679.79-989.69-686.83-1275.71-4540.24-13822.23-6889.3017947.1516690.363351.14FNPV(季度I=6%)2140.19-5422.51-667.03-961.94-661.28-1216.66-4289.23-12934.87-6386.2016479.5915180.993019.33税前折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.060.940.890.840.790.750.700.670.630.590.560.530.070.930.870.820.760.710.670.620.580.540.510.48FNPV(季度I=3%)10098.82-5580.44-706.45-1048.46-741.75-1404.47-5095.56-15679.80-7766.6222507.6921141.184473.51FNPV(季度I=6%)4293.17-5422.51-667.03-961.94-661.28-1216.66-4289.23-12825.08-6172.8117382.5415865.103262.07FNPV(季度I=7%)2810.08-5371.83-654.62-935.22-636.90-1160.86-4054.27-12009.22-5726.1115973.9414443.212941.96全部投资现金流量表单位:万元附表9序号项目合计2006年2007年2008年2009年第四季度第一季度第二季度第三季度第四季度第一季度第二季度第三季度第四季度第一季度第二季度1现金流入101362.840.000.000.000.000.000.004502.389275.6341604.9133412.7312567.181.1销售收入101362.840.000.000.000.000.000.004502.389275.6341604.9133412.7312567.182现金流出103314.575747.86749.471145.69834.851628.166084.3624702.0421000.2020697.1411794.688930.122.1开发建设投资92277.295747.86749.471145.69834.851628.166084.3624211.7819990.1916166.838156.417561.692.2经营税金及附加6194.400.000.000.000.000.000.00275.15566.842542.522041.89767.992.3土地增值税1126.250.000.000.000.000.000.0050.03103.06462.28371.25139.642.4企业所得税3716.640.000.000.000.000.000.00165.09340.111525.511225.13460.803净现金流量-1951.74-5747.86-749.47-1145.69-834.85-1628.16-6084.36-20199.66-11724.5720907.7721618.053637.064累计净现金流量-173914.50-5747.86-6497.32-7643.01-8477.86-10106.02-16190.38-36390.04-48114.61-27206.85-5588.80-1951.745所得税前净现金流量1764.90-5747.86-749.47-1145.69-834.85-1628.16-6084.36-20034.57-11384.4622433.2822843.184097.866所得税前累计净现金流量-164241.04-5747.86-6497.32-7643.01-8477.86-10106.02-16190.38-36224.96-47609.42-25176.14-2332.961764.90计算指标所得税后所得税前FIRR(季度)-7.09%-2.30%FNPV(季度I=3%)-5519.38-2702.98税后折现系数0.030.970.940.920.890.860.840.810.790.770.740.720.050.950.910.860.820.780.750.710.680.640.610.580.060.940.890.840.790.750.700.670.630.590.560.53FNPV(季度I=3%)-5519.38-5580.44-706.45-1048.46-741.75-1404.47-5095.56-16424.17-9255.4816024.0616085.862627.49FNPV(季度I=5%)-
本文档为【可行性研究财务评价计算表】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
下载需要: ¥16.9 已有0 人下载
最新资料
资料动态
专题动态
个人认证用户
慢慢老师
暂无简介~
格式:xls
大小:167KB
软件:Excel
页数:0
分类:
上传时间:2021-09-05
浏览量:186