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



Course Highlights

USD 660

1) Start from first principles

Begin with an exploration of the Income Statement, Cash flow Statement and Balance Sheet. Each line item in all three statements is discussed along with the key linkages between the financial statements. Understanding is reinforced through discussion of accounting concepts and use of detailed
examples that clarify topics such as different methods of calculating tax and accounting depreciation, valuing inventory, calculation of current and deferred taxes, direct and indirect methods of calculating operating cash flow etc. Implications for modelling are flagged throughout the discussion.

2) Learn about modelling best practice

Next explore modelling best practice including how to:

  • set up your model structure so that it is easy to understand
  • build consistency into your worksheets to avoid errors
  • input model assumptions in a way that allows the flexibility to carry out sensitivity and scenario analysis
  • use cell formatting for clarity
  • build in “Error Checks” that flag errors at each step through the modelling process
  • avoid formulae that are hard to understand
  • use clear number conventions to avoid errors
  • avoid risky practices such as the use of hard coding

3) Improve your Excel skills

While the Course assumes a familiarity with basic Excel operations, improve your efficiency and productivity by learning more about:

  • Excel Functions
  • Excel Keyboard Tips
  • Excel Shortcuts
  • Different types of Excel Error Messages and how to fix them
  • Using Excel Cell Styles for formatting
  • Using Conditional Formatting to highlight errors

4) Leverage multi-media to learn key concepts

Engage with animated diagrams, screenshots and video content to
understand concepts visually. Review as many times as required.

5) Follow step by step instructions

View screenshots with step by step instructions. Watch videos that bring it all together and download pdf “Notes” for future reference. Check your work against completed spreadsheets at each step along the way.

6) Learn about key management ratios

Learn about the four categories of management ratios, their uses and their weaknesses. Learn to model them on your spreadsheet.

  • Liquidity Ratios e.g. Current Ratio, Quick Ratio
  • Profitability Ratio e.g. Gross Margin, Operating Margin
  • Efficiency Ratios e.g. ROA, ROE and ROCE
  • Leverage Ratios e.g. Debt-Equity Ratio, Capitalisation Ratio

7) Learn how to carry out various types of analyses

Learn how to setup your model for Sensitivity Analysis and identify key risk factors. Learn how to setup for and carry out Scenario Analysis. Learn how and when to use a Change Log.

Who should take this Course?