路桥吾爱-公路工程经济评价系统V3.2-破解

1、效 益 计 算 表 （一）工程名称：路桥吾爱-新建工程计无新路时有新路时折算交通量有新路时交通量（绝对数）货 物人 均算老路折算 新 路老 路新路货车新路客车老路货车老路客车平 均国 民年交 通 量NYNYNHYNKYNHYYNKYY价 格收 入度（辆/日）（辆/日）（辆/日）（辆/日）（辆/日）（辆/日）（辆/日）（吨/元）（元/人）20031467411484023745602004845721320041497912018024855862004893768920051569612550025956122004942816420061641513081027056380004991864

2、020071713313612028146639005041911520081785014143029246898005092959120091856914678030357160005143100662010192871545803197754000519410542201119999157410325576780052461120520122072316270033647937005298118682013214411680203474819600535112531201422160173370358584570054051319420152287718118037478838005459

3、138572016235951939903805897500551414520201724314188080388991740055691518320182503119463040259494005624158462019257151998204132974700568116509202026466205260424410012005737171722021270802098104339102340057951783520222770821443044341056000585318498计算：罗杰慧复核：刘向英软件设计：罗杰慧确 认效 益 计 算 表 （二）工程名称：路桥吾爱-新建工程计无新路

4、时有新路时车辆平均速度无新路时有新路时车辆运输成本新路有新路时客货运年周转量算老路平均速度 新 路老 路老路运输成本新路运输成本老路运输成本节省时间新 路 周 转 量老 路 周 转 量年VWVYVYYCHWCHYCHYYTY货物QHY旅客QKY货物QHY旅客QKY度公里/小时公里/小时公里/小时元/千吨公里元/千吨公里元/千吨公里小时千万吨公里千万人公里千万吨公里千万人公里200336.1460.73-188.90128.62-0.172.0526.23-200436.0260.29-189.49128.62-0.172.1427.45-200535.7559.88-190.86128.65-

5、0.172.2428.67-200635.4959.49-192.17128.71-0.182.3329.88-200735.2559.12-193.42128.80-0.182.4331.09-200835.0158.76-194.63128.91-0.182.5232.30-200934.7958.42-195.79129.04-0.182.6233.53-201034.5857.94-196.91129.26-0.182.7635.31-201134.3757.78-197.98129.35-0.182.8135.95-201234.1857.48-199.04129.52-0.182.

6、9037.17-201333.9957.18-200.05129.71-0.183.0038.38-201433.8156.90-201.03129.90-0.193.0939.60-201533.6356.51-201.98130.21-0.193.2341.39-201633.4755.90-202.90130.73-0.193.2842.03-201733.3056.17-203.80130.48-0.193.3542.96-201833.1555.87-204.67130.76-0.193.4744.46-201933.0055.64-205.47130.98-0.193.5645.6

7、4-202032.8555.40-206.33131.22-0.193.6646.88-202132.7355.21-207.02131.42-0.193.7447.92-202232.6155.02-207.71131.63-0.193.8249.45-计算：罗杰慧复核：刘向英软件设计：罗杰慧效 益 计 算 表 （三）工程名称：路桥吾爱-新建工程计晋级效益减少拥挤效益货物节约在途旅客节约在途缩短里程效益缩短里程效益减少交通事故减少货物损失全社会使用算货运节约费用客运节约费用货运节约费用客运节约费用时间的价值时间的价值货运节约费用客运节约费用节约费用节约费用效益合计年BhjBkjBhyBkyB

8、hsBksBhdBkdBjshBsshB度（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）2003123.43158.110.000.003.66407.1894.40120.9314.150.07921.932004130.49167.100.000.003.87454.1099.13126.9414.810.08996.522005139.25178.330.000.004.11507.71104.26133.5215.470.081082.732006148.06189.580.000.004.37564.41109.42140.1016.120.

