The Investment Banking Training Group

Investment Banking Training Group Video Clips

Click here for more educational video clips

LEVEL 1: Basic & Fundamental Concepts
1.1 Accounting Financial Statements Overview	1.2 Accounting - Accrual Concept & Matching Principle	1.3 Accounting - EBIT & EBITDA Explanation	1.4 Accounting - Financial Statements Integration
1.5 Accounting - Non-Recurring Items	1.6 Accounting - Ratios - ROE	1.7 Accounting - Ratios - Days Outstanding	2.1 10K Footnotes - Enron Aftermath VIE FIN 46
2.2 10K Footnotes - FX Impact on Revenue	3.1 Finance 101 - CAGR Explained and Applied	3.2 Finance 101 - CAPM Simplified	3.3 Finance 101 - SML and Identifying Excess Returns
3.4 Finance 101 - WACC Defined and Calculated	3.5 Finance 101 - Cost of Debt Analyzed	3.6 Finance 101 - WACC Applied	4.1 Corporate Valuation - Basic Valuation Methodologies
4.2 Corporate Valuation - TEV & Exclusion of Leases	4.3 Corporate Valuation - Valuation Multiples	4.4 Corporate Valuation - Up and Down Capital Structure	4.5 Corporate Valuation - Proxy for PE Ratios
4.6 Corporate Valuation - Football Field	4.7 Corporate Valuation - Control Premiums Paid
LEVEL 2: Basic Financial Modeling Topics
6.1 Company Overview - Capital Structure Inputs	7.1 Basic Financial Modeling - Shares Outstanding for EPS	7.2 Basic Financial Modeling - Basic Valuation Model & DCF	7.3 Basic Financial Modeling - DCF Perpetuity Growth
7.4 Basic Financial Modeling - Implied Perpetual Growth	8.1 Trading Comps - LTM Different Fiscal Year End Part 1	8.2 Trading Comps - LTM Different Fiscal Year End Part 2
LEVEL 3: Core Financial & Valuation Modeling Topics
9.1 Adv FM Core Model - Income Statement Projection	9.2 Adv FM Core Model - Balance Sheet Projection Logic & Drivers	9.3 Adv FM Core Model - Balance Sheet Projection	9.4 Adv FM Core Model - Cash Flow Statement Dividends Projection
9.5 Adv FM Core Model - Cash Flow Statement Share Repurchase	9.6 Adv FM Core Model - Debt Sweep Starting Point-Balance Model	9.7 Adv FM Core Model - Integrating & Balancing the Model	9.8 Advanced Financial Modeling Core Model - Finalizing & Balancing the Model
10.1 Adv FM Enhancements - Segment Buildup Explanation	10.2 Adv FM Enhancements - Depreciation Expense Projection	10.3 Adv FM Enhancements - Credit Ratio Automation	11.1 Complex Trading Comps - LIFO FIFO Adjustment to Multiples
LEVEL 4: Core Merger Modeling Topics
13.1 M&A Deal Structuring - M&A Process & Timetable	13.2 M&A Deal Structuring - Stock vs Asset Deal Merger Modeling	13.3 M&A Deal Structuring - 338(h)(10) Merger Modeling Election	13.4 M&A Deal Structuring - Stock vs Cash Merger Breakeven
14.1 Merger Modeling Basics - Accretion Dilution	14.2 Merger Modeling Basics - Ability to Pay Merger Modeling	14.3 Merger Modeling Basics - Simple Merger Model	14.4 Merger Modeling Basics - Simple Merger Model Deal Structure
15.1 LBO Modeling - Leveraged Buyout Overview	15.2 LBO Modeling - Ideal LBO Candidate	15.3 LBO Modeling - Deal Expenses Accounting Treatment	15.4 LBO Modeling - Sources & Uses and Rollver Equity
15.5 LBO Modeling - Recap vs Purchase Accounting Explained	15.6 LBO Modeling - Recap vs Purchase Accounting Applied	16.1 LBO Modeling - IRR Calculation & Analysis
LEVEL 5: Super-Advanced Merger Modeling Topics
17.1 Complex LBO Modeling - Refinancing Scenarios Part 1	17.2 Complex LBO Modeling - Refinancing Scenarios Part 2	17.3 Complex LBO Modeling - Sources & Uses - Revolver Balancer	17.4 Complex LBO Modeling - Balance Sheet Pro Forma Debt Adj
17.5 Complex LBO Modeling - Cash Flow Statement Adjustments	17.6 Complex LBO Modeling - New Term Loan Construction	17.7 Complex LBO Modeling - Sensitivity Still Balances	17.8 Complex LBO Modeling - Credit Ratio Sensitivity
18.1 Super Advanced M&A - Merger Modeling Overview Part 1	18.2 Super Advanced M&A - Merger Modeling Overview Part 2	18.3 Super Advanced M&A - Merger Modeling Overview Part 3	18.4 Super Advanced M&A - Merger Modeling Sources & Uses Logic
18.5 Super Advanced M&A - Building Debt Sweep	18.6 Super Advanced M&A - Enhancing the Debt Sweep	18.7 Super-Advanced M&A - Purchase Price Allocation	19.1 Advanced Excel - Switches Alternatives
19.2 Advanced Excel - Basic Regression	19.3 Advanced Excel - Data Tables Sensitivity Tables	19.4 Advanced Excel - Vlookup Logic	19.5 Advanced Excel - Pivot Table Logic
19.6 Advanced Excel - Power of Arrays	19.7 Advanced Excel - Automated Row Shading Conditional Format	19.8 Advanced Excel - Tranpose	19.9 Advanced Excel - Separating Names Combining Functions
19.10 Advanced Excel - Drop Box Alternatives Logic	19.11 Advanced Excel - Excel 2003 Create Macro Part 1	19.12 Advanced Excel - Excel 2003 Create Macro Part 2
Exhibits & Overview of Financial Markets
20.1 Overview of Financial Markets - Buy-Side vs Sell-Side	20.2 Overview of Financial Markets - Investment Banking Explained	20.3 Overview of Financial Markets - Investment Banking Hierarchy	20.4 Overview of Financial Markets - Sales & Trading Explained
20.5 Overview of Financial Markets - Equity Research	20.6 Overview of Financial Markets - Asset Management Explained	20.7 Overview of Financial Markets - Alternatives & Private Equity	20.8 Overview of Financial Markets - Alternatives & Hedge Funds
20.9 Overview of Financial Markets - Structured Products & Asset Back	20.10 Depreciation and Working Capital	20.11 Share Repurchase 1	20.12 Share Repurchase 2
20.13 Treasury Dilutive Options Part 1	20.14 Treasury Dilutive Options Part 2	20.15 Circular Reference Part 1	20.16 Circular Reference Part 2