4.2) Merger Model - Advanced (400 Questions) Flashcards

1
Q

What’s the difference between Purchase Accounting and Pooling Accounting in an M&A deal?

A
  1. In Purchase Accounting the:
  2. Seller’s Shareholders’ Equity number is wiped out (seller’s Book Value)
  3. Premium Paid over that wiped out value is recorded as Goodwill on the combined BS
  4. 99% of M&A Deals use Purchase Accounting
  5. In Pooling Accounting you:
  6. Combine the Shareholders’ Equity numbers from the Buyer AND Seller
  7. Rather than worrying about Goodwill and the related items that get created
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Walk me through a concrete example of how to calculate revenue synergies.

A

Let’s say that Microsoft is going to acquire Yahoo.

Yahoo makes money from search advertising online, and they make a certain amount of revenue per search (RPS). Let’s say this RPS is $0.10 right now. If Microsoft acquired it, we might assume that they could boost this RPS by $0.01 or $0.02 because of their superior monetization.

So to calculate the additional revenue from this synergy, we would multiply this $0.01 or $0.02 by Yahoo’s total # of searches, get the total additional revenue, and then select a margin on it to determine how much flows through to the combined company’s Operating Income.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Walk me through an example of how to calculate expense synergies.

A

Let’s say that Microsoft still wants to acquire Yahoo!.

Microsoft has 5,000 SG&A-related employees, whereas Yahoo has around 1,000.

Microsoft calculates that post-transaction, it will only need about 200 of Yahoo’s SG&A employees, and its existing employees can take over the rest of the work.

To calculate the Operating Expenses the combined company would save, we would multiply these 800 employees Microsoft is going to fire post-transaction by their average salary.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do you take into account NOLs in an M&A deal?

A

• You apply Section 382 to determine how much of the seller’s NOLs are usable each year.

Allowable NOLs = Equity Purchase Price * Highest of Past 3 Months’ Adjusted Long Term Rates

• So if our equity purchase price were $1 billion and the highest adjusted long-term rate were 5%, then we do the following:

– Use $1 billion * 5% = $50 million of NOLs each year

– If the seller had $250 million in NOLs, then the combined company could use $50 million of them each year for 5 years to offset its taxable income.

You can look at long-term rates right here: http://pmstax.com/afr/exemptAFR.shtml

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why do deferred tax liabilities (DTLs) and deferred tax assets (DTAs) get created in M&A deals?

A
  • These get created when you write up assets – both tangible and intangible – and when you write down assets in a transaction.
  • An Asset Write-Up creates a Deferred Tax Liability
  • An Asset Write-Down creates a Deferred Tax Asset.

– You write down and write up assets because their book value often differs substantially from their “fair market value.” Book value is what’s on the Balance Sheet!

  • An Asset Write-Up creates a Deferred Tax Liability b/c you’ll have a higher depreciation expense on the new asset, which means you save on taxes in the short-term – but eventually you’ll have to pay them back, hence the liability.
  • The opposite applies for an asset write-down and a deferred tax asset.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How do DTLs and DTAs affect the Balance Sheet Adjustment in an M&A deal?

A

You take them into account with everything else when calculating the amount of Goodwill & Other Intangibles to create on your pro-forma balance sheet.

The formulas are as follows:

Deferred Tax Asset = Asset Write-Down * Tax Rate

Deferred Tax Liability = Asset Write-Up * Tax Rate

So let’s say you were buying a company for $1 billion with half-cash and half-debt, and you had a $100 million asset write-up and a tax rate of 40%. In addition, the seller has total assets of $200 million, total liabilities of $150 million, and shareholders’ equity of $50 million.

Here’s what would happen to the combined company’s balance sheet (ignoring transaction/financing fees):

  1. First, you simply add the seller’s Assets and Liabilities (but NOT Shareholders’ Equity – it is wiped out) to the buyer’s to get your “initial” balance sheet. Assets are up by $200 million and Liabilities are down by $150 million.
  2. Then, Cash on the Assets side goes down by $500 million.
  3. You have an asset write-up of $100 million, so Assets go up by $100 million.
  4. Debt on the Liabilities & Equity side goes up by $500 million.
  5. You get a new Deferred Tax Liability of $40 million ($100 million * 40%) on the Liabilities & Equity side.
  6. Assets are down by $200 million total and Liabilities & Shareholders’ Equity are up by $690 million ($500 + $40 + $150).
  7. So you need Goodwill & Intangibles of $890 million on the Assets side to make both sides balance.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Could you get DTLs or DTAs in an asset purchase?

A

No, because in an asset purchase the book basis of assets always matches the tax basis.

They get created in a stock purchase because the book values of assets are written up or written down, but the tax values are not.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How do you account for DTLs in forward projections in a merger model?

A
  1. You create a book vs. cash tax schedule and figure out what the company owes in taxes based on the Pretax Income on its books
  2. Then you determine what it actually pays in cash taxes based on its NOLs and newly created amortization and depreciation expenses (from any asset write-ups).
  • If the “cash” tax expense exceeds the “book” tax expense you record this as a decrease to the DTL on the Balance Sheet
  • If the “book” tax expense is higher than the “cash” tax expense then you record that as an increase to the DTL.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Explain the complete formula for how to calculate Goodwill in an M&A deal.

