Calculate the following ratios using Microsoft Excel:

Current Ratio

Quick Ratio

Debt Equity Ratio

Inventory Turnover Ratio

Receivables Turnover Ratio

Total Assets Turnover Ratio

Profit Margin (Net Margin) Ratio

Return on Assets Ratio

Use MACYS balance sheet and Income Statement

Balance sheet (in millions)
Current Assets:
Cash and cash equivalents	1,109	2,246
Receivables	558	424
Merchandise inventorie	5,506	5,417
Prepaid expenses and other current assets	479	493
Total Current Assets	7,652	8,580
Property and Equipment net	7,616	7,800
Goodwill	3,897	3,743
Other Intangible Assets net	514	496
Other Assets	897	711
Total Asset	20,576	21,330
LIABILITIES AND SHAREHOLDERS EQUITY
Current Liabilities:
Short-term debt	642	76
Merchandise accounts payable	1,526	1,594
Accounts payable and accrued liabilities	3,333	3,109
Income taxes	227	296
Total Current Liabilities	5,728	5,075
Long-Term Debt	6,995	7,233
Deferred Income Taxes	1,477	1,443
Other Liabilities	2,123	2,201
Shareholders Equity:
Common stock (310.3 and 340.6 shares outstanding)	3	4
Additional paid-in capita	621	1,048
Accumulated equity	6,334	7,340
Treasury stock	(1,665)	(1,942)
Accumulated other comprehensive loss	(1,043)	(1,072)
Total Macy's, Inc. Shareholders Equity	4,250	5,378
Noncontrolling interest	3	-
Total Shareholders' Equity	4,253	5,378
Total Liabilities and Shareholders Equity	20,576	21,330

INCOME STATEMENT (in millions)
	2015	2014	2013
Net sales	27,079	28,105	27,931
Cost of sales	(16,496)	(16,863)	(16,725)
Gross margin	10,583	11,242	11,206
Selling, general and administrative expenses	(8,256)	(8,355)	(8,440)
Impairments, store closing and other costs	(288)	(87)	(88)
Operating income	2,039	2,800	2,678
Interest expense	(363)	(395)	(390)
Premium on early retirement of debt	-	(17)	-
Interest income	2	2	2
Income before income taxes	1,678	2,390	2,290
Federal, state and local income tax expense	(608)	(864)	(804)
Net income	1,070	1,526	1,486
Net loss attributable to noncontrolling interest	2	-	-
Net income attributable to Macy's, Inc. shareholders	1,072	1,526	1,486
Basic earnings per share attributable to Macy's, Inc. shareholders	3.26	4.30	3.93
Diluted earnings per share attributable to Macy's, Inc. shareholders	3.22	4.22	3.86