20年国民经济评价计算表

序号项目施工期生产期年份123一增量效益流量03753751增量灌溉效益03753752增量流动资金回收3增量固定资产余值回收二增量费用流量128644.88 40.81增量固定资产投资12862增量年运行费40.840.83增量流动资金4.08三增量净效益流量-1286330.12 334.2四累计净效益流量-1286-955.88-621.68五1经济内部收益率（EIRR）24.88%2经济净现值（ENPV）（Is=12%）850.573经济效益费用比（EBCR）（Is=12%）1.614投资回收期（Pt）4.86效益流量B费用流量CB -C∑（B -C ）第一年01286 -1286-1286第二年37544.88330.12-955.88第三年37540.8 334.2-621.68第四年37540.8 334.2-287.48第五年37540.8 334.246.72第六年37540.8 334.2380.92第七年37540.8 334.2715.12第八年37540.8 334.21049.32第九年37540.8 334.21383.52第十年37540.8 334.21717.72计算指标第十一年37540.83 3 4 .22 0 5 1 .9 2第十二年37540.83 3 4 .22 3 8 6 .1 2第十三年37540.83 3 4 .22 7 2 0 .3 2第十四年37540.83 3 4 .23 0 5 4 .5 2第十五年507.6840.84 6 6 .8 83 5 2 1 .4说明：1、表中标明红色字体的需要输入数字2、F24输入数字，使G44尽量接近为零456737537537537537537537537540.840.8040.840.840.840.840.840.8334.2334.20334.2334.2-287.4846.72380.92715.12内部收益率EIRR(1+EBCR)-tB(1+Is)-tC(1+Is)-t0.248804039988215000000000000000-1029.7852655987100001148.2142.488040399882150000000000000000E-01211.68166671933800298.947735.778062.488040399882150000000000000000E-01171.60248018311000266.917629.040632.488040399882150000000000000000E-01137.41345694615900238.319325.929142.488040399882150000000000000000E-01110.03604452421200212.785123.151022.488040399882150000000000000000E-0188.11313945240810189.986720.670552.488040399882150000000000000000E-0170.55801921752240169.63118.455852.488040399882150000000000000000E-0156.50047321931170151.456216.478442.488040399882150000000000000000E-0145.24366626796380135.228814.712892.488040399882150000000000000000E-0136.22959633313710120.7413.13651国民经济评价表国民经济效益费用流量表（增量投2.488040399882150000000000000000E-0129.01143427873520107.803511.729032.488040399882150000000000000000E-0123.2313744588854096.2531610.472342...