Location

Date

Duration

Language

Discipline

Introduction

Number crunching is one the most important aspects of any job in the World of Finance. Unlike other Businesses, Professionals in the Finance Industry have to work with large amounts of numbers. There is thus a demand for Finance Professional who have an expertise in Microsoft Excel to create Financial Projections, Analyze Competition and Markets and make Financial Models. A mastery over Microsoft Excel is actually a way to excel in the Finance World, as it ensures Accuracy, Speed and can make you stand out in the crowd of Finance Professionals.

Objective

Upon successful completion of this course, the delegates will be able to:

• Perform financial modelling using advanced Excel tools.
• Build financial models through stepwise projection of Income statement, balance sheet and cash flows
• Conduct 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
• Use 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

DAY 1

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

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

• Estimating Terminal Value, DCF Valuation
• Trading Comps Valuation (P/E, P/B, EV/EBITDA, etc.)
• Scenario analysis
• Form controls for scenario analysis

DAY 4

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

• 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

TRAINIT ACADEMY will award an internationally recognized certificate(s) for each delegate on completion of training.

Methodology

The training course will be highly participatory and the course leader will present, guide and facilitate learning, using a range of methods including formal presentation, discussions, sector-specific case studies and exercises.  Above all, the course leader will make extensive use of real-life case examples in which he has been personally involved. 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.

• 30% Lectures
• 30% Workshops and work presentation
• 20% Case studies & Practical Exercises
• 10% Role Play
• 10% Videos, Software or Simulators (as applicable) & General Discussions

Fees

$6,150