Sensitivity Analysis in Excel - Financial Modeling

[Level 3] How to perform sensitivity analysis in Excel for FP&A, investment banking and equity research | taught by Tim Vipond
$347.00
FULL ACCESS Bundle - 18 courses and certificates worth over $1,800+ value. Financial modeling, valuation, analysis and more.

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 Course


sensitivity analysis example


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.

Read More

Instructor

Tim Vipond
Tim Vipond
Senior Instructor, Principal, Mathers Pacific Capital

Since 2005 Tim has been an active participant in capital markets across a wide range of industries and transactions including mergers, acquisitions, divestitures, and capital raising totaling more than $3 billion in aggregate value.

Tim has a broad range of experience that includes:

  • Investment banking
  • Wealth management
  • Corporate development
  • Strategy
  • Investor relations
  • Financial planning & analysis (FP&A)

In 2014 Tim founded Mathers Pacific Capital to bridge the gap between theory and practice by offering financial modeling and valuation courses to undergraduate and MBA students. Mathers Pacific also offers transaction advisory services to mid-market private companies and has advised on several M&A transactions, management buyouts, and capital raises.

Tim has an M.B.A. from the Sauder School of Business and a B.A. from Dartmouth College.

Reviews (9)

Sensitivity analysis

by Teka Derick Tikum
Awesome course and vital for dynamic models and clearly understanding how our constructed financial models and valuation analysis with respond to future changing variables. Was awesome! Recommend this CFI course to professionals.

Excellent course

by Barbara Alvarez
This is an excellent course! Advance financial modeling easy to follow and everything you need to know about sensitivity analysis. Very practical applications. Highly recommended for all finance professionals.

Good template

by Rustom Rupand
This was totally worth the time I like how the outputs are displayed in charts/graphs and definitely use the template in the future. Some parts are complicated but overall a very good course!
Read more

Sensitivity analysis

by Teka Derick Tikum
Awesome course and vital for dynamic models and clearly understanding how our constructed financial models and valuation analysis with respond to future changing variables. Was awesome! Recommend this CFI course to professionals.

by brian millen

by Robert Jackson

by Aarav Singh

Excellent course

by Barbara Alvarez
This is an excellent course! Advance financial modeling easy to follow and everything you need to know about sensitivity analysis. Very practical applications. Highly recommended for all finance professionals.

by Fraser Pogue

Great chats and outputs

by Cara Nowen

Good template

by Rustom Rupand
This was totally worth the time I like how the outputs are displayed in charts/graphs and definitely use the template in the future. Some parts are complicated but overall a very good course!

Very detailed explanation

by Jared Blum
The tornado chart is super useful