QUESTION 2 (50 MARKS) Selected financial data of Target and Wal-Mart for a recent year are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Total liabilities Average net receivables Average inventory Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year $62,884 $374,526 44,157 286,515 12,954 70,288 866 1,863 (1,371) 3,779 1.322 6,908 $2.214 $ 12,731 $17,488 26,618 $44,106 Balance Sheet Data (End of Year) $ 47,585 115,929 $163,514 $10,512 $ 58,454 19,882 13,712 40,452 64,608 $44.106 $163,514 Beginning-of-Year Balances $44,560 $151,587 15.307 61,573 11,782 52,148 29,253 90,014 Other Data $ 8,069 $ 3,247 6,243 4,430 34,433 20,354 Net cash provided by operating activities Instructions (a) For each company, compute the following ratios. (1) Current. (2) Accounts receivable turnover. (3) Average collection period. (4) Inventory turnover. (5) Days in inventory, (6) Profit margin. (7) Asset turnover. (8) Return on assets. (9) Return on common stockholders' equity. (10) Debt to assets. (11) Times interest earned. (b) Compare the liquidity, solvency, and profitability of the two companies. c) As a Group Finance Director, explain in full TWO (2) pages report on the financial positions of the company for two years based on the above data. Provide your recommendations also.