《《综合性可行性报告资料》某桥绿水堰效益分析.xls》由会员分享，可在线阅读，更多相关《《综合性可行性报告资料》某桥绿水堰效益分析.xls（13页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、表9-4 国民经济评价效益费用流量表序号年份建设期运 行 期合计项目123453031321增量效益流量B00376.89376.89376.89376.89376.89382.1311311.941.1灌溉效益00376.89376.89376.89376.89376.89376.8911306.71.2回收固定资产余值01.3回收流动资金5.245.242增量费用流量C1131.441021.8352.3952.3952.3952.3952.3952.393724.972.1本次投资1100995.632095.632.2年运行费用26.226.252.3952.3952.3952.395
2、2.3952.391624.12.3流动资金5.245.243增量净效益流量（B-C）-1131.44 -1021.83324.5324.5324.5324.5324.5329.747586.974累计增量净效益流量-1131.44 -2153.27 -1828.77 -1504.27 -1179.776932.737257.237586.97国 民 经 济 效 益 费 用 流 量 表序号年份建设期（4年）运 行 期（31年）项目1234567891011121314151617181增量效益流量B0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#R
3、EF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!1.1灌溉效益0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!1.1.1恢复灌溉增量效益0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!1.1.2改善灌溉增量效益0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#
4、REF!#REF!#REF!#REF!#REF!#REF!1.2回收固定资产余值1.3回收流动资金2增量费用流量C691.89732.52838.78955.67106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.32.1本次投资660690775870.632.2年运行费用21.2642.5263.7885.04106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.32.3流动资金10.633增量净效益流量（B-C） -69
5、1.89#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!4累计增量净效益流量-691.89#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!指标系数ic=12%0.892857 0.79719390.711780.635518 0.567427 0.506631 0.452349 0.4038830.360610.321973 0.287476 0.256
6、675 0.2291740.204620.182696 0.163122 0.1456440.130041.121.25441.404928 1.573519 1.762342 1.973823 2.210681 2.475963 2.773079 3.105848 3.47855 3.895976 4.363493 4.887112 5.473566 6.130394 6.866041 7.6899661.121.121.121.121.121.121.121.121.121.121.121.121.121.121.121.121.121.12-617.759#REF!#REF!#REF!#
7、REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!-617.759#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!指标系数ic=10%0.909091 0.8264463 0.751315 0.683013 0.620921 0.564474 0.513158 0.466507 0.424098 0.385543 0.350494 0.318631 0.289664 0.263331 0
8、.239392 0.217629 0.197845 0.1798591.11.211.3311.46411.61051 1.771561 1.948717 2.143589 2.357948 2.593742 2.853117 3.138428 3.452271 3.797498 4.177248 4.594973 5.05447 5.5599171.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.1-628.991#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#RE
9、F!#REF!#REF!#REF!#REF!-628.991#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!指标系数ic=17.5%0.851426 0.7249265 0.617221 0.5255180.447440.380962 0.3243610.276170.235138 0.200203 0.170458 0.145132 0.1235690.105210.0895790.076270.0649380.055291.17451.3794503 1.620164
10、1.902883 2.234936 2.624932 3.082983 3.620964 4.252822 4.994939 5.866556 6.89027 8.092622 9.504785 11.16337 13.11138 15.39931 18.086491.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.1745-589.093#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#
11、REF!#REF!#REF!#REF!#REF!#REF!#REF!-589.093#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!i=12%0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!617.7589 583.96046 597.027 607.3456 60.31747 53.85489 48.08472 42.93279 38.33285 3
12、4.22576 30.55871 27.28456 24.36122 21.75109 19.42061 17.33983 15.48199 13.82321EBCR=#REF!19202122232425262728293031323334#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF
13、!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!215.69215.6910.6310.63106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.36407.862995.63106.3106.3106.3106.3106
14、.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.33401.610.63#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0.116107 0.1036670.092560.0826430.073788 0.065882 0.058823 0.052521
15、 0.046894 0.041869 0.037383 0.033378 0.029802 0.026609 0.023758 0.0212128.612762 9.646293 10.80385 12.1003113.55235 15.17863 17.00006 19.04007 21.32488 23.88387 26.74993 29.95992 33.55511 37.58173 42.09153 47.142521.121.121.121.121.121.121.121.121.121.121.121.121.121.121.121.12#REF!#REF!#REF!#REF!#R
16、EF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!国 民 经 济 效 益 费 用 流 量 表运 行 期（31年）0.163508 0.148644 0.135131 0.1228460.111678 0.101526 0.092296 0.083905 0.076278 0.069343 0.063039 0.057309 0.052099 0.047362 0
17、.043057 0.0391436.1159096.72757.40025 8.1402758.954302 9.849733 10.83471 11.91818 13.10999 14.42099 15.86309 17.4494 19.19434 21.11378 23.22515 25.547671.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.1#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
18、#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0.047075 0.040081 0.034126 0.0290560.024739 0.021063 0.017934 0.015269 0.013001 0.011069 0.009425 0.008024 0.006832 0.005817 0.004953 0.00421721.24259 24.94942 29.30309 34.4164840.42216 47.47582 55.76035 65.49054 76.91864 90.34094 106.
19、1054 124.6208 146.3672 171.9082 201.9062 237.13891.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.1745#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
20、#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!12.34215 11.01978 9.839087 8.7848997.84366 7.003268 6.252917 5.582962 4.984788 4.450703 3.973842 3.548073 3.167923 2.828502 2.525448 2.254865 2950.26454#REF!国 民 经 济 效 益 费 用 流 量 表序号年份建设期运 行 期项目1234561增量效益流量
21、B00339.2339.2339.2339.21.1灌溉效益00339.2339.2339.2339.21.2回收固定资产余值1.3回收流动资金2增量费用流量C1131.921022.2353.253.253.253.22.1本次投资1100995.632.2年运行费用26.626.653.253.253.253.22.3流动资金5.323增量净效益流量（B-C）-1131.92 -1022.232862862862864累计增量净效益流量-1131.92 -2154.15 -1868.15 -1582.15 -1296.15 -1010.15指标系数ic=12%0.892857 0.7971
22、940.711780.635518 0.567427 0.5066311.121.25441.404928 1.573519 1.762342 1.9738231.121.121.121.121.121.12-1010.64 -814.915 203.5692 181.7582 162.2841 144.8965-1010.64 -1825.56 -1621.99 -1440.23 -1277.95 -1133.05指标系数ic=10%0.909091 0.826446 0.751315 0.683013 0.620921 0.5644741.11.211.3311.46411.610511.
23、7715611.11.11.11.11.11.1-1029.02 -844.818 214.876 195.3418 177.5835 161.4395-1029.02 -1873.84 -1658.96 -1463.62 -1286.03 -1124.6指标系数ic=22%0.822030.675734 0.555474 0.456616 0.375353 0.3085511.21651.479872 1.800265 2.190022 2.664162 3.2409531.21651.21651.21651.21651.21651.2165-930.473 -690.756 158.865
24、5 130.5923 107.3508 88.24566-930.473 -1621.23 -1462.36 -1331.77 -1224.42 -1136.17i=12%00241.4359 215.5677 192.4712 171.84931010.643 814.9155 37.86671 33.80956 30.18711 26.95278经济效益费用比EBCR=1.005142经济内部收益率经济净现值（ENPV） I=12%11.1446万元789101112131415339.2339.2339.2339.2339.2339.2339.2339.2339.2339.2339.23
25、39.2339.2339.2339.2339.2339.2339.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.2286286286286286286286286286-724.15-438.15-152.15133.85419.85705.85991.851277.851563.850.452349 0.4038830.360610.321973 0.287476 0.256675 0.2291740.204620.1826962.210681 2.475963 2.773079 3.10584
26、8 3.47855 3.895976 4.363493 4.887112 5.4735661.121.121.121.121.121.121.121.121.12129.3719 115.5106 103.1345 92.08435 82.21817 73.40908 65.54382 58.52127 52.25113-1003.68 -888.168 -785.034 -692.949 -610.731 -537.322 -471.778 -413.257 -361.0060.513158 0.466507 0.424098 0.385543 0.350494 0.318631 0.289
27、664 0.263331 0.2393921.948717 2.143589 2.357948 2.593742 2.853117 3.138428 3.452271 3.797498 4.1772481.11.11.11.11.11.11.11.11.1146.7632 133.4211 121.2919 110.2654 100.2413 91.12841 82.84401 75.31274 68.46613-977.832 -844.411 -723.119 -612.854 -512.613 -421.484 -338.64 -263.327 -194.8610.253639 0.20
28、8499 0.1713920.140890.115816 0.0952040.078260.064332 0.0528833.942619 4.796196 5.834572 7.097757 8.634422 10.50377 12.77784 15.54424 18.909571.21651.21651.21651.21651.21651.21651.21651.21651.216572.54062 59.63059 49.01816 40.29442 33.12324 27.22831 22.3825 18.39909 15.12462-1063.63-1004-954.985 -914
29、.69 -881.567 -854.339 -831.956 -813.557 -798.432153.4369 136.9972 122.3189 109.2133 97.51189 87.06419 77.73589 69.40704 61.9705724.06498 21.48659 19.18445 17.12898 15.29373 13.65511 12.19207 10.88577 9.719441EIRR=0.121502国 民 经 济 效 益 费 用 流 量 表运 行 期经济内部收益率161718192021222324339.2339.2339.2339.2339.2339
30、.2339.2339.2339.2339.2339.2339.2339.2339.2339.2339.2339.2339.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.253.22862862862862862862862862861849.852135.852421.852707.852993.853279.853565.853851.854137.850.163122 0.1456440.130040.116107 0.1036670.092560.082643 0.073788 0.0658826.
31、130394 6.866041 7.689966 8.612762 9.646293 10.80385 12.10031 13.55235 15.178631.121.121.121.121.121.121.121.121.1246.6528 41.65428 37.19132 33.20654 29.64869 26.47205 23.63576 21.10336 18.84228-314.353 -272.699 -235.507 -202.301 -172.652 -146.18 -122.544 -101.441 -82.59860.217629 0.197845 0.179859 0
32、.163508 0.148644 0.135131 0.122846 0.111678 0.1015264.5949735.054475.559917 6.1159096.72757.400258.140275 8.954302 9.8497331.11.11.11.11.11.11.11.11.162.24193 56.58358 51.43961 46.76329 42.51208 38.64734 35.13395 31.93995 29.03632-132.619 -76.0358 -24.5961 22.16715 64.67922 103.3266 138.4605 170.400
33、5 199.43680.043472 0.035735 0.029375 0.0241470.019850.016317 0.013413 0.011026 0.00906423.00349 27.98375 34.04223 41.41238 50.37816 61.28503 74.55323 90.69401 110.32931.21651.21651.21651.21651.21651.21651.21651.21651.216512.43289 10.22022 8.401329 6.906148 5.677064 4.666719 3.836185 3.153461 2.59224
34、1-785.999 -775.779 -767.378 -760.472 -754.795 -750.128 -746.292 -743.138 -740.54655.33087 49.40256 44.10943 39.38342 35.16377 31.39622 28.03234 25.02887 22.347218.678072 7.748279 6.918106 6.176881 5.515072 4.924171 4.396582 3.925519 3.504928运 行 期2526272829303132339.2339.2339.2339.2339.2339.2339.2344
35、.5210181.32339.2339.2339.2339.2339.2339.2339.2339.21017605.325.3253.253.253.253.253.253.253.253.23750.152095.6353.253.253.253.253.253.253.253.21649.25.32286286286286286286286291.326431.174423.854709.854995.855281.855567.855853.856139.856431.170.058823 0.052521 0.046894 0.041869 0.037383 0.033378 0.0
36、29802 0.02660917.00006 19.04007 21.32488 23.88387 26.74993 29.95992 33.55511 37.581731.121.121.121.121.121.121.121.1216.82347 15.02095 13.41156 11.97461 10.69162 9.546086 8.523291 7.7516411.1446-65.7752 -50.7542 -37.3426 -25.368 -14.6764 -5.13033 3.3929611.14460.092296 0.083905 0.076278 0.069343 0.0
37、63039 0.057309 0.052099 0.04736210.83471 11.91818 13.10999 14.42099 15.8630917.449419.19434 21.113781.11.11.11.11.11.11.11.126.39666 23.99696 21.81542 19.8322 18.02927 16.39025 14.90022 13.79763 354.5954225.8334 249.8304 271.6458 291.478 309.5073 325.8975 340.7978 354.59540.007451 0.006125 0.005035
38、0.004139 0.003402 0.002797 0.0022990.00189134.2155 163.2732 198.6219 241.6235293.935357.5719 434.9862 529.16081.21651.21651.21651.21651.21651.21651.21651.21652.130901 1.751665 1.439922 1.18366 0.973004 0.799839 0.657492 0.550532 -731.059-738.415 -736.664 -735.224 -734.04 -733.067 -732.267 -731.61 -7
39、31.05919.95287 17.81506 15.9063 14.20206 12.68041 11.32179 10.10874 9.167221 2178.3293.12942.794107 2.494738 2.227445 1.98879 1.775706 1.585451 1.415582 2167.184运 行 期国 民 经 济 效 益 费 用 流 量 表序号年份建设期运 行 期项目1234561增量效益流量B00376.89376.89376.89376.891.1灌溉效益00376.89376.89376.89376.891.2回收固定资产余值1.3回收流动资金2增量费用流
40、量C1131.441021.8352.3952.3952.3952.392.1本次投资1100995.632.2年运行费用26.226.252.3952.3952.3952.392.3流动资金5.243增量净效益流量（B-C）-1131.44 -1021.83324.5324.5324.5324.54累计增量净效益流量-1131.44 -2153.27 -1828.77 -1504.27 -1179.77 -855.27指标系数ic=12%0.892857 0.7971940.711780.635518 0.567427 0.5066311.121.25441.404928 1.573519
41、1.762342 1.9738231.121.121.121.121.121.12-1010.21 -814.597 230.9727 206.2256184.13164.4018-1010.21 -1824.81 -1593.84 -1387.61 -1203.48 -1039.08指标系数ic=10%0.909091 0.826446 0.751315 0.683013 0.620921 0.5644741.11.211.3311.46411.610511.7715611.11.11.11.11.11.1-1028.58 -844.488 243.8017 221.6379 201.489
42、 183.1718-1028.58 -1873.07 -1629.27 -1407.63 -1206.14 -1022.97指标系数ic=22%0.822030.675734 0.555474 0.456616 0.375353 0.3085511.21651.479872 1.800265 2.190022 2.664162 3.2409531.21651.21651.21651.21651.21651.2165-930.078 -690.485 180.2513 148.172 121.8019 100.1249-930.078 -1620.56 -1440.31 -1292.14 -11
43、70.34 -1070.21i=12%00268.2629 239.5204 213.8575 190.94421010.214 814.5966 37.29017 33.29479 29.72749 26.5424经济效益费用比EBCR=1.119894经济内部收益率经济净现值（ENPV） I=12%259.1193万元789101112131415376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.8952.3952.3952.39
44、52.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.39324.5324.5324.5324.5324.5324.5324.5324.5324.5-530.77-206.27118.23442.73767.231091.731416.231740.732065.230.452349 0.4038830.360610.321973 0.287476 0.256675 0.2291740.204620.1826962.210681 2.475963 2.773079 3.105848 3.47855 3.
45、895976 4.363493 4.887112 5.4735661.121.121.121.121.121.121.121.121.12146.7873 131.0601 117.018 104.480393.28683.29107 74.36702 66.39913 59.28494-892.293 -761.233 -644.215 -539.735 -446.449 -363.158 -288.791 -222.392 -163.1070.513158 0.466507 0.424098 0.385543 0.350494 0.318631 0.289664 0.263331 0.23
46、93921.948717 2.143589 2.357948 2.593742 2.853117 3.138428 3.452271 3.797498 4.1772481.11.11.11.11.11.11.11.11.1166.5198 151.3816 137.6197 125.1088 113.7353 103.3957 93.99609 85.45099 77.68272-856.449 -705.068 -567.448 -442.339 -328.604 -225.208 -131.212 -45.7612 31.921560.253639 0.208499 0.1713920.1
47、40890.115816 0.0952040.078260.064332 0.0528833.942619 4.796196 5.834572 7.097757 8.634422 10.50377 12.77784 15.54424 18.909571.21651.21651.21651.21651.21651.21651.21651.21651.216582.3057 67.65779 55.61676 45.71867 37.58214 30.89366 25.39553 20.8759 17.16062-987.908 -920.25 -864.633 -818.914 -781.332
48、 -750.439 -725.043 -704.167 -687.006170.4859 152.2195 135.9103 121.3485 108.3469 96.73828 86.37346 77.11916 68.8563923.69858 21.15944 18.89236 16.86818 15.06087 13.44721 12.00644 10.72003 9.571457EIRR=0.149795国 民 经 济 效 益 费 用 流 量 表运 行 期经济内部收益率161718192021222324376.89376.89376.89376.89376.89376.89376.
49、89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.89376.8952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.3952.39324.5324.5324.5324.5324.5324.5324.5324.5324.52389.732714.233038.733363.233687.734012.234336.734661.234985.730.163122 0.1456440.130040.116107 0
50、.1036670.092560.082643 0.073788 0.0658826.130394 6.866041 7.689966 8.612762 9.646293 10.80385 12.10031 13.55235 15.178631.121.121.121.121.121.121.121.121.1252.93298 47.26159 42.19785 37.67665 33.63987 30.03559 26.81749 23.94419 21.37874-110.174 -62.9124 -20.7145 16.96213 50.60199 80.63759 107.4551 1