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

Green Finance & Infrastructure: Transitioning Our World To Better Environments?

July 29th, 2021
OD Webinar: July 29th, 2021

10 Years of FLN: What Is the Future of the Built Environment?

July 8th, 2021
OD Webinar: July 8th, 2021

Sustainable Investment: ESG Implementation Barriers and Opportunities in North America

July 1st, 2021
OD Webinar: July 1st, 2021

Energy Transitions in Asia Pacific

June 29th, 2021
OD Webinar: June 29th, 2021