Three statement financial modelling in Excel - Workshop 2017

This workshop will teach you how to build a three statement financial forecasting model from scratch. At the end of this course, you will know how to gather information from a variety of sources to create an effective financial model to assist in planning, budgeting and making optimal business decisions. 

During the workshop you will work using a true to life dataset. Starting from a blank Excel spreadsheet, you will create a full set of forecast financial statements and a comprehensive financial model for your business which is pliable, sustainable and repeatable.

This course considers how business change might be incorporated in company analysis and includes detailed coverage of Excel functions that are both essential in financial modelling. Attendees can then choose a modelling scenario to see how the business performs under stress and how changing key financial measures will affect the business.

Click on the image below for Marcus Small's biography.

Key topics:

Starting to forecast the P&L from key assumptions

  • Key drivers for modelling
  • Key ratios driving the forecast
  • Drivers on revenues
  • Drivers on costs
  • Sources of data

Completing the balance sheet

  • Drivers for balance sheet items
  • Which creditors can we stretch, and by how much?
  • Forecasting the balance sheet
  • Impacts on cash flow
  • Is growth good?
  • Linking to other statements
  • Balancing the balance sheet

Cash flow

  • Modelling the cash flow statement
  • Key linkages to other statements
  • Presenting the cash flow statement

Learning objectives

  • Forecast an income statement
  • Complete a balance sheet
  • Model and present a cash flow statement

Audience

This workshop is designed specifically for finance and accounting professionals who use Excel in their day to day roles.

Participants will gain the maximum benefit from this course if they are already competent spreadsheets users. The course is designed for people who use Excel on a regular basis, and are comfortable with using its tools and functions.

Please bring a USB.

 

Looking for a customised learning solution for your organisation or team? Contact us today to discuss in-house learning options.

1 day

loading...