Partner
Participants are required to bring a laptop with the latest version of Excel pre-installed.
Course notes, exercises and solutions are included.
As this training is structured, educational and technical
in content, and enhances your ability to do your job, this
training can count towards CPD hours. Please contact
your CPD professional body directly for more details.
NOVEMBER 2024
BRISBANE
12-13
SYDNEY
19-20
PERTH
25-26
MELBOURNE
28-29
Dr. Liam Bastick
Managing Director
SumProduct
Make Your Business Excel
This hands-on training course guides participants through every stage of building a comprehensive financial model. Using an example case study, you’ll learn how to scope and structure the model, define key assumptions, build calculations, and develop fully integrated three-way financial statements.
You will refresh your Excel skills and frame accounting principles within the contexts of finance, budgeting, forecasting, and financial planning and analysis.
You will design a model from scratch, covering every step from layout, scope, and planning to execution. This exercise spans key areas such as revenue modelling, cost of goods sold, operating expenses, capital expenditures, working capital, financing, corporate tax, and basic what-if analysis.
The session will then shift focus to the impact of artificial intelligence (AI) on the field, addressing its current capabilities, debunking common myths, and examining the benefits and challenges of AI, including considerations for efficiency, privacy, confidentiality, and intellectual property.
Course notes, exercises and solutions are included.
LEARNING OBJECTIVES
Master Key Excel Functions and Features:
Understand when and where to apply the most relevant Excel functions and features for effective financial modelling.
Implement the Four Key Concepts of “Best Practice” (CRaFT):
Structure Financial Models in the Optimal Order:
Grasp the importance of building financial models in a specific sequence to enhance accuracy and efficiency.
Achieve Perfectly Balanced Balance Sheets:
Develop techniques to ensure your Balance Sheets balance correctly the first time, every time.
Reconcile Cash Flow Statements with Confidence:
Learn to seamlessly reconcile both direct and indirect Cash Flow Statements within your financial models.
Understand and Utilise Common Modelling Outputs:
Appreciate the value of various common outputs in financial modelling and how to incorporate them effectively.
Navigate the Intersection of Financial Modelling and AI:
Explore the risks and rewards that AI brings to financial forecasting, analysis, and modelling, preparing you for the future of finance.
WHO SHOULD ATTEND
This workshop is aimed at both new and experienced professionals in the finance arena. This course provides attendees with the modelling tools and skills required to make more informed business decisions based upon financial models.
If your role relies upon having accurate, timely and effective financial models, then this course is for you.
There were a lot of practical examples that could be brought into my daily work. Good & clear explanations of difficult concepts...I’m impressed by the instructor’s professionalism & clear explanations of functions that I’ve
never heard of that I could use.
DHL, Singapore
I wish someone had shown me this when I first started modelling.
Senior Manager, Big Four Australian Bank
The coverage of the syllabus and the material is a great fit. A very good introduction to Financial Modelling. The course met my knowledge and expectations perfectly.
CLP Ltd, Hong Kong
Explore the Workshop
