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

Asian Project Financing Solutions in the New Normal

OD Webinar: February 24th, 2021

Going Green – Driving Sustainable Outcomes in Infrastructure Finance

OD Webinar: February 19th, 2021

Sustainability in Ireland: Build Back Braver

OD Webinar: February 4th, 2021

Digital: The New Core Infrastructure?

OD Webinar: February 3rd, 2021