Financial Modelling: Business Simulation
Did you know Excel can be used to model potential business situations? In this course, you can learn the basics of business simulation in Excel, along with how to create financial models to aid decision making.
£150 +VAT
Financial Modelling: Business Simulation
£150 +VAT
365 days’ access
Financial Modelling: Business Simulation
This course is not currently available. To find out more, please get in touch.
This course will enable you to
- Understand the basics of business simulation in Excel
- Use Excel to create cost-efficient, effective business simulations
- Understand what constitutes good data, and how to properly analyse it
- Learn how to set up queuing simulations, and their importance
- Gain an understanding of financial models and the value they provide
About the course
As accountants, we use Microsoft Excel all the time. But have you ever used Excel to simulate potential real-world business situations? Often, we assume more sophisticated and expensive software is required, but Excel can often be the more cost-effective and efficient choice.
This course takes you through the basics of modelling and business simulation in Excel, and guides you through building some of the illuminating options available to you. It also looks at the importance of collecting good data for analysis and explores how to set up queuing simulations and financial models to aid decision making.
Contents
The basics
What is business simulation?
Business simulation with Excel
The principles of business simulation
Types of business simulation
The dangers of simulations in Excel
Getting started
How to begin
Identifying stakeholders
Agreeing on the question
Planning the data
Using data
Understanding Kali’s Korner
Understanding Bobby Bingo
Better data, better results
Using real data
Returning to Kali’s Korner
“Forecast Sheet” function
Normal distribution
Determining whether data is normally distributed
Examining the characteristics of a data sample
How to show if a set of data is normally distributed
Selecting data using a normal distribution
Understanding the Grange Hotel Restaurant
Queuing and waiting
Simulating queues
Challenges in queuing
Generating random events from a Poisson distribution
Using a Poisson distribution
Understanding Trumpton Town Zoo
Understanding the petting zoo
Understanding the digibox
Financial modelling
Simulation in financial models
Modelling input costs
Qualectro and input cost modelling
Modelling customer demand in a simulation
Using a Poisson distribution to model customer demand
Understanding Qualectro
Understanding the SupaScoota
Final thoughts
Author
Ross Maynard
Ross has worked as a consultant and trainer for over 20 years, specialising in finance processes, management information and performance measurement. He supports organisations to understand their processes; facilitates improvement teams; and supports staff to work together as a team to deliver tangible and sustainable improvements.
16 reviews for Financial Modelling: Business Simulation
You might also like
Take a look at some of our bestselling courses
Joanne Clough –
This course introduced me to a concepts and Excel functions I hadn’t encountered before. The videos explaining the models were excellent.
David Fannon –
Very thorough course but is more than 4 hours. Needs trimming or allocated more credits
Rishi Sharma –
A very relevant course!
Theunis Hugo –
Great course
Peter Barren –
The course used very specific business scenarios and Excel functions – would have liked more general discussion.
Nick Rudderforth –
Very interesting, new ideas i hadn’t experienced before
Tat Ying Mary Chua –
good guidance on creating businss simulation
Wendell Scantlebury –
It was a challenging course, while seemingly simple in theory, a lot of the formulae and underlying assumptions took a while to grasp, but I feel the better for it.
Gillian Sayer –
The only software system we have is a basic Sage. Everything else is managed on excel and I need to increase my knowledge of modelling to use the data more effectively
Amanda Liggins –
Helped me to further develop my business modelling and Excel skills
Syed Nouman Hussain –
It has now enabled me to present more informed analysis of business situations and predictions.
Julian Day –
Uuseful introduction to business simulation, introduced concepts and techniques I was unaware of
Alistair Davis –
I want to develop some cash flow forecasts. This gave me more ideas than expected as well as some very powerful tools to help.
Ann Marie Anderson –
use it frequently
Paul Curtis –
It gave me a better understanding of the capabilities of financial model, however was too in depth for an internet / home study course of 4 hours.
Muhammad Zameer –