LBO Case Study - Key Numbers
- 02:53
How to build a leveraged buyout model for Red Bull using Excel. Calculate the key numbers, such as revenue, EBITDA, cost savings, and net income, based on the sources and uses of funds.
Glossary
Cost Savings EBITDA Net Income RevenueTranscript
Once we've done the sources and uses of funds, we can then move to the key numbers. So I'm gonna come down to the row 21. I want to pull in the revenue forecast that we've got in our Red Bull model first. So I'm gonna go to the Red Bull model and I'm gonna pull in the revenue forecast from the income statement, just the total revenue number.
And I'm pulling that into the 2024 year. So I pulled that in. Then I'm going to go down and I've got some cost saving assumptions. So this is perspective of the private equity firm can come and buy this business. And because they are very focused, they have got a very concentrated shareholder base and they're all facing the same direction, we can assume that they are going to introduce some cost savings. We are making the simplifying assumption that they are 1% of revenue. So I'm gonna copy across the revenue reference.
And then underneath it, I've got my cost savings. I'm gonna then put in my EBITDA forecast from the Red Bull model. And again, I'll take it for the 2024 year and I can calculate the adjusted EBITDA. And the adjusted EBITDA is just going to be the EBITDA plus those cost savings. Because what's happening here is we're assuming that the private equity house is going to generate some improvements in the business and then we can just calculate a margin. The reason that margins useful is that you can think about that as a metric you want to compare against the industry. So it has the industry got this margin. So one of the things that I would do, bear in mind that that is a forecast margin, but we could go to our trading comps and we could take a look at some of the metrics, for example, the LTM EBITDA margin. And you can see that the Monster Beverage has a 27.7% margin and we are assuming a 30% margin. So that could be a little punchy. We may get some pushback from the commitments committee about that mutual reward benchmark that against the industry. And then I'm gonna go and get long-term effective tax rate again from the Red Bull model. And I'll go to the assumption section to get the long-term effective tax rate there. And that's gonna be used to calculate my net income number. So I got all that and because this is kind of significant model, I'm just going to copy that right now.
So I've got my key numbers in cost savings, we think the private equity house will do. And then what we can do is we can pull in the income statement.