9、081172.142007156.86200.900.000.004.62624.29114.58146.7416.770.091264.862008165.76212.280.000.004.89687.44119.80153.4217.430.091361.102009174.75223.800.000.005.16754.07125.09160.2018.090.101461.252010186.56238.860.000.005.51835.20132.52169.6619.050.101587.462011192.71246.770.000.005.72911.82135.66173

10、.7119.400.111685.882012201.72258.370.000.006.001004.61140.95180.5320.050.111812.332013210.79269.970.000.006.301101.84146.30187.3720.700.121943.382014219.95281.670.000.006.601203.93151.71194.2821.360.122079.632015231.98297.040.000.006.991326.03159.31203.9922.330.132247.802016236.87303.300.000.007.171

11、410.55162.52208.1023.900.132352.542017245.93314.940.000.007.511528.64166.84213.6523.180.142500.832018256.60328.570.000.007.881657.78173.41222.0523.980.142670.412019265.50339.990.000.008.211781.27178.72228.8624.620.152827.332020274.99352.170.000.008.551912.80184.34236.0725.290.152994.372021282.97362.

12、310.000.008.872038.73189.09242.1125.850.163150.082022291.00376.230.000.009.192190.54193.87250.6526.420.163338.07计算：罗杰慧复核：刘向英软件设计：罗杰慧（推荐方法：指数回归分析模型）年份时间交通量年份时间交通量年份时间交通量199113601995547119999610199223901996648920001067019933430199775002001117201994445219988550-Y=A*eBxA=5.829B=0.065R=0.988年份时间交通量年份时间交通

13、量年份时间交通量20021379020071810932012231511200314843200819116620132416122004158992009201244201425172020051696020102113272015261835200617102420112214162016271958年份时间交通量20172820892018292229201930237920203125382021322708国民经济评价指标表工程名称：路桥吾爱-新建工程评效 益折现率（12% ）价费 用（国民经济）折现系数费用现值收益现值净现金流量现值净现金流量现值年累 计度（万元）（万元）（万元）

14、（万元）（万元）（万元）2000900.0000.0000.893803.5710.000-803.571-803.57120011450.0000.0000.7971155.9310.000-1155.931-1959.5032002573.0770.0000.712407.9050.000-407.905-2367.4072003171.000921.9320.636108.674585.904477.231-1890.1772004179.550996.5180.567101.881565.451463.569-1426.6072005188.5301082.7320.50795.515

15、548.546453.030-973.5772006197.9501172.1380.45289.543530.216440.673-532.9042007207.8501264.8580.40483.947510.855426.908-105.9962008218.2441361.0970.36178.701490.825412.124306.1282009229.1561461.2490.32273.782470.483396.701702.8292010240.6141587.4630.28769.171456.358387.1871090.0162011252.6441685.8840

16、.25764.847432.724367.8771457.8932012931.4271812.3330.229213.459415.340201.8811659.7742013278.5411943.3810.20556.995397.654340.6592000.4332014292.4682079.6300.18353.433379.941326.5082326.9412015307.0912247.8030.16350.093366.665316.5722643.5132016322.4462352.5450.14646.962342.635295.6722939.1862017338

17、.5682500.8290.13044.027325.207281.1793220.3652018355.4962670.4080.11641.275310.053268.7773489.1422019373.2702827.3260.10438.696293.100254.4043743.5462020391.9352994.3680.09336.277277.158240.8803984.4262021411.5303150.0840.08334.010260.331226.3214210.7472022-1029.4303338.0660.074-75.960246.309322.269

18、4533.016ENPV=4533.015946EBCR=2.234233706EIRR=0.289251571N=9确认设计：罗杰慧复核：刘向英软件设计：罗杰慧国民经济敏感性分析指标表（效益下降10% 、费用增加10%）工程名称： 路桥吾爱-新建工程评效 益折现率（12% ）价费 用（国民经济）折现系数费用现值收益现值净现金流量现值净现金流量现值年累 计度（万元）（万元）（万元）（万元）（万元）（万元）2000990.0000.0000.893883.9290.000-883.929-883.92920011595.0000.0000.7971271.5240.000-1271.524-21

