Building Financial Models With Scenario And Sensitivity Analysis
Event Information
About this Event
Date: 4 August 2020
Time: 12:00 – 16:00 BST
Topic: Building Financial Models with Scenario and Sensitivity Analysis: financial prosperity / financial crash
Instructor: Tatiana Ufimtceva, Founder and CEO, keySkillset
Masterclass Description:
During this half day Masterclass you will build a valuation model for a real company using 10-K and other financial information. After completing a valuation model, you will develop scenario analysis to evaluate possible future events for the company: from the most positive scenario (financial prosperity) to the most negative one (financial crash). In addition to that, you will build sensitivity analysis to complete the evaluation picture of the scenarios variety. Over the course of this masterclass, you will learn useful Excel tricks necessary for scenario analysis functions (such as OFFSET, INDEX, CHOOSE and more), what-if analysis with data tables and conditional formatting in Excel, as well as, some other valuable financial modelling tricks in Microsoft Excel.
Key Takeaways:
- Building a simple financial model for the real company using 10-K and other financial information.
- Building Scenario Analysis for the company (base/positive/negative) using OFFSET, INDEX, CHOOSE and other Excel functions.
- Sensitivity Analysis in Excel: data tables, conditional formatting and more.
- Speeding Excel tricks, such as useful shortcuts and efficient approaches.
