Assignment with excel spreadsheet

User Generated

nfuyrlc666

Business Finance

Description

Purpose of Assignment

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: Financial Accounting: Tools for Business Decision Making

Write a 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 these 2014 values for each company based on the information in the financial statements:
    • Inventory turnover (Use cost of sales and inventories). (Note: that average inventory should be calculated and used in the Inventory turnover).
    • Days of inventory
  • Conclusions concerning the management of the inventory can you draw from this data.

Show work on Excel® spreadsheet and submit with analysis.

Unformatted Attachment Preview

Name Section Date Chapter 6 Comparative Analysis Problem 2 Amazon.com, Inc. vs. Wal-Mart Stores, Inc. (a) Amazon.com Inventory turnover: Days in inventory: (b) 377 Wal-Mart Comparative Analysis Problem: Amazon.com, Inc. vs. Wal-Mart Stores, Inc. Grading Guide ACC/290 Version 7 Principles of Accounting I Copyright Copyright © 2017, 2015, 2014, 2013, 2012, 2011 by University of Phoenix. All rights reserved. University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation. Edited in accordance with University of Phoenix® editorial standards and practices. Comparative Analysis Problem: Amazon.com, Inc. vs. Wal-Mart Stores, Inc. Grading Guide ACC/290 Version 7 Individual Assignment: Comparative Analysis Problem: Amazon.com, Inc. vs. Wal-Mart Stores, Inc. Purpose of Assignment 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. Resources Required Financial Accounting: Tools for Business Decision Making. Grading Guide Content Met Partially Met Not Met Total Available Total Earned 6 #/6 Partially Met Not Met Comments: Write a 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. Included the 2014 values based on the following: • Inventory turnover (Use cost of sales and inventories) • Days of inventory Included conclusions concerning the management of the inventory. The analysis was 1,050 words in length. Writing Guidelines The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements. Intellectual property is recognized with in-text citations and a reference page. Paragraph and sentence transitions are present, logical, and maintain the flow Met Comments: 2 Comparative Analysis Problem: Amazon.com, Inc. vs. Wal-Mart Stores, Inc. Grading Guide ACC/290 Version 7 Writing Guidelines Met Partially Met Not Met Total Available Total Earned 3 #/3 9 #/9 throughout the paper. Sentences are complete, clear, and concise. Rules of grammar and usage are followed including spelling and punctuation. Assignment Total Additional comments: # Comments: 3
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please check and revert

Running head: BASIC COMPARATIVE ANALYSIS

Comparative analysis using the financial statements of Amazon.com, Inc and financial
statements for Wal-Mart Stores, Inc.

Financial Accounting and Tools for Business Decision
Student’s Name
Institution

1

BASIC COMPARATIVE ANALYSIS

2

Introduction
One of the most frequently asked questions in efforts of understanding business operations is;
what is accounting? Accounting is a system that maintains operational records of an organization
and communicates this information to decision makers. An accounting system comprises of two
aspects namely managerial accounting and financial accounting. Managerial accounting is
concerned with preparation of detailed reports, plans and forecasts while financial accounting is
concerned with preparation of financial statements i.e. statement of cash flows, statement of
retained earnings, balance sheets, and the income statements. Most organizations use liquidity
ratios as to measure their ability to meet their short-term maturity requirements i.e. the ability of
a company to convert assets into cash without loss in value. This piece of work evaluates the
inventory sections of Wal-Mart store Inc. and Amazon.com Inc. in 2014 financial year using
primary comparative analysis. (Libby, 2001)
Financial statements in most companies are prepared quarterly or annually. In such reports,
key financial variables such as inventories play vital roles in stock supply chain i.e. stock-out and
overstock. Among other transactions done in inventories, include; sales, requisitions, return
orders and transfers. There are three types of inventories namely; raw ...


Anonymous
Really useful study material!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags