Overview

The problem with modelling in Excel is no two spreadsheets look the same.  This makes it difficult for end users to understand and modellers to take over others work. This session 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 modelling.

By attending this webinar you will:

  • understand what is meant by 'best practice' and whether there is such a thing
  • learn the four key principles of best practice modelling 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

Speaker

Dr. Liam Bastick FCA FCMA CGMA MVP 

Managing director of boutique modelling firm SumProduct, Liam is the author of An Introduction to Financial Modelling and has over 30 years’ experience in financial model development / auditing, valuations, M&A, strategy, training and consultancy. He is a senior accountant and professional mathematician who has worked with and trained accountants, bankers and analysts all over the world.

Liam has been recognised seven times by Microsoft as an 'Excel Most Valuable Professional in Excel', one of 84 in the world as at the time of writing.