Financial Modelling: Business Simulation

This activity is published by accountingcpd.

All year round, and on every accountingcpd purchase you make, get 10% off as a CA ANZ member. Just use code CAANZ101.

Please note you will be directed to accountingcpd to purchase this product.

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.

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.

• The basics
• Getting Started
• Better data, better results
• Queuing and waiting
• Financial modelling

Upon satisfactory completion of this activity, you will be able 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

After completing the course, you will be able to learn business simulation in Excel and understand financial models as well as the value they provide.

Self-spaced learning

Ross Maynard

Fellow of the Chartered Institute of Management Accountants. Ross has worked as a consultant and trainer for over 20 years, specialising in process improvement and lean for finance teams.



Topic: Business Mindset, Corporate Finance

Sub-Topic: Financial Modelling, Information & Communication Technology

Format: eLearning

Proficiency Level: Intermediate, Advanced

CPD: Upto 4 hours