Basic Financial Modelling

Training for Business Executives Packed With Interactive Group And Individual Exercises

Course Overview:
You will learn assumptions, projecting income statements, projecting working capital, depreciation schedules, amortization schedules, shareholders equity schedule, discounted cash flow statements, dividend dicount model,and Valuation methods along with Advanced MS Excel Skills.

Course Methodology:
This course will be highly interactive, with a mix of theory, including video clips and practical sessions. You will have the opportunity to share your experience, learn from others through group discussions and you will develop your skills through a series of individual and groupexercises.

We are pleased to announce Evanson Training’s two-days premier Basic Financial Modelling in Dubai on 2nd & 3rd June 2017 at 9:00 am to 3:00 pm.

Standard Price AED 2,500 per delegate.

  1. FOLLOW a logical, structured and disciplined approach towards model building.
  2. BUILD a model (or significant parts of one)from start to finish.
  3. LEARN a model (or significant parts of one) from start to finish.
  4. UNDERSTAND better how to tailor the outputs of the model towards end users and interpret the results.

This program is suitable for people in investment banking, project management, equity research, business planning, strategy, private equity, funds or commercial banking. It is also ideal for people who want a career with any of the above activities.

The program assumes you have basic knowledge of MS Excel. We will teach you various features Excel as part of the course, it is advisable that you know how to use Excel.

Day 1

  1. Introduction of Excel Efficiency using Excel
  2. Excel Warm Up
  3. Summarization using Pivot Table with examples.
  4. Creating a template for financial model.
  5. FMCG Case Study: The candidates will be given a case study and will be step by step taught
  6. Forecasted Income Statement, BalanceSheet & Cash FlowStatement.
  7. Stock / BusinessValuation

Day 2

  1. Dividend Discount Model
  2. Relative Valuation Methodology
  3. Advanced Financial Modeling Tools
  4. Creating and using developer tools
  5. Explanation of risk management tools and their application with examples
  6. Advance Excel Functions
Request Callback
Call me!