Accounting

PLEASE USE EXCEL ATTACHMENT THAT IS PROVIDED

    The purpose of this assignment is to evaluate the inventory section of two companies using basic comparative analysis, and to interpret the data to gain insight about the company's inventory management.

Assignment Steps

Resources: Appendices D @https://phoenix.vitalsource.com/#/books/9781119228301/cfi/6/52!/4/2/2@0:0.00  

and E @https://phoenix.vitalsource.com/#/books/9781119228301/cfi/6/54!/4/2/2@0:0.00 

located in Financial Accounting: Tools for Business Decision Making

Note: While the data are not from the same year, inferences can be drawn regarding inventory management of the two companies.

Write a 700 to 1,000-word comparative analysis using the financial statements of Amazon.com, Inc. presented in Appendix D, and the financial statements for Wal-Mart Stores, Inc., presented in Appendix E, including the following:

• Compute the 2014 values for Amazon.com and the 2015 values for Wal-Mart based on the information in the financial statements:
  • Inventory turnover (Use cost of sales and inventories)
  • Days of inventory

• Conclusions concerning the management of the inventory can you draw from this data. 

PLEASE USE EXCEL ATTACHMENT THAT IS PROVIDED

Show work on Excel® spreadsheet and submit with analysis.  There are two documents to be submitted (Excel spreadsheet showing the computed Inventory Turnover and Days in Inventory and comparative analysis on Word document).