Calculate assets ratios
shatta-gThe 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.
- 2 years ago
- 20
Answer(1)
Purchase the answer to view it
NOT RATED
- uu1.pdf
- CocaColaandPepsiRatioWorksheet.xlsx
- CocaColaandPepsiRatioAnalysis.edited.docx
- CocaColaandPepsiRatioAnalysis.edited2.docx
- CocaColaandPepsiRatioWorksheet.xlsx
other Questions(10)
- Think about what your corporation/organization's ethics statement is. Based on this week's content, write a 1-2 page paper on which you reflect on the following questions in regard to the company's ethics statement: What things about this ethics statement
- 4G LTE architecture PPT
- need it by 5pm today..written in your own words 50 words for each question..separate each question
- acc 497 wk3 dq 1
- ESSAYS IN EMS INSURANCE AND COBRA AND EMTALA
- Analyzing Results of a Marketing Strategy
- 3D work
- This is a Discussion Question No APA formatting needed no pages and no word count just answer...
- Strategic Plan
- mkt lo