污水工程投资估算表(excel)表格文件下载.xls

污水工程投资估算表(excel)表格文件下载.xls

《污水工程投资估算表(excel)表格文件下载.xls》由会员分享，可在线阅读，更多相关《污水工程投资估算表(excel)表格文件下载.xls（87页珍藏版）》请在冰点文库上搜索。

污水厂：

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.00711.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.80污泥回流泵房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建筑工程名称：

万元，2003年价）技术经济指标备注建筑安装工程设备与工器具购置其他费用合计单位数量指标（元）（占总投资）12345678910综合楼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建设单位管理费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.34工程费用0.50%2.14联合试运转费8.568.56设备购置1%2.15环境评价费10.5010.50估列污污水水处处理理厂厂工工程程投投资资估估算算表表续续附附表表3建筑工程名称：

万元，2003年价）技术经济指标备注建筑安装工程设备与工器具购置其他费用合计单位数量指标（元）（占总投资）123456789102.16水土保持评价费8.608.60估列2.17各类评审费12.0012.00估列第一，二部分费用合计1387.98855.55517.062760.5985.29%预备费276.06276.068.53%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%污污水水处处理理厂厂投投资资使使用用计计划划和和资资金金筹筹措措表表单位：

万元人民币序号项目年份合计建设期投产期1231建设项目总投资3317.211498.001693.7399.131.1固定投资3036.651450.001586.651.2建设期利息155.0848.00107.081.3流动资金125.4899.131.4固定资产投资方向调节税0.002资金筹措3317.211498.001693.7399.132.1自有资金（资本金）1337.64650.00650.0037.642.1.1其中：

固定投资1300.00650.00650.002.1.2铺底流动资金37.6437.642.2银行借款1979.57848.001043.7361.492.2.1固定投资借款1736.65800.00936.652.2.2建设期利息155.0848.00107.082.2.3流动资金借款87.8461.49附附表表444513.1813.1813.1813.1813.1813.1813.1813.1813.1813.18单位：

万元人民币投产期总总成成本本费费用用估估算算表表单位：

万元人民币项目年份平均投产营运期345678生产负荷（%）80%90%100%100%100%100%年折旧额139.69125.72125.72125.72125.72125.72125.72大修理基金72.8872.8872.8872.8872.8872.8872.88电费200.00163.27183.67204.08204.08204.08204.08药剂费37.6530.7334.5838.4238.4238.4238.42工资福利费72.0072.0072.0072.0072.0072.0072.00维修费30.3730.3730.3730.3730.3730.3730.37摊销费36.9836.9836.9836.9836.9836.9836.98财务费用3.983.253.664.064.064.064.06其中：

流动资金利息支出3.983.253.664.064.064.064.06管理费用及其他89.0389.0389.0389.0389.0389.0389.03年总成本（万元/年）686.55627.47652.53677.60677.60677.60677.60其中：

固定成本444.92430.22430.63431.04431.04431.04431.04可变成本241.63197.25221.91246.56246.56246.56246.56单位处理水量成本（元/m3）0.670.770.710.660.660.660.66年经营成本（万元/年）501.93458.28482.53506.78506.78506.78506.78单位处理水量经营成本（元/m3）0.500.560.520.500.500.500.50年运行成本（万元/年）429.05385.40409.65433.90433.90433.90433.90单位处理水量运行成本（元/m3）0.430.470.450.420.420.420.42污水处理收费预测（元/m3）0.850.850.850.850.850.850.85附附表表55总总成成本本费费用用估估算算表表单位：

万元人民币项目投产营运期91011121314100%100%生产负荷（%）100%100%100%100%125.72125.72年折旧额125.72125.72125.72125.7272.8872.88大修理基金72.8872.8872.8872.88204.08204.08电费204.08204.08204.08204.0838.4238.42药剂费38.4238.4238.4238.4272.0072.00工资福利费72.0072.0072.0072.0030.3730.37维修费30.3730.3730.3730.3736.9836.98摊销费36.9836.9836.9836.984.064.06财务费用4.064.064.064.064.064.06其中：

流动资金利息支出4.064.064.064.0689.0389.03管理费用及其他89.0389.0389.0389.03677.60677.60年总成本（万元/年）677.60677.60677.60677.60431.04431.04其中：

