How the ratios have changed in the last two years

Assignment Help Business Management

Reference no: EM133484374

Problem: The Coca Cola Company and PepsiCo Analysis

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:

I. Inventory turnover
II. 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

Question I. 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.

Question II. 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.

Reference no: EM133484374

Questions Cloud

Discuss two items on the list of the ten essentials public : Identify and discuss two items on the list of the Ten Essentials Public Health Services that relate to ethics and integrity.

Do you think batman should kill the joker : Do you think Batman should kill the Joker? Should the controller switch the trolley to another track? Are these questions one and the same?

Explain an event where a corporation has committed fraud : Find an article in the Waldorf Online Library to help you explain an event where a corporation has committed healthcare or accounting fraud

Which existentialist philosophers ethical ideas : Which existentialist philosopher's ethical ideas make the most sense to you: Kierkegaard, Nietzsche, or Sartre?

How the ratios have changed in the last two years : Your explanation should consider how the ratios have changed in the last 2 years. Your explanation should include a separate paragraph for each ratio.

Which other governmental institutions cannot do : which other governmental institutions cannot do. For example, "law enforcement" is one of the most important roles of the police

Describe kant concept of good will : How would you describe Kant's concept of a good will? Why does he think a good will is concerned only with what is willed, not the consequences

How might you or people you know be affected by the results : How might you or people you know be affected by the results of that study? What might you have done differently if you had conducted the study?

Discuss how time and location can play a part in problem : Discuss how time and location can play a part in problem solving when used in conjunction with the S.A.R.A. model

User Account

All Pages