From the Company Financial Statements of Walmart, identify the following items and input amounts into the...

  
 
 

Transcribed Image Text:

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 Sales** Cost of Goods Sold Interest Expense Income Tax Expense Liquidity Accounts Receivable Marketable Securities Total Current Assets Total Current Liabilities. Total Liabilities Compute the Following ratios (please input into shaded cell) Current Ratio Acid Test Asset Management Average Inventory Sale period Debt Management Debt to equity Times Interest Earned Profitability Return on Equity Net Profit Margin Market Performance Dividend Payout Inventory Total Stockholders' Equity Display answer to two decimal places. (1 point) (1 point) (1 point) (1 point) (2 points) (2 points) (1 point) (1 point) 2022 2021 (10 points, as indicated) Net Income Basic Earnings per share. Dividend ** Include all sources of revenue (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 Walmart Inc. Consolidated Balance Sheets As of January 31, 2022 2021 $ 14,760 8,280 56,511 1,519 81,070 $ 94,515 13,758 4,351 29,014 22,152 $ 244,860 $ 17,741 6,516 44,949 20,861 90,067 92,201 13,642 4,005 28,983 23,598 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 $ S 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 (Amounts in millions, except per share data) Revenues: Net sales Membership and other income Total revenues Walmart Inc. Consolidated Statements of Income 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 S 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, 2021 2020 2022 567,762 4,992 572,754 429,000 117,812 25,942 1,674 320 (158) 1,836 2,410 3,000 18,696 4,756 13,940 4.90 $ 4.87 $ 2,792 2,805 2.20 $ 555,233 3,918 559,151 420,315 116,288 22,548 1,976 339 (121) 2,194 (210) 20,564 6,858 13,706 4.77 $ 4.75 $ 519,926 4,038 523,964 2,831 2,847 2.16 $ 394,605 108,791 20,568 2,262 337 (189) 2,410 (1,958) 20,116 4,915 15,201 5.22 5.19 2,850 2,868 2.12 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 Sales** Cost of Goods Sold Interest Expense Income Tax Expense Liquidity Accounts Receivable Marketable Securities Total Current Assets Total Current Liabilities. Total Liabilities Compute the Following ratios (please input into shaded cell) Current Ratio Acid Test Asset Management Average Inventory Sale period Debt Management Debt to equity Times Interest Earned Profitability Return on Equity Net Profit Margin Market Performance Dividend Payout Inventory Total Stockholders' Equity Display answer to two decimal places. (1 point) (1 point) (1 point) (1 point) (2 points) (2 points) (1 point) (1 point) 2022 2021 (10 points, as indicated) Net Income Basic Earnings per share. Dividend ** Include all sources of revenue (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 Walmart Inc. Consolidated Balance Sheets As of January 31, 2022 2021 $ 14,760 8,280 56,511 1,519 81,070 $ 94,515 13,758 4,351 29,014 22,152 $ 244,860 $ 17,741 6,516 44,949 20,861 90,067 92,201 13,642 4,005 28,983 23,598 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 $ S 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 (Amounts in millions, except per share data) Revenues: Net sales Membership and other income Total revenues Walmart Inc. Consolidated Statements of Income 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 S 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, 2021 2020 2022 567,762 4,992 572,754 429,000 117,812 25,942 1,674 320 (158) 1,836 2,410 3,000 18,696 4,756 13,940 4.90 $ 4.87 $ 2,792 2,805 2.20 $ 555,233 3,918 559,151 420,315 116,288 22,548 1,976 339 (121) 2,194 (210) 20,564 6,858 13,706 4.77 $ 4.75 $ 519,926 4,038 523,964 2,831 2,847 2.16 $ 394,605 108,791 20,568 2,262 337 (189) 2,410 (1,958) 20,116 4,915 15,201 5.22 5.19 2,850 2,868 2.12

Answer rating: 100% (QA)

Formulas Liquidity Current Ratio Current assetsCurrent liabilities Acid Test ... View the full answer