Please calculate 5 investor ratios from the financial statements below for Barnes & Noble

Analyze a publicly traded companys financial statements for the prior five years. Include the following items as supplemental schedules to the analysis, prepared as individual worksheets within an Excel spreadsheet:

Calculation of at least five significant investor ratios for each of the five years analyzed.

Show the breakdown in Excel as to how the answer was calculated.

BARNES & NOBLE INCOME STATEMENT	2015	2014	2013	2012	2011
Shares Outstanding	64.03	59.88	59.89	60.2	60.25
Net Sales Or Revenues	6069.49	6381.35	6839	7129.19	6998.56
Cost Of Goods Sold	4196.99	4523.42	5156.49	5218.38	5205.71
Gross Profit	1872.49	1857.93	1682.5	1910.81	1792.85
Research And Development Expense	-	-	-	-	-
Selling General And Admin Expense	1545.15	1606.93	1675.37	1739.45	1629.46
Income Before Depreciation Depletion Amortization	327.34	250.99	7.12	171.36	163.38
Depreciation Depletion Amortization	194.17	216.8	227.13	232.66	228.64
Non Operating Income	-	-	-	-35.3	-57.35
Interest Expense	17.89	29.5	35.34	-	-
Pretax Income	115.28	4.68	-255.34	-96.6	-122.6
Provisionfor Income Taxes	78.68	51.95	-97.54	-27.74	-48.65
Minority Interest	-	-	-	-	-0.03
Investment Gains Losses	-	-	-	-	-
Other Income	-	-	-	-	-
Income Before Extraordinaries And Disc Operations	36.59	-47.26	-157.8	-68.86	-73.95
Extraordinary Items And Discontinued Operations	-	-	-	-	-
Net Income	36.59	-47.26	-157.8	-68.86	-73.92
Average Shares Used To Compute Diluted E P S	60.93	58.97	58.25	57.34	56.59
Average Shares Used To Compute Basic E P S	60.84	58.97	58.25	57.34	56.59
Income Before Non Recurring Items	36.6	-6.27	1.39	-66	-73.92
Income From Non Recurring Items	-	-41	-156.2	-2.87	-
E P S Basic Net	0.21	-1.12	-2.97	-1.41	-1.31
E P S Diluted Net	0.21	-1.12	-2.97	-1.41	-1.31
E P S Diluted Before Non Recurring Items	0.21	-0.42	-0.29	-1.36	-1.31
Preferred Dividends Acc Pd	-	-	-	-	-
Dividends Common	-	-	-	-	-
Dividend Per Share Common	-	-	-	-	0.75
update Date	0	0	0	0	0

BARNES & NOBLE BALANCE SHEET		2015	2014	2013	2012	2011
Shares Outstanding		64.03	59.88	59.89	60.2	60.25
Cash		74.36	340.17	160.47	54.13	59.42
Marketable Securities		-	-	-	-	-
Receivables		98.57	143.98	149.36	160.49	150.29
Inventory		1348.23	1234.63	1410.76	1561.84	1375.36
Raw Materials		-	-	-	-	-
Work In Progress		-	-	-	-	-
Finished Goods		-	-	-	-	-
Notes Receivable		-	-	-	-	-
Other Current Assets		208.14	261.65	326.52	221.32	161.93
Total Current Assets		1729.31	1980.43	2047.13	1997.79	1747.02
Property Plant And Equipment		3076.29	3165.17	3110.42	2983.79	2883.21
Accumulated Depreciation		2627	2674.46	2525.52	2361.14	2178.56
Net Property Plant And Equipment		449.29	490.71	584.9	622.65	704.65
Investment And Advances		-	-	-	-	-
Other Non Current Assets		-	-	-	-	-
Deferred Charges		-	-	-	-	-
Intangibles		1003.1	1021.76	1043.42	1083.73	1090.69
Deposits And Other Assets		47.78	44.53	57.06	61.06	54.1
Total Assets		3229.5	3537.44	3732.53	3765.24	3596.46
Notes Payable		-	127.25	-	-	-
Accounts Payable		655.06	735.11	805.19	959.42	949.01
Current Portion Of Long Term Debt		-	-	-	-	-
Current Portion Of Capital Leases		-	-	-	-	-
Accrued Expenses		434.04	502.58	569.24	546.49	785.66
Income Taxes Payable		-	-	-	-	-
Other Current Liabilities		358.14	356.7	341.03	321.36	-
Total Current Liabilities		1447.25	1721.64	1715.47	1827.28	1734.67
Mortgages		-	-	-	-	-
Deferred Charges Taxes Income		200.52	211.92	231.21	268.77	280.13
Convertible Debt		-	-	-	-	-
Long Term Debt		-	-	77	324.2	313.1
Non Current Capital Leases		-	-	-	-	-
Other Long Term Liabilities		196.3	366.98	419.94	405.06	448.64
Total Liabilities		1844.08	2300.55	2443.63	2825.31	2776.55
Minority Interest		-	-	-	-	-
Preferred Stock		196.05	578.19	575.16	192.27	-
Common Stock Net		0.09	0.09	0.09	0.09	0.09
Capital Surplus		1927.99	1395.46	1383.84	1340.9	1323.26
Retained Earnings		357.51	344.02	410.34	481.57	562.37
Treasury Stock		1079.71	1069.1	1063.85	1058.28	1054.19
Other Liabilities		-16.53	-11.77	-16.69	-16.63	-11.63
Shareholders Equity		1385.41	1236.89	1288.9	939.93	819.91
Total Liabilities And Shareholders Equity		3229.5	3537.44	3732.53	3765.24	3596.46
update Date		0	0	0	0	0