Modelling Professional Series

Solutions

Business Modelling Professional Series

Training solutions

From best practice modelling principles to in-depth financial modelling methodology, Deloitte can provide the training you need to master your financial and economic model build capability.

Tailored solutions

Deloitte offers comprehensive training on all aspects related to building high quality, robust excel models. From best practice modelling principles to in-depth financial modelling methodology, we can provide the training you need to master your financial and economic model building. Leveraging our broad experience providing modelling solutions to clients, we understand the techniques and insights needed by you. Whether you simply need to understand your existing models, improve and enhance those models or effectively building new models, we can provide the training to suit your needs.

It is important to understand the best approach to building models. Well thought out, appropriately designed models utilising best practice techniques result in robust models that can handle varying factors require less rework under changing circumstances and aid in the understanding of the model logic and mechanics by model users.

Courses are offered across Australia on a regular basis and we offer training to groups and individuals, with group bookings being able to be tailored to suit the group requirements. Courses on offer are descibed below. To express your interest in attending or if you wish to obtain further information on any of the training services we offer please contact us and one of our training specialists will be in touch.

Expression of interest

Register your interest here
Modelling best practice principles and application

This course will provide you with an in-depth understanding of modelling best practice principles, why they should be adhered to and what tools are available to assist in applying these principles. You will learn how to identify issues in models using Spreadsheet Detective, how to record and report these issues and how to correct for model errors or implement model changes according to modelling best practice principles. Through this process, you will improve your overall understanding of model design fundamentals and your ability to evaluate models effectively.

Modelling best practice principles and application
A practical guide to building versatile financial models

This course is designed to guide participants in the considerations to be given when building a financial model. It covers the entire model build life cycle from planning to output. You will learn the fundamental considerations when planning your model, how to undertake key financial calculations including depreciation, tax and working capital, and essential outputs including three way fundamentals, project metrics and sensitivity analysis.

A practical guide to building versatile financial models
A practical guide to building versatile operational models

This course is designed to guide participants in the considerations to be given when building an operational model. It covers the entire model build lifecycle from planning to output. You will learn the considerations needed to be given when developing an operational model to be used for ongoing business planning purposes. Key topics include structuring a model with budget, actuals and forecasts with rollover functionality, consideration of linkages to information sources and manual adjustments, and development of key outputs including variance analysis and KPI reporting.

A practical guide to building versatile operational models
Financing of transactions

This course will increase your understanding of the funding considerations for different types of transactions. We will cover the components required in a typical financing of transactions model, the treatment of different financing types, fundamental debt, equity and earnings calculations, and key debt ratios.

Financing of transactions
Introduction to VBA programming in Excel

This course provides you with the essentials to build macros into your excel models. Macros are commonly used to simplify and automate processes and procedures in a model, including data recording, data manipulation and scenario analysis. Using case studies, you will learn how to build a macro from scratch covering some commonly used macros, understand the risks of VBA and learn how to debug and test your macro.

Introduction to VBA programming in Excel
Project finance

This course will equip you with the understanding of the considerations to be given when projecting cash flows for an infrastructure project. Using a case study, we will look at the key considerations in developing a project finance model (including project financing structures, the payment mechanism, sources of funds, cash waterfall and reserve accounts), operating project finance models (including developing scenarios, debt sizing and evaluating project returns), and sensitivity analysis (stress testing and credit risk analysis).  

Contact us for more information

Contact us

Sarah McAlister-Smiley

Sarah McAlister-Smiley

Partner, Financial advisory

Sarah leads Deloitte Business Modelling in Queensland with experience in economic and financial modelling, forecasting, financial analysis and business case development. Sarah’s expertise is buttresse... More