Scenario and Sensitivity Analysis in Excel ON DEMAND

Overview

This advanced financial modeling course will teach you how to perform Excel sensitivity analysis with a focus on practical applications for professionals working in investment banking, equity research, financial planning and analysis, and finance functions. The course 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. Form and function are both critical to ensuring you can handle quick changes and information requests when you’re working on a live transaction.

Highlights

How to enhance financial modeling and analysis. Scenario analysis in Excel structure, setup and CHOOSE function. Sensitivity model integration. Analyzing results. Gravity sort table using LARGE and SMALL functions in Excel to auto-sort. Tornado charts. Presenting results.

Prerequisites

Attendees should have a basic understanding of accounting fundamentals, financial modeling, and Excel.

Designed For

CPAs and Business advisors.

Objectives

Properly structuring a model to run different scenarios. Analyze key metrics using data tables. Making the outputs presentation ready.

Preparation

None.

Notice

None.