Learn how to analyze mergers and acquisitions, build financial merger models, and evaluate deal impact using practical investment banking and corporate finance techniques. This course provides hands-on skills in merger modeling, financial statement integration, synergy analysis, accretion/dilution analysis, and purchase price allocation.
The course begins with industry and company analysis, helping learners understand market structure, competitive dynamics, and the strategic positioning of Comcast and Time Warner prior to the merger. Learners will evaluate industry trends, company financials, and the strategic rationale behind acquisition decisions.
As the course progresses, learners build transaction assumptions and prepare financial statements that form the foundation of a merger model. The course then focuses on integrating financial statements, analyzing accretion and dilution, and identifying revenue and cost synergies to assess the financial impact of the transaction.
Advanced modules cover balance sheet combination, purchase price allocation, accounting adjustments, free cash flow analysis, and sensitivity testing to complete a professional merger model.
What makes this course unique is its end-to-end, application-focused modeling approach that mirrors real-world investment banking and corporate finance workflows. By the end of the course, learners will be able to confidently build merger models, analyze acquisition scenarios, evaluate strategic transactions, and support M&A decision-making in professional finance environments.
This module introduces learners to the cable and media industry, highlighting market structure, key trends, and competitive dynamics, followed by an in-depth analysis of Comcast and Time Warner to understand their business models, financial performance, and strategic positioning prior to the merger.
What's included
6 videos4 assignments
Show info about module content
6 videos•Total 33 minutes
Industry Overview – Market Structure•5 minutes
Industry Overview – Key Trends•4 minutes
Comcast Profile – Business Overview•9 minutes
Comcast Profile – Financials•6 minutes
Time Warner Profile – Business Overview•4 minutes
Time Warner Profile – Financials•5 minutes
4 assignments•Total 60 minutes
Industry & Company Foundations•30 minutes
Industry Landscape & Trends•10 minutes
Comcast Deep Dive•10 minutes
Time Warner Analysis•10 minutes
Deal Framework & Assumptions
Module 2•2 hours to complete
Module details
This module focuses on understanding the merger deal structure, strategic rationale, and key considerations, followed by building transaction assumptions and preparing financial statements that serve as the foundation for merger modeling.
What's included
8 videos4 assignments
Show info about module content
8 videos•Total 32 minutes
Merger Overview – Deal Structure•4 minutes
Merger Overview – Strategic Rationale•4 minutes
Merger Overview – Key Considerations•4 minutes
Transaction Assumptions – Basics•5 minutes
Transaction Assumptions – Financing•3 minutes
Transaction Assumptions – Advanced•2 minutes
Buyer & Seller IS – Setup•7 minutes
Buyer & Seller IS – Projections•3 minutes
4 assignments•Total 60 minutes
Deal Framework & Assumptions•30 minutes
Understanding the Deal•10 minutes
Transaction Assumptions Setup•10 minutes
Advanced Assumptions & IS Setup•10 minutes
Financial Integration & Synergies
Module 3•2 hours to complete
Module details
This module guides learners through integrating financial statements, analyzing accretion and dilution, and identifying as well as quantifying revenue and cost synergies to evaluate the financial impact of the merger.
What's included
7 videos4 assignments
Show info about module content
7 videos•Total 32 minutes
Combined IS – Integration•4 minutes
Combined IS – Finalization•4 minutes
Accretion & Dilution Analysis•5 minutes
Synergies – Revenue•3 minutes
Synergies – Cost•7 minutes
Synergy Assumptions•5 minutes
Synergy Calculations•5 minutes
4 assignments•Total 60 minutes
Financial Integration & Synergies•30 minutes
Income Statement Integration•10 minutes
Deal Impact Analysis•10 minutes
Synergy Modeling•10 minutes
Balance Sheet, Adjustments & Final Model
Module 4•3 hours to complete
Module details
This module completes the merger modeling process by combining balance sheets, applying purchase price allocation and accounting adjustments, and performing advanced analysis including sensitivity testing, free cash flow calculation, and final model summarization.
Welcome to EDUCBA, a place where knowledge is limitless! We provide a wide selection of instructive and engaging programmes designed to empower students of all ages and experiences. From the convenience of your home, start a revolutionary educational experience with our cutting-edge technologies courses and experienced instructors.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.