巧用Excel提升项目敏感性分析水平

To Enhance the Level of Sensitivity Analysis by Using Excel

敏感性分析是财务经济评价的重要组成部分,是不确定性分析的重要方法。对项目主要敏感因素进行不确定性分析,可以判断哪些因素的变化会对项目的收益产生较大影响以及影响的程度,从而判断项目的抗风险能力,也为领导决策提供更加详实的依据。本文主要介绍利用Excel数据表进行单因素和多因素敏感性分析的方法。

The sensitivity analysis is an important part of the financial economic evaluation, and it is an important method of uncertainty analysis. The uncertainty analysis of the main sensitive factors of the project can determine the changes which will have larger impact on project earnings and the impact degree, so as the determine the ability to resist risk of the project to provide a more detailed basis for leadership decision-making. This paper mainly introduces the single-factor and multi-factor sensitivity analysis method by Excel table data.