固定成本431.04431.04431.04431.04246.56246.56可变成本246.56246.56246.56246.560.660.66单位处理水量成本（元/m3）0.660.660.660.66506.78506.78年经营成本（万元/年）506.78506.78506.78506.780.500.50单位处理水量经营成本（元/m3）0.500.500.500.50433.90433.90年运行成本（万元/年）433.90433.90433.90433.900.420.42单位处理水量运行成本（元/m3）0.420.420.420.420.850.85污水处理收费预测（元/m3）0.850.850.850.85续续附附表表55151617合计100%100%100%100%125.72125.72125.721885.7672.8872.8872.881093.19204.08204.08204.083000.0038.4238.4238.42564.7572.0072.0072.001080.0030.3730.3730.37455.5036.9836.9836.98554.694.064.064.0659.704.064.064.0659.7089.0389.0389.031335.47677.60677.60677.6010088.76431.04431.04431.046464.31246.56246.56246.563624.450.660.660.66506.78506.78506.787528.910.500.500.50433.90433.90433.906435.720.420.420.420.850.850.85单位：

万元人民币损损益益表表单位：

万元人民币序号项目年份合计投产营运期3456生产负荷（%）80%90%100%100%1产品销售（营业）收入12769.89694.96781.83868.70868.702销售税金及附加（）842.8145.8751.6057.3357.333总成本费用10088.76627.47652.53677.60677.604长期借款利息支出908.03113.50105.9498.3790.805利润总额930.29-91.88-28.2435.4042.976弥补前年亏损338.4991.88120.1384.737应纳税所得额591.79-91.88-120.13-84.73-41.768所得税（）306.990.000.000.000.009税后利润623.29-91.88-28.2435.4042.9710特种资金（）0.000.000.000.000.0011可供分配利润623.29-91.88-28.2435.4042.9711.1盈余公积金，公益金（）99.760.000.000.000.0011.2应付利润（11*10%）93.030.000.000.000.0011.3未分配利润430.51-91.88-28.2435.4042.9712累计未分配利润-91.88-120.13-84.73-41.76附附表表66序号项目7891011100%100%100%生产负荷（%）100%100%868.70868.70868.701产品销售（营业）收入868.70868.7057.3357.3357.332销售税金及附加（）57.3357.33677.60677.60677.603总成本费用677.60677.6083.2475.6768.104长期借款利息支出60.5452.9750.5358.1065.675利润总额73.2380.8041.760.000.006弥补前年亏损0.000.008.7758.1065.677应纳税所得额73.2380.802.9019.1721.678所得税（）24.1726.6647.6438.9344.009税后利润49.0754.140.000.000.0010特种资金（）0.000.0047.6438.9344.0011可供分配利润49.0754.147.155.846.6011.1盈余公积金，公益金（）7.368.120.885.816.5711.2应付利润（11*10%）7.328.0839.6127.2830.8311.3未分配利润34.3837.94-2.1425.1355.9612累计未分配利润90.35128.28投产营运期损损益益表表单位：

万元人民币续续附附表表66投产营运期121314151617100%100%100%100%100%100%868.70868.70868.70868.70868.70868.7057.3357.3357.3357.3357.3357.33677.60677.60677.60677.60677.60677.6045.4037.8330.2722.7015.137.5788.3795.93103.50111.07118.64126.200.000.000.000.000.000.0088.3795.93103.50111.07118.64126.2029.1631.6634.1636.6539.1541.6559.2164.2869.3574.4279.4984.560.000.000.000.000.000.0059.2164.2869.3574.4279.4984.568.889.6410.4011.1611.9212.688.849.5910.3511.1111.8612.6241.4945.0448.5952.1555.7059.25169.77214.81263.41315.55371.25430.51现现金金流流量量表表（全全部部投投资资）单位：

万元人民币附附表表序号项目年序合计建设期投产营运期12345生产负荷（%）80%90%100%1现金流入14046.26694.96781.83868.701.1营业（产品销售）收入12769.89694.96781.83868.701.2回收固定资产余值1150.891.3回收流动资金125.482现金流出11840.851450.001586.65603.28547.30577.292.1固定投资3036.651450.001586.652.2固定投资方向调节税0.002.3流动资金125.4899.1313.1813.182.4经营费用7528.91458.28482.53506.782.5销售税金及附加842.8145.8751.6057.332.6所得税306.992.7特种基金0.003所得税后净现金流量2205.41-1450.00-1586.6591.68234.53291.414所得税后累积净现金流量-18053.49-1450.00-3036.65-2944.96-2710.44-2419.035所得税前净现金流量（3+2.6+2.7）2512.41-1450.00-1586.6591.68234.53291.416所得税前累计净现金流量-16555.11-1450.00-3036.65-2944.96-2710.44-2419.03计算指标：