19、55.4532002630.3850.0000.712448.6950.000-448.695-2604.1482003188.100829.7390.636119.541527.314407.773-2196.3752004197.505896.8660.567112.070508.906396.836-1799.5392005207.383974.4580.507105.067493.691388.624-1410.9152006217.7451054.9240.45298.497477.194378.697-1032.2172007228.6351138.3720.40492.34245

20、9.769367.427-664.7902008240.0681224.9870.36186.571441.743355.172-309.6182009252.0721315.1240.32281.160423.435342.27432.6562010264.6751428.7170.28776.088410.722334.634367.2902011277.9081517.2950.25771.332389.452318.120685.41020121024.5701631.1000.229234.805373.806139.001824.4112013306.3951749.0430.20

21、562.694357.889295.1941119.6052014321.7151871.6670.18358.776341.947283.1701402.7762015337.8002023.0230.16355.103329.999274.8961677.6722016354.6912117.2900.14651.659308.371256.7131934.3852017372.4252250.7460.13048.430292.686244.2562178.6412018391.0462403.3680.11645.403279.047233.6442412.2852019410.597

22、2544.5930.10442.565263.790221.2242633.5102020431.1292694.9310.09339.905249.442209.5372843.0462021452.6832835.0760.08337.411234.298196.8873039.9332022-1132.3733004.2600.074-83.555221.678305.2343345.167ENPV=3345.166927EBCR=1.828009396 投资上浮(%):10EIRR=0.285737293 N=10收益下降(%):10设计：罗杰慧复核：刘向英软件设计：罗杰慧财务评价指标

23、表工程名称： 路桥吾爱-新建工程评收 益财务折现率（ 4.0365001009125% ）价费 用（车辆通行费收益）折现系数费用现值收益现值净现金流量现值净现金流量现值年累 计度（万元）（万元）（万元）（万元）（万元）（万元）2000947.3680.0000.961910.6110.000-910.611-910.61120011526.3160.0000.9241410.1750.000-1410.175-2320.7862002603.2380.0000.888535.7120.000-535.712-2856.4982003180.000600.0000.854153.649512.1

24、63358.514-2497.9842004189.000630.0000.820155.072516.906361.834-2136.1492005198.450661.5000.789156.508521.694365.185-1770.9642006208.780694.5750.758158.266526.525368.259-1402.7052007218.790729.3000.729159.420531.399371.979-1030.7262008229.730765.7690.700160.896536.323375.426-655.3002009241.220804.057

25、0.673162.389541.289378.901-276.3992010253.278844.2600.647163.891546.302382.412106.0122011265.941886.4730.622165.408551.362385.954491.9662012980.450930.7970.598586.153556.468-29.685462.2822013293.200977.3370.575168.486561.622393.136855.4182014307.8601026.2040.552170.046566.823396.7771252.1952015323.2

26、501077.5100.531171.620572.071400.4511652.6462016339.4201131.3890.510173.213577.370404.1582056.8032017356.3901187.9500.491174.816582.713407.8972464.7002018374.2101247.3560.471176.436588.114411.6782876.3782019392.9201309.7240.453178.069593.561415.4913291.8702020412.5601375.2110.436179.716599.058419.34

27、23711.2122021433.1901443.9700.419181.381604.605423.2244134.4362022569.072984.9800.402229.031396.420167.3894301.824FNPV=4301.824433FBCR=1.643892737FIRR=0.261325363N=11设计：罗杰慧复核：刘向英软件设计：罗杰慧确定财务敏感性分析评价表（效益下降10% 、费用增加10%）工程名称： 路桥吾爱-新建工程评收 益财务折现率（ 4.0365001009125% ）价费 用（车辆通行费收益）折现系数费用现值收益现值净现金流量现值净现金流量现值年

28、累 计度（万元）（万元）（万元）（万元）（万元）（万元）20001042.1050.0000.9611001.6720.000-1001.672-1001.67220011678.9470.0000.9241551.1920.000-1551.192-2552.8642002663.5620.0000.888589.2830.000-589.283-3142.1482003198.000540.0000.854169.014460.947291.933-2850.2152004207.900567.0000.820170.579465.216294.637-2555.5782005218.29

