Based on your analysis of the company (everything youve evaluated up to this point) , provide recommendations
Fantastic news! We've Found the answer you've been seeking!
Question:
Based on your analysis of the company (everything you’ve evaluated up to this point), provide recommendations for whether: Walmart (as of January 31, 2021)
- Creditors should loan money to this company in the short-term
- Creditors should loan money to this company in the long-term
- 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)
Transcribed Image Text:
Walmart Inc. 2021 2020 2019 Table B: Horizontal Analysis Balance Sheet Items Walmart Inc. Inventory 44,949 44,435 44,269 Base Year: 2019 Current Assets 90,067 61,806 2020 2010 2021 Property, Plant, and Equipment (net) 92,201 ##### Income Statement Items Total Assets ##### ##### ##### Net Sales 108 70% 101 86% 100 0 Current Liabilities 92,645 77,790 Cost of goods sold 109.09% 102 41% 10o o 77,153 ##### Long-term Liabilities 72,320 Other Operating Expenses 108 53% 101 53% 100 o Total Liabilities ##### Balance Sheet Items 79,634 Stockholders' Equity Total Liabilities and Stockholders' Equit #### Common Shares Outstanding 87,531 81,552 Inventory 101 54% 100 37% 100 0 ##### Total Assets 115 14% 107.84% 100 2,821 2,832 2,878 Income Statement Items Net Sales ##### ##### ##### Table C: Vertical Analysis Cost of Goods Sold ##### ##### ##### Walmart Inc. Gross Profit ##### ##### 2021 2020 Other Operating Expenses ##### ##### ##### Income Statement Items Net Income 13,510 14,881 Net Income 2.42% 2.84% Interest Expense 2,194 2,410 Cost of goods sold 75.17% 75.31% Income Tax Expense 6,858 4,915 Balance Sheet Items Statement of Retained Earnings Current Assets 35.67% 26.13% Total Cash Dividends 6,116 6,048 Property, Plant, and Equipment (net) 36.52% 44.49% 56.16% 50.21% 43.84% 49.79% Preferred Stock Cash Dividends Current Liabilities Long-term Liabilities Stockholders' Equity Common Stock Cash Dividends 6,116 6,048 Cash Flow Statement 34.67% 34.48% Net Cash Provided by Operating Activiti 36,074 25,255 Capital Expenditures 10,264 10.705 Other Table D: Ratio Analysis Market Price Per Share 140.49 114.49 Walmart Inc. 2021 2020 Liquidity Ratios (2,578) (15,984) Working Capital Current Ratio 0.97 0.79 Inventory Turnover 9.40 8.90 Days in Inventory 38.81 41.02 Solvency Ratios Debt to Asset Ratio 0.65 0.66 Times Interest Earned 10.28 9.21 Free Cash Flow 19,694 8,502 Profitability Ratios Earnings Per Share $4.78 $5.21 Price-Earnings Ratio 29.39 21.97 Gross Profit Rate 0.25 0.25 Profit Margin 0.024 0.028 Return on Assets 0.06 0.07 Asset Turnover 2.29 2.30 Payout Ratio 0.45 0.41 Return on Common Stockholders' Equity 0.16 0.18 Walmart Inc. 2021 2020 2019 Table B: Horizontal Analysis Balance Sheet Items Walmart Inc. Inventory 44,949 44,435 44,269 Base Year: 2019 Current Assets 90,067 61,806 2020 2010 2021 Property, Plant, and Equipment (net) 92,201 ##### Income Statement Items Total Assets ##### ##### ##### Net Sales 108 70% 101 86% 100 0 Current Liabilities 92,645 77,790 Cost of goods sold 109.09% 102 41% 10o o 77,153 ##### Long-term Liabilities 72,320 Other Operating Expenses 108 53% 101 53% 100 o Total Liabilities ##### Balance Sheet Items 79,634 Stockholders' Equity Total Liabilities and Stockholders' Equit #### Common Shares Outstanding 87,531 81,552 Inventory 101 54% 100 37% 100 0 ##### Total Assets 115 14% 107.84% 100 2,821 2,832 2,878 Income Statement Items Net Sales ##### ##### ##### Table C: Vertical Analysis Cost of Goods Sold ##### ##### ##### Walmart Inc. Gross Profit ##### ##### 2021 2020 Other Operating Expenses ##### ##### ##### Income Statement Items Net Income 13,510 14,881 Net Income 2.42% 2.84% Interest Expense 2,194 2,410 Cost of goods sold 75.17% 75.31% Income Tax Expense 6,858 4,915 Balance Sheet Items Statement of Retained Earnings Current Assets 35.67% 26.13% Total Cash Dividends 6,116 6,048 Property, Plant, and Equipment (net) 36.52% 44.49% 56.16% 50.21% 43.84% 49.79% Preferred Stock Cash Dividends Current Liabilities Long-term Liabilities Stockholders' Equity Common Stock Cash Dividends 6,116 6,048 Cash Flow Statement 34.67% 34.48% Net Cash Provided by Operating Activiti 36,074 25,255 Capital Expenditures 10,264 10.705 Other Table D: Ratio Analysis Market Price Per Share 140.49 114.49 Walmart Inc. 2021 2020 Liquidity Ratios (2,578) (15,984) Working Capital Current Ratio 0.97 0.79 Inventory Turnover 9.40 8.90 Days in Inventory 38.81 41.02 Solvency Ratios Debt to Asset Ratio 0.65 0.66 Times Interest Earned 10.28 9.21 Free Cash Flow 19,694 8,502 Profitability Ratios Earnings Per Share $4.78 $5.21 Price-Earnings Ratio 29.39 21.97 Gross Profit Rate 0.25 0.25 Profit Margin 0.024 0.028 Return on Assets 0.06 0.07 Asset Turnover 2.29 2.30 Payout Ratio 0.45 0.41 Return on Common Stockholders' Equity 0.16 0.18
Expert Answer:
Answer rating: 100% (QA)
1 Creditor should not loan money to this company in the short term as the current rat... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these organizational behavior questions
-
Based on your analysis of the company and the industry, describe the most significant problems or issues facing 7-Eleven in Taiwan.
-
Based on your analysis of the case of the 9 deaths at Alabama hospitals and a review of the available literature, you will develop recommendation to the hospital's management team regarding the steps...
-
The normal stresses acting on two perpendicular planes at a point in a strained material are 70 MN/ m2 tensile, and 35 MN/ m compressive. In addition, a shear stress of 40 N/mm2 acts on these planes....
-
Calculate the following ratios from the data given below: 1. Debt ratio 2. Debt service coverage multiples 3. Interest coverage Balance Sheet 12/31/2014 Assets Cash..$575,000 Short-term...
-
Rank the absolute values of the price elasticities of demand at the points A, B, C, D, and E on the following three demandcurves. P, B.
-
2) Two point charges of +50.0 C and -11.0 C are separated by a distance of 20.0 cm. What is the electric field due to these charges at a point midway between them?
-
Describe the Waterfall Development Model, its characteristics, and shortcomings.
-
Aspen Company estimates its manufacturing overhead to be $625,000 and its direct labor costs to be $500,000 for year 2. Aspen worked on three jobs for the year. Job 2-1, which was sold during year 2,...
-
i) What is the function of the host controller interface? ii) State the full meaning of IBSS and mention two of its properties b. 1 mark 2 marks (i) What is the main difference between Public Key...
-
Aaron, Deanne, and Keon formed the Blue Bell General Partnership at the beginning of the current year. Aaron and Deanne each contributed $110,000 and Keon transferred an acre of undeveloped land to...
-
Cosmic Corporation had the following transactions in June: More Info Jun. 1 Sold merchandise inventory on account to Cody Company, $1,485. Jun. 6 Sold merchandise inventory for cash, $560. Jun. 12...
-
Plot the average number of phonons for at least five values of T to show its evolution with increasing temperatures. For each one, plot the function and show that it is a good approximation for N()...
-
Work Prob. 13.51 for the NRTL equation. Prob. 13.51 For the acetone(1)/methanol(2)/water(3) system, based on Eq. (13.19) and the Wilson equation, make the following calculations: (a) BUBL P : t =...
-
Change in labor productivity is one of the most watched international statistics of growth. Visit the St. Louis Federal Reserve website and find the data section (http://research.stlouisfed.org)....
-
When a parent-subsidiary relationship exists, consolidated financial statements are prepared in recognition of the accounting concept of a. Reliability. b. Materiality. c. Legal entity. d. Economic...
-
In determining whether or not a variable interest entity is to be consolidated, the FASB focused on a. Legal control. b. Share of profits and obligation to absorb losses. c. Frequency of intercompany...
-
Define generalisation in neural networks that examine from training information, after which are examined on new data. Why need to now not all the available facts be used in the training set? [4...
-
Assessing simultaneous changes in CVP relationships Braun Corporation sells hammocks; variable costs are $75 each, and the hammocks are sold for $125 each. Braun incurs $240,000 of fixed operating...
-
Green Grow Inc. (GGI) manufactures lawn fertilizer and because of its very high quality often receives special orders from agricultural research groups. For each type of fertilizer sold, each bag is...
-
What is the underlying relationship in CVP analysis?
-
Value-Chain Analysis Required Develop a value chain of six to eight items for Tartan Corporation described in Problem 2-36. Why would the value chain be useful to a firm like Tartan? In Problem 2-36,...
-
This exercise considers the data described in the Section 13.2.2 ratemaking classification example using data in Table 13.3 Table 13.3 . a. Fit a gamma regression model using a log-link function with...
-
This exercise considers data from the Medical Expenditure Panel Survey (MEPS) described in Exercise 1.1 and Section 11.4. Our dependent variable consists of the number of outpatient (COUNTOP) visits....
-
Verify that the Tweedie distribution is a member of the linear exponential family of distributions by checking equation (13.9). In particular, provide an expression for \(S(y, \phi)\) (note that...
Study smarter with the SolutionInn App