CATEGORY TYPE: Finance & Accounting

COURSE NAME:Advanced Financial Modeler


This course can be scheduled at your convenience, to request this course please click here


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
  • Accountants
  • Corporate financiers & Investment bankers
  • Financial Controllers
  • Finance staff
  • Commercial bankers
  • Business and financial analysts
    • 5 Day(s)

    The presentation is generally appealing to me. The dedication & devotion of the instructor are both laudable & admirable.
    Mohammed F. Alotaibi

    Really this course is important for any inspector, so I will recommended it for our employees. And thanks a lot!
    Ahmed Al-Yami

    You are doing excellent bringing such very talented instructor. Please keep it up.
    Ahmed Afifi
    Al-Zamil CoolCare

    I would like to appreciate you as well as the instructor for a good training due to the fact that the helping to gain new information about the types of valve with advantages and disadvantage as well. Many thinking.
    Zaki Ali Aldawood

    This course was very beneficial and helpful to understand one of the Major NDT method. I encourage ITC to continue with this performance.
    Talal Saad AlHasawi

    ITC service was in overall excellent. Thanks.
    Wael M. Morsy

    This course was good and a nice guide to the PMP exam. Thanks.
    Yazeed Mohamed Mreki
    General Authority of Civil Aviation (GACA)

    It was good course & good preparation with excellent instructor. Thanks a lot.
    Faisal Mahdi Al-Qahtani

    It was a nice course to have. I suggest taking this course with the same instructor to other people. Thanks for the instructor for his kindness & helfull during the course.
    Abdul-Moniem Al-Humoud

    It is very important course, which enable us to improve our knowledge to work approaching our big account and can be recall us the key account. This is will support us to active result for the best of the Co.
    Mohammed Amjad
    Al-Suwadi Services

    The instructor is highly and technical knowledgeable in explaining all the subject in the course taken.
    Noel V. Garan
    Coldstorec Group Of Saudi Arabia

    Instructor was well prepared and knowledgeable I gain lot of useful information.
    Gulam Khan
    Saudi Aramco

    It was a good learning experience. Got to know the concept involved in key account.
    Muthuraman Nachiappan
    Al-Suwadi Services

    The instructor Mr. Ahmed Sabry has a very nice spirit.
    Salam Fakhoury
    Al Khodari Company

    It is very useful to us and increase our knowledge.
    Mohammed Rashed Afifi
    Al Khodari Company

    The course is excellent and helpful. It help me in organizing the work in more safe manner.
    Muzammil Hayat
    Al Khodari Company

    The instructor is very knowledge and hard working, his way of teaching is very good.
    Ibrahim Darwish
    Al Khodari Company