Complete the Ratio Analysis for Nike, Inc. using the information provided in the Balance Sheets and/or Statements of Income.

Balance Sheets for Nike, Inc. Fill in the blanks on the table below. Amounts do not need the dollar sign ($), whole numbers only, no decimals needed. (example 0000) Percentages should be two decimal places and no percentage sign (%) is needed. (example 00.00)

(in millions)	2018	2017	2016
ASSETS
Current Assets
Cash and equivalents	4,249	3,808	3,138
Short-term investments	996	2,371	2,319
Accounts receivable, net	3,498	3,677	3,241
Inventories	5,261	5,055	4,838
Prepaid expenses and other current assets	1,130	1,150	1,489
Total Current Assets	15,134	16,061	15,025
Property, plant and equipment; net	4,454	3,989	3,520
Identifiable intangible assets, net	285	283	281
Goodwill	154	139	131
Deferred income taxes and other assets	2,509	2,787	2,422
TOTAL ASSETS	22,536	23,259	21,379
LIABILITIES AND SHAREHOLDERS' EQUITY
Current Liabilities
Current portion of long-term debt	6	6	44
Notes payable	336	325	1
Accounts payable	2,279	2,048	2,191
Accrued liabilities	3,269	3,011	3,037
Income taxes payable	150	84	85
Total current liabilities	6,040	5,474	5,358
Long-term debt	3,468	3,471	1,993
Deferred income taxes and other liabilities	3,216	1,907	1,770
Commitments and contingencies
Redeemable preferred stock
Shareholders' equity
Common stock at stated value
Class A convertible - 329 and 353 shares outstanding
Class B - 1,314 and 1,329 shares outstanding	3	3	3
Capital in excess of stated value	6,384	5,710	7,786
Accumulated other comprehensive (loss) income	(92)	(213)	318
Retained earnings	3,517	6,907	4,151
Total shareholders' equity	9,812	12,407	12,258
TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY	22,536	23,259	21,379

Statements of Income, Nike, Inc.

in millions, except per share data	2018	2017	2016
Revenues	36,397	34,350	32,376
Cost of sales	20,441	19,038	17,405
Gross Profit	15,956	15,312	14,971
Demand creation expense	3,577	3,341	3,278
Operating overhead expense	7,934	7,222	7,191
Total selling and administrative expense	11,511	10,563	10,469
Interest expense (income), net	54	59	19
Other expense (income), net	66	(196)	(140)
Income before income taxes	4,325	4,886	4,623
Income tax expense	2,392	646	863
NET INCOME	1,933	4,240	3,760
Earnings per common share:
Basic	1.19	2.56	2.21
Diluted	1.17	2.51	2.16
Dividends declared per common share	0.78	0.70	0.62

Liquidity	2018	2017
Working Capital
Current Ratio
Quick Ratio
Profitability	2018	2017
Asset Turnover
Return on Total Assets
Return on Stockholder's Equity
Solvency	2018	2017
Ratio of fixed assets to long-term liabilities
Ratio of liabilities to stockholders' equity
Times interest earned