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.
Starting to forecast the P&L from key assumptions
Completing the balance sheet
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.
Please note enrolments close 2 working days prior to the workshop date. Please enrol at least 3 working days prior to the workshop to ensure any dietary and special requirements can be accommodated.
Looking for a customised learning solution for your organisation or team? Contact us today to discuss in-house learning options.