Comcast and Time Warner Merger Modeling Training
"Unlocking Synergy: Master the Future of Comcast and Time Warner Integration!"
Updated on Jun, 2025
Language - English
Finance and Accounting,Other Finance and Accounting,
Lectures -32
Duration -2.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
M&A Modeling – Comcast and Time Warner Training
- Merger and acquisition is laymen terms can be understood as a situation in which two individual entities come together to form a new entity.
- Wherein in case of acquisitions a company takes over another company in this the company being acquired (called as the target company cease to exist).
- Through this online M&A Modeling- Comcast and Time Warner course you will learn how to prepare a merger model right from scratch of a potential merger deal.
What you will learn in this M&A Modeling Course?
- We would be learning about the Comcast and Time Warner merger deal which is a proposed acquisition of Time Warner by Comcast, which was announced on February 13, 2014. Comcast Corporation and Time Warner Inc. are companies that belong to the Broadcasting and Cable TV sector of US. Merger and acquisition modeling is basically finding out the effect of the merger on the new entity in terms of its earnings per share (EPS).
- This is known as the accretion/dilution analysis in investment banking terms.
- At the end of this course you will learn how the combined financial statements of the companies under merger are prepared, calculation of synergies and incorporating them in the merger model, calculation of accretion/dilution and making the necessary adjustments in order to finalize the combined financial statements.
Course Highlights for M&A Modeling:
- Learn important excel tools and functions which are required by the analyst
- Learn how to combine the financial statements of the companies under a merger deal
- Understand the concept of synergies and calculate them for the merger deal
- Learn the effect on EPS through accretion/dilution analysis
- Prepare a recommendation report on the proposed merger deal
Target Audience for M&A Modeling Course:
- Students/professionals who want to make their career in Investment Banking
- Candidates who are appearing for CFA
- Anyone who wants to make their career in finance
Goals
Course Goals for Comcast and Time Warner Merger Modeling Training
- Conceptual Foundations of Mergers and Acquisitions: Evaluate the theoretical perspectives informing mergers and acquisitions, using the case of Comcast and Time Warner merger as a point of focus.
- Financial Modeling Proficiency: Know how to measure the impact of the merger by appropriate financial modeling techniques and projecting the effects of the merger on the business.
- Valuation Techniques: Learn the theory and practice of accounting for the value of a company, assessing prospective advantages of the merged firm.
- Risk Assessment: Recognize and assess risks arising from the deal, including laws and legislation, operations and market risks.
- Scenario Analysis: Provide scenario analysis so that the outcomes weighted will be for certain weighted assumptions without considering that the market is in equilibrium.
- Integration Strategies: Examine different ways of integrating organizations after the merger is complete, paying attention to the cultural, operational and technological aspects.
- Communication Skills: Develop the ability not only to build sophisticated financial models and merger evaluations, but also to present these to the audiences in most efficient manner.
- Collaborative Learning: Encourage togetherness among the participants to give room for the enactment of operational merger and acquisition processes.
Prerequisites
Pre-requisites for M&A Modeling Course
- Basic knowledge of accounting is required
- Computer with Internet connection
Curriculum
Check out the detailed breakdown of what’s inside the course
Industry and Company analysis
6 Lectures
-
Industry Overview 1
04:55
04:55
-
Industry Overview 2
03:51
03:51
-
Comcast Company Profile 1
09:13
09:13
-
Comcast Company Profile 2
06:20
06:20
-
Company Profile 1
04:24
04:24
-
Company Profile 2
04:35
04:35
Overview of Merger Modeling
3 Lectures
Transaction Assumptions
3 Lectures
Buyer and Seller IS
2 Lectures
Combining the IS
2 Lectures
Calculating the Accretion and Dilution
1 Lectures
Synergies
4 Lectures
Combining the Balance sheet
2 Lectures
Calculating the adjustments
4 Lectures
Adjusting the Balance sheet
1 Lectures
Adjusting the Income Statement
1 Lectures
Sensitivity Analysis
1 Lectures
Calculating the free cash flows
1 Lectures
Summarizing the Model
1 Lectures
Instructor Details
Corporate Bridge Consultancy Private Limited
Corporate Bridge Consultancy Private Limited - EDUCBA is an initiative by IIT IIM Graduates, We are one of the leading providers of skill-based education addressing the needs of 1,000,000+ members across 70+ Countries. With more the 15+ years of experience in Training and Development, our expertise lies in Self-paced learning, Digital Learning content, Corporate Training, Content Development and Consultancy.
Our Vision:
To be a leading and progressive partner with our clients in their journey of progress.
"We are passionate about our work. We believe in empowering and improving our members’ lives with skill-based, hands-on training programs."
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now