《某桥绿水堰效益分析.xls》由会员分享，可在线阅读，更多相关《某桥绿水堰效益分析.xls（13页珍藏版）》请在三一文库上搜索。
1、表9-4 国民经济评价效益费用流量表 序 号 年份建设期运 行 期 合计 项目12345303132 1增量效益流量B00376.89376.89376.89376.89376.89382.1311311.94 1.1灌溉效益00376.89376.89376.89376.89376.89376.8911306.7 1.2回收固定资产余值0 1.3回收流动资金5.245.24 2增量费用流量C1131.441021.8352.3952.3952.3952.3952.3952.393724.97 2.1本次投资1100995.632095.63 2.2年运行费用26.226.252.3952.3
2、952.3952.3952.3952.391624.1 2.3流动资金5.245.24 3增量净效益流量（B-C）-1131.44 -1021.83324.5324.5324.5324.5324.5329.747586.97 4累计增量净效益流量-1131.44 -2153.27 -1828.77 -1504.27 -1179.776932.737257.237586.97 国 民 经 济 效 益 费 用 流 量 表 序 号 年份建设期（4年）运 行 期（31年） 项目123456789101112131415161718 1增量效益流量B0#REF!#REF!#REF!#REF!#REF!#
3、REF!#REF!#REF!#REF!#REF!#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!#R
4、EF!#REF!#REF!#REF!#REF!#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.3 2.1本次投资660690775870.63 2.2年运行费用21.2642.5263.7885.04106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3
5、 2.3流动资金10.63 3增量净效益流量（B-C） -691.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.403
6、8830.360610.321973 0.287476 0.256675 0.2291740.204620.182696 0.163122 0.1456440.13004 1.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.689966 1.121.121.121.121.121.121.121.121.121.121.121.121.121.121.121
7、.121.121.12 -617.759#REF!#REF!#REF!#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
8、 0.350494 0.318631 0.289664 0.263331 0.239392 0.217629 0.197845 0.179859 1.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.559917 1.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.1 -628.991#REF!#REF!#REF!#REF!#R
9、EF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#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.07
10、6270.0649380.05529 1.17451.3794503 1.620164 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.08649 1.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.1745 -589.093#REF!
11、#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#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.34
12、56 60.31747 53.85489 48.08472 42.93279 38.33285 34.22576 30.55871 27.28456 24.36122 21.75109 19.42061 17.33983 15.48199 13.82321 EBCR=#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!#
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!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! 215.69215.69 10.6310.63 106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.
14、3106.3106.3106.3106.36407.86 2995.63 106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.33401.6 10.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.1
15、16107 0.1036670.092560.0826430.073788 0.065882 0.058823 0.052521 0.046894 0.041869 0.037383 0.033378 0.029802 0.026609 0.023758 0.021212 8.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.14252 1.121.121.121.121.12
16、1.121.121.121.121.121.121.121.121.121.121.12 #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! 国 民 经 济 效 益 费 用 流 量 表 运 行 期（31年） 0.163508 0.148644 0.135131 0.1228460.111678 0.101526 0.
17、092296 0.083905 0.076278 0.069343 0.063039 0.057309 0.052099 0.047362 0.043057 0.039143 6.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.54767 1.11.11.11.11.11.11.11.11.11.11.11.11.11.11.11.1 #REF!#REF!#REF!#REF!#REF!#
18、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.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.004217 21.24259 24.9494
19、2 29.30309 34.4164840.42216 47.47582 55.76035 65.49054 76.91864 90.34094 106.1054 124.6208 146.3672 171.9082 201.9062 237.1389 1.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!#
20、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! 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
21、 2.525448 2.254865 2950.26454 #REF! 国 民 经 济 效 益 费 用 流 量 表 序 号 年份建设期运 行 期 项目123456 1增量效益流量B00339.2339.2339.2339.2 1.1灌溉效益00339.2339.2339.2339.2 1.2回收固定资产余值 1.3回收流动资金 2增量费用流量C1131.921022.2353.253.253.253.2 2.1本次投资1100995.63 2.2年运行费用26.626.653.253.253.253.2 2.3流动资金5.32 3增量净效益流量（B-C）-1131.92 -1022.23286
22、286286286 4累计增量净效益流量-1131.92 -2154.15 -1868.15 -1582.15 -1296.15 -1010.15 指标系数ic=12%0.892857 0.7971940.711780.635518 0.567427 0.506631 1.121.25441.404928 1.573519 1.762342 1.973823 1.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 -127
23、7.95 -1133.05 指标系数ic=10%0.909091 0.826446 0.751315 0.683013 0.620921 0.564474 1.11.211.3311.46411.610511.771561 1.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.308551 1
24、.21651.479872 1.800265 2.190022 2.664162 3.240953 1.21651.21651.21651.21651.21651.2165 -930.473 -690.756 158.8655 130.5923 107.3508 88.24566 -930.473 -1621.23 -1462.36 -1331.77 -1224.42 -1136.17 i=12%00241.4359 215.5677 192.4712 171.8493 1010.643 814.9155 37.86671 33.80956 30.18711 26.95278 经济效益费用比E
25、BCR=1.005142经济内部收益率 经济净现值（ENPV） I=12%11.1446万元 789101112131415 339.2339.2339.2339.2339.2339.2339.2339.2339.2 339.2339.2339.2339.2339.2339.2339.2339.2339.2 53.253.253.253.253.253.253.253.253.2 53.253.253.253.253.253.253.253.253.2 286286286286286286286286286 -724.15-438.15-152.15133.85419.85705.85991.
26、851277.851563.85 0.452349 0.4038830.360610.321973 0.287476 0.256675 0.2291740.204620.182696 2.210681 2.475963 2.773079 3.105848 3.47855 3.895976 4.363493 4.887112 5.473566 1.121.121.121.121.121.121.121.121.12 129.3719 115.5106 103.1345 92.08435 82.21817 73.40908 65.54382 58.52127 52.25113 -1003.68 -
27、888.168 -785.034 -692.949 -610.731 -537.322 -471.778 -413.257 -361.006 0.513158 0.466507 0.424098 0.385543 0.350494 0.318631 0.289664 0.263331 0.239392 1.948717 2.143589 2.357948 2.593742 2.853117 3.138428 3.452271 3.797498 4.177248 1.11.11.11.11.11.11.11.11.1 146.7632 133.4211 121.2919 110.2654 100
28、.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.861 0.253639 0.208499 0.1713920.140890.115816 0.0952040.078260.064332 0.052883 3.942619 4.796196 5.834572 7.097757 8.634422 10.50377 12.77784 15.54424 18.90957 1.21651.21651.21651.21
29、651.21651.21651.21651.21651.2165 72.54062 59.63059 49.01816 40.29442 33.12324 27.22831 22.3825 18.39909 15.12462 -1063.63-1004-954.985 -914.69 -881.567 -854.339 -831.956 -813.557 -798.432 153.4369 136.9972 122.3189 109.2133 97.51189 87.06419 77.73589 69.40704 61.97057 24.06498 21.48659 19.18445 17.1
30、2898 15.29373 13.65511 12.19207 10.88577 9.719441 EIRR=0.121502 国 民 经 济 效 益 费 用 流 量 表 运 行 期 经济内部收益率 161718192021222324 339.2339.2339.2339.2339.2339.2339.2339.2339.2 339.2339.2339.2339.2339.2339.2339.2339.2339.2 53.253.253.253.253.253.253.253.253.2 53.253.253.253.253.253.253.253.253.2 286286286286286
31、286286286286 1849.852135.852421.852707.852993.853279.853565.853851.854137.85 0.163122 0.1456440.130040.116107 0.1036670.092560.082643 0.073788 0.065882 6.130394 6.866041 7.689966 8.612762 9.646293 10.80385 12.10031 13.55235 15.17863 1.121.121.121.121.121.121.121.121.12 46.6528 41.65428 37.19132 33.2
32、0654 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.5986 0.217629 0.197845 0.179859 0.163508 0.148644 0.135131 0.122846 0.111678 0.101526 4.5949735.054475.559917 6.1159096.72757.400258.140275 8.954302 9.849733 1.11.11.11.11.11.
33、11.11.11.1 62.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.4005 199.4368 0.043472 0.035735 0.029375 0.0241470.019850.016317 0.013413 0.011026 0.009064 23.00349 27.98375 34.04223 41.41238 50.37816 61.2
34、8503 74.55323 90.69401 110.3293 1.21651.21651.21651.21651.21651.21651.21651.21651.2165 12.43289 10.22022 8.401329 6.906148 5.677064 4.666719 3.836185 3.153461 2.592241 -785.999 -775.779 -767.378 -760.472 -754.795 -750.128 -746.292 -743.138 -740.546 55.33087 49.40256 44.10943 39.38342 35.16377 31.396
35、22 28.03234 25.02887 22.34721 8.678072 7.748279 6.918106 6.176881 5.515072 4.924171 4.396582 3.925519 3.504928 运 行 期 2526272829303132 339.2339.2339.2339.2339.2339.2339.2344.5210181.32 339.2339.2339.2339.2339.2339.2339.2339.210176 0 5.325.32 53.253.253.253.253.253.253.253.23750.15 2095.63 53.253.253.
36、253.253.253.253.253.21649.2 5.32 286286286286286286286291.326431.17 4423.854709.854995.855281.855567.855853.856139.856431.17 0.058823 0.052521 0.046894 0.041869 0.037383 0.033378 0.029802 0.026609 17.00006 19.04007 21.32488 23.88387 26.74993 29.95992 33.55511 37.58173 1.121.121.121.121.121.121.121.1
37、2 16.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.1446 0.092296 0.083905 0.076278 0.069343 0.063039 0.057309 0.052099 0.047362 10.83471 11.91818 13.10999 14.42099 15.8630917.449419.19434 21.11378 1.11.11.11.
38、11.11.11.11.1 26.39666 23.99696 21.81542 19.8322 18.02927 16.39025 14.90022 13.79763 354.5954 225.8334 249.8304 271.6458 291.478 309.5073 325.8975 340.7978 354.5954 0.007451 0.006125 0.005035 0.004139 0.003402 0.002797 0.0022990.00189 134.2155 163.2732 198.6219 241.6235293.935357.5719 434.9862 529.1
39、608 1.21651.21651.21651.21651.21651.21651.21651.2165 2.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 -731.059 19.95287 17.81506 15.9063 14.20206 12.68041 11.32179 10.10874 9.167221 2178.329 3.12942.794107 2.
40、494738 2.227445 1.98879 1.775706 1.585451 1.415582 2167.184 运 行 期 国 民 经 济 效 益 费 用 流 量 表 序 号 年份建设期运 行 期 项目123456 1增量效益流量B00376.89376.89376.89376.89 1.1灌溉效益00376.89376.89376.89376.89 1.2回收固定资产余值 1.3回收流动资金 2增量费用流量C1131.441021.8352.3952.3952.3952.39 2.1本次投资1100995.63 2.2年运行费用26.226.252.3952.3952.3952.39
41、 2.3流动资金5.24 3增量净效益流量（B-C）-1131.44 -1021.83324.5324.5324.5324.5 4累计增量净效益流量-1131.44 -2153.27 -1828.77 -1504.27 -1179.77 -855.27 指标系数ic=12%0.892857 0.7971940.711780.635518 0.567427 0.506631 1.121.25441.404928 1.573519 1.762342 1.973823 1.121.121.121.121.121.12 -1010.21 -814.597 230.9727 206.2256184.13
42、164.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.564474 1.11.211.3311.46411.610511.771561 1.11.11.11.11.11.1 -1028.58 -844.488 243.8017 221.6379 201.489 183.1718 -1028.58 -1873.07 -1629.27 -1407.63 -1206.14 -1022.97 指标系数ic=22%0.8
43、22030.675734 0.555474 0.456616 0.375353 0.308551 1.21651.479872 1.800265 2.190022 2.664162 3.240953 1.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 -1170.34 -1070.21 i=12%00268.2629 239.5204 213.8575 190.9442 1010.214 814.
44、5966 37.29017 33.29479 29.72749 26.5424 经济效益费用比EBCR=1.119894经济内部收益率 经济净现值（ENPV） I=12%259.1193万元 789101112131415 376.89376.89376.89376.89376.89376.89376.89376.89376.89 376.89376.89376.89376.89376.89376.89376.89376.89376.89 52.3952.3952.3952.3952.3952.3952.3952.3952.39 52.3952.3952.3952.3952.3952.3952
45、.3952.3952.39 324.5324.5324.5324.5324.5324.5324.5324.5324.5 -530.77-206.27118.23442.73767.231091.731416.231740.732065.23 0.452349 0.4038830.360610.321973 0.287476 0.256675 0.2291740.204620.182696 2.210681 2.475963 2.773079 3.105848 3.47855 3.895976 4.363493 4.887112 5.473566 1.121.121.121.121.121.12
46、1.121.121.12 146.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.107 0.513158 0.466507 0.424098 0.385543 0.350494 0.318631 0.289664 0.263331 0.239392 1.948717 2.143589 2.357948 2.593742 2.853117 3.13
47、8428 3.452271 3.797498 4.177248 1.11.11.11.11.11.11.11.11.1 166.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.92156 0.253639 0.208499 0.1713920.140890.115816 0.0952040.078260.064332 0.052883 3.9
48、42619 4.796196 5.834572 7.097757 8.634422 10.50377 12.77784 15.54424 18.90957 1.21651.21651.21651.21651.21651.21651.21651.21651.2165 82.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 -750.439 -725.043 -704.167 -687.006 170.4859
49、 152.2195 135.9103 121.3485 108.3469 96.73828 86.37346 77.11916 68.85639 23.69858 21.15944 18.89236 16.86818 15.06087 13.44721 12.00644 10.72003 9.571457 EIRR=0.149795 国 民 经 济 效 益 费 用 流 量 表 运 行 期 经济内部收益率 161718192021222324 376.89376.89376.89376.89376.89376.89376.89376.89376.89 376.89376.89376.89376.89376.89376.89376.89376.89376.89 52.3952.3952.3952.3952.3952.3952.3952.3952.39 52.3952.3952.3952.3952.3952.3952.3952.3952.39 324.5324.5324.5324.5324.5324.5324.5324.5324.5 2389.732714.233038.733363.233687.7340