These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge before enrolling in this course:
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.
This course is highly condensed, and students will learn a lot in a short time. The agenda for this tutorial is:
By the end of this course, you will have a thorough grasp of building a robust sensitivity analysis system into your Excel financial model. Form and function are critical to ensuring you can handle quick changes and information requests while working on a live transaction.
This course is based on years of practical experience performing financial model sensitivity analysis. We use real-life templates and examples to teach you how to perform it step-by-step the way industry veterans do.
Unlike other courses, ours uses both the direct and direct methods of measuring financial sensitivity – and applies those methods to both operating and financial stresses.
Our sensitivity analysis Excel template can be downloaded at the end of the course and used as an example in your work.
For further CPE information, please read before purchasing:
https://corporatefinanceinstitute.com/about/cpe-information/
Level 3
Approx 2.5h to complete
100% online and self-paced
Scenario & Sensitivity Analysis in Excel is part of the Financial Modeling & Valuation Analyst (FMVA)® certification, which includes 38 courses.
7 courses from beginner to intermediate level.
01 Optional11 courses from beginner to intermediate level.
02 Required19 courses at an advanced level.
03 RequiredSubmit your FMVA® checklist and order your certificate.
Get access to the Global Corporate Finance Society.