工程项目国民经济效益费用流量计算表xls

1、*工程项目国民经济效益费用流量表 序序号号项项目目名名称称计计算算期期(年年份份,其其中中第第一一年年为为建建设设期期,第第二二年年起起为为运运行行期期) 1234567891011121314151617181920211 1增量效益流量b0.0029.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.861.1增量灌溉效益29.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.8629.862

2、9.8629.8629.8629.8629.8629.8629.861.2回收固定资产余值1.3回收流动资金0.531.4项目间接效益2增量费用流量c101.685.845.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.312.1固定资产投资(含更新改造投资)101.682.2流动资金0.532.3年运行费用5.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.315.312.4项目间接费用3 3增量净效

3、益流量(b-c)-101.6824.0224.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.5524.554 4累计增量净效益流量-101.68-77.66-53.11-28.56-4.0120.5445.0969.6494.19118.74143.29167.84192.39216.94241.49266.04290.59315.14339.69364.24388.79经经济济内内部部收收益益率率eirr12.594%； 经经济济净净现现值值enpv=6.57万万元元0

4、； 经经济济效效益益费费用用比比ebcr=1.031.0； 静静态态投投资资回回收收期期=8.39年年计计算算内内容容1、内内部部收收益益率率eirr23.723.723.723.723.723.723.723.723.723.723.723.723.723.723.723.723.723.723.723.723.7*工程项目国民经济效益费用流量表 序序号号项项目目名名称称计计算算期期(年年份份,其其中中第第一一年年为为建建设设期期,第第二二年年起起为为运运行行期期) 123456789101112131415161718192021(b-c)t*(1+eirr)-t(101.7)19.416

5、.013.010.58.56.95.54.53.62.92.41.91.51.21.00.80.70.50.40.3(b-c)t*(1+eirr)-t=0注注：调调整整内内部部收收益益率率eirr首首格格的的数数据据，当当(b-c)t*(1+eirr)-t=0时时即即可可。2、净净现现值值enpv=(b-c)t*(1+is)-t81.23社会折现率is=12%12.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.0012.00(b-c)t*(1+is)-

6、t= -101.6821.4519.5717.4715.6013.9312.4411.119.928.857.907.066.305.635.024.494.003.583.192.852.553、效效益益比比ebcr=bt*(1+is)-t /ct*(1+is)-t1.57社会折现率is=12%bt*(1+is)-t=0.0026.6623.8021.2518.9816.9415.1313.5112.0610.779.618.587.666.846.115.464.874.353.883.473.10ct*(1+is)-t=101.685.214.233.783.373.012.692.402.141.911.711.531.361.221.090.970