Explain the meaning of each ratio and what the calculated results tell you about each of the companies.

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 notes 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 turnoverAverage days in inventoryIn 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 a discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio to increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet.
FYI: Intext citation is required for descriptions and or explanations. Kindly use 7th edition APA for citations and references.
Some resources:Coca-Cola Co. (NYSE:KO) | Analysis of Short-term Activity Ratios (stock-analysis-on.net)
SEC Filings (pepsico.com)11+ Financial Memo Examples in PDF | MS Word | Pages | Google Docs | Examples

RECENT ASSIGMENTS

Write an essay on how having a child could change ( or have changed ) a persons life .

Explain why it is essential that young people change their mindset towards self-employment?

Discuss the article’s purpose, audience, and rhetorical situation or context in your own words.

What are the non-negotiables in terms of policy and practice?

Describe current state of malpractice in healthcare and how healthcare professionals respond against allegations of malpractice.

Do you happen to know when your family first immigrated to the United States?

What specific elements of each religion are mentioned in the readings and other course content areas that show a specifically Buddhist or Muslim approach to caring for the environment?

Write a paper analyzing ethnic identity of your choice (identity of your own ethnic group or any other ethnic group) based on theoretical ideas of Tajfel, Turner, Volkan, Horowitz, Eriksen or other theorists.

Write an assay that explores the elements of the UAE culture such as Islam, language, architecture, attire, cuisine.

Explain the meaning of each ratio and what the calculated results tell you about each of the companies.