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