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?