Module 1: Introduction 1. Course introduction Free Preview 2. Learning objectives 3. Downloadable files 4. Scenario analysis vs sensitivity analysis Free Preview 5. Interactive exercise 1 Free PreviewModule 2: Scenario Analysis 1. Why perform scenario analysis? 2. Model layout and overview Free Preview 3. Designing the structure for scenarios 4. Creating switch for live case 5. Using CHOOSE function to build scenarios 6. Testing and analyzing the scenarios Free Preview 7. Preparing for sensitivity analysis 8. Interactive exercise 2Module 3: Sensitivity Analysis - Model Integration 1. Why perform sensitivity analysis? 2. Overview of integration methods Free Preview 3. Direct method Free Preview 4. Setting up the data table 5. Linking the data table 6. Indirect method 7. Setting up the data tables 8. Linking the data tables 9. Interactive exercise 3Module 4: Sensitivity Analysis - Analyzing & Presenting Results 1. Analyzing results 2. Gravity sort overview 3. Gravity sort linkup Free Preview 4. Tornado chart overview 5. Tornado chart linkup 6. Presenting results 7. Interactive exercise 4Module 5: Completed Model 1. Sensitivity analysis wrap up 2. Download completed sensitivity model 3. Summary Free PreviewModule 6: Qualified Assessment 1. Qualified assessment 2. Share Your Feedback 3. Course Completion

Get flat 10% off  on CFI's all-access subscription plans

English

United States dollar

This course will help you perform Excel sensitivity analysis. It focuses on the practical application of this technique for financial professionals in financial banking, equity research and finance. This tutorial walks you through the entire process of creating an Excel analysis.

Mohammad Bashar Al Barini

Ayinde Wasiu

Yordan Kanchev, FCCA

Mark Morse

Learn "Scenario & Sensitivity Analysis in Excel" "Certification" by "Corporate Finance Institute (CFI)" and upskill your career by acquiring skills like Financial Management etc with Careervira.

Scenario & Sensitivity Analysis in Excel

Scenario & Sensitivity Analysis in Excel

Description

Features

Duration

Skills

Learning Goals

Course Content

Target Audience

Instructors

Mohammad Bashar Al Barini

Ayinde Wasiu

Yordan Kanchev, FCCA

Mark Morse

FAQs

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?

Will these courses help me advance my career?

Can I email the instructor if I have questions?

What is the price of the subscription?

What is included in the subscription?

More Questions?

₹3,018