国民经济评价指标计算破解.xls

国民经济评价指标计算破解.xls

《国民经济评价指标计算破解.xls》由会员分享，可在线阅读，更多相关《国民经济评价指标计算破解.xls（5页珍藏版）》请在冰豆网上搜索。

经经济济费费用用效效益益分分析析指指标标计计算算单单位位:

万万元元评价采用的基本参数：

1、社会折现率（is）8%评价期年份费用流量合计效益流量合计净现金流量折现系数各年经济净现值CCttBBtt（Bt-Ct）（Bt-Ct）（1+8%）（1+8%）-t-t（Bt-Ct）（1+8%）-t（Bt-Ct）（1+8%）-t1201036942.3436942.3400-36942.3400.9259-34205.870220117070280028002730.0000.85732340.5353201272723880.53880.53808.5000.79383023.3104201373.4473.444210.54210.54137.0600.73503040.8635201474.9174.91456945694494.0900.68063058.6026201576.4176.414957.54957.54881.0900.63023075.9157201677.9477.94537953795301.0600.58353093.1188201779.4979.495836.55836.55757.0100.54033110.3339201881.0881.086331.56331.56250.4200.50023126.766102019959.91959.916868.56868.55908.5900.46322736.82011202084.3684.36745574557370.6400.42893161.14112202186.0586.05808880888001.9500.39713177.68413202287.7787.778776.58776.58688.7300.36773194.82814202389.5289.52952295229432.4800.34053211.39215202491.3191.3110330.510330.510239.1900.31523227.820162025-18376.17-18376.1712160.512160.530536.6700.29198913.363经济净现值（ENPV）=17286.62017286.620经济效益费用比（EBCR）=1.5791.579经济内部收益率（EIRR）=13.36%13.36%动态投资回收期（N）=12.3912.39函函数数求求解解:

11、经经济济净净现现值值（ENPVENPV）函函数数:

NPV=:

NPV=￥17,286.62017,286.620函函数数:

NPV=:

NPV=￥17,286.62017,286.62022、经经济济效效益益费费用用比比（EBCREBCR）￥47,134.441.5791.579￥29,847.821.5791.57933、内内部部经经济济收收益益率率（EIRREIRR）函函数数:

IRR=:

IRR=13.36%13.36%函函数数:

IRR=:

IRR=13.36%13.36%44、投投资资回回收收期期（NN）（动动态态）1934.04512.3912.39-1260.7831311、经经济济净净现现值值（ENPVENPV）本本项项目目评评价价期期内内总总效效益益大大于于总总费费用用，可可以以得得到到以以现现值值计计算算的的社社会会盈盈余余，项项目目可可行行，ENPVENPV的的数数值值越越大大，方方案案的的经经济济可可行行就就越越好好。

22、经经济济效效益益费费用用比比（EBCREBCR）33、内内部部经经济济收收益益率率（EIRREIRR）44、投投资资回回收收期期（NN）（动动态态）附件1公路建设项目预可行性研究报告文本格式及内容要求7经济评价7.1评价依据和方法7.2经济费用效益分析7.2.1参数选择与确定7.2.2经济费用调整7.2.3经济效益计算7.2.4经济费用效益分析指标计算7.2.5敏感性分析7.3财务分析7.3.1资金来源与融资方案7.3.2财务费用计算7.3.3收费收入计算7.3.4财务分析指标计算7.3.5敏感性分析7.4评价结论经经济济效效益益费费用用比比（EBCREBCR）利利用用单单变变量量求求解解计计算算-内内部部经经济济收收益益率率经济净现值（ENPV）净效益折现值累计效益折现值净费用折现值累计费用折现值试算-假定经济内部收益率BBttBBttCCttCCtt0.04-34205.8700.0000.00034205.87034205.870-31865.3352400.5492400.54960.01434265.884-28842.0253080.4665481.01557.15634323.040-25801.1633094.8438575.85853.98134377.021-22742.5613109.58511685.44350.98234428.003-19666.6463124.06614809.50848.15134476.154-16573.5283138.59517948.10345.47734521.632-13463.1953153.27921101.38342.94634564.578-10336.4293167.32624268.70940.56034605.138-7599.6083181.44427450.153444.62435049.762-4438.4673197.32230647.47536.18135085.942-1260.7833211.85633859.33134.17235120.1141934.0453227.10137086.43232.27335152.3875145.4373241.87040328.30230.47835182.8658373.2573256.60443584.90728.78535211.65017286.62017286.6203549.53447134.44147134.441-5363.82929847.82129847.821万元经经济济效效益益费费用用比比（EBCREBCR）=1.5791.579年经经济济费费用用效效益益分分析析指指标标计计算算单单位位:

万万元元本本项项目目评评价价期期内内总总效效益益大大于于总总费费用用，可可以以得得到到以以现现值值计计算算的的社社会会盈盈余余，项项目目可可行行，ENPVENPV的的数数值值越越大大，方方案案的的经经济济可可行行就就越越好好。

反算折算系数反算的净现值累计净现值试算-假定经济内部收益率反算折算系数反算的净现值累计净现值0.13360.13360.962-35521.481-35521.4810.882-32587.113-32587.1130.9252524.038-32997.4420.7782124.250-30462.8630.8893385.743-29611.7000.6862614.077-27848.7860.8553536.376-26075.3230.6052504.827-25343.9590.8223693.814-22381.5090.5342400.210-22943.7490.7903857.596-18523.9130.4712299.565-20644.1840.7604028.370-14495.5430.4162202.993-18441.1910.7314206.591-10288.9520.3672110.420-16330.7710.7034391.462-5897.4900.3232021.168-14309.6030.6763991.632-1905.8580.2851685.383-12624.2200.6504787.8272881.9690.2521854.563-10769.6570.6254997.9947879.9630.2221776.043-8993.6140.6015218.22613098.1900.1961701.122-7292.4910.5775447.02218545.2120.1731629.021-5663.4710.5555685.45924230.6700.1521559.868-4103.6030.53416303.77840534.4480.1344103.6030.0000.000计计算算结结果果=13.36%13.36%计计算算过过程程利利用用单单变变量量求求解解计计算算-内内部部经经济济收收益益率率