Assessment Description

The purpose of this assignment is to calculate asset ratios, then analyze and compare them between two competitors in the same industry.

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:

Inventory turnover

Average days in inventory