可行性报告中的财务评价报表（带公式）--敏感分析.xls

附附件件6： 敏敏感感度度分分析析一一（销销售售收收入入变变化化的的影影响响) 销销售售收收入入变变化化率率-15%-15%-10%-10%-5%-5%0 05%5%10%10% 销售收入289,812,600306,860,400323,908,200340,956,000358,003,800375,051,600 与销 售收 入变 化相 对应 的指 标值 及其 变化 率 净现值npv38,879,92750,084,40161,288,87672,493,35083,697,82594902299.49 变变化化率率-46.4%-46.4%-30.9%-30.9%-15.5%-15.5%0.0%0.0%15.5%15.5%30.9%30.9% 内部收益率27.6%32.4%37.1%41.4%45.6%49.59% 变变化化率率-33.5%-33.5%-21.7%-21.7%-10.6%-10.6%0.0%0.0%10.1%10.1%19.6%19.6% 税后利润61,891,51275,143,19488,394,875101,646,556114,898,237128149918.1 变变化化率率-39.1%-39.1%-26.1%-26.1%-13.0%-13.0%0.0%0.0%13.0%13.0%26.1%26.1% 成本利润率32.2%39.1%46.0%52.9%59.8%0.667016651 变变化化率率-39.1%-39.1%-26.1%-26.1%-13.0%-13.0%0.0%0.0%13.0%13.0%26.1%26.1% 15%15% 结论 392,099,400 106,106,774 销售收入每增减 5%,npv值相应等 比增减15.5% , 影响率约为1:3 46.4%46.4% 53.4% 28.8%28.8% 141,401,599 销售收入每增减 5%,税后利润相 应等比增减约 13%,影响率约为 1:2.6 39.1%39.1% 73.6% 销售收入每增减 5%,成本利润率 相应等比增减约 13.%,影响率约 为1:2.6 39.1%39.1% 敏敏感感度度分分析析一一（销销售售收收入入变变化化的的影影响响) 附附件件7： 敏敏感感度度分分析析二二（工工程程成成本本变变化化的的影影响响) 工工程程成成本本变变化化率率-15%-15%-10%-10%-5%-5%0 05%5% 工程成本886945489393512199178277104424017109672339 与工 程成 本变 化相 对应 的指 标值 及其 变化 率 净现值npv9528221987688082800917927249335064892756 变变化化率率31.4%31.4%21.0%21.0%10.5%10.5%0.0%0.0%-10.5%-10.5% 内部收益率55.37%50.47%45.84%41.45%37.27% 变变化化率率33.6%33.6%21.8%21.8%10.6%10.6%0.0%0.0%-10.1%-10.1% 税后利润12621063011802480210983677710164655693454138 变变化化率率24.2%24.2%16.1%16.1%8.1%8.1%0.0%0.0%-8.1%-8.1% 成本利润率77.32%68.28%60.19%52.91%46.32% 变变化化率率46.1%46.1%29.0%29.0%13.8%13.8%0.0%0.0%-12.4%-12.4% 10%10%15%15% 结论 114923244120176732 5729000949685109 工程成本每增减 5%,npv值相应 等比增减10.5% , 影响率约为1:2 -21.0%-21.0%-31.5%-31.5% 33.29%29.48% -19.7%-19.7%-28.9%-28.9% 8525952377062712 工程成本每增减 5%,税后利润相 应等比增减8.1% ,影响率约为1:1.6 -16.1%-16.1%-24.2%-24.2