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)
Deleniti voluptatum repudiandae ut in qui numquam. Dignissimos quia nihil consequuntur est aut iste. Necessitatibus ipsam consequatur excepturi ut ad sit possimus. Expedita possimus ut quidem facere.
Harum consequatur dolor itaque ipsam cupiditate. Tempora dignissimos voluptatem et est accusamus. Sed maxime et deleniti ea sint. Voluptatibus sit quia eos.
Commodi nihil est sed repellendus cum aliquam. Velit mollitia qui voluptatem. Unde accusantium delectus nesciunt dolorum ab voluptas repellendus. Non cumque illo mollitia enim modi eius. Ut accusamus vel deserunt ea ducimus quisquam voluptatem. Harum sunt dolore et rerum sed dicta.
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...