Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please show how to do the equations. Thank you.
Target
Corporation Wal-Mart
Stores, Inc.
Income Statement Data for Year
Net sales $66,700 $409,000
Cost of goods sold 46,000 306,000
Selling and administrative expenses 14,700 76,000
Interest expense 650 1,800
Other income (expense) (95 ) (420 )
Income tax expense 1,400 7,200
Net income $ 3,855 $ 17,580

Balance Sheet Data
(End of Year)
Current assets $19,000 $48,000
Noncurrent assets 25,600 120,000
Total assets $44,600 $168,000
Current liabilities $10,000 $55,000
Long-term debt 18,200 44,000
Total stockholders’ equity 16,400 69,000
Total liabilities and stockholders’ equity $44,600 $168,000

Beginning-of-Year Balances
Total assets $43,000 $162,000
Total stockholders’ equity 13,500 66,000
Current liabilities 10,500 55,000
Total liabilities 29,500 96,000

Other Data
Average net accounts receivable $7,800 $3,900
Average inventory 7,000 33,700
Net cash provided by operating activities 5,600 26,800
Capital expenditures 1,800 12,400
Dividends 460 4,500

For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.)
Ratio Target Wal-Mart
(1) Current ratio enter the current ratio :1 enter the current ratio :1
(2) Accounts receivable turnover enter accounts receivable turnover in times times enter accounts receivable turnover in times times
(3) Average collection period enter average collection period in days days enter average collection period in days days
(4) Inventory turnover enter inventory turnover in times times enter inventory turnover in times times
(5) Days in inventory enter days in inventory ratio days enter days in inventory ratio days
(6) Profit margin enter percentages % enter percentages %
(7) Asset turnover enter asset turnover in times times enter asset turnover in times times
(8) Return on assets enter percentages % enter percentages %
(9) Return on common stockholders’ equity enter percentages % enter percentages %
(10) Debt to assets ratio enter percentages % enter percentages %
(11) Times interest earned enter times interest earned times enter times interest earned times
(12) Free cash flow $enter a dollar amount $enter a dollar amount