Course Overview

3-Statement Modelling is for participants who need an introduction to financial modelling as it leverages both corporate finance and cash flow concepts to cover a wide variety of needs to develop core modelling skills.

Course Objectives

This course will cover the general approaches for calculating working capital, income taxes and depreciation, and three of the notoriously more difficult financial concepts to model. With a focus on instructional best practices, this course will teach you how to standardize, simplify and follow a step-by-step process for review management so that you have the tools to feel confident to build models. 

Duration:
 		1.0 day / 8.0 hours
Course level:
 Level II (Intermediate)
Course type: 
 Instructor-led, in-person or virtual.
Prerequisites:
 None.
Who should attend:
 Targeted to those interested in pursuing a career in corporate finance, but will be helpful to anyone using Excel to perform various calculations.
Format: Interactive lecture, participant discussion and hands-on practical.

What you will learn:

  • Where and how to start modelling.
  • Components of the model structure, including the tab order & layout, model schedules, the model audit tab, and periodicity / granularity considerations.
  • How to version control, including input and scenario management.
  • What is modelling revenues such as quantity x price and currency.
  • What is modelling expenses such as (COGS) Cost of Goods Sold, fixed vs. variable, (SG&A) Selling, General, & Administrative.
  • How to apply working capital using days and waterfall methods.
  • A review of income taxes including tax calculations. 
  • What is (PPE) Property, Plant & Equipment such as depreciation of existing and new capital expenditures.
  • A review of financing profiles and structures such as term loans, revolver / operating lines, equity.
  • What is model circularity and the pros and cons of Excel iteration / circuit breakers.
  • What are the types of financial statements including Income Statement, Cash Flow Statement and Balance Sheet.


What you will receive:

  • All the worksheets, checklists, and forms in Microsoft® Excel template format. 
  • Receive detailed feedback on your materials to help improve your output.


You may also be interested in...