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
626 RexCorp Plaza, Suite #PMB 6019, Uniondale, NY 11556 USA
Office: +1 (212) 537-6631 Toll-Free: +1 (877) 837-9755 Fax: +1 (212) 656-1221
Email:
Click here to contact us
© 2009 Investment Banking Training Group &
Wall St. Training
. All rights reserved.