First of all we like to be certain of client requirements. Together we can develop the workshop outline to achieve the best mix of practical and demonstration sessions with exercises. We often use pre-course evaluations to ensure that participants can influence the content and gain as much as possible from the workshops.

Our training style is highly interactive. As well as lecturing, we provide plenty of time for exercises and questions to ensure that participants can play a full part in the learning process. Interaction and group work make training more enjoyable for participants and at the same time are stimulating and effective.

Day One  Overview of Modelling Techniques
 
Module 1  Introduction and Overview
 
  Outline of financial modelling
  Examples of Excel financial models
  Useful Excel features and techniques
  Exercise: analysing examples of modelling techniques
 
Module 2  Spreadsheet Best Practice
 
  Model design and structure – key steps
  Financial analysis basics – financial statements
  Cash flow and ratios
  Exercise: Techniques for modelling financial statements
 
Module 3  Auditing and Testing
 
  Examples of spreadsheet errors
  Essential testing and auditing techniques
  Example: testing financial analysis model with cash flows and ratios
  Exercise: debugging and checking a financial model
 
Module 4  Practical – Project Model 1
 
  Practical project model exercise
 
Day Two  Forecasting and Risk
 
Module 5  Macros and Security
 
  Visual Basic in Excel
  Writing and auditing and macros
  Spreadsheet security
  Exercise: writing and auditing macros
 
Module 6  Forecasting Models
 
  Review of forecasting methods
  Understanding financial ‘drivers’
  Exercise: deriving forecast free cash flow and ratios
  Exercise: producing a financial forecast
 
Module 7  Risk Techniques
 
  Valuation model and cost of capital fundamentals
  Risk and multiple answers
  Scenario techniques
  Exercise: Producing a valuation and testing the results
 
Module 8  Risk Techniques 2
 
  Advanced scenario methods
  Composite methods
 
Day Three  Optimisation and Reporting
 
Module 9  Practical – Project Model 2
 
  Review of initial answers and identification of potential risks
  Exercise: adding risk techniques to the project model in module 4
 
Module 10  Optimisation and Targeting
 
  Overview of optimisation and targeting
  Goal seek and Solver methods
  Exercise: adding optimisation to case models
 
Module 11  Management Reporting
 
  Requirement to consolidate and summarise data
  Exercise: consolidating data from different sources
  Exercise: pivot tables
  Techniques for summarising data
  Exercise: producing a management analysis
 
Module 12  Practical - Management Reporting and Forecasting
 
  Analysis of company financial data
  Exercise: producing management summaries with charts