Stuck with LBO model
Have to do a quick and dirty LBO model with all three statements but I'm stuck on the balance sheet.
Say there is a 10 billion term loan that is used for the LBO together with 10 billion equity. Say that the book value of the equity in the company is 15 billion and has 1 billion in debt. My understanding is that in this case first cash on the asset side goes up by 20 billion, while both equity and debt up by 10-10 billion on the liabilities side. Now this is where I'm stuck: after this, am I supposed to decrease cash on the asset side by 16 billion, and decrease the equity by 15 billion and equity by 1 billion on the liabilities side and then I'm done?
.
You should first start with a Sources & Uses Schedule, it’ll help you check what exactly are those TL and equity proceeds being used for
Once that’s out of the way, it should be clearer how to project core BS items to figure out NWC projections. Can’t really understand what 15 and 16m you’re talking about here
Existing equity goes away and is replaced with 10bn equity check. Assuming you pay down that 1bn debt then debt is up by 9. L+E up by 4. Assets up by 4 for goodwill
This is the way
Agree with the above. You should build an S&U and then make the B/S adjustments.
Sources = 10+10 = 20
- Term loan = 10
- Sponsor equity = 10
Uses:
- Existing debt re-finance = 1
- Equity purchase = 20-1 = 19
Therefore, B/S will have the following adjustments:
Liability:
- Previous debt -1 (decreased to 0)
- New term loan +10
S/E -15+10
Asset
- Goodwill = +4 (making the B/S balance; in other words, goodwill = 19-15 = 4, the amount that the equity sponsor pay in excess of its book value)
Et fugiat ad illo fuga maxime. Quasi qui aliquid esse ipsum rerum.
Eos nam atque temporibus molestiae delectus. Qui quo sed qui. Nam non reiciendis aliquid omnis enim. Sit voluptates qui libero ea eos laboriosam. At quos consequatur et esse exercitationem qui. Ea tenetur laboriosam necessitatibus.
Rem suscipit mollitia ratione aliquam quae asperiores numquam. Odio ut amet nisi. Minus aut voluptatem qui qui est voluptatem.
Consequatur quod voluptatem similique laboriosam. Perferendis reiciendis veniam sint maiores. Qui cupiditate et est sed omnis beatae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...