Perform ratio analysis on your company using the ratios listed below (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.).

Here's the list of ratios:

Liquidity and Efficiency:

-Current ratio

-Acid-test ratio

-Accounts Receivable Turnover

-Inventory Turnover

-Days' sales uncollected

-Days' sales in inventory

-Total asset turnover

Solvency:

-Debt ratio

-Equity ratio

-Debt-to-equity ratio

-Times interest earned

Profitability:

-Profit margin ratio

-Gross margin ratio

-Return on total assets

-Return on common stockholder's equity

-Book value per common share

-Basic earnings per share

Market prospects:

-Price-earnings ratio

-Dividend yield

Income statement:

In Millions of USD (except for per share items)	53 weeks ending 2016-07-30	52 weeks ending 2015-07-25	52 weeks ending 2014-07-26	52 weeks ending 2013-07-27
Revenue	6,995.40	4,802.90	4,790.60	4,714.90
Other Revenue, Total	-	-	-	-
Total Revenue	6,995.40	4,802.90	4,790.60	4,714.90
Cost of Revenue, Total	3,066.70	2,133.70	2,130.60	2,137.70
Gross Profit	3,928.70	2,669.20	2,660.00	2,577.20
Selling/General/Admin. Expenses, Total	3,385.50	2,337.00	2,204.00	2,096.70
Research & Development	-	-	-	-
Depreciation/Amortization	358.7	218.2	193.6	176
Interest Expense(Income) - Net Operating	-	-	-	-
Unusual Expense (Income)	89.9	348.9	51.6	48.5
Other Operating Expenses, Total	-	-	-	-
Total Operating Expense	6,900.80	5,037.80	4,579.80	4,458.90
Operating Income	94.6	-234.9	210.8	256
Interest Income(Expense), Net Non-Operating	-	-	-	-
Gain (Loss) on Sale of Assets	-	-	-	-
Other, Net	-	-	-	-
Income Before Tax	-8.3	-240.6	203.5	242.6
Income After Tax	-11.9	-236.8	138.2	155.2
Minority Interest	-	-	-	-
Equity In Affiliates	-	-	-	-
Net Income Before Extra. Items	-11.9	-236.8	138.2	155.2
Accounting Change	-	-	-	-
Discontinued Operations	-	-	-	-
Extraordinary Item	-	-	-	-
Net Income	-11.9	-236.8	133.4	151.3
Preferred Dividends	-	-	-	-
Income Available to Common Excl. Extra Items	-11.9	-236.8	138.2	155.2
Income Available to Common Incl. Extra Items	-11.9	-236.8	133.4	151.3
Basic Weighted Average Shares	-	-	-	-
Basic EPS Excluding Extraordinary Items	-	-	-	-
Basic EPS Including Extraordinary Items	-	-	-	-
Dilution Adjustment	-	-	-	-
Diluted Weighted Average Shares	192.2	162.6	165.1	163.3
Diluted EPS Excluding Extraordinary Items	-0.06	-1.46	0.84	0.95
Diluted EPS Including Extraordinary Items	-	-	-	-
Dividends per Share - Common Stock Primary Issue	0	0	0	0
Gross Dividends - Common Stock	-	-	-	-
Net Income after Stock Based Comp. Expense	-	-	-	-
Basic EPS after Stock Based Comp. Expense	-	-	-	-
Diluted EPS after Stock Based Comp. Expense	-	-	-	-
Depreciation, Supplemental	-	-	-	-
Total Special Items	-	-	-	-
Normalized Income Before Taxes	-	-	-	-
Effect of Special Items on Income Taxes	-	-	-	-
Income Taxes Ex. Impact of Special Items	-	-	-	-
Normalized Income After Taxes	-	-	-	-
Normalized Income Avail to Common	-	-	-	-
Basic Normalized EPS	-	-	-	-
Diluted Normalized EPS	0.24	-0.06	1.05	1.14b

Balance sheet:

In Millions of USD (except for per share items)	As of 2016-07-30	As of 2015-07-25	As of 2014-07-26	As of 2013-07-27
Cash & Equivalents	371.8	240.6	156.9	186.4
Short Term Investments	1.8	13.4	30.4	3
Cash and Short Term Investments	373.6	254	187.3	189.4
Accounts Receivable - Trade, Net	84.7	70.8	90.8	80.9
Receivables - Other	-	-	-	-
Total Receivables, Net	84.7	70.8	90.8	80.9
Total Inventory	649.3	489.3	553.2	540.9
Prepaid Expenses	132.1	45.6	40.6	39.4
Other Current Assets, Total	0.3	90.2	51.7	92.2
Total Current Assets	1,240.00	949.9	923.6	942.8
Property/Plant/Equipment, Total - Gross	2,676.90	1,949.90	1,754.80	1,387.40
Accumulated Depreciation, Total	-1,046.80	-779.9	-644.2	-562.6
Goodwill, Net	1,279.30	319.7	581.4	581.4
Intangibles, Net	1,268.70	388.3	435.4	451.1
Long Term Investments	-	-	-	-
Other Long Term Assets, Total	88.2	78.3	72.8	71.6
Total Assets	5,506.30	2,906.20	3,123.80	2,871.70
Accounts Payable	429.4	238.8	253.2	259.2
Accrued Expenses	379.6	389	293.2	268.6
Notes Payable/Short Term Debt	0	0	0	0
Current Port. of LT Debt/Capital Leases	54	0	0	0.6
Other Current liabilities, Total	150.7	89.9	85.5	108.1
Total Current Liabilities	1,013.70	717.7	631.9	636.5
Long Term Debt	1,594.50	106.5	172	135
Capital Lease Obligations	-	-	-	-
Total Long Term Debt	1,594.50	106.5	172	135
Total Debt	1,648.50	106.5	172	135.6
Deferred Income Tax	442.2	181.8	147.7	131.7
Minority Interest	-	-	-	-
Other Liabilities, Total	592.6	382.1	434.5	412.1
Total Liabilities	3,643.00	1,388.10	1,386.10	1,315.30
Redeemable Preferred Stock, Total	-	-	-	-
Preferred Stock - Non Redeemable, Net	-	-	-	-
Common Stock, Total	1.9	1.6	1.6	1.6
Additional Paid-In Capital	1,050.30	669.8	642.2	592.8
Retained Earnings (Accumulated Deficit)	828.8	859.3	1,096.10	963.2
Treasury Stock - Common	-	-	-	-
Other Equity, Total	-17.7	-12.6	-2.2	-1.2
Total Equity	1,863.30	1,518.10	1,737.70	1,556.40
Total Liabilities & Shareholders' Equity	5,506.30	2,906.20	3,123.80	2,871.70
Shares Outs - Common Stock Primary Issue	-	-	-	-
Total Common Shares Outstanding	194.2	163.2	161.8	159.5