A

Goodwill =

Equity Purchase Price

– (Less) Seller Book Value

+ (Plus) Seller’s Existing Goodwill

– (Less) Asset Write-Ups

– (Less) Seller’s Existing Deferred Tax Liability

+ (Plus) Write-Down of Seller’s Existing Deferred Tax Asset

+ (Plus) Newly Created Deferred Tax Liability

5 Key Points

  1. Seller Book Value is just the Shareholders’ Equity number.
  2. You add the Seller’s Existing Goodwill because it gets written down to $0 in an M&A deal.
  3. You subtract the Asset Write-Ups because these are additions to the Assets side of the Balance Sheet – Goodwill is also an asset, so effectively you need less Goodwill to “plug the hole.”
  4. Normally you assume 100% of the Seller’s existing DTL is written down.
  5. The seller’s existing DTA may or may not be written down completely.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Explain why we would write down the seller’s existing Deferred Tax Asset in an M&A deal.

A
  • You write it down to reflect the fact that Deferred Tax Assets include NOLs
  • AND that you might use these NOLs post-transaction to offset the combined entity’s taxable income.
  • In an asset or 338(h)(10) purchase you assume that the entire NOL balance goes to $0 in the transaction, and then you write down the existing Deferred Tax Asset by this NOL write-down.
  • In a stock purchase the formula is:

DTA Write-Down = Buyer Tax Rate * MAX(0, NOL Balance – Allowed Annual NOL Usage * Expiration Period in Years)

• This formula is saying, “If we’re going to use up all these NOLs post transaction, let’s not write anything down. Otherwise, let’s write down the portion that we cannot actually use post-transaction, i.e. whatever our existing NOL balance is minus the amount we can use per year times the number of years.”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What’s a Section 338(h)(10) election and why might a company want to use it in an M&A deal?

A

A Section 338(h)(10) election blends the benefits of a stock purchase and an asset purchase:

  1. Legally it is a stock purchase
  2. But accounting-wise it’s treated like an asset purchase.
  3. The seller is still subject to double-taxation – on its assets that have appreciated and on the proceeds from the sale.
  4. But the buyer receives a step-up tax basis on the new assets it acquires, and it can depreciate/amortize them so it saves on taxes.

• Even though the seller still gets taxed twice, buyers will often pay more in a 338(h)(10) deal because of the tax-savings potential. It’s particularly helpful for:

A. Sellers with high NOL balances (more tax-savings for the buyer because this NOL balance will be written down completely – and so more of the excess purchase price can be allocated to asset write-ups).

B. If the company has been an S-corporation for over 10 years – in this case it doesn’t have to pay a tax on the appreciation of its assets.

C. The requirements to use 338(h)(10) are complex and bankers don’t deal with this – that is the role of lawyers and tax accountants.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is an exchange ratio and when would companies use it in an M&A deal?

A
  • An exchange ratio is an alternate way of structuring a 100% stock M&A deal, or any M&A deal with a portion of stock involved.
  • Let’s say you were going to buy a company for $100 million in an all-stock deal. Normally you would determine how much stock to issue by dividing the $100 million by the buyer’s stock price, and using that to get the new share count.
  • With an exchange ratio, by contrast, you would tie the number of new shares to the buyer’s own shares – so the seller might receive 1.5 shares of the buyer’s shares for each of its shares, rather than shares worth a specific dollar amount.
  • Buyers might prefer to do this if they believe their stock price is going to decline posttransaction – sellers, on the other hand, would prefer a fixed dollar amount in stock unless they believe the buyer’s share price will rise after the transaction.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Walk me through the most important terms of a Purchase Agreement in an M&A deal.

A

There are dozens, but here are the most important ones:

  1. Purchase Price: Stated as a per-share amount for public companies.
  2. Form of Consideration: Cash, Stock, Debt…
  3. Transaction Structure: Stock, Asset, or 338(h)(10)
  4. Treatment of Options: Assumed by the buyer? Cashed out? Ignored?
  5. Employee Retention: Do employees have to sign non-solicit or non-compete agreements? What about management?
  6. Reps & Warranties: What must the buyer and seller claim is true about their respective businesses?
  7. No-Shop / Go-Shop: Can the seller “shop” this offer around and try to get a better deal, or must it stay exclusive to this buyer?
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What’s an Earnout and why would a buyer offer it to a seller in an M&A deal?

A

An Earnout is a form of “deferred payment” in an M&A deal – it’s most common with private companies and start-ups, and is highly unusual with public sellers.

It is usually contingent on financial performance or other goals – for example, the buyer might say, “We’ll give you an additional $10 million in 3 years if you can hit $100 million in revenue by then.”

Buyers use it to incentivize sellers to continue to perform well and to discourage management teams from taking the money and running off to an island in the South Pacific once the deal is done.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How would an accretion / dilution model be different for a private seller?

