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

Course Details

FINANCIAL MODELLING AND DECISION MAKING

Location
Dubai, UAE
Date
From Date: 15-Jan-2024   
To Date: 19-Jan-2024
Duration
5 Days
Language
English
Discipline
ACCOUNTING & FINANCE
Introduction

RefNo:         FB050
Title:            FINANCIAL MODELLING AND DECISION MAKING
Start Date:  15 January 2024  End Date: 19 January 2024
Fee:             $5,500
Venue:         Dubai, UAE

In any of the 5 star hotel. Exact venue will be informed soon.

The modern business professional needs to be able to use spreadsheet software such as Excel to support good business decisions.  This course offers training in the enhanced use of spreadsheets to support both short-term and long-term financial decisions.

The programme takes a practical approach, demonstrating how spreadsheet models are constructed, and how they can be tailored flexibly to specific business scenarios.  We also explore how such models can be further adapted to capture and reduce business risk.  The course offers recommendations to help delegates make their spreadsheet-based dashboards highly relevant, impactful and digestible.

Objective
  • 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

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
  •  

NOTE:
Pre & Post Tests will be conducted
Case Studies, Group Exercises, Group Discussions, Last Day Review & Assessments will be carried out.

Certificate

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

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
5,500 US$ per participant for Public Training includes Materials/Handouts, tea/coffee breaks, refreshments & Buffet Lunch

DEFINE Help you to unlock & unleash the power within and cater your large scale Trainings