所得税后所得税前财务内部收益率FIRR=财务净现值ic=%投资回收期（从建设期算起）现现金金流流量量表表（全全部部投投资资）序号项目投产营运期67891011100%100%100%生产负荷（%）100%100%100%868.70868.70868.701现金流入868.70868.70868.70868.70868.70868.701.1营业（产品销售）收入868.70868.70868.701.2回收固定资产余值1.3回收流动资金564.11567.01583.282现金流出585.78588.28590.782.1固定投资2.2固定投资方向调节税2.3流动资金506.78506.78506.782.4经营费用506.78506.78506.7857.3357.3357.332.5销售税金及附加57.3357.3357.332.9019.172.6所得税21.6724.1726.662.7特种基金304.59301.69285.423所得税后净现金流量282.92280.42277.92-2114.44-1812.74-1527.334所得税后累积净现金流量-1244.41-963.99-686.06304.59304.59304.595所得税前净现金流量（3+2.6+2.7）304.59304.59304.59-2114.44-1809.85-1505.266所得税前累计净现金流量-1200.67-896.08-591.49投产营运期单位：

万元人民币续续附附表表121314151617100%100%100%100%100%100%868.70868.70868.70868.70868.702145.07868.70868.70868.70868.70868.70868.701150.89125.48593.27595.77598.27600.76603.26605.76506.78506.78506.78506.78506.78506.7857.3357.3357.3357.3357.3357.3329.1631.6634.1636.6539.1541.65275.43272.93270.43267.94265.441539.31-410.64-137.71132.73400.66666.102205.41304.59304.59304.59304.59304.591580.96-286.9117.68322.27626.86931.452512.41现现金金流流量量表表（全全部部投投资资）投产营运期现现金金流流量量表表（自自有有资资金金）单位：

万元人民币序号项目年序合计建设期投产营运期12345生产负荷（%）80%90%100%1现金流入14046.26694.96781.83868.701.1营业（产品销售）收入12769.89694.96781.83868.701.2回收固定资产余值1150.891.3回收流动资金125.482现金流出12778.47650.00650.00743.76766.18788.602.1自有资金1300.00650.00650.002.2借款本金偿还1891.73126.12126.12126.122.3借款利息偿还908.03113.50105.9498.372.4经营费用7528.91458.28482.53506.782.5销售税金及附加842.8145.8751.6057.332.6所得税306.992.7特种基金0.003所得税后净现金流量1267.79-650.00-650.00-48.8015.6580.104所得税后累积净现金流量-12141.20-650.00-1300.00-1348.80-1333.15-1253.055所得税前净现金流量（3+2.6）1574.78-650.00-650.00-48.8015.6580.106所得税前累计净现金流量-10642.82-650.00-1300.00-1348.80-1333.15-1253.05计算指标：

所得税后所得税前财务内部收益率FIRR=财务净现值ic=4%投资回收期（从建设期算起）附附表表88现现金金流流量量表表（自自有有资资金金）序号项目投产营运期67891011100%100%100%生产负荷（%）100%100%100%868.70868.70868.701现金流入868.70868.70868.70868.70868.70868.701.1营业（产品销售）收入868.70868.70868.701.2回收固定资产余值1.3回收流动资金781.03776.36785.072现金流出780.00774.93769.862.1自有资金126.12126.12126.122.2借款本金偿还126.12126.12126.1290.8083.2475.672.3借款利息偿还68.1060.5452.97506.78506.78506.782.4经营费用506.78506.78506.7857.3357.3357.332.5销售税金及附加57.3357.3357.332.9019.172.6所得税21.6724.1726.662.7特种基金87.6792.3483.633所得税后净现金流量88.7093.7798.84-1165.38-1073.04-989.414所得税后累积净现金流量-900.71-806.94-708.0987.6795.24102.805所得税前净现金流量（3+2.6）110.37117.94125.50-1165.38-1070.14-967.346所得税前累计净现金流量-856.97-739.03-613.52投产营运期单位：

万元人民币续续附附表表88121314151617100%100%100%100%100%100%868.70868.70868.70868.70868.702145.07868.70868.70868.70868.70868.70868.701150.89125.48764.79759.72754.65749.58744.51739.44126.12126.12126.12126.12126.12126.1245.4037.8330.2722.7015.137.57506.78506.78506.78506.78506.78506.7857.3357.3357.3357.3357.3357.3329.1631.6634.1636.6539.1541.65103.91108.98114.05119.12124.191405.63-604.18-495.20-381.15-262.03-137.841267.79133.07140.64148.21155.77163.341447.28-480.45-339.81-191.61-35.84127.501574.78现现金金流流量量表表（自自有有资资金金）投产营运期资资金金来来源源及及应应用用表表单位：

万元人民币序号项目年序合计建设期投产营运期12345生产负荷（%）80%90%100%1资金来源8301.221660.701856.43169.94147.63211.271.1利润总额930.29-91.88-28.2435.401.2折旧费2137.19125.72125.72125.72125.72125.721.3摊销费640.1636.9836.9836.9836.9836.981.4长期贷款（包