Walmart's Ratio Analysis Required: Comment on the Walmart's 3-year trends in the following liquidity, solvency, and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Walmart's Ratio Analysis Required: Comment on the Walmart's 3-year trends in the following liquidity, solvency, and profitability ratios: • Return on Assets. Is it up or down, and why? Data: Walmart's return on assets decreased in 2016 (7.5%, -10.7%), 2017 (7.2%, -4.1%), 2018 (5.2%, -27.3%) and 2019 (3.4%, -35.1%) and increased in 2020 (6.7%, +96.9%). Debt equity ratio Is it up or down, and why? Data: Fiscal Year 2016-01-31 2017-01-31 2018-01-31 2019-01-31 2020-01-31 Total Debt 50.772 B 46.568 B 46.673 B 58.461 B 73.129 B Common Equity 80.546 B 77.798 B 77.869 B 72.496 B 74.669 B Debt / Equity Ratio • Current Ratio. Is it up or down, and why? Data: 63.0% 59.9% 59.9% 80.6% 97.9% Walmart's current ratio decreased in 2016 (0.9x, -3.9%), 2017 (0.9x, -7.5%), 2018 (0.8x, -11.8%) and 2020 (0.8x, -0.5%) and increased in 2019 (0.8x, +5.1%). Annual Data | Millions of US $ except per share data Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS - Earnings Per Share EEE 3 Lul EEEEEE EEE ..... EEEEE 2020-01-31 $523,964 $394,605 $129,359 $108,791 $503,396 $20,568 $-452 $20,116 $4,915 $15,201 $15,201 $14,881 $31,555 $20,568 2,850 2,868 $5.22 $5.19 2019-01-31 $514,405 $385,301 $129,104 $107,147 $492,448 $21,957 $-10,497 $11,460 $4,281 $7,179 $7,179 $6,670 $32,635 $21,957 2,929 2,945 $2.28 $2.26 2018-01-31 $500,343 $373,396 $126,947 $106,510 $479,906 $20,437 $-5,314 $15,123 $4,600 $10,523 - $10,523 $9,862 $30,966 $20,437 2,995 3,010 $3.29 $3.28 Annual Data | Millions of US $ except per share data Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEE EE EEEEEE 3 3 3 3 3 EE 2020-01-31 $9,465 $6,284 $44,435 $1,622 $61,806 $105,208 $31,073 $38,408 $174,689 $236,495 $77,790 $64,192 $77,153 $154,943 $284 $83,943 $-12,805 $81,552 $236,495 2019-01-31 $7,722 $6,283 $44,269 $3,623 $61,897 $104,317 $31,181 $14,822 $157,398 $219,295 $77,477 $50,203 $62,184 $139,661 $288 $80,785 $-11,542 $79,634 $219,295 2018-01-31 $6,756 $5,614 $43,783 $3,511 $59,664 $107,675 $18,242 $11,798 $144,858 $204,522 $78,521 $36,825 $45,179 $123,700 $295 $85,107 $-10,181 $80,822 $204,522 Annual Data | Millions of US $ except per share data Net Income/Loss Total Depreciation And Amortization - Cash Flow Other Non-Cash Items Total Non-Cash Items Change In Accounts Receivable Change In Inventories Change In Accounts Payable Change In Assets/Liabilities Total Change In Assets/Liabilities Cash Flow From Operating Activities Net Change In Property, Plant, And Equipment Net Change In Intangible Assets Net Acquisitions/Divestitures Net Change In Short-term Investments Net Change In Long-Term Investments Net Change In Investments - Total Investing Activities - Other Cash Flow From Investing Activities Net Long-Term Debt Net Current Debt Debt Issuance/Retirement Net - Total Net Common Equity Issued/Repurchased Net Total Equity Issued/Repurchased Total Common And Preferred Stock Dividends Paid Financial Activities - Other Cash Flow From Financial Activities Net Cash Flow Stock-Based Compensation Common Stock Dividends Paid EEEEEEE EEE E الا EEEEE الا اسا L.M اسا الا ... اسا اسا E 2020-01-31 $15,201 $10,987 $-2,587 $8,400 $154 $-300 $-274 $-327 $25,255 $-10,384 $-56 $1,312 $-9,128 $3,585 $-4,656 $-1,071 $-5,717 $-5,717 $-6,603 $-908 $-14,299 $1,759 $-6,603 2019-01-31 $7,179 $10,678 $7,867 $18,545 $-368 $-1,311 $1,831 $295 $27,753 $-9,825 $-14,656 $445 $-24,036 $12,088 $-53 $12,035 $-7,410 $-7,410 $-6,533 $-629 $-2,537 $742 $-6,533 2018-01-31 $10,523 $10,529 $2,832 $13,361 $-1,074 $-140 $4,086 $3,243 $28,337 $-9,673 $-375 $969 $-9,079 $-5,585 $4,148 $-1,437 $-8,296 $-8,296 $-6,814 $-3,328 $-19,875 $-130 $-6,814 Annual Data Current Ratio Long-term Debt / Capital Debt/Equity Ratio Gross Margin Operating Margin EBIT Margin EBITDA Margin Pre-Tax Profit Margin Net Profit Margin Asset Turnover Inventory Turnover Ratio Receiveable Turnover Days Sales In Receivables ROE - Return On Equity Return On Tangible Equity ROA - Return On Assets ROI - Return On Investment Book Value Per Share Operating Cash Flow Per Share Free Cash Flow Per Share EEEEEE سا 1.bl ..... لسا لا Lul .... لا L.h .... ..... EEE 2020-01-31 0.7945 0.4404 0.8882 24.6885 3.9255 3.9255 6.0224 3.8392 2.8401 2.2155 8.8805 83.3807 4.3775 18.6396 30.1135 6.4276 10.4299 28.7966 8.8058 5.1851 2019-01-31 0.7989 0.3867 0.7287 25.0977 4.2684 4.2684 6.3442 2.2278 1.2966 2.3457 8.7036 81.8725 4.4582 9.015 14.8164 3.2737 5.5292 27.6699 9.4238 6.0876 2018-01-31 0.7598 0.313 0.5752 25.372 4.0846 4.0846 6.189 3.0225 1.971 2.4464 8.5283 89.1242 4.0954 13.02 16.8153 5.1452 8.9446 27.3787 9.4143 6.2007 Walmart's Ratio Analysis Required: Comment on the Walmart's 3-year trends in the following liquidity, solvency, and profitability ratios: • Return on Assets. Is it up or down, and why? Data: Walmart's return on assets decreased in 2016 (7.5%, -10.7%), 2017 (7.2%, -4.1%), 2018 (5.2%, -27.3%) and 2019 (3.4%, -35.1%) and increased in 2020 (6.7%, +96.9%). Debt equity ratio Is it up or down, and why? Data: Fiscal Year 2016-01-31 2017-01-31 2018-01-31 2019-01-31 2020-01-31 Total Debt 50.772 B 46.568 B 46.673 B 58.461 B 73.129 B Common Equity 80.546 B 77.798 B 77.869 B 72.496 B 74.669 B Debt / Equity Ratio • Current Ratio. Is it up or down, and why? Data: 63.0% 59.9% 59.9% 80.6% 97.9% Walmart's current ratio decreased in 2016 (0.9x, -3.9%), 2017 (0.9x, -7.5%), 2018 (0.8x, -11.8%) and 2020 (0.8x, -0.5%) and increased in 2019 (0.8x, +5.1%). Annual Data | Millions of US $ except per share data Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS - Earnings Per Share EEE 3 Lul EEEEEE EEE ..... EEEEE 2020-01-31 $523,964 $394,605 $129,359 $108,791 $503,396 $20,568 $-452 $20,116 $4,915 $15,201 $15,201 $14,881 $31,555 $20,568 2,850 2,868 $5.22 $5.19 2019-01-31 $514,405 $385,301 $129,104 $107,147 $492,448 $21,957 $-10,497 $11,460 $4,281 $7,179 $7,179 $6,670 $32,635 $21,957 2,929 2,945 $2.28 $2.26 2018-01-31 $500,343 $373,396 $126,947 $106,510 $479,906 $20,437 $-5,314 $15,123 $4,600 $10,523 - $10,523 $9,862 $30,966 $20,437 2,995 3,010 $3.29 $3.28 Annual Data | Millions of US $ except per share data Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity EEEE EE EEEEEE 3 3 3 3 3 EE 2020-01-31 $9,465 $6,284 $44,435 $1,622 $61,806 $105,208 $31,073 $38,408 $174,689 $236,495 $77,790 $64,192 $77,153 $154,943 $284 $83,943 $-12,805 $81,552 $236,495 2019-01-31 $7,722 $6,283 $44,269 $3,623 $61,897 $104,317 $31,181 $14,822 $157,398 $219,295 $77,477 $50,203 $62,184 $139,661 $288 $80,785 $-11,542 $79,634 $219,295 2018-01-31 $6,756 $5,614 $43,783 $3,511 $59,664 $107,675 $18,242 $11,798 $144,858 $204,522 $78,521 $36,825 $45,179 $123,700 $295 $85,107 $-10,181 $80,822 $204,522 Annual Data | Millions of US $ except per share data Net Income/Loss Total Depreciation And Amortization - Cash Flow Other Non-Cash Items Total Non-Cash Items Change In Accounts Receivable Change In Inventories Change In Accounts Payable Change In Assets/Liabilities Total Change In Assets/Liabilities Cash Flow From Operating Activities Net Change In Property, Plant, And Equipment Net Change In Intangible Assets Net Acquisitions/Divestitures Net Change In Short-term Investments Net Change In Long-Term Investments Net Change In Investments - Total Investing Activities - Other Cash Flow From Investing Activities Net Long-Term Debt Net Current Debt Debt Issuance/Retirement Net - Total Net Common Equity Issued/Repurchased Net Total Equity Issued/Repurchased Total Common And Preferred Stock Dividends Paid Financial Activities - Other Cash Flow From Financial Activities Net Cash Flow Stock-Based Compensation Common Stock Dividends Paid EEEEEEE EEE E الا EEEEE الا اسا L.M اسا الا ... اسا اسا E 2020-01-31 $15,201 $10,987 $-2,587 $8,400 $154 $-300 $-274 $-327 $25,255 $-10,384 $-56 $1,312 $-9,128 $3,585 $-4,656 $-1,071 $-5,717 $-5,717 $-6,603 $-908 $-14,299 $1,759 $-6,603 2019-01-31 $7,179 $10,678 $7,867 $18,545 $-368 $-1,311 $1,831 $295 $27,753 $-9,825 $-14,656 $445 $-24,036 $12,088 $-53 $12,035 $-7,410 $-7,410 $-6,533 $-629 $-2,537 $742 $-6,533 2018-01-31 $10,523 $10,529 $2,832 $13,361 $-1,074 $-140 $4,086 $3,243 $28,337 $-9,673 $-375 $969 $-9,079 $-5,585 $4,148 $-1,437 $-8,296 $-8,296 $-6,814 $-3,328 $-19,875 $-130 $-6,814 Annual Data Current Ratio Long-term Debt / Capital Debt/Equity Ratio Gross Margin Operating Margin EBIT Margin EBITDA Margin Pre-Tax Profit Margin Net Profit Margin Asset Turnover Inventory Turnover Ratio Receiveable Turnover Days Sales In Receivables ROE - Return On Equity Return On Tangible Equity ROA - Return On Assets ROI - Return On Investment Book Value Per Share Operating Cash Flow Per Share Free Cash Flow Per Share EEEEEE سا 1.bl ..... لسا لا Lul .... لا L.h .... ..... EEE 2020-01-31 0.7945 0.4404 0.8882 24.6885 3.9255 3.9255 6.0224 3.8392 2.8401 2.2155 8.8805 83.3807 4.3775 18.6396 30.1135 6.4276 10.4299 28.7966 8.8058 5.1851 2019-01-31 0.7989 0.3867 0.7287 25.0977 4.2684 4.2684 6.3442 2.2278 1.2966 2.3457 8.7036 81.8725 4.4582 9.015 14.8164 3.2737 5.5292 27.6699 9.4238 6.0876 2018-01-31 0.7598 0.313 0.5752 25.372 4.0846 4.0846 6.189 3.0225 1.971 2.4464 8.5283 89.1242 4.0954 13.02 16.8153 5.1452 8.9446 27.3787 9.4143 6.2007
Expert Answer:
Answer rating: 100% (QA)
ANSWER Walmarts return on assets ROA decreased from 75 in 2016 to 34 in 2019 before increasing to 67 ... View the full answer
Related Book For
Corporate Financial Accounting
ISBN: 978-1337272124
15th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
P Company has provided the following data: Sales Price per unit: RM50 Variable Cost per unit: RM30 Fixed Cost: RM135,000 Expected Sales: 20,000 units a) What is the breakeven point in sales dollars?...
-
The Culleye Corporation reported the following solvency ratios: 2017 2016 Debt to total assets.....56.0%....................52.8% Interest coverage........5.1 times............3.3 times (a) Identify...
-
CHAPTER EXERCISES: [110] 1. Let A 0 1 1 and B= 2 5 1 0 1 [1 2 3] 3. Find A and B- by [108] (a) Solving the matrix equation AX = I for X (b) Adjoining the matrices with I or using Gauss-Jordan...
-
In September 2020 Kevin sells a drawing for 2,000. He bought the drawing in February 2014 for 50,000 when it was thought (incorrectly) to be by a famous artist. Compute the allowable loss.
-
Using the coconut oil demand function from Question 1.9, calculate the income elasticity of demand for coconut oil. (If you do not have all the numbers necessary to calculate numerical answers, write...
-
Find x-intercept of the equation. y= 5x-0 Type only the x-intercept rounding to the hundredths place if applicable. For example if x-intercept is (4, 0), you will type only 4. For help click here 6
-
A process is said to be feasible if (a) \(\Delta G>0\) (b) \(\Delta G <0\) (c) \(\Delta G <1\) (d) \(\Delta G>1\).
-
Complete the table below and plot the EAC as a function of time. What are yourconclusions? Cumulative Cost, in Thousands Variance S Week BCWS BCWP ACWP Schedule Cost EAC 50 70 90 120 130 140 165 200...
-
Stoichiometric air-fuel ratio for gasoline An average formulation for gasoline is C-H13. Complete combustion in air produces C7H13 + 10.25 02 + 38.54 N2 = 7 CO2 +6.5 H20+ 38.54 N2 Determine the...
-
A randomized controlled trial comparing two drugs for treating insomnia is said to have 85% power to detect a 20% relative reduction (RR=0.80) in sleep problems nine months following treatment at the...
-
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the...
-
What is the function of air chambers in a reciprocating pump?
-
What is the main difference between a plunger and bucket type pumps?
-
Define slip in a reciprocating pump.
-
How do you classify centrifugal pumps?
-
How do you classify pumps?
-
From their formulas, one might think that the molecules CO2 and SO would have the same molecular geometry. Yet they do not. Tell the molecular geometry for each. Explain why their geometries are...
-
A genetically engineered strain of Escherichia coli (E. coli) is used to synthesize human insulin for people suffering from type I diabetes mellitus. In the following simplified reaction scheme,...
-
The following accounts and their balances were selected from the unadjusted trial balance of Point Loma Group Inc., a freight forwarder, at October 31, the end of the current fiscal year: Common...
-
Ralph Lauren Corporation (RL) sells apparel through company-owned retail stores. Financial information for Ralph Lauren follows (in thousands): Assume the apparel industry average return on total...
-
Sears Editing Company is a small editorial services company owned and operated by Deloris Sears. On January 31, 20Y1, the end of the current year, Sears Editing Companys accounting clerk prepared the...
-
Explain the principle of hit-and-run entry in the context of a perfectly contestable market.
-
Is it possible for a firm or firms operating in a natural monopoly to be subject to contestability? Explain.
-
Firms like Google, Facebook, Amazon, Apple and Netflix are relatively new players in their respective markets, albeit that all are basically part of the tech industry. They can all be seen as having...
Study smarter with the SolutionInn App