Use the financial statements given above to fill in the shaded grey spaces on the excel sheet, please answer with clear handwriting.

ACCTG 231-SPRING 2021 RATIO PROBLEM - DUE APRIL 29th (25 POINTS) ACCTG 231 ends the semester with a step back into working with financial statements presented to external users, along with ratios commonly employed to evaluate companies for either investment potential or creditworthiness. For this assignment you will use the financial statements and Excel template provided in Canvas to: Find the financial statement amounts requested and enter them into the Excel spreadsheet template. (15 points) Compute the ratios requested in the Excel template. (10 points) . A couple of notes: The financial statements uploaded to Canvas for this assignment were explicitly chosen to ensure a positive net income and existence of a few key items. . Also, ratios presented online may differ from those you compute as websites may adjust formulas and/or omit items from some calculations (i.e. some ratios have a few variations with regard to alternative calculations). Points for this assignment will be based on: Using amounts from the specific financial statements provided Computing ratios using the specific formulas in Chapter 14 (a summary of the Chapter 14 formulas is in Exhibit 14-6 in the text) - present all computations to two decimal places. . Walmart Inc. Consolidated Balance Sheets As of January 31, (Amounts in millions) 2022 2021 ASSETS Current assets: $ $ 17,741 Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other 14,760 8,280 56,511 6,516 44,949 1,519 20,861 Total current assets 81,070 90,067 94,515 Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net 13,758 92,201 13,642 4,005 28,983 4,351 Goodwill 29,014 Other long-term assets 22,152 23,598 252,496 Total assets $ 244,860 $ | LIABILITIES AND EQUITY Current liabilities: $ 410 $ 224 Short-term borrowings Accounts payable 55,261 49,141 37,966 Accrued liabilities 26,060 Accrued income taxes 851 242 2,803 3,115 1,483 1,466 Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Total current liabilities 511 491 87,379 92,645 34,864 Long-term debt Long-term operating lease obligations Long-term finance lease obligations 13,009 41,194 12,909 3,847 14,370 4,243 Deferred income taxes and other 13,474 Commitments and contingencies Equity: Common stock 276 282 Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest 4,839 86,904 (8.766) 3,646 88,763 (11,766) 83,253 80,925 8,638 6,606 Total equity 91,891 87,531 Total liabilities and equity $ 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 Membership and other income 4,992 3,918 4,038 Total revenues 572,754 559,151 523,964 Costs and expenses: Cost of sales 429,000 420,315 394,605 Operating, selling, general and administrative expenses 117,812 116,288 108,791 Operating income 25,942 22,548 20,568 Interest: 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 3,000 (210) (1,958) Income before income taxes 18,696 20,564 20.116 Provision for income taxes 4,756 6,858 4,915 Consolidated net income 13,940 13,706 15,201 Net income per common share: Basic net me per share attributable to Walmart $ 4.90 $ 4.77 $ 5.22 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 ACCTG 231 - SPRING 2022 RATIO ASSIGNMENT DUE FRIDAY, APRIL 29th 1 (15 Points - 1 point per account) 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 2 Compute the following ratlos (please input into shaded cell) Display answer to two decimal places. (10 points, as indicated) Liquidity Current Ratia Acid Test (1 point) (1 point) Asset Management Average Inventory Sale period (1 paint) Debt Management Debt to equity Times Interest Earned (1 paint) (2 points) Profitability Return on Equity Net Profit Margin (2 points) (1 paint) Market Performance Divicend Payout (1 point)