(完整版)敏感性分析计算

不确定因素基本投资销售费用变化率%0.00%10.00%5.00%-5.00%-10.00%10.00%5.00%-5.00%-10.00%10.00%5.00%-5.00%-10.00%内部收益率%14.8313.2314.0415.7316.716.5215.6813.9613.069.1412.1117.3719.76敏感度系数%0.160.1580.180.1870.1690.170.1740.1770.5690.40.5080.493敏感性分析图252015投资105销售费用0-15.00%-10.00%-5.00%0.00%5.00%因素变化率(%)内部收益率（%）10.00%15.00%年限年度业务收入产品成本费用税金及附加利润12016年1350.00769.50409.0536.45135.00135.000.87117.45135.000.87722017年1552.50884.93470.4141.92155.25155.250.756117.37155.250.7692018年项目投资现金流量表(万元)3456710112019年2020年2021年2022年2023年2024年2025年2026年1707.75973.42517.46.11170.78170.780.658112.37170.780.6751844.371051.29558.8449.80184.44184.440.572105.5184.440.5921955.031114.37592.3752.79195.50195.500.49797.16195.500.5192072.331181.23627.9255.95207.23207.230.432.52207.230.4562196.671252.10665.5959.31219.67219.670.37682.59219.670.42328.471327.23705.5362.87232.85232.850.32776.14232.850.3512468.181406.86747.8666.246.82246.820.28470.1246.820.3082616.271491.27792.7370.261.63261.630.247.62261.630.272773.251580.75840.2974.88277.33277.330.21559.62277.330.237基本1200

利润15%1187.8314%1259.93内部收益率118.4119.39115.27109.1914.83%184.440.592109.19184.440.613113.0613.23%184.440.572105.5184.440.613113.0614.04%184.440.552101.81184.440.572105.515.73%184.440.53498.49184.440.552101.8116.70%101.4794.587.8781.7376.0270.14.82%246.82261.630.3080.2776.0270.246.82261.630.3330.29582.1977.1811.83%246.82261.630.2840.24770.1.62246.82261.630.3330.29582.1977.1813.23%246.82261.630.2630.227.9159.39246.82261.630.2840.24770.1.6216.49%246.82261.630.2430.20859.98.42246.82261.630.2630.227.9159.3918.95%65.73投资10%1320

利润14%1259.9313%1338.02内部收益率135.000.877118.4135.000.885119.48155.250.769119.39155.250.783121.56170.780.675115.27170.780.693118.35195.500.519101.47195.500.3106.16207.230.45694.5207.230.49.47219.670.487.87219.670.42593.36232.850.35181.73232.850.37687.55277.330.23765.73277.330.26172.38投资5%1260

利润15%1187.8313%1338.02内部收益率135.000.87117.45135.000.885119.48155.250.756117.37155.250.783121.56170.780.658112.37170.780.693118.35195.500.49797.16195.500.3106.16207.230.432.52207.230.49.47219.670.37682.59219.670.42593.36232.850.32776.14232.850.37687.55277.330.21559.62277.330.26172.38投资-5%1140

利润16%1121.8615%1187.83内部收益率135.000.862116.37135.000.87117.45155.250.743115.35155.250.756117.37170.780.1109.47170.780.658112.37195.500.47693.06195.500.49797.16207.230.4184.97207.230.432.52219.670.377.76219.670.37682.59232.850.30571.02232.850.32776.14277.330.195.08277.330.21559.62投资-10%1080

利润17%1062.3216%1121.86内部收益率135.000.855115.43135.000.862116.37155.250.731113.49155.250.743115.35170.780.624106.56170.780.1109.47195.500.456.15195.500.47693.06207.230.3980.82207.230.4184.97219.670.33373.15219.670.377.76232.850.28566.36232.850.30571.02277.330.17849.36277.330.195.08销售10%1200

利润17%1168.5516%1234.04内部收益率148.500.855126.97148.500.862128.01170.780.731124.84170.780.743126.187.850.624117.22187.850.1120.41202.880.534108.34202.880.552111.9916.52%193.660.552106.9193.660.572110.7715.68%175.220.592103.73175.220.613107.4113.96%165.990.59298.27165.990.613101.7513.06%128.550.68387.8215.050.45698.06215.050.476102.37227.960.3988.9227.960.4193.46241.630.33380.46241.630.385.256.130.28573256.130.30578.12271.50287.790.2430.20865.9759.86271.50287.790.2630.22771.465.3318.13%259.16274.710.2630.22768.1662.36259.16274.710.2840.24773.667.8516.52%234.48248.550.3080.2772.2267.11234.48248.550.3330.29578.0873.3213.06%222.14235.460.3080.2768.4263.58222.14235.460.3330.29573.9769.4611.19%172.030.42472.94182.350.38670.39305.060.178.3305.060.19559.49销售5%1200

利润16%1177.9415%1247.24内部收益率141.750.862122.19141.750.87123.32163.010.743121.12163.010.756123.24179.310.1114.94179.310.658117.99205.280.47697.71205.280.497102.02217.590.41.21217.590.43294230.650.381.65230.650.37686.72244.490.30574.57244.490.32779.95291.190.19556.78291.190.21562.61销售-5%1200

