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

Venue details:  
Online EU, ,
Start date & time:  
01 January 2019 00:00
End date & time:  
01 January 2022 00:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
Strategic finance and management reporting

Booking with a Training Ticket

Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed

Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification

Course Overview

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.

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?