Course Details

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

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.

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