Scenario Modelling in Excel Mini-Masterclass (Includes Monte Carlo Simulation)

Описание: This mini-masterclass with Financial Modelling in Excel specialist Danielle Stein Fairhurst shows various techniques for building scenarios into financial models. This session explores how to reduce uncertainty in decision-making with sensitivity and scenario analysis techniques, applying in-built standard spreadsheet tools, and understanding the inputs, assumptions and drivers when creating forecasts. Discussion includes identifying best practices for dealing with the unknown, while utilising several different methods to perform scenario and sensitivity analysis in Excel models with the goal of reducing volatility and mitigating risk.

3:11 What is a financial model?
4:25 Is it a spreadsheet or a financial model?
6:21 What's the difference between sensitivities, scenarios and what-if analysis?
9:35 Manual Scenario selection (Data validation dropdown & Combo box dropdown)
13:10 Scenario Manager
14:27 Data Tables
18:57 Goal Seek (What-if Analysis)
21:01 Advantages and disadvantages of scenario methods
26:58 Statistical background for Monte Carlo simulations
29:52 Building a Monte Carlo (Stochastic) Simulation in Excel

★ Download the Excel file ► https://plumsolutions.com.au/scenario...
★ Learn Financial Modelling ► https://plumsolutions.com.au/elearning/