Financial modelling

Led by Liam Bastick, the Financial Modelling Institute's inaugural Lifetime Achievement Award recipient for financial modelling, Fellow Chartered Accountant, and Fellow Chartered Management Accountant, this course demystifies financial modelling by breaking complex concepts into practical, easy-to-follow modules.

Designed for flexible, self-paced learning, you can progress through the content at a time and pace that suits you.

A strong understanding of the three core financial statements, the Income Statement, Balance Sheet, and Cash Flow Statement, is fundamental to effective financial modelling and informed business decision-making. This course explores how these statements interact, highlights their impact on business performance, and helps you avoid the common mistakes often made when working with financial data. By mastering these core concepts, you'll build a solid foundation for creating accurate and reliable financial models.

This course also offers flexibility in learning methods, presenting key knowledge points in interactive slides, for the hands-on learner, or presenting the same knowledge points in videos for the visual learner. 

Starting with a blank Excel workbook in the beginning of the course, you work through the course and develop a small, straightforward model that enables our methods to be demonstrated readily and practiced comprehensively. Break down the complicated financial modelling process into bite sized, digestible chunks to be consumed at your own pace! At the end of this course, users will have built a complete set of financial statements and will be able to repeat this process when building their own models, including knowledge of the importance of error checks and sensitivity / scenario analyses. 
 
Learning outcomes

Introducing Best Practice modelling through the acronym CRaFT 

Develop a straightforward approach that can be employed again for future financial modelling projects 

Balance the Balance Sheet first time every time 

Reconcile the direct and indirect Cash Flow Statements in seconds 

Learn to avoid common mistakes. 

Conditional formatting 

Data validation 

Key functions, including why VLOOKUP is not as good as you think it is, and combinations you should master.