Sensitivity Analysis for Financial Modeling

$347.00

Full Access Bundle: 21 courses & certificates at $2,000+ value

Course description

This advanced financial modeling course will teach you how to perform sensitivity analysis in Excel with focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions.

Course agenda includes:

Introduction
Why perform sensitivity analysis?
Financial 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 Excel 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.

sensitivity analysis excel

This course is designed based on years of practical experience performing model sensitivity analysis. We use real life templates and examples to teach you how to perform it, step-by-step.

Unlike other courses, ours uses both the direct and direct methods of measuring financial sensitivity - to both operating and financial stresses.

Our sensitivity analysis template can be downloaded at the end of the course and used as an example in your own work.

Reviews (13)

Super

by SUNIL KUMAR SOM

Hi Tim, This is what I always wanted to understand and showcase to my management and seniors. I love the way you link the variables in the indirect method and without actually chaining the inputs the probable results are there. Love from India...

Simple explanation of a more difficult topic

by George Link

The only suggestion I have is when you do the tornado topic the negatives and positives side can differ as it was in my working. Therefore maybe I would suggest instead of using ABS to separate positive and negative side calculation.