I need help with the blank ones please, and can you please show me how you did it? I tried two times but I am messing up somewhere. Thank You!
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense $66,700 45,000 15,200 740 (95) 1,400 $4,265 $418,000 309,000 78,000 1,900 (420) 6,700 $ 21,980 Other income (expense) Income tax expense Net income Balance Sheet Data (End of Year) Current assets $18,000 $45,000 Noncurrent assets 25,600 120,000 Total assets $43,600 $165,000 Current liabilities $11,000 $56,000 17,200 44,000 Long-term debt Total stockholders' equity 15,400 65,000 Total liabilities and stockholders' equity $43,600 $165,000 Total liabilities and stockholders' equity $43,600 $165,000 Beginning-of-Year Balances Total assets $45,000 $ 163,000 Total stockholders' equity 13,400 65,000 Current liabilities 10,600 58,000 Total liabilities 31,600 98,000 Other Data Average net accounts receivable $7,500 $3,900 Average inventory 7,000 32,800 Net cash provided by operating activities 5,800 26,900 Capital expenditures 1,700 11,800 Dividends 450 4,400 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%) Target Wal-Mart Ratio 1.64 Current ratio times 8.89 times 107.18 (2) Accounts receivable turnover 41.04 days 3,41 days (3) Average collection period Albertsons Finan....... Acct 101 Project....pdf (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, eg. 1.83 or 1.83%) Ratio Target Wal-Mart (1) Current ratio 164 .80 :1 (2) Accounts receivable turnover 8.89 times 107.18 times (3) Average collection period 41.04 days 3.41 days (4) Inventory turnover 6.43 times 942 times times Days in inventory 56.77 days 38.75 days (5) (6) Profit margin 6.39 5.26 (7) Asset turnover times 2.53 times (8) Return on assets 19) Return on common stockholders' equity 33.82 % (10) Debt to assets ratio (11) Times interest earned 8.66 times times 16.09 10700 (12) Free cash flow 3650 $