50.1K

Verified Solution

Link Copied!

2021 was 50,000. Compute selected ratios, and compare liquidity, profitability, and solvency for two companies P15.5 (LO 2) Selected financial data of Target (USA) and Wal-Mart Stores, Inc. (USA) for a recent year are presented below (in millions). Wal-Mart Target Stores, Inc. Corporation Income Statement Data for Year $476,294 358,069 91,353 $72,596 51,160 Net sales Cost of goods sold 16,816 Selling and administrative expenses Interest expense Other income (expense) Income tax expense 2,335 1,126 (410) 8,105 (391) 1,132 $ 16,022 $ 1,971 000 EC Net income Statement of Financial Position 00 08 Data (End of Year) $32,980 11,573 $143,566 Non-current assets 61,185 Current assets $204,751 $44,553 Total assets $ 81,339 54,067 69,345 $16,231 Total equity 15,545 Non-current liabilities 12,777 Current liabilities $204,751 $44,553 Total equity and liabilities Beginning-of-Year Balances $203,105 81,738 $48,163 Total assets 16,558 Total equity Current liabilities 71,818 14,031 31,605 131,287 Total liabilities Other Data $ 6,723 44,331 $2,921 Average net accounts receivable Average inventory Net cash provided by operating activities 8,335 23,257 6,520 Instructions a. For each company, compute the following ratios. 1. Current ratio. 2. Accounts receivable turnover. 3. Average collection period. a. 4. Inventory turnover Target 6.1 4. Inventory turnover 5. Days in inventory. 6. Profit margin. 7. Asset turnover. 8. Return on assets. 9. Return on ordinary shareholders' equity. 10. Debt to assets ratio. 11. Times interest earned. b. Compare the liquidity, profitability, and solvency of the two companies

Answer & Explanation Solved by verified expert

See Answer