What if..? Advanced Techniques for Performing Sensitivity Analysis in Excel Financial Models
At its most basic, sensitivity analysis involves changing an input value and observing its effect on the model’s results; tools such as Goal Seek and Data Tables can illustrate this direct relationship. But in complex models, the route from input to output may be convoluted and indirect. The analyst needs to understand the precise way in which a particular input influences the behaviour of the model, and in this webinar Jonathan Swan will demonstrate techniques for identifying, quantifying and recording the effects of sensitivity analysis not just on the key results, but on the underlying cash flows of the model.
– Jonathan Swan, Operis