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

MAESTRO CONSULTANTS Certificate of Completion for delegates who attend and complete the training course

Methodology

Our courses are highly interactive, typically taking a case study approach that we have found to be an effective method of fostering discussions and transferring knowledge. Participants will learn by active participation during the program through the use of individual exercises, questionnaires, team exercises, training videos and discussions of “real life” issues in their organizations.
The material has been designed to enable delegates to apply all of the material with immediate effect back in the workplace.

Fees

$5,250 per attendee including training material/handouts, morning/afternoon coffee breaks and Lunch.