Building a Spreadsheet Forecasting Model

ideas2action

• Building a Spreadsheet Forecasting Model 1:50:26

  • 1: Principles of Spreadsheet Model Building 07:45
  • 2: The Key Elements in a Spreadsheet Model 08:10
  • 3: Definitions, Assumptions and Sources of Data 13:38
  • 4: Exercise Model Foundations 03:22
  • 5: Building the Spreadsheet Model Input Data 06:12
  • 6: Building the Model: Intermediate Calculations 04:00
  • 7: Building the Core Model 08:08
  • 8: Output Data and the Executive Summary 08:22
  • 9: Exercise: Reviewing a Model 02:55
  • 10: Sensitivity Analysis 15:36
  • 11: Building a Spreadsheet Model of Your Business 16:44
  • 12: Planning and Decision-Making Using the Business Model 08:13
  • 13: Presenting the Outputs of your Spreadsheet Model 07:21

A good spreadsheet model tells a story – it has a beginning, a middle, and an end. The model needs to be easy to understand, so that non-experts can see how changes in variables affect the model and can take ownership of it. Equally importantly, if the person who built the model is unavailable, someone else can take over and “drive” it without too much difficulty.

The course will focus on building models for:

• Forecasting the likely, and possible, outcomes of business activity
• Reviewing the feasibility of proposed business ventures
• Planning the financial needs and performance of business projects
• Modelling the performance of the business as a whole through various business scenarios.

Key Learning Points

On completion of the course, delegates will be able to:

• Understand the need for structure when building a spreadsheet model.
• Detail the components of a well-structured spreadsheet forecasting or planning model, and why they are needed.
• Work through a defined series of steps to build a productive and understandable spreadsheet model.
• Use the model to assess the impact of a range of potential outcomes and scenarios using “What if” and sensitivity analysis.
• Build accessible, understandable and flexible spreadsheet models in any arena or situation.
• Develop the confidence to adapt, adjust and experiment with spreadsheet models in a wide range of scenarios.
• Understand the value of a spreadsheet business model for the running of their organisation.
• Make better business decisions using a business model.

Curriculum

L1 Principles of Spreadsheet Model Building

L2 The Key Elements in a Spreadsheet Model

L3 Definitions, Assumptions and Sources of Data

L4 Exercise: Model Foundations

L5 Building the Spreadsheet Model: Input Data

L6 Building the Model: Intermediate Calculations

L7 Building the Model: The Core Model

L8 Output Data and the Executive Summary

L9 Exercise: Reviewing a Model

L10 Sensitivity Analysis

L11 Building a Spreadsheet Model of your Business

L12 Planning and Decision Making using the Business Model

L13 Presenting the Outputs of your Spreadsheet Model

Additional Resources

Spreadsheet copies of the models covered in the course

Accountants and finance professionals

Business managers

Forecasters and decision makers

Students of business management

There are no pre-course requirements

There are currently no Q&As for this course. Be the first to ask a question.