Northside College
IntermediateEnglish

Financial Modelling in Excel

Build a three statement model that ties out

DITaught by Deepa Iyer

4.0(1 review)

17 enrolled

About this course

A model that does not tie out is worse than no model, because someone will believe it. This course builds a three statement model from a blank workbook to a working forecast, and spends as much time on checking it as on building it.

The worked example is a mid sized manufacturer with seasonal working capital, a term loan and a revolver, which is where most templates quit and real businesses begin.

Curriculum

15 lessons, 5m total

1 lesson is free to preview.

  1. 01Before you build

    3 lessons, 1m

    1. What a model is for, and what it is not0:20
    2. Reading the filings you will model from0:20
    3. Workbook structure and colour conventions0:20

  2. 02The income statement

    3 lessons, 1m

    1. Revenue build: volume and price, not a growth rate0:20
    2. Cost of sales and gross margin0:20
    3. Operating expenses that scale and those that do not0:20

  3. 03Working capital and the balance sheet

    3 lessons, 1m

    1. Days based working capital drivers0:20
    2. Fixed assets, capex and depreciation schedules0:20
    3. Making the balance sheet balance0:20

  4. 04Debt, cash and circularity

    3 lessons, 1m

    1. The cash flow statement as a bridge0:20
    2. Revolver logic without a circular reference0:20
    3. Interest on average balances, and when to bother0:20

  5. 05Checking and presenting

    3 lessons, 1m

    1. Error checks that catch real mistakes0:20
    2. Scenarios and sensitivity tables0:20
    3. Handing the model to someone else0:20
Financial Modelling in Excel | Northside College