Download Agenda !

Advanced Financial Modelling & Dashboards with Excel

Course Introduction

This intensive and highly practical 3-Day workshop will teach delegates how to design and construct and then effectively use robust financial models, using the unique branded system developed by Gerald Strever, the Financial Modelling Quadrant system.

The four Quadrants are:

  • Identifying the Drivers of the intrinsic value of the company
  • Model the Financial Statements - Balance Sheet, Income Statement and Cash Flow
  • Model the Sensitivity of the intrinsic value of the company by flexing the Drivers
  • Simulate the possible variability of the intrinsic value of the company using Monte Carlo Simulation.
  • Course Objective

  • DISCOVER the most efficient ways in planning, designing, structuring, cross-checking and auditing your financial models
  • CONSTRUCT robust, reliable financial models that are easy to amend and maintain integrity
  • UNDERSTAND advanced techniques and applications in financial modelling
  • LEARN to measure, interpret and predict a companys performance using advanced Excel financial models
  • IMPROVE decision-making processes with better risk evaluation, sensitivity analysis and scenario modelling
  • SAVE time on the analysis and manipulation of your financial models with keen insights from our expert
  • SOLVE your real-life financial modelling issues and challenges
  • APPLY powerful visualization techniques to deliver maximum impact when presenting your financial models
  • OPTIMIZE financial models to ensure they are easy-to-use and well-documented in accordance with spread-sheet modelling best practices
  • PREPARE financial models to address a variety of financial modelling scenarios
  • Training Details

    • Location : Americas
    • Date : Nov 20th - 22nd 2018