top of page
Background FMOD Logo-02.png
FMOD Logo

Partner

Sum Product Logo

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.

HRLM image.jpg

NOVEMBER 2024

BRISBANE

12-13

SYDNEY

19-20

PERTH

25-26

MELBOURNE

28-29

Liam Bastick

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.

 

Background FMOD Logo-02.png

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):

Learn the essential principles of the CRaFT methodology to ensure your models are robust, clear, and accurate.

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.

3D illustration of blocks in a blockchai

If your role relies upon having accurate, timely and effective financial models, then this course is for you.

DTNZ Print-129.jpg
quotes

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

quotes

I wish someone had shown me this when I first started modelling.

Senior Manager, Big Four Australian Bank 

quotes

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

bottom of page