29、5595.3500.789172.159469.524297.365-2258.2132006229.658625.1180.758174.093473.873299.779-1958.4332007240.669656.3700.729175.362478.259302.897-1655.5362008252.703689.1920.700176.986482.690305.704-1349.8322009265.342723.6510.673178.628487.160308.533-1041.2992010278.606759.8340.647180.280491.672311.392-

30、729.9072011292.535797.8260.622181.949496.226314.277-415.63020121078.495837.7170.598644.768500.821-143.947-559.5762013322.520879.6030.575185.335505.460320.125-239.4512014338.646923.5840.552187.051510.141323.09083.6392015355.575969.7590.531188.782514.863326.082409.7212016373.3621018.2500.510190.534519

31、.633329.099738.8202017392.0291069.1550.491192.298524.442332.1441070.9642018411.6311122.6200.471194.079529.303335.2231406.1872019432.2121178.7520.453195.876534.205338.3281744.5152020453.8161237.6900.436197.688539.152341.4652085.9802021476.5091299.5730.419199.519544.145344.6262430.6062022625.979886.48

32、20.402251.935356.778104.8432535.449FNPV=2535.449117FBCR=1.345003149 投资上浮(%):10FIRR=0.24292516 N=15 收益下降(%):10设计：罗杰慧复核：刘向英软件设计：罗杰慧 基建投资贷款还本付息估算表工程名称： 路桥吾爱-新建工程年年初当年当年当年年末公路养护当年当年借款借款应付还本借款收费管理收入收入余额累计支用利息付息累计收入费用余额累计份（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）20000.000600.00037.2600.000637.2600.0000.0000.00

33、00.0002001637.2601000.000101.6740.0001738.9340.0000.0000.0000.00020021738.934400.000132.8280.0002271.7620.0000.0000.0000.00020032271.7620.000141.076420.0001992.838600.000180.0000.0000.00020041992.8380.000123.755441.0001675.593630.000189.0000.0000.00020051675.5930.000104.054463.0501316.598661.500198.

34、4500.0000.00020061316.5980.00081.761485.795912.563694.575208.7800.0000.0002007912.5630.00056.670510.510458.724729.300218.7900.0000.0002008458.7240.00028.487487.2100.000765.769229.73048.82948.82920090.0000.0000.0000.0000.000804.057241.220562.837611.66620100.0000.0000.0000.0000.000844.260253.278590.98

35、21202.64820110.0000.0000.0000.0000.000886.473265.941620.5321823.18020120.0000.0000.0000.0000.000930.797980.450-49.6531773.52720130.0000.0000.0000.0000.000977.337293.200684.1372457.66420140.0000.0000.0000.0000.0001026.204307.860718.3443176.00820150.0000.0000.0000.0000.0001077.510323.250754.2603930.26

36、820160.0000.0000.0000.0000.0001131.389339.420791.9694722.23720170.0000.0000.0000.0000.0001187.950356.390831.5605553.79720180.0000.0000.0000.0000.0001247.356374.210873.1466426.94320190.0000.0000.0000.0000.0001309.724392.920916.8047343.74720200.0000.0000.0000.0000.0001375.211412.560962.6518306.3982021

37、0.0000.0000.0000.0000.0001443.970433.1901010.7809317.17820220.0000.0000.0000.0000.000984.980569.072415.9099733.086设计：罗杰慧复核：刘向英软件设计：罗杰慧确 定 基建投资贷款还本付息估算表(效益下降10%，费用增加10）工程名称： 路桥吾爱-新建工程年年初当年当年当年年末公路养护当年当年借款借款应付还本借款收费管理收入收入余额累计支用利息付息累计收入费用余额累计份（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）（万元）20000.000600.00037.2600.000637.2600.0000.0000.0000.0002001637.2601000.000101.6740.0001738.9340.0000.0000.0000.00020021738.934400.000132.8280.