Financial modelling - Australia

Presented by the Financial Modelling Institute’s inaugural Lifetime Achievement Award winner for financial modelling, this course tackles the age-old issue of financial modelling head on and breaks down the seemingly complicated process into small segments that are easily digestible. Furthermore, it offers you the ability to learn at your own pace, jumping in and out as and when you like! In financial modelling, it’s important to understand the three primary financial statements: namely, the Income Statement, Balance Sheet and Cash Flow Statement, and their key impacts upon the business decision making process. Only through understanding the core concepts can you avoid the common mistakes that people make when working with these three statements. 

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.