complete all parts using excel

13-50 CHAPTER 13 Financial Analysis: The Big Picture Compule selected ratins, and compare liquidity, profitability, and solvency for the companies PI3 5A (LO 31. AN Selected hypothetical financial data o here (in millions). ial data of Target and Wal-Mart for 2022 are presented Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Wal-Mart Corporation Stores, Inc Income Statement Data for Year $65,357 S-408214 45.53 304,657 15, 101 79,607 2,065 (94) (411) 707 1,384 7.139 $ 2,488 $ 14,335 Balance Sheet Data (End of Year) S18,424 26,109 $ 48,331 122,375 $48,533 $170,706 Current assets Noncurrent assets Total assets Current liabilities Long-term deb Total stockholders' equity Total liabilities and stockholders' equity $ 55,561 44,089 71,056 $44,533 $170,706 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $44,106 $163,429 13,712 65,682 55,390 30,394 97,747 10 512 Other Data $ Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $ 7.525 6,942 5,881 1,729 496 4,025 33,836 26,249 12.184 4,217 Instructions a. For each company, compute the following ratios. 1. Current ratio. 7. Asset turnover. 2. Accounts receivable turnover. 8. Return on assets 3. Average collection period. 9. Return on common stockholders' equity. 4. Inventory turnover. 10. Debt to assets ratio. 5. Days in inventory. 11. Times interest earned. 6. Profit margin 12. Free cash flow. b. Compare the liquidity, solvency, and profitability of the two companies