We've now populated all of our source information for our comparable companies, and it's now time to calculate our ratios, the ones that we're going to look at and decide whether we can use them to value Red Bull.

So we scroll to the right and we found our, we find our first ratio, which is the enterprise value over sales.

We could just find the enterprise value and divide by the sales figure, but we're going to be a little bit more sophisticated. On occasions, we might have a zero on the bottom of our fraction, which would give us an error. So we're going to use the IF error function, and you can see that this will basically give you a value unless it's an error.

So our value is the enterprise value over here in column H, and we want to lock that column.

So we hit F four until we get a dollar in front of the H, and then we're going to divide that by the sales figure, just alongside it in column I. However, if there was an error, we want it to show us there's an error, so we ask it to give us an na.

If there's an error, and hopefully for this one, it'll be fine.

We hit return and we get a fairly sensible number, 7.5 times for the EV over sales figure.

Now, because we've locked our ev, we should just be able to copy this to the right and it works. The sales figure moves, but the EV doesn't.

Similarly, because the sales EBITDA and EBIT columns, the source information is in the same order.

We can just copy those three calculations to the right.

If we're happy with them, we can copy down for the next three companies.

And you can see that we do get a couple of those errors for lason, where we don't have information. We don't have forecast information For 2023, we're now gonna move to the right, and we have another couple of ratios to calculate.

The first one is the EBITDA margin.

So the EBITDA divided by sales. This is just a simple division, so we're going to take the last 12 months EBITDA figure and divide by sales in the same year, and that gives a margin of 32.5%. Final calculation For us to do is the revenue growth, where we're going to look at the rate of growth of revenue from the last 12 months to the first forecast year. So we're going to find 2022 revenue divide by the last 12 months revenue, and then subtract one to give us that percentage increase.

We're comfortable with those figures. You can use control D to copy down, and our ratios are complete.