Modelling Financial Statements

Leverage the power of multi-media to see the interlinkages

Modelling Financial Statements

Modelling Financial Statements is a comprehensive web based Course designed for practitioners.  It takes the user step by step through the process of modelling an integrated 3 statement financial model i.e. incorporating the Income Statement, the Cash flow Statement and the Balance Sheet.  The course contains cell by cell instructions and a video demonstration of each step.

Starting from a clean spreadsheet, the user learns to analyse historical trends, identify key “Drivers”, seek additional information and make defensible model assumptions. Next, the user learns how to accurately and efficiently convert the model assumptions into an integrated set of pro-forma financial statements.

Each core module covers

  • Forecasting Methods
  • Model Assumptions
  • Cell by cell modelling instructions
  • Demonstration Video
  • “Check” spreadsheets to verify work completed
  • Detailed notes as an on-going reference

The Course also covers core accounting concepts relating to the three financial statements, a discussion of key management ratios and provides instructions for using the model to carry out different types of analyses

 

 

Who should take this Course?