Description
Welcome to the Mergers & Acquisitions Modeling Course! This comprehensive program is designed to equip participants with the knowledge and skills to navigate the complex world of mergers, acquisitions, and spin-off transactions. Whether you're an aspiring financial analyst, investment banker, or corporate strategist, this course will provide you with the essential tools to excel in corporate finance. Throughout this course, you will explore various aspects of M&A transactions, including strategic considerations, financial analysis, and valuation methodologies. From understanding the motives behind mergers to dissecting the financial implications of spin-offs, each module offers valuable insights and practical knowledge that can be applied in real-world scenarios.
This course includes:
- 20+ hours on-demand video
- Unlimited Access, Anytime, on mobile and TV
- Certificate of completion
Mergers & Acquisitions: This module provides a comprehensive exploration of mergers and acquisitions (M&A), covering essential topics such as strategies, motives, and the stages involved in the M&A process. With over 9 hours of content, participants will gain a deep understanding of the intricacies of M&A transactions. The module includes detailed case studies, including modeling tutorials for mergers involving companies like Albemarle Corp and Axiall Corp, as well as Hannifin and Clarcor. By studying these real-world examples, participants will learn how to analyze financial statements, perform valuation assessments, and understand the implications of M&A transactions on stakeholders.
Advanced Modeling Techniques and Spin-Offs De-Merger Modeling: In this module, participants delve into the world of spin-offs and de-mergers, crucial aspects of corporate restructuring. Over 2 hours, learners will explore the intricacies of modeling spin-off transactions, examining their impact on both the parent and spun-off entities. Through case studies and practical examples, participants will gain insights into the financial and strategic considerations involved in spin-off transactions. Topics covered include financial statement analysis, valuation techniques, and the evaluation of spin-off strategies to maximize shareholder value.
Course Curriculum
- 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)
- 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)
- 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)
- 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)
- 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)