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.

Speaker:

Jonathan Swan, Operis


You Might Also Like

See more

Physical Climate Risk – Can Technology Protect Assets?

OD Webinar: March 2nd, 2023

Waste-to-Energy: Sector Landscape in Asia and Beyond

OD Webinar: March 1st, 2023

Data Centre Investments in Germany – An Outlook

OD Webinar: February 23rd, 2023

The Hydrogen Economy - Is the Vision Still Relevant?

OD Webinar: February 2nd, 2023