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 & 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. Form and function are both critical to ensuring you can handle quick changes and information requests when you’re working on a live transaction.
Learning Objectives
• Properly structuring a model to run different scenarios
• Analyze key metrics using data tables
• Making the outputs presentation-ready
Major Topics
• Introduction, scenario vs sensitivity
• Why perform sensitivity analysis
•
• how to enhance financial modeling and analysis
• Scenario analysis in Excel
• structure, setup and CHOOSE function
• Sensitivity model integration
• direct and Indirect methods, data tables
• Analyzing results
• sorting and organizing the data
• Gravity sort table
• using LARGE and SMALL functions in Excel to auto-sort
• Tornado charts
• a visual representation of the results
• Presenting results
• making the output presentation ready
