Advanced Merger Model, Part 2: Combining and Adjusting the Balance Sheets

What You’ll Learn In This Video

You’ll learn how to combine the buyer and sellers’ balance sheets in an M&A deal, taking into account purchase price allocation, transaction assumptions, and the deal structure in this lesson.

Hey there,

In this second lesson, you’re going to learn how to combine the balance sheets, make the necessary adjustments, and ensure that everything balances post-transaction.

We’ll be using United Technologies’ $16 billion acquisition of Goodrich Corporation for our example here, and you’ll learn even more since this is a very “real-world” example.

In addition to the standard adjustments, you’ll learn about some trickier points that are easy to forget when you’re combining the balance sheets – and you’ll learn how to ensure that your model handles all scenarios.

You can follow along using the “Before” Excel file above and then check your work with the “After” Excel file.

Coming up next, we’ll continue with the model and move into how to calculate revenue and expense synergies in the deal.


How to Download These Files:

  • In Firefox, Chrome, and Internet Explorer:
    Right click the link and click Save Link As...

    Save link as...
  • In Safari:
    Right click the link and click Download Linked File As...

    Save link as...
BREAKING INTO WALL STREET PREMIUM is a proven Financial Modeling Training Program that shows you...

How to Land Investment Banking Offers and Gain an Unfair Advantage Once You Start Working.

Master Accounting, Valuation, and Financial Modeling,
and You'll Leap Ahead of Everyone Else - in Interviews and On the Job.

Breaking Into Wall Street Premium Package

BIWS Premium teaches you Excel, financial modeling, and advanced financial modeling from the ground up – everything you need to ace your interviews and leap ahead on the job.

The course is based on 10+ global case studies, including companies such as EasyJet (UK), Vivendi (France), Jazz Pharmaceuticals (US), Suntory (Japan), 7 Days Inn (China), Kakao / Daum (Korea), and Netflix (US).

The Advanced lessons are also based on a case study of one of the most significant tech M&A deals of all time: Microsoft's proposed $44 billion acquisition of Yahoo.

Through these case studies, you'll get practice building models and creating client advisory presentations and investment recommendations for roles such as investment banking, private equity, hedge funds / asset management, equity research, growth equity, and more.

Topics covered include accounting and the 3 financial statements, valuation (the basics up through calendarization and adjusting for non-recurring charges), M&A deals and merger models (the concepts up through more advanced models), and leveraged buyouts and LBO models (including examples of PE case studies and solutions). Additional supplemental lessons cover private company valuation and equity, debt, and convertible bond analysis (for use in equity and debt capital markets and Leveraged Finance roles).

You'll also get to practice yourself with the exercises included in each course.

Plus, you also get free, bonus case studies based on real M&A deals and leveraged buyouts in other industries - such as TPG's $3 billion leveraged buyout of J Crew and the $6 billion LBO of Kinetic Concepts.

Click here now to find out more

Our Customers Love BIWS Premium

Over 22,981+ students and finance professionals have used Breaking Into Wall Street to master modeling, win interviews, and land offers in investment banking, private equity, hedge funds, equity research, and more.

"I Landed an Offer at a Firm with $6 Billion AUM and a Fast-Growing Presence in Mid-Market PE."

Whether you need to brush up on interview questions, or compete against people with far more experience than you - and beat them - it's all here.

Advanced Combined BS

Click here now to find out more