+966 920007771
Advanced Financial Modeler


How You Benefit from this Course

  • To provide experienced modellers with a deeper understanding of financial modelling methodologies, techniques and approaches.
  • To provide you with a structured approach to modelling that generates models that are reliable, robust, controlled, extendable and easy to use.
  • To provide solutions to common modelling problems.


Part 1: Building Blocks

Financial Modelling in Excel

  • Key functions used in modelling
  • Advanced range names, including formulas and naming conventions
  • Pivot Tables
  • Scenarios, sensitivity, data tables
  • Best practice guidelines and spreadsheet modelling standards

Financial Modelling Overview

  • Modelling fundamentals
  • Steps in model building
  • Key concepts

Part 2: Advanced Modelling Techniques

Model Components

  • Capital budgeting & depreciation modelling
  • Debt modelling
  • Capital Structure
  • Ratio analysis
  • Tax considerations
  • Inflation
  • Reporting considerations: changing timescales, changing currencies, units

Specific Purpose Modelling

  • Company valuation & financial statement simulation
  • Project evaluation
  • Mergers & Acquisitions
  • Divestiture
  • High-growth companies

Part 3: Advanced Modelling Applications

  • Multi-variable Monte Carlo Simulations
  • Introduction to VBA Macros: useful functions and macros, and how to apply these to models
  • Working with other people’s models
  • Tracking and recording model changes

Who Should Attend

  • Accountants
  • Corporate financiers & Investment bankers
  • Financial Controllers
  • Finance staff
  • Commercial bankers
  • Business and financial analysts


5 Days

Start Date End Date Country City

Register Now

Please enter full name.
Please enter full name.
Please provide a valid email.
Please enter 10 digit mobile number.