Scenario & Sensitivity Analysis in Excel

Subscribe

Intermediate level

Approx 2.50h to complete

100% online and self-paced

Subscribe to get access to FMVA® and other programs

From $497/year

Learn More

Overview

Recommended Prep Courses

These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:

  1. Building a 3 Statement Financial Model
  2. Business Valuation Modeling

Scenario and sensitivity analysis course overview

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.


Scenario and sensitivity analysis course overview


What will I learn about Excel sensitivity analysis?

This course is highly condensed and students will learn a lot in a short time.  The agenda for this tutorial is:

  • 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

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.


Excel sensitivity analysis course example


Why take this Excel sensitivity analysis course?

This course is designed 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 own work.

For further CPE information, please read before purchasing:

https://corporatefinanceinstitute.com/about/cpe-information/


sensitivity analysis excel and scenario analysis example

Become a certified Financial Modeling & Valuation Analyst (FMVA)®

Scenario & Sensitivity Analysis in Excel is part of the Financial Modeling & Valuation Analyst (FMVA)® certification, which includes 30 courses.

Financial Modeling & Valuation Analyst (FMVA)® Certification
  • Skills Learned Financial Modeling and Valuation, Sensitivity Analysis, Strategy
  • Career Prep Investment Banking and Equity Research, FP&A, Corporate Development

Path To Certification

Prerequisite Courses

7 courses from beginner to intermediate level.

01Optional

Core Courses

11 courses from beginner to intermediate level.

02Required

Elective Courses

Take 3 out of 11 courses at an advanced level.

03Required

Get Certified

Submit your FMVA® checklist and order your certificate.

04Required

Join Our Community

Get access to the Global Corporate Finance Society.

05Optional

How the Certification Works

FMVA® Financial Analyst Certification courses are offered 100% online, allowing you the flexibility to start the financial analyst program anytime and learn when it’s most convenient for you.

The program is a part of the All Access Subscription, which includes all programs and courses.

CFI courses are designed by instructors with over 21 years of financial analyst training experience.

Students must complete all core and elective courses (14 in total) and demonstrate mastery of the topics through successful completion of course materials, quizzes, and assessments.
Within 48 hours of program completion, your Blockchain Verified FMVA Certification will be emailed to you.

What Our Students Say

Financial Risk Analyst
Excellent!

Vinodh Kumar Soundararajan

Scenario & Sensitivity Analysis in Excel
Excellent Course !

KOFFI ASSOUMAN EUDES BEDEL

CFI -FMVA
Would highly recommend this course to anyone willing to advance their skill-set in financial modeling and valuation analysis in Finance and investment Industry, comparing to CFA I personally found out that CFA is time-consuming and more theoretical after CFA you feel you still need some practical course for your Career, unlike CFI-FMVA provides great immense and valuable and practical knowledge in financial modeling, excel , budgeting & forecasting, strategy, presentation, accounting, and investment and business valuation, because of all that great combination the most distinguished about this certificate is you will become a confident a world-Class Financial Analyst.

Zuhur Jaralah

Very detailed explanation
The tornado chart is super useful

Jared Blum

See More

Frequently Asked Questions

How do I enroll in this course?
Are there any additional fees or costs?
What currency are your courses priced in?
Can I download the Excel files and financial modeling templates for the course?
How long do I have to complete the courses?
Are CFI courses officially accredited?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
What is included in the subscription?
More Questions?