敏感性分析计算

变化率内部收益率敏感度系数%%%基本0.00%14.8310.00%13.230.165.00%14.040.158-5.00%15.730.18-10.00%16.70.18710.00%16.520.1695.00%15.680.17-5.00%13.960.174-10.00%13.060.17710.00%9.140.5695.00%12.110.544-5.00%17.370.508-10.00%19.760.493年限1234567891011年度 2016年2017年2018年2019年2020年2021年2022年2023年2024年2025年2026年业务收入1350.001552.501707.751844.371955.032072.332196.672328.472468.182616.272773.25产品成本769.50884.93973.421051.291114.371181.231252.101327.231406.861491.271580.75费用409.05470.41517.45558.84592.37627.92665.59705.53747.86792.73840.29税金及附加36.4541.9246.1149.8052.7955.9559.3162.8766.6470.6474.88利润135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.33基本 利润135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.33120015%0.870.7560.6580.5720.4970.4320.3760.3270.2840.2470.2151187.83117.45117.37112.37105.597.1689.5282.5976.1470.164.6259.62135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.3314%0.8770.7690.6750.5920.5190.4560.40.3510.3080.270.237不确定因素投资销售费用项目投资现金流量表(万元)0510152025-15.00% -10.00%-5.00%0.00%5.00%10.00%15.00%内部收益率（%）因素变化率(%)敏感性分析图投资销售费用1259.93118.4119.39115.27109.19101.4794.587.8781.7376.0270.6465.73内部收益率投资10%利润135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.33132014%0.8770.7690.6750.5920.5190.4560.40.3510.3080.270.2371259.93118.4119.39115.27109.19101.4794.587.8781.7376.0270.6465.73135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.3313%0.8850.7830.6930.6130.5430.480.4250.3760.3330.2950.2611338.02119.48121.56118.35113.06106.1699.4793.3687.5582.1977.1872.38内部收益率投资5%利润135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.33126015%0.870.7560.6580.5720.4970.4320.3760.3270.2840.2470.2151187.83117.45117.37112.37105.597.1689.5282.5976.1470.164.6259.62135.00155.25170.78184.44195.50207.23219.67232.85246.82261.63277.3313%0.8850.7830.6930.6130.5430.480.4250.3760.3330.2950.2611338.02119.48121.56118.35113.061...