50.1K

Verified Solution

Link Copied!

Conclusion - Walmart (as of January 31, 2021)

Based on your analysis of the company (everything youve evaluated up to this point), provide recommendations for whether:

1. Creditors should loan money to this company in the short-term
2. Creditors should loan money to this company in the long-term
3. Investors should buy, hold, or sell the stock (use the competitor as a baseline, and be sure to consider the current price of the stock)

Walmart Inc. 2021 2020 Balance Sheet Items Inventory 44,949 44,435 Current Assets 90,067 61,806 Property, Plant, and Equipment (net) 92,201 ##### Total Assets Current Liabilities 92,645 77,790 Long-term Liabilities 72,320 77,153 Total Liabilities ##### ##### Stockholders' Equity 87,531 81,552 Total Liabilities and Stockholders' Equit ##### ##### Common Shares Outstanding 2,821 2,832 Income Statement Items Net Sales ##### Cost of Goods Sold ##### Gross Profit Other Operating Expenses Net Income 13,510 Interest Expense 2,194 Income Tax Expense 6,858 Statement of Retained Earnings Total Cash Dividends 6,116 Preferred Stock Cash Dividends 0 Common Stock Cash Dividends 6,116 Cash Flow Statement Net Cash Provided by Operating Activiti 36,074 Capital Expenditures Other Market Price Per Share 2019 Table B: Horizontal Analysis Walmart Inc. 44,269 Base Year: Income Statement Items ##### Net Sales Cost of goods sold Other Operating Expenses Balance Sheet Items 79,634 Inventory Total Assets 2,878 ##### Table C: Vertical Analysis ##### Walmart Inc. ##### ##### ##### Income Statement Items 14,881 Net Income 2,410 Cost of goods sold 4,915 Balance Sheet Items Current Assets 6,048 Property, Plant, and Equipment (net) 0 Current Liabilities 6,048 Long-term Liabilities Stockholders' Equity 25,255 10,264 10,705 Table D: Ratio Analysis 140.49 114.49 Walmart Inc. Liquidity Ratios Solvency Ratios Profitability Ratios Working Capital Current Ratio Inventory Turnover Days in Inventory Debt to Asset Ratio Times Interest Earned Free Cash Flow Earnings Per Share Price-Earnings Ratio Gross Profit Rat Profit Margin Return on Assets Asset Turnover Payout Ratio Return on Common Stockholders' Equity 2019 2021 2020 2015 108 70% 101 86% 100.0 109.09% 102 41% 100.0 108 53% 101 53% 100.00 100 37% 101 54% 115 14% 100.0 100.00 107 84% 2021 2020 2.42% 2.84% 75.17% 75.31% 35.67% 26.13% 36.52% 44.49% 56.16% 50.21% 43.84% 49.79% 34.67% 34.48% 2021 2020 (2,578) (15,984) 0.97 0.79 9.40 8.90 38.81 41.02 0.65 0.66 10.28 9.21 19,694 8,502 $4.78 $5.21 29.39 21.97 0.25 0.25 0.024 0.028 0.06 0.07 2.29 2.30 0.45 0.41 0.16 0.18

Answer & Explanation Solved by verified expert

See Answer