污水工程投资估算表(excel)

1、更多免费计算工具请下载水业导航客户端：点击下载污污水水处处理理厂厂工工程程投投资资估估算算表表附附表表3 建筑工程名称：污水厂：Q=2.8万m3/d ; 序 号工程及费用名称工程估算费用（人民币：万元，2003年价）技术经济指标备注建筑安装工程设备与工器具购置其他费用合计单位数量指标（元）（占总投资）12345678910工程费用1387.98855.5524.002267.53m3/d28000.00798.1370.06%1.1污水处理厂1387.98855.5524.002267.53m3/d28000.00798.1370.06%1.1.1污水处理构筑物471.35240.420.00

2、711.7721.99%粗格栅 井15.5639.6855.24细格栅井16.2340.0356.26曝气沉砂池35.7135.71初沉池126.8770.03196.90曝气池90.2019.87110.07二沉池155.7670.81226.57接触池31.0231.021.1.2污泥处理构筑物258.90158.650.00417.5512.90%浓缩池12.116.9819.09消化池229.5624.21253.77机械脱水机房17.23127.46144.691.1.3主要辅助构筑物189.86212.980.00402.8412.45%污水提升泵房145.6071.20216.8

3、0污泥回流泵房12.7618.9831.74剩余污泥泵房14.5668.1082.66鼓风机房8.548.54加药间1.9530.5032.45变配电间6.4524.2030.651.1.4其他建筑物133.7636.4024.00194.166.00%传达室3.203.20仓库8.508.50机修间17.3635.4052.76污污水水处处理理厂厂工工程程投投资资估估算算表表续续附附表表3 建筑工程名称：污水厂：Q=2.8万m3/d ; 序 号工程及费用名称工程估算费用（人民币：万元，2003年价）技术经济指标备注建筑安装工程设备与工器具购置其他费用合计单位数量指标（元）（占总投资）1234

4、5678910综合楼80.0080.00食堂,浴室,锅炉房20.7020.70车库4.001.0024.0029.001.1.5自控,化验,仪表26.50139.60166.105.13%1.1.6污水处理厂平面222.3412.50234.847.26%1.1.7厂内三通一平12.0012.000.37%1.1.8厂内绿化36.8736.871.14%1.1.9设备备件55.0055.001.70%1.1.10厂内管渠36.4036.401.12%工程建设其他费用0.000.00493.06493.0615.23%2.1征地费235.00235.00ha3.71633423.182.2建设单

5、位管理费29.4829.48工程费用1.30%2.3工程监理费39.0039.00工程费用1.72%2.4工程质检费5.675.67工程费用0.25%2.5生产人员培训费10.3710.37人月定员36%8006月2.6办公及生活家具购置费6.006.00人6010002.7设计费49.8949.89工程费用2.20%2.8施工图预算审查费2.492.49设计费5%2.9施工图预算编制费4.994.99设计费10%2.10竣工图编制费2.492.49设计费5%2.11勘察费45.3545.35工程费用2%2.12招投标管理费11.3411.34工程费用0.50%2.13工程保险费11.3411

6、.34工程费用0.50%2.14联合试运转费8.568.56设备购置1%2.15环境评价费10.5010.50估列污污水水处处理理厂厂工工程程投投资资估估算算表表续续附附表表3 建筑工程名称：污水厂：Q=2.8万m3/d ; 序 号工程及费用名称工程估算费用（人民币：万元，2003年价）技术经济指标备注建筑安装工程设备与工器具购置其他费用合计单位数量指标（元）（占总投资）123456789102.16水土保持评价费8.608.60估列2.17各类评审费12.0012.00估列第一，二部分费用合计1387.98855.55517.062760.5985.29%预备费276.06276.068.5

7、3%3.1其中：工程因素276.06276.068.53%3.2价格因素0.000.000.00%固定资产投资方向调节税0.000.000.00%建设期贷款利息155.08155.084.79%铺底流动资金44.8444.841.39%0.00%建设工程总投资1387.98855.55993.043236.57m3/d28000.001143.16100.00%占总投资的百分比42.88%26.43%30.68%100.00%更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客

8、户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载更多免费计算工具请下载水业导航客户端：点击下载 污污水水处处理理厂厂投投资资使使用用计计划划和和资资金金筹筹措措表表单位：万元人民币序号项目 年份合计 建设期投产期1234

