当前位置:文档之家› 公路工程经济评价课程设计计算表格

公路工程经济评价课程设计计算表格

序号项目1231现金流入004261.371.1收费收入4261.371.2回收资产余值1.3其他收入2现金流出5717.128575.681439.052.1建设投资(不含建设期利息)5717.128575.682.2经营成本622.002.2.1运营期管理费4002.2.2养护费222.002.2.3大中修费0.002.3营业税金及附加255.68222.4所得税561.37226553净现金流量(1-2)-5717.12 -8575.68 2822.324累计净现金流量-5717.12 -14292.80 -11470.48

序号项目1231现金流入004261.371.1收费收入4261.371.2回收资产余值1.3其他收入2现金流出6860.5410290.821726.872.1建设投资(不含建设期利息)6860.5410290.822.2经营成本622.002.2.1运营期管理费4002.2.2养护费222.002.2.3大中修费0.002.3营业税金及附加255.68222.4所得税561.37226553净现金流量(1-2)-6860.54 -10290.82 2534.504累计净现金流量-6860.54 -17151.36 -14616.86

序号项目1231现金流入003409.0961.1收费收入3409.0961.2回收资产余值1.3其他收入2现金流出6860.5410290.821726.872.1建设投资(不含建设期利息)6860.5410290.82

建设期

建设期建设期内部收益率 14%投资回收期8.36净现值 9623.02效益费用比 1.252.2经营成本622.002.2.1运营期管理费4002.2.2养护费222.002.2.3大中修费0.002.3营业税金及附加204.545762.4所得税561.37226553净现金流量(1-2)-6860.54 -10290.82 1682.234累计净现金流量-6860.54 -17151.36 -15469.13

建设期运营期序号项目1.002.003.001.00现金流入0.000.003409.101.10收费收入3409.101.20回收资产余值1.30其他收入2.00现金流出5717.128575.681439.052.10建设投资(不含建设期利息)5717.128575.682.20经营成本622.002.2.1运营期管理费400.002.2.2养护费222.002.2.3大中修费0.002.30营业税金及附加255.682.40所得税561.373.00净现金流量(1-2)-5717.12-8575.681970.044.00累计净现金流量-5717.12-14292.80-12322.76

内部收益率 8%净现值 -16.43

投资回收期 8.79效益费用比1.20

投资回收期 12.45效益费用比 0.9996

内部收益率 13%净现金流量6412.61456789104359.254535.174711.0848875094.585343.615523.044359.254535.174711.0848875094.585343.615523.04

1499.751584.631670.731758.131856.211967.933837.13653.10685.76720.04756.04793.85833.543243.90420441463.05486.2025510.512625536.03826562.840169233.10244.76256.99269.84283.33297.500.002681.06261.555272.1102282.6648293.22305.6748320.6166331.3824585.0940619626.764602668.026956708.86071756.686074813.77816261.8490822859.502950.543040.353128.873238.373375.681685.91-8610.98 -5660.44 -2620.10 508.783747.157122.828808.73

456789104359.254535.174711.0848875094.585343.615523.044359.254535.174711.0848875094.585343.615523.04

1799.701901.562004.882109.752227.452361.524604.56653.10685.76720.04756.04793.85833.543243.90420441463.05486.2025510.512625536.03826562.840169233.10244.76256.99269.84283.33297.500.002681.06261.555272.1102282.6648293.22305.6748320.6166331.3824585.0940619626.764602668.026956708.86071756.686074813.77816261.8490822559.552633.612706.202777.252867.132982.09918.48-12057.30 -9423.69 -6717.49 -3940.24 -1073.11 1908.982827.4614%8.3598149¥9,623.02¥48,197.29¥38,574.271.24946748

456789103487.43628.1363768.8643909.64075.6644274.8884418.4323487.43628.1363768.8643909.64075.6644274.8884418.432

1799.701901.562004.882109.752227.452361.524604.56

表5-11 财务评价敏感性分析(投表5-11 财务评价敏感性分析(效益-20653.10685.76720.04756.04793.85833.543243.90420441463.05486.2025510.512625536.03826562.840169233.10244.76256.99269.84283.33297.500.002681.06209.244217.68816226.13184234.576244.53984256.49328265.10592585.0940619626.764602668.026956708.86071756.686074813.77816261.8490821687.701726.581763.981799.851848.211913.37-186.13 -13781.43 -12054.85 -10290.87 -8491.02 -6642.80 -4729.43 -4915.56 8%¥-16.4312.45155560.99957398¥38,557.83#########

4.005.006.007.008.009.0010.003487.403628.143768.863909.604075.664274.894418.433487.403628.143768.863909.604075.664274.894418.43

1499.751584.631670.731758.131856.211967.933837.13653.10685.76720.04756.04793.85833.543243.90420.00441.00463.05486.20510.51536.04562.84233.10244.76256.99269.84283.33297.500.002681.06261.56272.11282.66293.22305.67320.62331.38585.09626.76668.03708.86756.69813.78261.851987.652043.512098.132151.472219.462306.95581.30-10335.11-8291.60-6193.47-4042.00-1822.54484.411065.710.136412.618.791.2038557.8332145.22

表5-11 财务评价敏感性分析(效111213141516175702.485881.916149.1054596365.597136548.620286731.64346914.666565702.485881.916149.116365.606548.626731.646914.67

2154.872250.762374.262484.612586.992691.362797.83918.98964.931013.171063.831117.021172.871231.52590.9821775620.53129651.5578507684.135743718.34253754.25966791.9726398328.00344.39361.61379.70398.68418.61439.54

342.1488352.9146368.9463276381.935828392.917217403.89861414.8799936893.740899932.91478992.13752451038.842411077.048961114.59061151.4341343547.613631.153774.853880.993961.634040.284116.8312356.3515987.5019762.3523643.3427604.9731645.2535762.08

111213141516175702.485881.916149.1054596365.597136548.620286731.64346914.666565702.485881.916149.116365.606548.626731.646914.67

2585.842700.912849.112981.533104.393229.643357.40918.98964.931013.171063.831117.021172.871231.52590.9821775620.53129651.5578507684.135743718.34253754.25966791.9726398328.00344.39361.61379.70398.68418.61439.54

相关主题