A
  • The mechanics are the same
  • But the transaction structure is more likely to be an asset purchase or 338(h)(10) election
  • Private sellers also don’t have Earnings Per Share so you would only project down to Net Income on the seller’s Income Statement
  • Note that accretion / dilution makes no sense if you have a private buyer because private companies do not have Earnings Per Share.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How would I calculate “break-even synergies” in an M&A deal and what does the number mean?

A
  • You would set the EPS accretion / dilution to $0.00
  • Then back-solve in Excel to get the required synergies to make the deal neutral to EPS.

***It’s important because you want an idea of whether or not a deal “works” mathematically

***And a high number for the break-even synergies tells you that you’re going to need a lot of cost savings or revenue synergies to make it work

17
Q

Normally in an accretion / dilution model you care most about combining both companies’ Income Statements.

But let’s say I want to combine all 3 financial statements – how would I do this?

A

You combine the Income Statements like you normally would (see the question on this), and then you do the following:

  1. Combine the buyer’s and seller’s balance sheets (except for the seller’s Shareholders’ Equity number).
  2. Make the necessary Pro-Forma Adjustments (cash, debt, goodwill/intangibles, etc.).
  3. Project the combined Balance Sheet using standard assumptions for each item (see the Accounting section).
  4. Then project the Cash Flow Statement and link everything together as you normally would with any other 3-statement model.
18
Q

How do you handle options, convertible debt, and other dilutive securities in a merger model?

A

• The exact treatment depends on the terms of the Purchase Agreement

—The buyer might assume them

—Or it might allow the seller to “cash them out” assuming that the per-share purchase price is above the exercise prices of these dilutive securities

• If you assume they’re exercised, then you calculate dilution to the equity purchase price in the same way you normally would – Treasury Stock Method for options, and assume that convertibles convert into normal shares using the conversion price.

19
Q

What are the main 3 transaction structures you could use to acquire another company?

A

Stock Purchase, Asset Purchase, and 338(h)(10) Election.

1. Stock Purchase:

A. Buyer acquires all asset and liabilities of the seller as well as off-balance sheet items.

B. The seller is taxed at the capital gains tax rate.

C. The buyer receives no step-up tax basis for the newly acquired assets, and it can’t depreciate/amortize them for tax purposes.

D. A Deferred Tax Liability gets created as a result of the above.

E. Most common for public companies and larger private companies.

2. Asset Purchase:

A. Buyer acquires only certain assets and assumes only certain liabilities of the seller and gets nothing else.

B. Seller is taxed on the amount its assets have appreciated (what the buyer is paying for each one minus its book value) and also pays a capital gains tax on the proceeds.

C. The buyer receives a step-up tax basis for the newly acquired assets, and it can depreciate/amortize them for tax purposes.

D. No Deferred Tax Liability is created as a result of the above.

E. Most common for private companies, divestitures, and distressed public companies.

3. Section 338(h)(10) Election:

A. Buyer acquires all asset and liabilities of the seller as well as off-balance sheet items.

B. Seller is taxed on the amount its assets have appreciated (what the buyer is paying for each one minus its book value) and also pays a capital gains tax on the proceeds.

C. The buyer receives a step-up tax basis for the newly acquired assets, and it can depreciate/amortize them for tax purposes.

D. No Deferred Tax Liability is created as a result of the above.

E. Most common for private companies, divestitures, and distressed public companies.

G. To compensate for the buyer’s favorable tax treatment, the buyer usually agrees to pay more than it would in an Asset Purchase.

20
Q

Would a seller prefer a stock purchase or an asset purchase? What about the buyer?

A
  • Seller prefers a Stock Purchase to avoid double taxation and to get rid of all its liabilities.
  • Buyer prefers an Asset Deal:
  1. So it can be more careful about what it acquires
  2. To get the tax benefit from deducting D&A of Asset Write-Ups
21
Q

Explain what a contribution analysis is and why we might look at it in a merger model.

A

Contribution Analysis compares the following from what the buyer and seller are “contributing” to estimate what the ownership of the combined company should be:

  1. Revenue
  2. EBITDA
  3. Pre-Tax Income
  4. Cash and possibly other items

For example, let’s say that the buyer is set to own 50% of the new company and the seller is set to own 50%.

But the buyer has $100 million of revenue and the seller has $50 million of revenue – a contribution analysis would tell us that the buyer “should” own 66% instead because it’s contributing 2/3 of the combined revenue. It’s most common to look at this with merger of equals scenarios, and less common when the buyer is significantly larger than the seller.

22
Q

How do you account for Transaction Costs, Financing Fees, and Miscellaneous Expenses in a Merger Model?

A

In the “old days” you used to Capitalize these Expenses and then Amortize them

• With new accounting rules introduced at the end of 2008, you’re supposed to:

  1. Expense Transaction Fees upfront
  2. Capitalize Financing Fees
  3. Amortize Financing Fees over the life of the debt

  • Expensed Transaction Fees come out of Retained Earnings when you adjust the Balance Sheet
  • Capitalized Financing Fees appear as a new Asset on the Balance Sheet
  • Capitalized Financing Fees are Amortized every year according to the tenor of the debt