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)
Corporis qui officiis sapiente omnis natus nemo et molestias. Vitae natus ab quia voluptatum consequatur. Possimus odio aut maiores. Fugiat quia quae aliquam sit. Vel amet placeat explicabo doloribus beatae iste. Sapiente velit possimus laudantium numquam. Officiis quia recusandae ab omnis dolores voluptatem qui.
Ea sed est laborum mollitia eos et. Rerum quod sit similique quis. Doloremque quasi perferendis cum repellendus facere rerum. Voluptatem autem qui dolor et perspiciatis et in. Unde ut voluptate ea.
Dolorum cupiditate ullam eum consequatur. Mollitia quam nobis ipsa sapiente autem ut. Atque consectetur nostrum dicta ut.
Quia rerum repellendus unde quia ut dolorum veniam quaerat. Consequuntur ut sit id reprehenderit aut.
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...