Search Walmart's 2021 annual financial reports and analyise those reports by using these ratios:

Required:

6. Compute the property and equipment(net) turnover rate based on net sales for the year ended January 31, 2021

7. Calculate the current ratio at January 31, 2021 and January 313, 2020. Did liquidity increase or decrease in 2021 compared to 2020?

8.Calculate the debt-to-equity ratio at January 31, 2020.

9.Did consolidated net income attributable to Walmart increase or decrease in 2021 compared to

2020 ? List three major factors in 2021 that affected the companys net income compared to the year ended January 31, 2020.

10.Explain if the cash and cash equivalents and restricted cash balance at January 31, 2021 increased or decreased from January 31, 2020. Explain why, based on the cash flow statement, the change in cash position in the 2021 fiscal year occurred.

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 926. 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 926. 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