1. Category
  2. Duration
  3. Global coverage
  4. Navigation
Green vertical standing travel suitcase with extended handle

Our bags are packed

Our courses are intended for a global audience, with each one being completely customisable to suit the needs of the individuals it is being delivered to.

They can be delivered in London or in your home town. You decide.

Get in touch

Financial Modelling 3 days

  • Corporate Finance, Financial Modelling, Risk and Credit
  • Duration: Three days
  • Information

    This is a comprehensive 3 day workshop to teach delegates how to design and build superior financial models.

    We listen to our clients and develop quantitative workshops which are informative and add real value. All our workshops are 'hands-on' with theory and demonstrations followed by 'leaning by doing'. This ensures that we provide real-world methods and internationally recognised techniques that can be successfully implemented immediately after the workshops.


    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

    Register interest

    As every course we run is tailored to meet the specific needs of each client, we can only provide an estimate after fully understanding your specific requirements. Please complete the form below of call +44 (0) 208 894 4977 to discuss how Taylor Associates can help you.

    * indicates a required field

    Personal details
    Company details
    Your enquiry