Building a Spreadsheet Forecasting Model

Summary

This course explains how to build and operate spreadsheets for forecasting planning and business models. Its a practical guide, which takes a step-by-step approach to building models using Microsoft Excel.

This course is provided by a third party provider accountingcpd.net and the fee charged is exclusive of VAT.  Training tickets are not applicable on this product. 

Venue details:  
Online, ,
Start date & time:  
01 January 2019 00:00
End date & time:  
01 January 2022 00:00
Price: €85.00  (€85.00 Member price)
By registering for this course you have accepted the terms and conditions
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
Finance, management reporting and analysis

This course explains how to build and operate spreadsheets for forecasting planning and business models. Its a practical guide, which takes a step-by-step approach to building models using Microsoft Excel.

Course overview 

Foundations of spreadsheet models

  • What are the guiding principles of spreadsheet model building?
  • What are the key elements in a spreadsheet model?
  • How do we structure the spreadsheet?
  • What is the purpose and scope of the model?
  • What are the definitions, assumptions and sources of data?
  • How do we achieve version control?

Building the model

  • How do we input data?
  • What are the intermediate calculations?
  • What is the core model?
  • What is the output data sheet?
  • What about the executive summary?
  • What goes into the appendices and user guide?

Scenario planning and sensitivity analysis

  • How do we look at what-ifs and sensitivity analysis?
  • What does the sensitivity analysis for our example cashflow forecast look like?
  • What about scenario planning?
  • How can we use the model for decision making?
  • How do we present the outputs of the model?

Building a spreadsheet model of your business

  • What are the key principles of building the business?
  • What is the structure of the business model?
  • What about revenue streams?
  • How do we plan and make decisions using the business model?
  • How do we maintain the business model?