9、1建设项目总投资3317.211498.001693.7399.1313.181.1固定投资3036.651450.001586.651.2建设期利息155.0848.00107.081.3流动资金125.4899.1313.181.4固定资产投资方向调节税0.002资金筹措3317.211498.001693.7399.1313.182.1自有资金（资本金）1337.64650.00650.0037.642.1.1其中：固定投资1300.00650.00650.002.1.2铺底流动资金37.6437.642.2银行借款1979.57848.001043.7361.4913.182.2.1固

10、定投资借款1736.65800.00936.652.2.2建设期利息155.0848.00107.082.2.3流动资金借款87.8461.4913.18附附表表4 4513.1813.1813.1813.1813.18投产期总总成成本本费费用用估估算算表表单位：万元人民币附附表表5 5项目年份平均投产营运期3456789生产负荷（%）80%90%100%100%100%100%100%年折旧额139.69125.72125.72125.72125.72125.72125.72125.72大修理基金72.8872.8872.8872.8872.8872.8872.8872.88电费200.00

11、163.27183.67204.08204.08204.08204.08204.08药剂费37.6530.7334.5838.4238.4238.4238.4238.42工资福利费72.0072.0072.0072.0072.0072.0072.0072.00维修费30.3730.3730.3730.3730.3730.3730.3730.37摊销费36.9836.9836.9836.9836.9836.9836.9836.98财务费用3.983.253.664.064.064.064.064.06其中：流动资金利息支出3.983.253.664.064.064.064.064.06管理费用及

12、其他89.0389.0389.0389.0389.0389.0389.0389.03年总成本（万元/年）686.55627.47652.53677.60677.60677.60677.60677.60其中：固定成本444.92430.22430.63431.04431.04431.04431.04431.04可变成本241.63197.25221.91246.56246.56246.56246.56246.56单位处理水量成本（元/m3）0.670.770.710.660.660.660.660.66年经营成本（万元/年）501.93458.28482.53506.78506.78506.78

13、506.78506.78单位处理水量经营成本（元/m3）0.500.560.520.500.500.500.500.50年运行成本（万元/年）429.05385.40409.65433.90433.90433.90433.90433.90单位处理水量运行成本（元/m3）0.430.470.450.420.420.420.420.42污水处理收费预测（元/m3）0.850.850.850.850.850.850.850.85总总成成本本费费用用估估算算表表单位：万元人民币项目投产营运期10111213141516100%生产负荷（%）100%100%100%100%100%100%125.72年

14、折旧额125.72125.72125.72125.72125.72125.7272.88大修理基金72.8872.8872.8872.8872.8872.88204.08电费204.08204.08204.08204.08204.08204.0838.42药剂费38.4238.4238.4238.4238.4238.4272.00工资福利费72.0072.0072.0072.0072.0072.0030.37维修费30.3730.3730.3730.3730.3730.3736.98摊销费36.9836.9836.9836.9836.9836.984.06财务费用4.064.064.064.0

15、64.064.064.06其中：流动资金利息支出4.064.064.064.064.064.0689.03管理费用及其他89.0389.0389.0389.0389.0389.03677.60年总成本（万元/年）677.60677.60677.60677.60677.60677.60431.04其中：固定成本431.04431.04431.04431.04431.04431.04246.56可变成本246.56246.56246.56246.56246.56246.560.66单位处理水量成本（元/m3）0.660.660.660.660.660.66506.78年经营成本（万元/年）506.

16、78506.78506.78506.78506.78506.780.50单位处理水量经营成本（元/m3）0.500.500.500.500.500.50433.90年运行成本（万元/年）433.90433.90433.90433.90433.90433.900.42单位处理水量运行成本（元/m3）0.420.420.420.420.420.420.85污水处理收费预测（元/m3）0.850.850.850.850.850.85投产营运期续续附附表表5 517合计100%100%125.721885.7672.881093.19204.083000.0038.42564.7572.001080.

17、0030.37455.5036.98554.694.0659.704.0659.7089.031335.47677.6010088.76431.046464.31246.563624.450.66506.787528.910.50433.906435.720.420.85投产营运期损损益益表表单位：万元人民币附附表表6 6序号项目年份合计 投产营运期34567生产负荷（%）80%90%100%100%100%1产品销售（营业）收入 12769.89694.96781.83868.70868.70868.702销售税金及附加 （ ）842.8145.8751.6057.3357.3357.333

