《利用单变量求解工具进行风险敏感性分析.doc》由会员分享，可在线阅读，更多相关《利用单变量求解工具进行风险敏感性分析.doc（5页珍藏版）》请在三一文库上搜索。
1、http:/ http:/ http:/ http:/ of single variable solving tool for risk sensitivity analysis 商业信用是最古老的信用形式，通常是指工商企业之间进行商品交易时，以实物形态提供的直接信用。从经济意义上来看，商业信用可以看作是一种准货币，在商品流通中调节资金在时间与空间上分布的失衡。但是商业信用也是一把“双刃剑”，它一方面推动经济的发展，另一方面也存在巨大的风险。传统的商业信用决策是假设外部经济参数是静止的。但这样的假设前提是不现实的，本文针对以上分析思路的不足，利用Excel软件的相关分析工具，提出动态经济环境下
2、的商业信用决策方法。Commercial credit is one of the oldest forms of credit, usually refers to the commodity trading between industry and commerce enterprise, offers in physical form of direct credit. From an economic sense, commercial credit can be thought of as a quasi currency, regulation in the circulation
3、 of commodities funds in time and space distribution imbalance. But business credit is also a double-edged sword, it promote the development of the economy on the one hand, on the other hand, there is also a huge risk. The traditional commercial credit decision is to assume that the external economy
4、 parameter is static. Is not realistic, but such assumptions in this paper, aiming at the shortcomings of the above analysis, related analysis using the Excel software tools, and put forward the dynamic economic environment of the commercial credit decision method. 利用单变量求解工具进行风险敏感性分析 Use of single v
5、ariable solving tool for risk sensitivity analysis 单变量求解工具具有根据结果反推出原因的作用，即具有处理假设需要得到的结果，那么原因是什么这类问题的功能。应用单变量求解工具是通过“工具”菜单上的“单变量求解”命令来实现的。具体操作过程中可以在“可变单元格”或“目标单元格”中输入单元格的引用位置或名称，“可变单元格”中的单元引用必须包含在“目标单元格”的公式之中，同时还要注意“可变单元格”不能包含公式，当单变量求解工作完成后，xcel会将结果显示在“单变量求解”对话框中。Goal seek tools have the function of
6、the reason of blade frequency are deduced according to the results, which have as a result, dealing with assumptions need to be so what is the reason of this kind of problem. Application goal seek tool is through the tools menu of the goal seek command. Variable cell specific operation process can b
7、e found in or target cell type in the name of the reference position or cell, variable cell in the cell reference must be included in the formula of target cell , at the same time also note variable cell cannot contain formula, when, after the completion of the goal seek job Excel results will be di
8、splayed in the goal seek dialog box. 利用模拟运算表进行风险敏感性分析Simulated operation table for risk sensitivity analysis 模拟运算表是xcel提供的只需简单操作就可以完成因素变化的分析工具。在具体分析过程中，利用模拟运算表工具进行“假设”分析，来观察某些因素变化对目标结果的影响程度。模拟运算表具有如下功能：一是提供一种便捷的计算手段，在简单的操作定义过程后，完成多组不同数据之间运算；二是提供一种显示与比较表式，在模拟工作表中可以同时显示与比较多个不同数值变化结果。Simulation operati
9、on table is Excel to provide simple operation can be completed factors change analysis tools. In the process of concrete analysis, simulated operation table assumption analysis tools, to look at some factors change the influence degree of the result of the goal. Simulation operation table has the fo
10、llowing functions: one is to provide a convenient calculation method, defined in simple operation process, after completion of multiple sets of data between different calculations; 2 it is to provide a comparison table shows, in a simulated work can also show in the table and compare several differe
11、nt numerical change results. 方案管理器是xcel软件为财务人员提供的一种强有力的分析工具，它可以管理多个方案，每个方案可以建立多个假设条件，并据此生成多种结果以方案摘要报告形式保存除渣机，通过阅读方案摘要报告，可以清楚地看出因素变动对目标值的影响情况.Project manager is the Excel software for financial personnel to provide a powerful analysis tool, it can manage multiple solutions, each project can create mu
12、ltiple assumptions, and thus generate a variety of results in solution to save the report form, by reading the plan summary report, can clearly see that changes in factors impact on the target. Excel提供了多种图形控制工具，激活这些控制图标，例如视窗中的工具栏，建立与相关单元之间链接三轮汽车，拖动这些控件，可直观地反映相关因素的变动以及对目标参数的影响。Excel offers a variety of graphical control tool, activate the control icon, such as the window of the toolbar, set up and the related links between units, drag the controls, can directly reflect the changes of related factors and effect on the target parameter.