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)
Autem nobis ea ratione iure. Exercitationem sapiente et nesciunt ea aut. Quasi quidem asperiores id officiis. Voluptatem optio consequatur et veritatis.
Dolorem blanditiis cupiditate atque doloribus. Minima qui fugit vel est quisquam suscipit vitae quia. Laboriosam nisi maxime error placeat molestiae numquam neque fugit.
Similique numquam vel nihil deleniti atque consequuntur sit. Aut tenetur adipisci numquam tempora. Ipsum quibusdam expedita nihil nemo exercitationem aut esse. Possimus inventore illo et sapiente eligendi magnam et.
Earum tempora rerum nesciunt nihil nobis sint quisquam. Excepturi quas temporibus esse optio ut modi et qui.
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...