某桥绿水堰效益分析.xls

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年）项目123456789101112131415161增量效益流量B0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#

3、REF!#REF!#REF!#REF!1.1灌溉效益0#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!1.1.2改善灌溉增量效益0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!1.2回收固定资产余值1.3回收流动资金

4、2增量费用流量C691.89732.52838.78955.67106.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.32.3流动资金10.633增量净效益流量（B-C）-691.89#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#

5、REF!#REF!4累计增量净效益流量-691.89#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.256675 0.2291740.204620.182696 0.1631221.121.25441.404928 1.573519 1.762342 1.973823 2.210681

6、 2.475963 2.773079 3.105848 3.47855 3.895976 4.363493 4.887112 5.473566 6.1303941.121.121.121.121.121.121.121.121.121.121.121.121.121.121.121.12-617.759#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!

7、#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.239392 0.2176291.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.5949731.11.11.11.1

8、1.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!#REF!#REF!#REF!-628.991#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

9、.170458 0.145132 0.1235690.105210.0895790.076271.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.111381.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.17451.1745-589.093#REF!#REF

10、!#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!i=12%0#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.9327

11、9 38.33285 34.22576 30.55871 27.28456 24.36122 21.75109 19.42061 17.33983EBCR=#REF!171819202122232425262728293031323334#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!#

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!#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.

13、3106.3106.36407.862995.63106.3106.3106.3106.3106.3106.3106.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!#REF!#REF

14、!#REF!#REF!0.1456440.130040.116107 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.0212126.866041 7.689966 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 3

15、7.58173 42.09153 47.142521.121.121.121.121.121.121.121.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!#REF!#REF!#REF!#REF!运 行 期（31年）0.197845

16、 0.179859 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.043057 0.0391435.05447 5.559917 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.547671.11.11.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!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#