What you'll learn:
- Understand What Is Scenario Analysis in Business Context
- Explain When Scenario Analyses Can be Used
- Learn Implementing Scenario Analyses Using Microsoft Excel
- Learn How to Calculate Profit and Costs Including Fixed and Variable Costs
- Learn How to Use Data Table, Goal Seek, and Solver Commands in Excel
- Learn the Steps of Scenario Analyses
In this course three goals are pursued:1- Learning Scenario Analysis and it's technics including but limited to Monte Carlo Simulation 2- Learning Microsoft Excel's scenario Analysis tools 3- and learning business analytics formula and parameters that are applicable in all business contexts and are essential for anyone involved in business, economics, and finance.
Scenario Analysis is a powerful planning and management technic to deal with various possible futures and make sure to achieve an acceptable outcome under different scenarios. This technic is used in business, finance, economics, politics, negotiations, and even military operations. The main argument of this technic is that when outlining a plan, our assumptions can change due to unpredicted events and therefore the outcomes can change. For this reasons, we need to count in different scenarios (through changes in assumptions) and study their impact on the outcomes. Essentially, scenario analysis is a method of dealing with randomness in life.
An advance technic of dealing with randomness is called Monte Carlo Simulation, which uses random sampling to predict and forecast future outcomes under numerous random scenarios. In this course, students will learn this powerful technic and learn how to implement a sample Monte Carlo Simulation using Microsoft Excel creatively. Also, Microsoft Excel Provides various powerful tools for scenario analysis including Goal Seek, Data Tables, Scenario Manager, and Solver.
In this course after learning the Scenario Analysis concept and applications, students first learn how to analyze and calculate profit and cost (including fixed and variable cost), how to calculate the Break Even volume, and how to form an Income Statement using Microsoft Excel. While calculating these important business metrics, students learn how to set up excel sheets to be ready for further scenario analyses. Then using excel tools such as Goal Seek, Data Table, and Solver, students implement some scenario analyses to achieve certain desired outcomes. Monte Carlo Simulation is offered at the end of the course as an advanced bonus for curious minds.
About the Instructor:
My name is Mohammad Habibi. I have a Ph.D. in business and have taught in various programs including undergrad and graduate (MBA) courses in different parts of the world such as US, Canada, Malaysia, and Iran. My teaching style is quick and to the point and I believe learning will occur while doing. If you have any questions please send me an email or connect with through LinkedIn.
