Scenario & Sensitivity Analysis in Excel

$97.00
Enroll Now Free Preview

Intermediate level

Approx 2.5 to complete

100% online and self-paced

Upgrade

From $847.00
FMVA Full Immersion
Buy Now
From $497.00
FMVA Self Study
Buy Now

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

Get the course in a bundle

Scenario & Sensitivity Analysis in Excel

Financial Modeling & Valuation Analyst (FMVA)® Certification
Starts at $497
Learn More
  • All 32 FMVA® courses
  • Skills Learned Financial Modeling and Valuation, Sensitivity Analysis, Strategy
  • Career Prep Investment Banking and Equity Research, FP&A, Corporate Development
Starts at $497
Learn More

Path To Certification

Prerequisite Courses

8 courses from beginner to intermediate level.

01Optional

Core Courses

12 courses from beginner to intermediate level.

02Required

Elective Courses

Take 3 out of 13 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.
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

Scenario & Sensitivity Analysis in Excel
This course is very useful. I recommend it to every one!

Mohammad Bashar Al Barini

Highly Recommended
A detailed breakdown of one of the most important component of financial modeling and decision making. I enjoyed all the contents of the course. Highly recommended!

AYINDE Wasiu

Amazing course
The course is extremely helpful and practical. The skills learnt can be immediately put into practice.

Yordan Kanchev, FCCA

Challenging
I'M LEARNING A LOT!

Mark Morse

See More

Frequently Asked Questions

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?
Are there any additional fees or costs?
What currency are your courses priced in?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
More Questions?