污水工程投资经济评价模板.xls

基础数据表 项目名称单位数值项目名称单位数值 第一类费用万元2267污水处理量万吨/ 天3 第二类费用万元493劳动定员人24 基本预备费万元165.6人均年工资福利万元1 销售税金及附加%6.60%贷款利率%6% 贷款偿还期年10装机容量千瓦400 固定资产原值万元2925.6电费单价元/度0.52 无形及递延资产万元20大修理基金万元49.74 银行贷款万元2100能源消耗万元180.96 流动资金利率%5.84%药剂费用万元40 第一年保底水量%65%工资福利万元24 第二年保底水量%75%日常检修维护费万元29.26 第三年保底水量%85%污泥运输费(15元/吨.10km)万元13 销售水价元/吨0.80 总成本费用估算表 单位：万元 序号项目名称合计 生 产 期 34567891011121325 生产负荷（% ）65%75%85%100%100%100%100%100%100%100%100%100% 1动力费175.06117.62135.72153.82180.96180.96180.96180.96180.96180.96180.96180.96180.96 2药剂费38.7026.0030.0034.0040.0040.0040.0040.0040.0040.0040.0040.0040.00 3工资福利费24.0024.0024.0024.0024.0024.0024.0024.0024.0024.0024.0024.0024.00 4折旧费125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80 5大修理费49.7449.7449.7449.7449.7449.7449.7449.7449.7449.7449.7449.7449.74 6检修维护费29.2629.2629.2629.2629.2629.2629.2629.2629.2629.2629.2629.2629.26 7污泥运输费12.588.459.7511.0513.0013.0013.0013.0013.0013.0013.0013.0013.00 8摊销费0.872.002.002.002.002.002.002.002.002.002.000.000.00 9管理及其他45.5138.0940.4342.7746.2846.2846.2846.2846.2846.2846.2846.2846.28 10财务费用33.19129.06116.46103.8691.2678.6666.0653.4640.8628.2615.663.063.06 固定资产投资利息30.13126.00113.40100.8088.2075.6063.0050.4037.8025.2012.600.000.00 流动资金贷款利息3.063.063.063.063.063.063.063.063.063.063.063.063.06 11总成本费用534.70550.02563.15576.29602.29589.69577.09564.49551.89539.29526.69512.09512.09 11.1固定成本275.43368.31357.01345.71335.06322.46309.86297.26284.66272.06259.46244.86244.86 11.2可变成本259.27181.71206.15230.58267.24267.24267.24267.24267.24267.24267.24267.24267.24 13经营成本374.83293.15318.89344.62383.23383.23383.23383.23383.23383.23383.23383.23383.23 14单位制水成本0.490.500.510.530.550.540.530.520.500.490.480.470.47 15单位经营成本0.340.270.290.310.350.350.350.350.350.350.350.350.35 损益表 单位：万元 序号项目名称合计 生 产 期 34567891011121325 生产负荷（% ）65%75%85%100%100%100%100%100%100%100%100%100% 1销售收入19491.00569.40657.00744.60876.00876.00876.00876.00876.00876.00876.00876.00876.00 2销售税金及附加1286.4137.5843.3649.1457.8257.8257.8257.8257.8257.8257.8257.8257.82 3总成本费用12298.08550.02563.15576.29602.29589.69577.09564.49551.89539.29526.69512.09512.09 4利润总额5906.52-18.2050.49119.17215.89228.49241.09253.69266.29278.89291.49306.09306.09 5应缴所得税额5906.52-18.2050.49119.17215.89228.49241.09253.69266.29278.89291.49306.09306.09 6所得税1955.160.0016.6639.3371.2475.4079.5683.7287.8892.0396.19101.01101.01 7税后利润3951.36-18.2033.8379.84144.65153.09161.53169.97178.42186.86195.30205.08205.08 8提取的基金595.430.005.0711.9821.7022.9624.2325.5026.7628.0329.3030.7630.76 8.1其中: 盈余公积金396.960.003.387.9814.4615.3116.1517.0017.8418.6919.5320.5120.51 累计盈余公积金0.003.3811.3725.8341.1457.2974.2992.13110.82130.35150.86396.96 8.2公益金198.480.001.693.997.237.658.088.508.929.349.7710.2510.25 累计公益金0.001.695.6812.9220.5728.6537.1546.0755.4165.1775.43198.48 9未分配利润3355.93-18.2028.7567.87122.95130.13137.30144.48151.65158.83166.01174.32174.32 10累计未分配利润34494.31-18.2010.5578.42201.37331.50468.80613.28764.93923.761089.771264.093355.93 借款还本付息计算表 单位: 万元 序号项目名称合计 生 产 期 34567891011121325 利率6% 1借款及还本付息2436.002213.401990.801768.201545.601323.001100.40877.80655.20432.600.000.00 1.1年初借款本息累计2226.002003.401780.801558.201335.601113.00890.40667.80445.20222.600.000.00 1.1.1本金2100.001890.001680.001470.001260.001050.00840.00630.00420.00210.000.000.00 1.1.2建设期利息126.00113.40100.8088.2075.6063.0050.4037.8025.2012.600.000.00 1.2本年借款 1.3本年应计利息 1.4本年还本210.00210.00210.00210.00210.00210.00210.00210.00210.00210.000.000.00 1.5本年付息126.00113.40100.8088.2075.6063.0050.4037.8025.2012.600.000.00 2偿还能力109.60156.55195.67250.75257.93265.10272.28279.45286.63293.81300.12300.12 2.1利润总额-18.2028.7567.87122.95130.13137.30144.48151.65158.83166.01174.32174.32 2.2折旧125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80 2.3摊销2.002.002.002.002.002.002.002.002.002.000.000.00 2.4其他资金 3本年节余资金-2326.40-2056.85-1795.13-1517.45-1287.67-1057.90-828.12-598.35-368.57-138.79300.12300.12 4累计节余资金 现金流量表（全部投资） 单位: 万元 序号项目名称合计 建设期生 产 期 1234567891011121325 1现金流入0.000.00569.40657.00744.60876.00876.00876.00876.00876.00876.00876.00876.00930.67 1.1销售收入569.40657.00744.60876.00876.00876.00876.00876.00876.00876.00876.00876.00 1.2回收固定资产原值32.18 1.3回收流动资金22.48 2现金流出 2.1固定资产投资1494.301557.30 2.2流动资金74.95 2.3经营成本293.15318.89344.62383.23383.23383.23383.23383.23383.23383.23383.23383.23 2.4销售税金及附加37.5843.3649.1457.8257.8257.8257.8257.8257.8257.8257.8257.82 2.5所得税0.0016.6639.3371.2475.4079.5683.7287.8892.0396.19101.01101.01 3所得税前净现金流量-1494.30-1557.30163.72294.75350.83434.96434.96434.96434.96434.96434.96434.96434.96489.62 4税前累计净现金流量-1494.30-3051.60-2887.88-2593.13-2242.29-1807.34-1372.38-937.42-502.46-67.51367.45802.411237.376511.52 5所得税后净现金流量-1494.30-1557.30163.72278.09311.51363.71359.55355.40351.24347.08342.92338.76333.95388.61 6税后累计净现金流量-1494.30-3051.60-2887.88-2609.79-2298.28-1934.57-1575.01-1219.62-868.38-521.30-178.37160.39494.344556.37 财务内部收益率： 10.87%税前财务内部收益率： 8.53%税后 财务净现值(i=8%)： ￥781.04税前财务净现值(i=8%)： ￥132.86税后 投资回收期： 8.16税前投资回收期： 8.53税后 资金来源与运用表 单位:万元 序号项目名称合计 建设期生 产 期 1234567891011121325 生产负荷（% ）65%75%85%100%100%100%100%100%100%100%100%100% 1资金来源13207.781494.301557.30184.55230.75299.43396.16408.76421.36433.96446.56459.16471.76484.36591.48 1.1利润总额5906.52-18.2050.49119.17215.89228.49241.09253.69266.29278.89291.49306.09306.09 1.2折旧费2893.42125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80125.80 1.3摊销费20.002.002.002.002.002.002.002.002.002.002.000.000.00 1.4银行借款3306.631050.001050.0052.4652.4652.4652.4652.4652.4652.4652.4652.4652.4652.4652.46 1.5自有资金974.08444.30507.3022.48 1.6回收固定资产残值32.1832.18 1.7回收的流动资金74.9574.95 2资金运用7106.761494.301557.30210.00226.66249.33281.24285.40289.56293.72297.88302.03306.19101.01101.01 2.1固定资产投资2925.601462.801462.80 2.2建设期利息126.0031.5094.50 2.3流动资金0.00 2.4所得税1955.160.0016.6639.3371.2475.4079.5683.7287.8892.0396.19101.01101.01 2.5长期借款的本金偿还2100.00210.00210.00210.00210.00210.00210.00210.00210.00210.00210.000.000.00 3盈余资金6101.02-25.454.0950.11114.91123.35131.80140.24148.68157.12165.56383.35490.47 4累计的盈余资金-25.45-21.3628.75143.66267.01398.81539.04687.72844.841010.411393.756101.02 投资计划与资金筹措表 单位: 万元 序号名称 建设期生产期 合计备注 12345 1总投资1494.301557.3074.953126.55 1.1固定资产投资1462.801462.802925.60 1.2固定资产投资方向调节税0.000.00 1.3建设期利息31.5094.50126.00 1.4流动资金74.9574.95 2资金筹措1494.301557.3074.953126.55 2.1自有资金（资本金）444.30507.3022.48974.0831.16% 2.1.1其中：固定投资444.30507.30951.60 2.1.2铺底流动资金22.4822.48 2.2银行借款1050.001050.0052.462152.4668.84% 2.2.1固定投资借款1050.001050.000.002100.00 2.2.2流动资金借款0.000.0052.46 流动资金估算表 单位: 万元 序号项目名称周转次数 生 产 期 34567891011121325 生产负荷(%)65%75%85%100%100%100%100%100%100%100%100%100% 1流动资产65.2971.2077.1285.9985.9985.9985.9985.9985.9985.9985.9985.99 1.1应收帐款648.8653.1557.4463.8763.8763.8763.8763.8763.8763.8763.8763.87 1.2存货38.6710.0011.3313.3313.3313.3313.3313.3313.3313.3313.3313.33 1.2.1原材料6 1.2.2燃料8 1.2.3在产品6 1.2.4产成品7 1.2.5其他 1.3现金87.768.058.358.788.788.788.788.788.788.788.788.78 2流动负债10.2810.5010.7211.0411.0411.0411.0411.0411.0411.0411.0411.04 2.1应付帐款610.2810.5010.7211.0411.0411.0411.0411.0411.0411.0411.0411.04 3流动资金55.0060.7066.4074.9574.9574.9574.9574.9574.9574.9574.9574.95 资产负债表 单位: 万元 序号项目名称合计 建设期生 产 期 1234567891011121325 生产负荷(%)65%75%85%100%100%100%100%100%100%100% 1资产1494.303051.602857.642739.842668.062664.042659.592663.592676.032696.902726.232763.993021.536219.20 1.1流动资产总额39.8449.84105.86229.65353.00484.79625.03773.71930.831096.401479.746187.01 1.1.1应收帐款48.8653.1557.4463.8763.8763.8763.8763.8763.8763.8763.8763.87 1.1.2存货8.6710.0011.3313.3313.3313.3313.3313.3313.3313.3313.3313.33 1.1.3现金7.768.058.358.788.788.788.788.788.788.788.788.78 1.1.4累计盈余资金-25.45-21.3628.75143.66267.01398.81539.04687.72844.841010.411393.756101.02 1.2在建工程1494.303051.60 1.3固定资产净值2799.802674.002548.202422.402296.602170.802044.991919.191793.391667.591541.7932.18 1.4无形及递延资产净值18.0016.0014.0012.0010.008.006.004.002.000.000.000.00 2负债及所有者权益444.30951.603898.933710.383567.843490.213420.703359.633307.013262.823227.083199.782972.265433.25 2.1流动负债总额0.000.0062.7562.9663.1863.5063.5063.5063.5063.5063.5063.5063.5063.50 2.1.1应付帐款10.2810.5010.7211.0411.0411.0411.0411.0411.0411.0411.0411.04 2.1.2流动资金借款52.4652.4652.4652.4652.4652.4652.4652.4652.4652.4652.4652.46 2.1.3其他短期借款 2.2长期借款0.000.002436.002213.401990.801768.201545.601323.001100.40877.80655.20432.600.000.00 负债小计2436.002213.401990.801768.201545.601323.001100.40877.80655.20432.600.000.00 2.3所有者权益444.30951.601400.191434.011513.861658.501811.591973.132143.102321.522508.382703.682908.765369.75 2.3.1资本金444.30951.601418.381418.381418.381418.381418.381418.381418.381418.381418.381418.381418.381418.38 2.3.2累计盈余公积金0.003.3811.3725.8341.1457.2974.2992.13110.82130.35150.86396.96 2.3.3累计公益金0.001.695.6812.9220.5728.6537.1546.0755.4165.1775.43198.48 2.3.4累计未分配利润-18.2010.5578.42201.37331.50468.80613.28764.93923.761089.771264.093355.93 资产负债率0.300.310.850.810.750.660.580.500.410.330.240.160.000.00 流动比率0.630.791.683.625.567.639.8412.1814.6617.2623.3097.43 速动比率0.500.631.503.415.357.429.6311.9714.4517.0523.0997.22 固定资产折旧表 单位: 万元 序号项目名称合计 生 产 期 34567891011121325 折旧率4.30% 1固定资产原值2925.6