Building a Spreadsheet Forecasting Model – eLearning
This activity is published by accountingcpd.
All year round, and on every accountingcpd purchase you make, get 10% off as a CA ANZ member. Just use code CAANZ101.
Please note you will be directed to accountingcpd to purchase this product.
This course explains how to build and operate spreadsheets for forecasting, planning and business models. It’s a practical guide, which takes a step-by-step approach to building, utilising and maintaining models.
This course explains how to build and operate spreadsheets for forecasting, planning and business models. It’s a practical guide, which takes a step-by-step approach to building, utilising and maintaining models.
Upon satisfactory completion of this activity you will be able to:
- Establish the ground rules for building a spreadsheet model, including guiding principles and the core elements.
- Build a model including input data, intermediate calculation and output data.
- Put together an executive summary of your model along with any appendices necessary.
- Use a range of different techniques to assess the impact of potential changes in inputs or variables.
Benefits:
This course arms you with the knowledge and skills you need to be able to apply a structured approach to modelling, undertake scenario planning and sensitivity analysis and build a spreadsheet model of your business.
Fellow of the Chartered Institute of Management Accountants. Ross has worked as a consultant and trainer for over 20 years, specialising in process improvement and lean for finance teams.
No prerequisites.
No materials distributed.
No assessments required.
EVENT DETAILS
Topic: Corporate Finance
Sub-Topic: Business Planning & Analysis, Financial Modelling
Format: eLearning
Proficiency Level: Intermediate
CPD: Upto 4 hours