Laying Out a Financial Model
Dr. Liam Bastick FCA FCMA CGMA MVP
Liam has over 30 years’ experience in financial model development/auditing, valuations, M&A, strategy, training, and consultancy. He has considerable experience in many different sectors (e.g. banking, energy, media, mining, oil and gas, private equity, transport, and utilities). Liam has headed Ernst & Young’s modeling team in Melbourne and was an Assistant Director in their strategic valuations team in London. He was also a senior member of the UK Post Office’s M&A and strategy teams and has worked for/assisted various other Australian modeling companies including BPM, Corality, Navigator Project Finance, PKF, and SumProduct.
He has worked in the UK, Australia, Belgium, Denmark, France, Germany, Hong Kong, Indonesia, Malaysia, New Zealand, Switzerland, and Vietnam, with many internationally recognised clients, constructing and reviewing strategic, operational and valuation models for many high-profile IPOs, LBOs and strategic assignments. He is a regular contributor to the American Institute of Certified Public Accountants (AICPA), the Institute of Chartered Accountants in Australia and New Zealand (CAANZ), Certified Practising Accountants Australia (CPAA), the Chartered Institute of Management Accountants (CIMA), Finance 3.0 and various LinkedIn specialist discussion groups. He is also an experienced facilitator for CAANZ. Liam is a Fellow of the Institute of Chartered Accountants (ICAEW), a Fellow of the Institute of Chartered Management Accountants (CIMA) and is a professional mathematician specialising in a probabilistic/strategic analysis. Liam has been recognised seven times by Microsoft as an Excel Most Valuable Professional in Excel, one of 103 in the world as at the time of writing.
The problem with modeling in Excel is no two spreadsheets look the same. This makes it difficult for end users to understand and modelers to take over others work. This course considers the four key principles required for laying out a good financial model and provides practical tips and tricks to get your spreadsheets on the right track from the very start. The session revolves around building the rudiments for a model from scratch and will provide attendees with a template they may use for future modeling.
This topic relates to building any sort of time series/financial model in Excel, whether it is for documenting historical performance, forecasting or variance analysis.
This session illustrates the pros and cons of designing a financial model. By attending this session, you will
- Understand what is meant by “Best Practice” and whether there is such a thing
- Learn the four key principles of Best Practice modeling using the craft methodology
- Realise why models should be laid out in a particular way
- Appreciate the importance of hyperlinks, styles, error checks and time series
Who Should Attend
Analysts, Accountants, spreadsheets, and management who require a more consistent approach to financial modeling that makes it easier for end users and modelers alike.