In: Finance
The following modeling activities are the basic types of
analytical modeling, EXCEPT:
What-if Analysis |
||
Sensitivity Analysis |
||
Goal-seeking Analysis |
||
PESTLE Analysis |
PESTLE analysis is not a type of Analytical modelling.
It is a framework of macro-environmental factors used in the environmental scanning component of strategic management.
It is a strategic tool for understanding market growth or decline, business position, potential and direction for operations.
It contains analysis of the following parameters
political, economic, socio-cultural, technological, legal and enviromental aspects of any particular given problem
Goal Seek
The Goal Seek Excel function (often referred to as What-if-Analysis) is a method of solving for a desired output by changing an assumption that drives it
Sensitivity Analysis
A sensitivity analysis is a financial modeling tool companies use to determine how changes to a given variable might affect an outcome, assuming other conditions stay the same.
What if analysis
process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.