Scenario & Sensitivity Analysis

Course Code: IEF-1153
Course Instructor: Elvis Cornerstone
Category: Financial Modelling
Credit Hours: 18
Course Duration: 5 Days
Cost: $1,000.00

Course Overview

Time changes, and successful businesses should be able to respond to economic turbulence or when the business environment is functioning as powerfully and effectively as possible.

A financial model is a great way to assess the performance of a business on both a historical and projected basis. It is critical to have a linked 3-Statement Financial Model in Excel before beginning either type of analysis. A linked model will dynamically show how your assumptions affect your financial statements. It provides a way for the analyst to organize a business’s operations and analyze the results in both a “time-series” format (measuring the company’s performance against itself over time) and a “cross-sectional” format (measuring the company’s performance against industry peers).

This Scenario and Sensitivity in Financial modelling course will offer examples of both Sensitivity Analysis and Scenario Analysis, explanations of each type, when it should be used, and the advantages of each. The programme is also designed to teach you how to perform Excel sensitivity analysis with a focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions.  The tutorial goes step by step through all the formulas and functions required to perform the analysis in Excel from scratch.

By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your Excel financial model that can be used in corporate finance, investment banking, commercial banking, and portfolio management.


Find a programme


Course Content

This training programme will test the examining and analytical abilities of participants to see how you can adjust your forecast to economic conditions in this selection. The programme curriculum will help participants to:

» Understand the difference between Sensitivity analysis and Scenario Analysis in personal and corporate finance.

» Know why and when to perform these analyses and how to enhance financial modelling.

» Identify strategies to respond to unprecedented levels of uncertainty for almost all businesses.

» Learn how to structure your analysis to reflect today’s challenging business environment to give you the strongest possible planning foundation.

» Discover how to consider a range of possible scenarios to optimize the process.


Find a programme


Key Takeaways


By the end of the course, participants will be able to:

» Make challenging decisions and implement changes swiftly in order to mitigate near-term risk and drive long-term continuity.

» Use scenario analysis to create a much more dynamic and robust financial model.

» Provide business leaders with insights on various outcomes and assist them in planning and dealing with uncertainty.

» Incorporate a structured process for sensitivity and scenario analysis into a financial model built by someone else.

» Extract the key outputs required to assess the risk in a proposed investment or credit.

» Use sensitivity analysis to ensure that the underlying financial model responds in a commercially sensible way to changes in assumptions.


Find a programme


Target Audience


Financial analysts, Business analysts, Venture capitalists, Private Equity professionals, Startup entrepreneurs, Equity Analysts, Finance Managers, Investment Bankers and Business students.


Find a programme


Register Now


Book your place

*We do not send spam emails.


Find a programme