• Home
  • Building a Spreadsheet Forecasting Model – eLearning

Building a Spreadsheet Forecasting Model – eLearning


This activity is published by accountingcpd.

CA ANZ members are entitled to receive 10% off every purchase. Use code CAANZ101 at checkout to take advantage of this discount.

Save $180 and get 20 hours of CPD at your fingertips when you pick ANY 5 4-hr CPD courses for just $495 – use code CAANZ20 at checkout.

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 models using Microsoft Excel.

Content Description:

Modern spreadsheet tools, like Microsoft Excel, make it easy to build a forecasting or business model. The problem is that the formulae can quickly become very complex, and the structure of the model can get very unwieldy. When building a spreadsheet model you may be able to navigate it well enough, but other people will have to use it and may find it impenetrable.


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 models using Microsoft Excel.


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.


No prerequisites.


No materials distributed.


No assessments required.
 


EVENT DETAILS


Topic: Corporate Finance

Sub-Topic: Business Planning & Analysis, Financial Modelling

Format: Self-paced

Proficiency Level: Intermediate

CPD: 4 hours