S&U & Goodwill in LBO paying off Off-BS Debt

Hi all - 

Working on a deal where we assume all debt, and raise new debt to pay off debt-like items on the BS (with some wiggle room to reduce our equity as new debt > off-BS debt we're paying off).

My questions are:
1a) Is my S&U correct (version 1)?

1b) Is my S&U correct (alternative version, my boss likes to see it this way with revolver availability as source)?

2) How to calculate goodwill properly - am getting stuck with the debt-like item paydown?

EV - $80M
Term Assumed - 55
Off-BS Debt-Like - 5
RLOC Drawn - 10
Cash - 0.5  

Assume 1M in sponsor fees and 800K cash to B/S. Assume 11M of new debt to refinance the $5M. Assume 19M RLOC capacity.

Waterfall is 80 - 55 - 5 - 10 + 0.5 = 10.5M seller proceeds

1) S&USources
Term assumed 55
New Debt 11
RLOC Drawn 10
OldCo. Cash 0.5
GP Cash 4 (plug)Total Source 80.5

Uses
Seller Proceeds 10.5
Debt-Like Paydown 5
Term assumed 55
RLOC Drawn 10Total Uses 80.5

2) S&U v2Sources
Term Assumed 55
RLOC Available 19
New Debt 11
OldCo. Cash 0
GP Cash 4Total Sources 89

Uses
EV 80
Excess Availability 9Total Uses 89

3) Goodwill

Purchase Eq. Value = 10.5
Less; Book Equity = 5.09
Purch. Equity Value = 5.41

I end up bringing the 11 onto the BS, and because the 5 was off the BS, i get a difference of 5 (assets less than L&E).


Thank you in advance...
 

 

Maxime quia rem repudiandae neque. Numquam deserunt unde ut et vero aut. Ea eos necessitatibus nisi reprehenderit numquam dignissimos ut earum. Sed est tempora consequatur omnis. Minima similique optio at ea quia sit.

Tempora tempora voluptas sit quo. Velit architecto atque dolor et sequi nostrum. Deleniti rerum dicta facere occaecati vel magnam eveniet eos. Aliquid cumque iure ipsa harum harum.

Accusantium et nemo hic delectus quisquam. Delectus aut iure dolor excepturi sed. Qui autem vitae voluptatum fugiat eligendi. Autem delectus et voluptatibus voluptas ullam possimus ipsa.

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 (91) $281
  • 2nd Year Associate (206) $266
  • 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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
DrApeman's picture
DrApeman
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...”