About this course: Sensitivity Analysis for Financial Modeling
This advanced financial modeling course will take a deep dive into sensitivity analysis with focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. It goes step by step through all the formulas and functions required to perform the analysis in Excel from scratch.
Course agenda includes:
- Why perform sensitivity analysis?
- Scenario analysis in Excel
- Model integration – Direct and Indirect methods
- Analyzing results
- Gravity sort table
- Tornado charts
- Presenting results
By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your financial model. Form and function are both critical to ensure you can handle quick changes and information requests when you’re working on a live transaction.
Created by: Corporate Finance Institute
Duration: 30 mins+