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

Recent ESG Trends in European Infrastructure

OD Webinar: May 12th, 2022

Powering Data Centres in Asia

OD Webinar: May 12th, 2022

Africa's Rail Poised For Growth

OD Webinar: May 9th, 2022

Building Blocks of a Project - EP 1 | Insurance

OD Webinar: April 20th, 2022