LBO exercise question


Well, I have got a question. I dont know if this the right place to ask so dont be angry at me if it isn't. I have been training LBO models lately, so easter holidays have been a real blast ahaha. I am currently doing a carlyle lbo exercise and there's something that I am not sure about it.

My question is about Equity Value and Goodwill:

1) Carlyle will buy a publicly traded firm with a 25 % premium. Imagine Stock Price = 10$ and 50 Basic Shares Out. and 10 stock options at 5$. Using the Treasury Stock Method, new shares issued is 5 (using the 10$) and so fully diluted shares outstanding = 15. Equity value would be 10$ * (1+25%) *15. But I have seen other people's solutions where they completely ignore the stock options, while others use the 10$ * (1+%premium = 25%) as the repurchase price, which hecking baffles me. How would you tackle it?


2) Now about Goodwill = Equity Value - Total Assets + Liabilities + (Existing Goodwill?), so does Goodwill accumulate? It is the only way my BS balances after 2 hours looking at what the heck was wrong on the model.


Bonus Question: They also mention that this is a stock deal so "no step-ups in the basis of the assets". So we don't do anything to PP&E, Intangible assets, and other L.T assets, right?

I'm happy to share the Carlyle exercise and my model as soon as I have finished (although I am still a rookie on this). I am in a recruitment process of a small PE firm so any help would be appreciated! Thank you!

 

Voluptatem tempore odio voluptatem eveniet earum porro magnam omnis. Rerum esse sed voluptatibus. Voluptatibus aspernatur sit dolorem fuga repellat rem. Et et voluptate officiis voluptatem sint nulla reiciendis.

Career Advancement Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

April 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (90) $280
  • 2nd Year Associate (205) $268
  • 1st Year Associate (387) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (314) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
bolo up's picture
bolo up
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”