某桥绿水堰效益分析.xls

年份建设期合计项目12345303132100376.89376.89376.89…376.89376.89382.1311311.941.1灌溉效益00376.89376.89376.89…376.89376.89376.8911306.71.2回收固定资产余值01.3回收流动资金5.245.2421131.441021.8352.3952.3952.39…52.3952.3952.393724.972.1本次投资1100995.632095.632.2年运行费用26.226.252.3952.3952.39…52.3952.3952.391624.12.3流动资金5.245.243-1131.44 -1021.83324.5324.5324.5…324.5324.5329.747586.974累计增量净效益流量-1131.44 -2153.27 -1828.77 -1504.27 -1179.77…6932.737257.237586.97表9-4 国民经济评价效益费用流量表序号运 行 期增量效益流量B增量费用流量C增量净效益流量（B-C）年份项目1234567891011121314151610#REF!#REF!#REF!#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!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回收流动资金2691.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-691.89#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!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 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!#REF!#REF!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.217629国 民 经 济 效 益 费 用 流 量序号建设期（4年）增量效益流量B增量费用流量C增量净效益流量（B-C）指标系数ic=12%指标系数ic=10%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.5949731.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!#REF!#REF!#REF!-628.991#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0.851426 0.7249265 0.617221 0.5255180.447440.380962 0.3243610.276170.235138 0.200203 0.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!#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.93279 38.33285 34.22576 30.55871 27.28456 24.36122 21.75109 19.42061 17.33983EBCR=#REF!指标系数ic=17.5%171819202122……232425262728293031323334#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!#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.3……106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.3106.36407.86……2995.63106.3106.3106.3106.3106.3106.3……106.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!#REF!#REF!#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 37.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!0.197845 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.039143效 益 费 用 流 量 表运 行 期（31年）5.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!#...