Review the most recent annual reports of The Coca Cola Company and PepsiCo and focus on the balance sheet and inventory note included in the notes to the financial statements. Calculate the following ratios for each company for the last 2 years using Microsoft Excel. Be sure you are utilizing the correct formulas and a separate tab for each ratio:

1. Inventory turnover
2. Average days in inventory

Years in question are 2023 and 2022. Please solve and provide ratio numbers.

https://www.sec.gov/ix?doc=/Archives/edgar/data/21344/000002134424000009/ko-20231231.htm

https://www.pepsico.com/investors/financial-information/sec-filings