• info at definetraining.com
  • +971 2 626 44 55

Course Details

Financial Modelling & Decision Making

Location
Dubai
Date
From Date: 09-Jan-2022   
To Date: 13-Jan-2022
Duration
5 days
Language
English
Discipline
Accounting, Finance
Introduction
Objective

COURSE OBJECTIVES:

  • Learn financial modeling using advanced Excel tools.
  • Build financial models through stepwise projection of Income statement, balance sheet and cash flows
  • Learn business valuation using comparable and discounted cash flow approach
  • Master Trading Comps valuation (P/E, P/B,EV, EBITDA etc.)
  • Apply scenario and sensitivity analysis
  • Learn circular reference technique and check sheets
  • Differentiate key modeling techniques between Modeling for Mezzanine Capital Investments and modeling for Investments in convertible structures
  • Conduct Merger and Acquisition Accretion Analysis
  • Design Data Dashboards
Audience

WHO SHOULD ATTEND

Professionals and graduate students working or aspiring to work in the field of investment banking, project consultancy, private equity, corporate finance, asset valuation and equity research.

Content
COURSE DAILY OUTLINE
Day One
  • Overview of Financial Modeling
  • Excel tools used in Financial Modeling including Data Tables, Nested Ifs, Index, Time Value of Money Applications
  • FAST standards for financial modeling
  • Structuring input sheet and structuring time sheet using timing flags
  • Modeling for assumptions & inputs
  • Business Structure & revenue modeling
  • Modeling for & projecting operating expenses
Day Two
  • Projecting key schedules including debt/interest, depreciation, working capital and equity
  • Stepwise projection of income statement, balance sheet and cash flows
  • Ratio analysis and common size analysis
  • Beta computation using regression models
  • Computing cost of equity using CAPM and WACC
Day Three
  • Estimating Terminal Value, DCF Valuation
  • Trading Comps Valuation (P/E, P/B, EV/EBITDA, etc.)
  • Scenario analysis
  • Form controls for scenario analysis
Day Four
  • Financial analysis of the project
  • Debt covenant analysis and Check sheet concept
  • Debt structuring using different types of financing options
  • Free cash flow analysis
  • NPV and IRR analysis for project
  • Data Analysis and Dashboard design:
  • Working with Charts and Tables in Excel
  • Lookups
  • Analyzing Data using Pivot Tables
  • Principles of Dashboard Design and Reporting
  • Making Interactive and Dynamic Dashboards
  • Introducing Macros
  • Summarization & presentation of a financial model
Day Five
  • Financing Mix and Accretion-Dilution Analysis
  • Merger Mix Analysis
  • Contribution and Breakeven Analysis
  • Sensitivity Analysis using data tables and Scenario Analysis
  • Charting for M&A modeling
Certificate

Training Certificate

Define Management Consultancy & Training Certificate of course completion will be issued to all attendees

 

Methodology

TRAINING METHODOLOGY:

A highly interactive combination of lectures and discussion sessions will be managed to maximize the amount and quality of information and knowledge transfer. The sessions will start by raising the most relevant questions, and motivate everybody find the right answers. You will also be encouraged to raise your own questions and to share in the development of the right answers using your own analysis and experiences.  Tests of multiple-choice type will be made available on daily basis to examine the effectiveness of delivering the course.

Very useful Course Materials will be given.

  • 30% Lectures
  • 30% Workshops and work presentation
  • 20% Group Work& Practical Exercises
  • 20% Videos& General Discussions
Fees
US $4,500

We help you to unlock & unleash the power within your large scale Trainings