Course Features
Duration
3 hours
Delivery Method
Online
Available on
Limited Access
Accessibility
Desktop, Laptop
Language
English
Subtitles
English
Level
Intermediate
Teaching Type
Self Paced
Video Content
3 hours
Course Description
Course Overview
Personlized Teaching
Case Based Learning
Post Course Interactions
Case Studies,Instructor-Moderated Discussions
Skills You Will Gain
What You Will Learn
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
Target Students
This monthly cash flow modeling course is critical for anyone working in Financial Planning & Analysis (FP&A), accounting, or finance departments and is required to build monthly financial models in their job