-
About The Speaker
Danielle Stein Fairhurst is the author of “Using Excel for Business and Financial Modelling” (3rd edition, 2019) and “Financial Modeling in Excel For Dummies” (2nd edition, 2022). In 2021 she received the Microsoft Most Valuable Professional (MVP) award. Danielle founded the Financial Modellers’ Meetup groups which attracts participants from all over the world as well as a LinkedIn forum with over 55,000 members. An advocate for women in finance, she was on the Diversity Council for the ModelOff Financial Modeling World Championships and founded the Women in Financial Modelling online community. She is a Chartered Financial Modeler (FMI) and holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management (MGSM) and has taught management accounting subjects at Sydney University.
-
Summit Session
Scenario Modelling for better Forecasting in Excel
06th September 2022 | 10:05 to 11:00 hrs – Azerbaijan Time (GMT +4)
Using in-built standard Excel tools, we will explore how to reduce uncertainty in decision-making with sensitivity and scenario analysis. Understanding the inputs, assumptions and drivers when creating forecasts is critical for accurate forward planning. We will discuss the best ways to deal with the unknown and evaluate several different methods to perform scenario and sensitivity analysis in Excel models to reduce volatility in outcomes and mitigate risk. -
Masterclass
Topic : Budget and forecast modelling in Excel
Masterclass Length : 2 days x 4 hours per day
Date : 08th September 2022 & 09th September 2022
Time : 09:00 to 13:30 hrs – Azerbaijan Time (GMT +4)
During the class, participants will build their own capital expenditure forecasting model to bring a practical application to the skills they have learned. The model will include capex spend spend, cashflow and depreciation calculations as well as scenarios and sensitivity testing.
This practical course covers issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques.
✔ Difference between Budgets and Forecasts
✔ How to create your own budget model
✔ Perform what-if analysis
✔ Break-even and budget scenarios
{Click here to register now for masterclass}