Course Report
Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.
Visit Course Report
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