Mergers & Acquisitions
-
Introduction to M&A (7:01)
-
Examples of M&A (6:42)
-
Horizontal & Vertical Merger (7:29)
-
Horizontal & Vertical Merger Continue (4:56)
-
Conglomerate Mergers (8:06)
-
Motive of M&A (4:26)
-
Life Cycle (8:01)
-
Modes of Payment (8:24)
-
Dividend Discount Model (10:25)
-
Hostile Takeover (8:11)
-
Timliness in M&A (5:00)
-
Synergy in Basics (11:23)
-
Case study - Valuation Techniques (11:35)
-
Case study - Valuation Techniques Continue (8:13)
-
More on Case study - Valuation Techniques (4:41)
-
Key Concepts on Valuations (8:34)
-
Key Concepts on Valuations Continue (4:03)
-
Valuation Factors (6:05)
-
Building Model in TCF Valuation (7:29)
-
Free Cash From Equity (6:45)
-
Understanding Terminal Value (6:31)
-
Estimated Value or Share (7:31)
-
Comparatative Value Matrix (8:03)
-
Calculating Free Cash Flow (5:37)
-
Comparable Company Analysis (6:52)
-
Average Takeover Premium (6:26)
-
Average Estimated Stock Value (7:05)
-
EG on PEG Ratio (9:05)
-
Comparable Transaction (6:03)
-
Functioning Numbers in Comparable Transaction (7:49)
-
Break Up Value Method (6:57)
-
Average Capitalization Ratio (8:22)
-
Value Based on Market Assets (9:42)
-
Earning Value Method (5:48)
-
Equity Share Capital (7:27)
-
Networth of Equity (6:38)
-
Constant Growth Method (6:07)
-
Real Time Case Study (10:58)
-
Reverse Merger (6:46)
-
Concept of Synergy In Totality (5:43)
-
Value After Merger (7:10)
-
Calculating Maximum Share Price (6:15)
-
Market Value of Shares (6:47)
-
Cash Deal & Synergy in Earnings (6:25)
-
Post Merger PE Ratio (6:03)
-
Stock and Synergy in Value (7:22)
-
Post Merger Share Price (5:52)
-
True Cost of Acquisition (8:19)
-
Post Merger EPS (10:40)
-
Cross Border Merger (10:43)
-
Merger Analysis Model Map (5:45)
-
Target Ownership (8:25)
-
I Gate Merger Deal (6:36)
-
Merger Deal Assumptions (7:18)
-
I Gate Financial Statements (8:03)
-
Percentage of Sales (8:12)
-
Profit After Tax (7:36)
-
Gross Profit Margin (5:36)
-
Input For Merger Analysis (6:25)
-
Acquirer Target Combinations (7:46)
-
Drivers and Assumptions (6:35)
-
Pre Tax Synergies (6:34)
-
Calculating Equity Data (7:00)
-
Diluted Earning Per Share (8:06)
-
Analysis At Various Prices (6:20)
-
Enterprise Value (7:03)
-
Earning Per Share (12:08)
-
Impact of Financing Mix (6:40)
-
Issuing New Debt (6:41)
-
Amortization of Transaction Fees (10:22)
-
Pro Forma Numbers (7:47)
-
Merger Plan - Analysis at Various Prices (9:41)
-
Share Dynamics (7:13)
-
Buyers Share Price (6:26)
-
Earn Out Model (8:18)
Merger Modeling - Albemarle Corp and Axiall Chemicals
-
Introduction to Financial Statements and Projections (9:11)
-
Assumptions (7:11)
-
Assumptions Continue (7:22)
-
Purchase Price Calculation Part 1 (7:31)
-
Purchase Price Calculation Part 2 (6:33)
-
Purchase Price Calculation Part 3 (5:35)
-
Sources and Uses of Funds (6:13)
-
Purchase Price Allocation (3:50)
-
ProForma Opening Balance sheet Format (6:33)
-
ProForma Opening Balance Sheet Adjustments (5:56)
-
Proforma PL Forecast (6:43)
-
Proforma P L forecast Continues (7:30)
-
Proforma NI and EPS (5:45)
-
ProForma Balance Sheet Actuals (5:13)
-
ProForma Balance Sheet Forecast (6:56)
-
Working capital Calculation (6:09)
-
ProForma Statement Completion (5:02)
-
Prepare ProForma Cash Flow Statement (9:46)
-
Axll Debt Repayment Schedule (7:52)
-
Debt Repayment Schedule Continues (12:03)
-
ALB Debt Repayment Schedule (10:56)
-
More on ALB Debt Schedule (12:14)
-
Term Loan and Other Debt (6:39)
-
Find out Interest Cost (5:05)
-
Debt Raised for Acquisitions (11:50)
-
Albemarle Standalone EPS (6:23)
-
Albemarle Profit and Loss (6:19)
-
what is EPS Accretion (5:14)
-
Use Data Table (7:22)
-
EPS Accretion Sensitivity (5:43)
Hannifin and Clarcor Merger Modeling Case Study
-
Introduction to Hannifin and Clarcor Merger Modeling (7:01)
-
Introduction to Hannifin and Clarcor Merger Modeling Continues (7:12)
-
Template and Sources Used for Valuation (9:11)
-
Calculation of Target Offer Value (7:48)
-
Calculation of Target Transaction Value (8:22)
-
Target Enterprise Value (8:28)
-
Target Enterprise Value Continues (8:22)
-
Target LTM Period Narration (6:42)
-
More on LTM Period Narration (6:44)
-
Target LTM Financials (6:55)
-
Example of Target LTM Financials (7:23)
-
Example of Target LTM Financials Continues (10:03)
-
Target LFY Financials (7:12)
-
Multiples LFY Financials (7:53)
-
Acquiror Balance Sheet (12:11)
-
Clarcor Target Balance Sheet (7:15)
-
Reclassification of Target Balance Sheet (8:42)
-
Acquistion Adjustments (8:19)
-
Acquiror Pro Forma Balance Sheet (8:28)
-
Acquiror Income Statement (7:15)
-
Target FY Income Statement (5:07)
-
Target LTM Income Statement (8:12)
-
More on Acquiror Pro Forma Income Statement (11:40)
Comcast and Time Warner Merger Modeling Training
-
Industry Overview 1 (4:55)
-
Industry Overview 2 (3:51)
-
Comcast Company Profile 1 (9:13)
-
Comcast Company Profile 2 (6:20)
-
Company Profile 1 (4:24)
-
Company Profile 2 (4:35)
-
Overview 2 (4:01)
-
Overview 3 (4:17)
-
Overview 4 (3:36)
-
Transaction Assumptions 1 (5:04)
-
Transaction Assumptions 2 and 3 (3:00)
-
Transaction assumption 4 (2:00)
-
Buyer and seller IS 1 (7:23)
-
Buyer and seller IS 2 (2:39)
-
Combining the IS 1 (3:49)
-
Combining the IS 2 (4:10)
-
Calculating accretion and dilution (5:01)
-
Synergies 1 (2:39)
-
Synergies 2 (6:46)
-
Synergy assumptions (5:13)
-
synergy calculations (4:41)
-
Combining the BS 1 (9:29)
-
Combining the BS 2 (12:19)
-
Calculating the adjustments 1 (5:17)
-
Calculating the adjustments 2 (4:53)
-
Calculating the adjustments 3 (3:52)
-
Calculating the adjustments 4 (6:40)
-
Adjusting the BS (7:25)
-
Adjusting the IS (7:42)
-
Sensitivity Analysis (8:20)
-
Calculating the free cash flows (8:38)
-
Summarizing the model (6:47)
Spin-Offs De-Merger Modeling
-
Introduction to Spinoff and Financial Impacts (1:01)
-
Definition of Spinoff (10:10)
-
More about Spinoff Situation (11:05)
-
Financial Modeling Implications (9:00)
-
Financial Modeling Implications Continues (7:08)
-
Modeling Spinoff (9:19)
-
Valuation of Spinoff (10:12)
-
Recommendations (2:47)
-
Potential Take Over Scenario (11:41)
-
Spinoff Valuation ARNC (4:17)
-
Pension Liabilities and Activists (7:08)
-
Valuation of Parent Ex-Spin (11:21)
-
Valuation of Parent Ex - Spin Continues (7:20)
-
Arconic Valuation (6:14)
-
Bull and Bear Case Scenario (10:44)
-
Conclusion (7:33)
