Football Field Case Study - Intro and Key Numbers
- 01:53
How to pull key data for Red Bull from a valuation model, such as historical debt, cash, revenue, and EBITDA.
Transcript
All the valuation methodologies are completed in this model. So now what we need to do is pull the analysis together. To start, we just need to get some key data for Red Bull. We need to get the historical debt and the historical cash and financial assets so we can do the equity to enterprise value bridge accurately. We need to also get revenue and EBITDA for the forecast years. So I'm going to get the total debt number from the historical balance sheet in the model, and I'm going to go up to the revolver plus the long-term debt. So that's my historical debt number.
Now you can see that that formula is quite long, so I probably should rename that tab RB rather than Red Bull model. I'm not going to do that now. And then I'm gonna go and pull in the cash and financial assets. So cash plus the long-term financial assets there. Because that will allow me to do the bridge accurately. And then we need to do the revenue and EBITDA numbers based on an LTM basis, CY1, and CY2. So I'm gonna go and get my revenue number from the Red Bull model. Go to the income statement. I'm gonna get my total revenue number, so that's the actual year and then copy that right. And then I'll go and get EBITDA as well. And I'll pull that in again in the actual year and then copy that, right? So this means we've got all the key information that we need for our valuation summary.