Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Horizontal Analysis - Walmart (as of January 31, 2021) Table B: Horizontal Analysis Walmart Inc. Base Year: 2019 2021 2020 2019 Income Statement Items Net

Horizontal Analysis - Walmart (as of January 31, 2021)

Table B: Horizontal Analysis
Walmart Inc.
Base Year: 2019
2021 2020 2019
Income Statement Items
Net Sales 108.70% 101.86% 100.00%
Cost of goods sold 109.09% 102.41% 100.00%
Other Operating Expenses 108.53% 101.53% 100.00%
Balance Sheet Items
Inventory 101.54% 100.37% 100.00%
Total Assets 115.14% 107.84% 100.00%
  1. Use the horizontal analysis tab from the Excel portion of the assignment to answer these questions.
  2. What trend do you notice about your companys key income statement items over the last three years (i.e. current year and two prior years)? How are each of these key accounts changing? What does this tell you about the company does this indicate a good or bad trend?
  3. What trend do you notice about your companys key balance sheet items over the last three years (i.e. current year and two prior years)? How are each of these key accounts changing? What does this tell you about the company does this indicate a good or bad trend?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Managerial Accounting

Authors: Peter Brewer, Ray Garrison, Eric Noreen

7th edition

978-1259675539, 125967553X, 978-1259594168, 1259594165, 78025796, 978-0078025792

More Books

Students also viewed these Accounting questions