18、总成本费用10088.76627.47652.53677.60677.60677.604长期借款利息支出908.03113.50105.9498.3790.8083.245利润总额930.29-91.88-28.2435.4042.9750.536弥补前年亏损338.4991.88120.1384.7341.767应纳税所得额591.79-91.88-120.13-84.73-41.768.778所得税（）306.990.000.000.000.002.909税后利润623.29-91.88-28.2435.4042.9747.6410特种资金（）0.000.000.000.000.000.0

19、011可供分配利润623.29-91.88-28.2435.4042.9747.6411.1盈余公积金，公益金（）99.760.000.000.000.007.1511.2应付利润(11*10%)93.030.000.000.000.000.8811.3未分配利润430.51-91.88-28.2435.4042.9739.6112累计未分配利润-91.88-120.13-84.73-41.76-2.14损损益益表表序号项目 投产营运期8910111213100%100%生产负荷（%）100%100%100%100%868.70868.701产品销售（营业）收入868.70868.70868.

20、70868.7057.3357.332销售税金及附加 （ ）57.3357.3357.3357.33677.60677.603总成本费用677.60677.60677.60677.6075.6768.104长期借款利息支出60.5452.9745.4037.8358.1065.675利润总额73.2380.8088.3795.930.000.006弥补前年亏损0.000.000.000.0058.1065.677应纳税所得额73.2380.8088.3795.9319.1721.678所得税（）24.1726.6629.1631.6638.9344.009税后利润49.0754.1459.21

21、64.280.000.0010特种资金（）0.000.000.000.0038.9344.0011可供分配利润49.0754.1459.2164.285.846.6011.1盈余公积金，公益金（）7.368.128.889.645.816.5711.2应付利润(11*10%)7.328.088.849.5927.2830.8311.3未分配利润34.3837.9441.4945.0425.1355.9612累计未分配利润90.35128.28169.77214.81 投产营运期单位：万元人民币续续附附表表6 614151617100%100%100%100%868.70868.70868.70

22、868.7057.3357.3357.3357.33677.60677.60677.60677.6030.2722.7015.137.57103.50111.07118.64126.200.000.000.000.00103.50111.07118.64126.2034.1636.6539.1541.6569.3574.4279.4984.560.000.000.000.0069.3574.4279.4984.5610.4011.1611.9212.6810.3511.1111.8612.6248.5952.1555.7059.25263.41315.55371.25430.51 投产营运期现

23、现金金流流量量表表（全全部部投投资资）单位：万元人民币附附表表序号项目 年序合计建设期投产营运期123456生产负荷（%）80%90%100%100%1现金流入14046.26694.96781.83868.70868.701.1营业（产品销售）收入12769.89694.96781.83868.70868.701.2回收固定资产余值1150.891.3回收流动资金125.482现金流出11840.851450.001586.65603.28547.30577.29564.112.1固定投资3036.651450.001586.652.2固定投资方向调节税0.002.3流动资金125.4899

24、.1313.1813.182.4经营费用7528.91458.28482.53506.78506.782.5销售税金及附加842.8145.8751.6057.3357.332.6所得税306.992.7特种基金0.003所得税后净现金流量2205.41-1450.00-1586.6591.68234.53291.41304.594所得税后累积净现金流量-18053.49-1450.00-3036.65-2944.96-2710.44-2419.03-2114.445所得税前净现金流量（3+2.6+2.7）2512.41-1450.00-1586.6591.68234.53291.41304.

25、596所得税前累计净现金流量-16555.11-1450.00-3036.65-2944.96-2710.44-2419.03-2114.44计算指标：所得税后所得税前财务内部收益率FIRR=财务净现值ic=%投资回收期（从建设期算起）现现金金流流量量表表（全全部部投投资资）单位：万元人民币序号项目投产营运期78910111213100%100%生产负荷（%）100%100%100%100%100%868.70868.701现金流入868.70868.70868.70868.70868.70868.70868.701.1营业（产品销售）收入868.70868.70868.70868.70868

26、.701.2回收固定资产余值1.3回收流动资金567.01583.282现金流出585.78588.28590.78593.27595.772.1固定投资2.2固定投资方向调节税2.3流动资金506.78506.782.4经营费用506.78506.78506.78506.78506.7857.3357.332.5销售税金及附加57.3357.3357.3357.3357.332.9019.172.6所得税21.6724.1726.6629.1631.662.7特种基金301.69285.423所得税后净现金流量282.92280.42277.92275.43272.93-1812.74-15

