Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required: Complete the following tasks for Walmart Inc. for its fiscal year ended January 31, 2021. The financial statements can be found in the annual
Required: Complete the following tasks for Walmart Inc. for its fiscal year ended January 31, 2021. The financial statements can be found in the annual report at the following location:
3.Compute the inventory turnover rate for the year ended January 31, 2021
6. Compute the property and equipment(net) turnover rate based on net sales for the year ended January 31, 2021
Walmart Inc
Consolidated Balance Sheet
Please add the explanation and formula as well. Thank you.
As of January 31, 2021 2020 $ (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets 17,741 $ 6,516 44,949 20,861 90,067 9,465 6,284 44,435 1,622 61,806 Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Goodwill Other long-term assets Total assets 92,201 13,642 4,005 28,983 23,598 252,496 $ 105,208 17,424 4,417 31,073 16,567 236,495 $ 224 S LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Total current liabilities 49,141 37,966 242 3,115 1,466 491 92,645 575 46,973 22,296 280 5,362 1,793 511 77,790 Long-term debt Long-term operating lease obligations Long-term finance lease obligations Deferred income taxes and other 41,194 12,909 3,847 14,370 43,714 16,171 4,307 12,961 Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 282 3,646 88,763 (11,766) 80,925 6,606 87,531 252,496 284 3,247 83,943 (12,805) 74,669 6,883 81,552 236,495 S Fiscal Years Ended January 31, 2021 2020 2019 $ 13,706 $ 15,201$ 7,179 11,152 (8,589) 10,678 3,516 4,850 8,401 (Amounts in millions) Cash flows from operating activities: Consolidated net income Adjustments to reconcile consolidated net income to net cash provided by operating activities: Depreciation and amortization Net unrealized and realized (gains) and losses Losses on disposal of business operations Asda pension contribution Deferred income taxes Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions and dispositions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities 10,987 (1,886) 15 (1,036) 320 1,981 1,911 1,521 (499) 1,734 (1,086) (2,395) 6,966 4,623 (136) 36,074 154 (300) (274) 186 (93) 25,255 (368) (1,311) 1,831 183 (40) 27,753 Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities (10,264) 215 56 (180) 102 (10,071) (10,705) 321 833 (56) 479 (9,128) (10,344) 519 876 (14,656) (431) (24,036) (324) Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Other financing activities Net cash used in financing activities (5,382) (6,116) (2,625) (434) (1,236) (16,117) (4,656) 5,492 (1,907) (6,048) (5,717) (555) (908) (14,299) (53) 15,872 (3,784) (6,102) (7,410) (431) (629) (2,537) Effect of exchange rates on cash, cash equivalents and restricted cash 235 (69) (438) 1,759 742 Net increase in cash, cash equivalents and restricted cash Cash and cash equivalents reclassified as assets held for sale Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of year 10,121 (1,848) 9,515 17,788 7,756 9,515 7,014 7,756 S $ S Supplemental disclosure of cash flow information: Income taxes paid Interest paid $ 5,271 2,216 3,616 $ 2,464 3,982 2,348 Walmart International Corporate and support Walmart U.S. Sam's Club Consolidated $ $ $ 369,963 $ 19,116 121,360 3,660 63,910 1,906 (2,134) (Amounts in millions) Fiscal Year Ended January 31, 2021 Net sales Operating income (loss) Interest, net Other gains and (losses) Income before income taxes Total assets Depreciation and amortization Capital expenditures 555,233 22,548 (2,194) 210 20,564 252,496 11,152 10,264 $ $ $ $ 113,490 6,561 6,131 109,445 2,633 2,436 13,415 599 $ 16,146 $ 1,359 1,209 488 Fiscal Year Ended January 31, 2020 Net sales 341 004 120 130 S 58 792 $ 519 926Step 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