In this case study for the beverages market, we're going to take a look at analyzing the different comparable companies in the sector.

We have four main companies, Coca-Cola Co, Keurig Dr. Pepper, PepsiCo, and Monster.

Most of the exercises actually analyzing preexisting information.

However, to understand how the information was first developed, we're going to go down and we're going to calculate the numbers for one of the companies, which is Dr. Pepper. We also have two European companies, Suntory and Danone, but because they're less comparable, we're going to leave those alone.

So if we come down to the bottom here, you can see that we have the companies in columns, and for each company we have two years, the prior year, 2022, and the current year, or the last historical year, 2023. For Keurig Dr Pepper we have one blank column, which is the 2023 year.

And we want to complete the income statement items and you'll see that we have the reported items in many cases, but we also have adjusted items.

And we'll start by looking at what the company reports as adjusted items, and then perhaps we'll make some adjustments ourself to their adjustments.

We go through the income statement, and then after the income statement, we have selected balance sheet items, which we'll need to complete.

And then after the balance sheet items, we've got some additional components of property, plant and equipment working, capital and debt.

Finally, we look at the ratios, and these are really key to understanding the comparability and the relative performance of the different companies.

And there are three main groups of ratios.

They're profitability ratios, asset efficiency ratios, and leverage ratios.

Right at the bottom, we have an adjustment for leases to correct for the different accounting between operating leases and finance leases between US GAAP and IFRS accounting.

So our goal here is to go down column G in the spreadsheet and build the numbers from the filings.