Analyzing Asset Ratios

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

Review the most recent annual reports of The Coca-Cola Company and PepsiCo focusing on the balance sheet and footnote inventories.

Using the correct formulas and a separate tab for each ratio, calculate the following ratios for each company for the last 2 years using Excel:

1. Inventory turnover
2. Average days in inventory

In a Word file, include the following:

1. Explain the meaning of each ratio and what the calculated results tell you about each of the companies. Refer to the calculated ratios in your analysis. Your explanation should consider how the ratios changed in the last 2 years. Your explanation should include a separate paragraph for each ratio.
2. Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet.

Submit the Excel file that contains your ratios and the Word file memo to your instructor.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.