Answered step by step
Verified Expert Solution
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% |
- Use the horizontal analysis tab from the Excel portion of the assignment to answer these questions.
- 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?
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started