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 (1.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, 2022 2021 $ (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets 14,760 $ 8,280 56,511 1,519 81,070 17,741 6,516 44,949 20,861 90,067 Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Goodwill Other long-term assets Total assets 94,515 92,201 13,758 13,642 4,351 4,005 29,014 28,983 22,152 23,598 244,860 S 252,496 SP Trom the company and want to the following them and input and into the shaded calls Windo not want to put for Balance et Balance Sheet2221 coment2032 ani C 2021 Accue Cet of Good Solid Man To Set weest To Current Income Total Current Tot Bestare per D of Genfortiment in the Daley were tweede G od 15 Antony DE MAR D M $ 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 410 $ 55,261 26,060 851 2,803 1,483 511 87,379 224 49,141 37,966 242 3,115 1,466 491 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 13,474 41,194 12,909 3,847 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 91,891 $ 244,860 S 3,646 88,763 (11,766) 80,925 6,606 87,531 252,496 Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2022 2021 2020 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 Loss on extinguishment of debt 2,410 Other (gains) and losses 3,000 (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 income per common share attributable to Walmarts 4.90 4.77 $ 5.22 Diluted net income per common share attributable to 4.87 4.75 5.19 Walmart (210) Weighted average common shares outstanding: Basic 2.792 2,850 2,831 2,847 2,805 2,868 Diluted $ 2.20 2.16 $ 2.12 Dividends declared per common share