27、27.334所得税后累积净现金流量-1244.41-963.99-686.06-410.64-137.71304.59304.595所得税前净现金流量（3+2.6+2.7）304.59304.59304.59304.59304.59-1809.85-1505.266所得税前累计净现金流量-1200.67-896.08-591.49-286.9117.68投产营运期续续附附表100%100%100%868.70868.70868.702145.07868.70868.70868.70868.701150.89125.48598.27600.76603.26605.765

28、06.78506.78506.78506.7857.3357.3357.3357.3334.1636.6539.1541.65270.43267.94265.441539.31132.73400.66666.102205.41304.59304.59304.591580.96322.27626.86931.452512.41单位：万元人民币投产营运期现现金金流流量量表表（自自有有资资金金）单位：万元人民币附附表表8 8序号项目年序合计建设期投产营运期123456生产负荷（%）80%90%100%100%1现金流入14046.26694.96781.83868.70868.701.1营业（产品销

29、售）收入12769.89694.96781.83868.70868.701.2回收固定资产余值1150.891.3回收流动资金125.482现金流出12778.47650.00650.00743.76766.18788.60781.032.1自有资金1300.00650.00650.002.2借款本金偿还1891.73126.12126.12126.12126.122.3借款利息偿还908.03113.50105.9498.3790.802.4经营费用7528.91458.28482.53506.78506.782.5销售税金及附加842.8145.8751.6057.3357.332.6所得

30、税306.992.7特种基金0.003所得税后净现金流量1267.79-650.00-650.00-48.8015.6580.1087.674所得税后累积净现金流量-12141.20-650.00-1300.00-1348.80-1333.15-1253.05-1165.385所得税前净现金流量（3+2.6）1574.78-650.00-650.00-48.8015.6580.1087.676所得税前累计净现金流量-10642.82-650.00-1300.00-1348.80-1333.15-1253.05-1165.38计算指标：所得税后所得税前财务内部收益率FIRR=财务净现值ic=4%

31、投资回收期（从建设期算起）现现金金流流量量表表（自自有有资资金金）序号项目投产营运期78910111213100%100%生产负荷（%）100%100%100%100%100%868.70868.701现金流入868.70868.70868.70868.70868.70868.70868.701.1营业（产品销售）收入868.70868.70868.70868.70868.701.2回收固定资产余值1.3回收流动资金776.36785.072现金流出780.00774.93769.86764.79759.722.1自有资金126.12126.122.2借款本金偿还126.12126.12126

32、.12126.12126.1283.2475.672.3借款利息偿还68.1060.5452.9745.4037.83506.78506.782.4经营费用506.78506.78506.78506.78506.7857.3357.332.5销售税金及附加57.3357.3357.3357.3357.332.9019.172.6所得税21.6724.1726.6629.1631.662.7特种基金92.3483.633所得税后净现金流量88.7093.7798.84103.91108.98-1073.04-989.414所得税后累积净现金流量-900.71-806.94-708.09-604.

33、18-495.2095.24102.805所得税前净现金流量（3+2.6）110.37117.94125.50133.07140.64-1070.14-967.346所得税前累计净现金流量-856.97-739.03-613.52-480.45-339.81投产营运期单位：万元人民币续续附附表表8 814151617100%100%100%100%868.70868.70868.702145.07868.70868.70868.70868.701150.89125.48754.65749.58744.51739.44126.12126.12126.12126.1230.2722.7015.13

34、7.57506.78506.78506.78506.7857.3357.3357.3357.3334.1636.6539.1541.65114.05119.12124.191405.63-381.15-262.03-137.841267.79148.21155.77163.341447.28-191.61-35.84127.501574.78投产营运期资资金金来来源源及及应应用用表表单位：万元人民币序号项目年序合计建设期投产营运期123456生产负荷（%）80%90%100%100%1资金来源8301.221660.701856.43169.94147.63211.27205.661.1利润总

35、额930.29-91.88-28.2435.4042.971.2折旧费2137.19125.72125.72125.72125.72125.72125.721.3摊销费640.1636.9836.9836.9836.9836.9836.981.4长期贷款（包括建设期利息）1891.73848.001043.731.5流动资金借款87.8461.4913.1813.181.6自有资金1337.64650.00650.0037.64其中：固定投资1300.00650.00650.00流动资金37.6437.641.7其他0.000.001.8回收固定资产余值1150.891.9回收流动资金125.482资金应用5659.151498.001693.73187.60139.29139.29126.122.1固定投资（含投资方向调节税）3036.651450.001586.652.2建设期利息155.0848.00107.082.3流动资金87.