Posted: October 11th, 2022

calculate asset ratios, then analyze and compare them between two competitors in the same industry; The Coca Cola Company and PepsiCo

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

https://investors.coca-colacompany.com/filings-reports/annual-filings-10-k
https://www.pepsico.com/investors/financial-information/sec-filings
https://www.examples.com/business/financial-memo.html
Assessment Descriiption
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
In a Microsoft Word file, prepare a memo to the instructor discussing the following. Be sure to include a minimum of one paragraph per company to support your findings.
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 have changed in the last 2 years. Your explanation should include a separate paragraph for each ratio.
Summarize how effective each 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.
General Requirements:
Submit the Excel file that contains your ratios and a separate Word file using an appropriate memo template. Please include a reference page as the last page of the memo document.
Name the Excel file “LastnameFirstinitial.T3Ratios” and name the Word document “LastnameFirstinitial.T3Memo.”
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.
Rubric Criteria
Ratio Calculations
9.5 points
Mechanics of Excel
4.75 points
Explanation of Inventory Turnover
19 points
Explanation of Average Days in Inventory
19 points
Effectiveness of Managing Inventory
19 points
Thesis Development and Purpose
4.75 points
Argument Logic and Construction
4.75 points
Mechanics of Writing
4.75 points
Paper Format
4.75 points
Documentation of Sources
4.75 points
Total
95 points

For This or a Similar Paper Click To Order Now