Problem 13-5A

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			$66,400			$407,000
Cost of goods sold			46,000			306,000
Selling and administrative expenses			15,500			79,000
Interest expense			670			1,800
Other income (expense)			(85)			(390)
Income tax expense			1,300			7,500
Net income			$ 2,845			$ 12,310
		Balance Sheet Data (End of Year)
Current assets			$19,000			$47,000
Noncurrent assets			27,300			123,000
Total assets			$46,300			$170,000
Current liabilities			$11,000			$56,000
Long-term debt			18,100			45,000
Total stockholders equity			17,200			69,000
Total liabilities and stockholders equity			$46,300			$170,000
		Beginning-of-Year Balances
Total assets			$43,000			$164,000
Total stockholders equity			14,300			66,000
Current liabilities			10,800			57,000
Total liabilities			28,700			98,000
		Other Data
Average net accounts receivable			$7,900			$4,100
Average inventory			6,800			34,000
Net cash provided by operating activities			5,600			26,300
Capital expenditures			1,800			11,500
Dividends			520			4,200

(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)

		Ratio		Target			Wal-Mart
(1)		Current ratio		________	:1		_______	:1
(2)		Accounts receivable turnover		________	times		_______	times
(3)		Average collection period		________	days		_______	days
(4)		Inventory turnover		________	times		_______	times
(5)		Days in inventory		________	days		_______	days
(6)		Profit margin		________	%		_______	%
(7)		Asset turnover		________	times		_______	times
(8)		Return on assets		________	%		_______	%
(9)		Return on common stockholders equity		________	%		_______	%
(10)		Debt to assets ratio		________	%		_______	%
(11)		Times interest earned		________	times		_______	times
(12)		Free cash flow		$ _______			$ _______