From the Company Financial Statements of Walmart, identify the following items and input amounts into the shaded cells. If Walmart does not have an account requested put 0 (zero). Balance Sheet (2022 amounts only) Balance Sheet (2022 and 2021 amounts) Income Statement (2022 only) Cash 2022 2021 Sales** Accounts Receivable Inventory Cost of Goods Sold Marketable Securities Total Stockholders' Equity Interest Expense Total Current Assets Income Tax Expense Total Current Liabilities Net Income Total Liabilities Basic Earnings per share Dividend ** Include all sources of revenue Compute the following ratios (please input into shaded cell) Display answer to two decimal places. (10 points, as indicated) Liquidity Current Ratio Acid Test (1 point) (1 point) Asset Management Average Inventory Sale period (1 point) Debt Management Debt to equity Times Interest Earned (1 point) (2 points) Profitability Return on Equity Net Profit Margin (2 points) (1 point) Market Performance Dividend Payout (1 point) Walmart Inc. Consolidated Balance Sheets As of January 31, 2022 2021 (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories $ 14,760 $ 17,741 8,280 6,516 44,949 56,511 1,519 Prepaid expenses and other 20,861 Total current assets 81,070 90,067 94,515 92,201 Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net 13,758 4,351 13,642 4,005 Goodwill 29,014 28,983 Other long-term assets 22,152 23,598 Total assets $ 244,860 $ 252,496 LIABILITIES AND EQUITY Current liabilities: $ 410 $ 224 Short-term borrowings Accounts payable 55,261 49,141 37,966 Accrued liabilities 26,060 851 242 2,803 3,115 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 1,483 1,466 511 491 87,379 92,645 Long-term debt Long-term operating lease obligations Long-term finance lease obligations Deferred income taxes and other 34,864 13,009 4,243 41,194 12,909 3,847 13,474 14,370 Commitments and contingencies 276 282 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 4,839 86,904 (8,766) 83,253 8,638 3,646 88,763 (11,766) 80,925 6,606 91,891 87,531 $ 244,860 $ 252,496 Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, 2022 2021 2020 (Amounts in millions, except per share data) Revenues: Net sales $ 567,762 $ 555,233 $ 519,926 4,992 3,918 4,038 572,754 559,151 523,964 Membership and other income Total revenues Costs and expenses: Cost of sales Operating, selling, general and administrative expenses Operating income Interest: 429,000 117,812 420,315 116,288 22,548 394,605 108,791 20,568 25,942 Debt 1,674 1,976 2,262 Finance lease 320 339 337 Interest income (158) (121) (189) Interest, net 1,836 2,194 2,410 2,410 Loss on extinguishment of debt Other (gains) and losses Income before income taxes 3,000 18,696 (210) 20,564 6,858 (1,958) 20,116 4,915 Provision for income taxes 4,756 Consolidated net income 13,940 13,706 15,201 4.90 $ 4.77 $ 5.22 Net income per common share: Basic net income per common share attributable to Walmart $ Diluted net income per common share attributable to Walmart 4.87 4.75 5.19 Weighted average common shares outstanding: Basic 2.792 2,831 2,850 Diluted 2,805 2,847 2,868 Dividends declared per common share $ 2.20 $ 2.16 $ 2.12