利润14%1196.9313%1271.1内部收益率128.250.877112.48128.250.885113.5147.490.769113.42147.490.783115.48162.240.675109.51162.240.693112.43185.730.51996.39185.730.3100.85196.870.456.77196.870.44.5208.680.483.47208.680.42588.69221.200.35177.221.200.37683.17263.460.23762.44263.460.26168.76销售-10%1200

利润14%1133.9313%1204.2内部收益率121.500.877106.56121.500.885107.53139.730.769107.45139.730.783109.4153.700.675103.75153.700.693106.51175.950.51991.32175.950.395.186.510.45685.05186.510.48.52197.700.479.08197.700.42584.02209.560.35173.56209.560.37678.8249.590.23759.15249.590.26165.14费用10%1200

利润10%1130.794.100.90985.53108.210.826.38119.030.751.39136.270.62184.62144.440.581.46153.110.51378.162.290.46775.79193.300.3567.659%1210.96内部收益率94.100.91786.29108.210.84291.11119.030.77291.128.550.701.029.14%156.490.61395.93156.490.63699.5312.11%212.380.516109.59212.380.534113.4117.37%240.320.482115.83240.320.499119.9219.76%136.270.6588.57144.440.59686.09153.110.783.75162.290.50281.47172.03182.350.460.42279.1376.951.80%209.43221.990.3330.29569.7465.49209.43221.990.3610.32275.671.4.13%284.21301.260.2250.19163.9557.284.21301.260.2430.20869.0662.6619.75%321.60340.900.1940.16262.3955.23321.60340.900.2090.17667.226024.24%193.300.38875费用5%1200

利润13%1135.3112%1208.33内部收益率114.550.885101.37114.550.3102.29131.730.783103.14131.730.797104.99144.900.693100.42144.900.712103.17165.880.390.08165.880.56794.06175.840.4884.4175.840.507.15186.390.42579.21186.390.45284.25197.570.37674.29197.570.40479.82235.310.26161.42235.310.28767.53费用-10%1200

利润18%1159.5317%1223.27内部收益率155.450.847131.67155.450.855132.91178.770.718128.36178.770.731130.68196.650.609119.76196.650.624122.71225.120.43798.38225.120.456102.66238.630.3788.29238.630.3993.07252.950.31479.43252.950.33384.23268.120.26671.32268.120.28576.42319.340.16251.73319.340.17856.84费用-20%1200

利润20%1185.2919%1246.57内部收益率175.910.833146.53175.910.84147.76202.290.694140.39202.290.706142.82222.520.579128.84222.520.593131.952.740.402102.412.740.419106.74270.020.33590.46270.020.35295.05286.230.27979.86286.230.29684.72303.400.23370.69303.400.24975.55361.350.138.78361.350.14853.48122027年2939.651675.600.7179.37293.97293.970.187.97293.970.208132028年3116.031776.14944.1684.13311.60311.600.16350.79311.600.182142029年3302.991882.701000.81.18330.30330.300.14146.57330.300.16152030年3501.171995.671060.8594.53350.12350.120.12343.06350.120.1461.1456.7152..02293.970.20861.14293.970.23167.91311.600.18256.71311.600.20463.57330.300.1652.85330.300.18159.78350.120.1449.02350.120.1656.02293.970.187.97293.970.23167.91311.600.16350.79311.600.20463.57330.300.14146.57330.300.18159.78350.120.12343.06350.120.1656.02293.970.16849.39293.970.187.97311.600.145.18311.600.16350.79330.300.121.29330.300.14146.57350.120.10837.81350.120.12343.06293.970.15244.68293.970.16849.39311.600.1340.51311.600.145.18330.300.11136.66330.300.121.29350.120.09533.26350.120.10837.81323.360.15249.15323.360.168.32342.760.1344.56342.760.149.7363.330.11140.33363.330.125.42385.130.09536.59385.130.10841.59308.660.16851.86308.660.18757.72327.180.147.44327.180.16353.33346.810.123.35346.810.14148.9367.620.10839.7367.620.12345.22279.270.20858.09279.270.231.51296.020.18253.88296.020.20460.39313.780.1650.21313.780.18156.79332.610.1446.57332.610.1653.222.570.20855.032.570.23161.12280.440.18251.04280.440.20457.21297.270.17.56297.270.18153.81315.110.1444.11315.110.1650.42204.0.31965.36217.190.2962.98230.220.26360.55244.030.23958.32204.0.35672.94217.190.32670.8230.220.29968.84244.030.27567.11249.430.23157.62249.430.257.12.400.20453.942.400.22960.55280.260.18150.73280.260.20557.45297.070.17.53297.070.183.36338.500.13746.37338.500.15251.45358.810.111.62358.810.1346.65380.340.09937.65380.340.11142.22403.160.08433.87403.160.09538.3383.040.11242.9383.040.12447.06.020.09337.706.020.10442.23430.380.07833.57430.380.08837.87456.200.06529.656.200.07433.76