qq

WhitbreadPLCMycompany.xlsx

Home >Business & Finance homework help >Accounting homework help >qq

balance sheet

Assets
ESOP Debt Guarantee	2015	2016	2017
Cash & Short Term Investments	3.3M	60.3M	75.3M
Cash Only	2.1M	57.1M	63M
Short-Term Investments	1.2M	3.2M	12.3M
Cash & Short Term Investments Growth	-92.03%	1727.27%	24.88%
Cash & ST Investments / Total Assets	0.09%	1.36%	1.59%
Total Accounts Receivable	88.4M	101M	118.8M
Accounts Receivables, Net	78.4M	92.7M	92.6M
Accounts Receivables, Gross	82.3M	98.5M	94.2M
Bad Debt/Doubtful Accounts	(3.9M)	(5.8M)	(1.6M)
Other Receivables	10M	8.3M	26.2M
Accounts Receivable Growth	13.92%	14.25%	17.62%
Accounts Receivable Turnover	29.5	28.93	26.14
Inventories	37.1M	44.8M	48.2M
Finished Goods	30.4M	34.8M	35.4M
Work in Progress	-	-	-
Raw Materials	6.7M	10M	12.8M
Progress Payments & Other	-	-	-
Other Current Assets	35.6M	39M	44.8M
Miscellaneous Current Assets	35.6M	39M	44.8M
Total Current Assets	164.4M	245.1M	287.1M
	2015	2016	2017
Net Property, Plant & Equipment	3.28B	3.83B	3.97B
Property, Plant & Equipment - Gross	3.95B	4.6B	4.78B
Buildings	2.69B	3.15B	3.2B
Land & Improvements	-	-	-
Computer Software and Equipment	-	-	-
Other Property, Plant & Equipment	-	-	-
Accumulated Depreciation	674.1M	771.7M	811M
Total Investments and Advances	34.5M	61.1M	96.3M
Other Long-Term Investments	2.2M	21.6M	43.3M
Long-Term Note Receivable	7.3M	7.7M	6.8M
Intangible Assets	248.1M	258.1M	275.7M
Net Goodwill	179.4M	180M	177.1M
Net Other Intangibles	68.7M	78.1M	98.6M
Other Assets	1.1M	2.3M	50.5M
Tangible Other Assets	1.1M	2.3M	50.5M
Total Assets	3.82B	4.43B	4.74B
Assets - Total - Growth	11.28%	15.89%	6.91%
Liabilities & Shareholders' Equity
	2015	2016	2017
ST Debt & Current Portion LT Debt	73.1M	94M	157.4M
Short Term Debt	73.1M	94M	157.4M
Current Portion of Long Term Debt	-	-	-
Accounts Payable	121.6M	144.4M	162.1M
Accounts Payable Growth	11.25%	18.75%	12.26%
Income Tax Payable	35.4M	41.2M	45.9M
Other Current Liabilities	354M	412.9M	473.4M
Dividends Payable	-	-	-
Accrued Payroll	-	-	-
Miscellaneous Current Liabilities	354M	412.9M	473.4M
Total Current Liabilities	584.1M	692.5M	838.8M
Long-Term Debt	512.2M	872.9M	795.6M
Long-Term Debt excl. Capitalized Leases	512.2M	872.9M	795.6M
Non-Convertible Debt	512.2M	872.9M	795.6M
Convertible Debt	-	-	-
Capitalized Lease Obligations	-	-	-
Provision for Risks & Charges	581.6M	310.8M	437.4M
Deferred Taxes	43.7M	94.7M	62M
Deferred Taxes - Credit	134.6M	122M	112.1M
Deferred Taxes - Debit	90.9M	27.3M	50.1M
Other Liabilities	34.3M	29.7M	30.2M
Other Liabilities (excl. Deferred Income)	34.3M	29.7M	30.2M
Deferred Income	-	-	-
Total Liabilities	1.85B	2.03B	2.21B
Non-Equity Reserves	-	-	-
Total Liabilities / Total Assets	48.29%	45.75%	46.72%
Preferred Stock (Carrying Value)	-	-	-
Redeemable Preferred Stock	-	-	-
Non-Redeemable Preferred Stock	-	-	-
Common Equity (Total)	1.97B	2.4B	2.53B
Common Stock Par/Carry Value	149.8M	150M	150.2M
Retained Earnings	1.98B	2.38B	2.48B
ESOP Debt Guarantee	(9.8M)	-	-
Cumulative Translation Adjustment/Unrealized For. Exch. Gain	(1.4M)	5.6M	28.4M
Unrealized Gain/Loss Marketable Securities	-	-	-
Revaluation Reserves	-	-	-
Treasury Stock	(194.7M)	(197.8M)	(191.4M)
Common Equity / Total Assets	51.56%	54.20%	53.35%
Total Shareholders' Equity	1.97B	2.4B	2.53B
Total Shareholders' Equity / Total Assets	51.56%	54.20%	53.35%
Accumulated Minority Interest	5.9M	2.1M	(3.5M)
Total Equity	1.98B	2.4B	2.52B
Liabilities & Shareholders' Equity	3.82B	4.43B	4.74B
	2015	2016	2017
Liquidity ratios
current ratio	28.15%	35.39%	34.23%
quick ratio	15.49%	22.83%	21.67%
working capital	-419.7	-447.4	-551.7
Turnover ratios
inventory turnover	70.35	65.18	64.52
asset turnover	68.32%	65.91%	65.61%
Solvency ratios
debt ratio	44.05%	63.36%	57.00%
debt to equity ratio	84.99%	116.95%	107.21%
times interest earned	27.08	20.75	18.67
Profitability ratios
profit margin	14.18%	13.40%	13.56%
return on assets	9.69%	8.83%	8.89%
return on equity	18.79%	16.30%	16.66%
Investor ratios
P/E ratio	8.21	5.48	5.88
dividends payout ratio	0.35	0.40	0.40
dividend yield	0.04	0.07	0.07

income statement

Fiscal year is March-February. All values GBP millions.	2015	2016	2017
Sales/Revenue	2.61B	2.92B	3.11B
Sales Growth	13.45%	12.03%	6.30%
Cost of Goods Sold (COGS) incl. D&A	1.17B	1.29B	1.39B
COGS excluding D&A	1B	1.11B	1.17B
Depreciation & Amortization Expense	168.4M	187.5M	220.1M
Depreciation	155.7M	171.4M	202.5M
Amortization of Intangibles	12.7M	16.1M	17.6M
COGS Growth	9.80%	10.58%	7.44%
Gross Income	1.44B	1.63B	1.72B
Gross Income Growth	16.60%	13.20%	5.40%
Gross Profit Margin	-	-	55.28%
	2015	2016	2017
SG&A Expense	942.4M	1.07B	1.13B
Research & Development	-	-	-
Other SG&A	942.4M	1.07B	1.13B
SGA Growth	16.42%	13.60%	5.88%
Other Operating Expense	-	16.9M	4.9M
Unusual Expense	(3.9M)	15.3M	68.4M
EBIT after Unusual Expense	500.5M	526.2M	510.2M
Non Operating Income/Expense	(23.3M)	(20M)	28.4M
Non-Operating Interest Income	200,000	600,000	300,000
Equity in Affiliates (Pretax)	-	-	-
Interest Expense	17M	23.3M	27.4M
Interest Expense Growth	-9.09%	37.06%	17.60%
Gross Interest Expense	21.3M	33.3M	36.3M
Interest Capitalized	4.3M	10M	8.9M
Pretax Income	460.4M	483.5M	511.5M
Pretax Income Growth	33.64%	5.02%	5.79%
Pretax Margin	-	-	16.47%
Income Tax	97.7M	100.4M	99.5M
Income Tax - Current Domestic	104.1M	108.1M	109.9M
Income Tax - Current Foreign	-	-	-
Income Tax - Deferred Domestic	(6.4M)	(7.7M)	(10.4M)
Income Tax - Deferred Foreign	-	-	-
Income Tax Credits	-	-	-
Equity in Affiliates	3.4M	4.2M	3.9M
Other After Tax Income (Expense)	-	-	-
Consolidated Net Income	366.1M	387.3M	415.9M
Minority Interest Expense	(4M)	(3.9M)	(5.7M)
Net Income	370.1M	391.2M	(5.7M)
Net Income Growth	12.87%	5.70%	7.77%
Net Margin Growth	-	-	13.57%
Extraordinaries & Discontinued Operations	-	-	-
Extra Items & Gain/Loss Sale Of Assets	-	-	-
Cumulative Effect - Accounting Chg	-	-	-
Discontinued Operations	-	-	-
Net Income After Extraordinaries	370.1M	391.2M	421.6M
Preferred Dividends	-	-	-
Net Income Available to Common	370.1M	391.2M	421.6M
EPS (Basic)	2.05	2.16	2.31
EPS (Basic) Growth	11.93%	5.30%	7.29%
Basic Shares Outstanding	180.7M	181.4M	182.2M
EPS (Diluted)	2.03	2.14	2.31
EPS (Diluted) Growth	12.00%	5.53%	7.89%
Diluted Shares Outstanding	182.5M	182.8M	182.6M
EBITDA	665M	729M	798.7M
EBITDA Growth	15.23%	9.62%	9.56%
EBITDA Margin	-	-	25.71%

cash flow

Fiscal year is March-February. All values GBP millions.	2015	2016	2017
Net Income before Extraordinaries	370.1M	387.3M	415.9M
Net Income Growth	14.44%	4.65%	7.38%
Depreciation, Depletion & Amortization	168.4M	187.5M	220.1M
Depreciation and Depletion	155.7M	171.4M	202.5M
Amortization of Intangible Assets	12.7M	16.1M	17.6M
Deferred Taxes & Investment Tax Credit	-	-	(10.4M)
Deferred Taxes	-	-	(10.4M)
Investment Tax Credit	-	-	-
Other Funds	(45.7M)	(16.4M)	(34.7M)
Funds from Operations	492.8M	558.4M	590.9M
Extraordinaries	-	-	-
Changes in Working Capital	27M	11.5M	35M
Receivables	(7.4M)	(15.2M)	(7.1M)
Accounts Payable	41M	34.3M	45.2M
Other Assets/Liabilities	-	-	-
Net Operating Cash Flow	519.8M	569.9M	625.9M
Net Operating Cash Flow Growth	21.28%	9.64%	9.83%
Net Operating Cash Flow / Sales	19.93%	19.51%	20.15%
Investing Activities
	2015	2016	2017
Capital Expenditures	(545.8M)	(715.7M)	(609.8M)
Capital Expenditures (Fixed Assets)	(518.5M)	(680.3M)	(571.2M)
Capital Expenditures (Other Assets)	(27.3M)	(35.4M)	(38.6M)
Capital Expenditures Growth	-78.25%	-31.13%	14.80%
Capital Expenditures / Sales	-20.93%	-24.50%	-19.63%
Net Assets from Acquisitions	(19.5M)	(9.2M)	-
Sale of Fixed Assets & Businesses	-	-	-
Purchase/Sale of Investments	-600,000	(3M)	6.4M
Purchase of Investments	-600,000	(3M)	(7.7M)
Sale/Maturity of Investments	-	-	14.1M
Other Uses	-100,000	-200,000	-
Other Sources	-	-	192.9M
Net Investing Cash Flow	(566M)	(728.1M)	(410.5M)
Net Investing Cash Flow Growth	-84.49%	-28.64%	43.62%
Net Investing Cash Flow / Sales	-21.70%	-24.92%	-13.22%
Financing Activities
	2015	2016	2017
Cash Dividends Paid - Total	(130.6M)	(155.1M)	(167.1M)
Common Dividends	(130.6M)	(155.1M)	(167.1M)
Preferred Dividends	-	-	-
Change in Capital Stock	3.2M	3.6M	5.6M
Repurchase of Common & Preferred Stk.	-	-	-
Sale of Common & Preferred Stock	3.2M	3.6M	5.6M
Proceeds from Stock Options	3.2M	3.6M	5.6M
Other Proceeds from Sale of Stock	-	-	-
Issuance/Reduction of Debt, Net	135.1M	364.1M	(49.8M)
Change in Current Debt	71.2M	20.8M	17.6M
Change in Long-Term Debt	63.9M	343.3M	(67.4M)
Issuance of Long-Term Debt	63.9M	445.2M	-
Reduction in Long-Term Debt	-	(101.9M)	(67.4M)
Other Funds	-	-	-
Other Uses	-	-	-
Other Sources	-	-	-
Net Financing Cash Flow	7.7M	212.6M	(211.3M)
Net Financing Cash Flow Growth	106.42%	2661.04%	-199.39%
Net Financing Cash Flow / Sales	0.30%	7.28%	-6.80%
Exchange Rate Effect	-800,000	600,000	1.8M
Miscellaneous Funds	0	0	0
Net Change in Cash	(39.3M)	55M	5.9M
Free Cash Flow	1.3M	(110.4M)	54.7M
Free Cash Flow Growth	-99.09%	-8592.31%	149.55%
Free Cash Flow Yield	-	-	-1.60%

https://www.marketwatch.com/investing/stock/wtbdy/financials/cash-flow https://www.marketwatch.com/investing/stock/wtbdy/financials/cash-flow https://www.marketwatch.com/investing/stock/wtbdy/financials/cash-flow https://www.marketwatch.com/investing/stock/wtbdy/financials/cash-flow https://www.marketwatch.com/investing/stock/wtbdy/financials/cash-flow https://www.marketwatch.com/investing/stock/wtbdy/financials/cash-flow

Historicalprices 2017

Date	Open	High	Low	Close	Volume
12/29/17	13.6	13.6	13.38	13.59	3083
12/28/17	13.24	13.31	13.17	13.17	10372
12/27/17	13.12	13.25	13.08	13.08	15416
12/26/17	12.96	13.01	12.96	13.01	8717
12/22/17	13.03	13.41	13.01	13.044	12444
12/21/17	12.81	13.48	12.81	12.9	12931
12/20/17	12.85	13.09	12.82	12.82	8725
12/19/17	13.31	13.31	12.77	12.77	8541	Mean	12.8953924
12/18/17	12.78	13.3	12.78	12.79	13619	standard deviation	1.0996338048
12/15/17	13.26	13.27	12.71	13.25	7572	highest price	27.72
12/14/17	12.8	13.3	12.73	12.73	2022	lowest price	11.74
12/13/17	12.8545	13.35	12.8545	13.33	13739
12/17/12	13.34	13.34	13.146	13.25	4273
11/17/12	13.03	13.3963	13.03	13.03	2371
8/17/12	13.3	13.57	13.26	13.52	6092
7/17/12	13.77	13.79	13.13	13.7	15370
6/17/12	13.35	13.94	13.13	13.94	5861
5/17/12	12.39	13.07	12.37	12.38	9472
4/17/12	12.52	12.52	12.18	12.3	4924
1/17/12	12.12	12.6	11.84	12.6	6278
11/30/17	12.43	12.62	12.03	12.05	5216
11/29/17	12.19	12.52	12.19	12.52	3230
11/28/17	12.035	12.43	11.88	11.93	5914
11/27/17	12.17	12.17	11.84	12.17	5103
11/24/17	12.175	12.31	11.92	11.92	5723
11/22/17	12.08	12.43	11.9	12.006	5728
11/21/17	12	12.23	12	12	4892
11/20/17	11.96	12.09	11.94	12.07	8712
11/17/17	12.1	12.34	12.1	12.34	1605
11/16/17	12.25	12.28	11.75	12.27	4787
11/15/17	12	12.17	11.83	12.17	3356
11/14/17	11.79	11.94	11.68	11.9	10228
11/13/17	11.74	12.14	11.74	12.08	6050
10/17/11	12.32	12.32	11.99	12.32	1794
9/17/11	12.31	12.31	11.86	12.3	2616
8/17/11	14.49	14.49	12.05	12.1	1314
7/17/11	16.33	16.33	13.5	14.61	1970
6/17/11	27.72	35.505	27.72	27.72	1480
3/17/11	14.5	14.5	14.5	14.5	1458
2/17/11	12.5	15.715	12.5	12.755	4188
1/17/11	13.04	13.25	12.3	13.25	4538
10/31/17	12.735	13.165	12.735	13.165	2862
10/30/17	12.95	12.985	12.6725	12.985	3164
10/27/17	12.95	12.95	12.67	12.94	3538
10/26/17	13.1	13.125	12.6125	13.125	8614
10/25/17	13.155	13.185	12.55	12.92	7064
10/24/17	12.355	12.995	12.355	12.995	9760
10/20/17	13.415	13.54	13.3025	13.54	5128
10/19/17	13.455	13.525	13.275	13.425	5020
10/18/17	13.235	13.615	13.235	13.5	6926
10/17/17	13.295	13.485	13.295	13.45	8144
10/16/17	13.735	13.735	13.525	13.525	2704
10/13/17	13.805	13.805	13.625	13.745	5290
12/17/10	13.705	13.755	13.45	13.755	4976
11/17/10	13.275	13.475	13.275	13.475	2650
10/17/10	13.075	13.25	13.055	13.055	2498
9/17/10	12.875	13.04	12.875	13.04	1934
6/17/10	13.01	13.01	12.78	12.78	8490
5/17/10	13	13	12.8575	12.8575	3848
4/17/10	13.37	13.37	12.715	13.14	5006
3/17/10	12.695	12.875	12.695	12.875	5528
2/17/10	12.875	12.875	12.7125	12.8	8438
09/29/17	12.75	12.87	12.585	12.87	12062
09/28/17	12.745	12.75	12.7165	12.75	2952
09/27/17	12.75	12.75	12.405	12.75	8064
09/26/17	12.51	12.81	12.385	12.61	6876
09/25/17	12.625	12.95	12.505	12.505	8448
09/22/17	12.625	12.625	12.6075	12.625	3534
09/21/17	12.625	12.625	12.4625	12.625	2570
09/20/17	12.625	12.625	12.46	12.625	11092
09/19/17	12.25	12.62	12.25	12.536	3104
09/18/17	12.4	12.62	12.4	12.62	2758
09/15/17	12.72	12.72	12.31	12.31	7102
09/14/17	12.5	12.645	12.475	12.5	5566
09/13/17	12.655	12.655	12.4775	12.4775	3732
12/17/09	12.56	12.72	12.4	12.61	3068
11/17/09	12.525	12.6725	12.5	12.5625	5724
8/17/09	12.705	12.705	12.39	12.705	6720
7/17/09	12.515	12.6345	12.375	12.375	2428
6/17/09	12.16	12.4	12.16	12.4	2732
5/17/09	12.68	12.68	12.225	12.37	8266
1/17/09	12.53	12.58	12.3671	12.58	14736
08/31/17	12.3565	12.5	12.075	12.075	6662
08/30/17	12.0225	12.22	11.825	11.825	2922
08/29/17	12.189	12.225	11.825	12.025	4284
08/28/17	11.905	12.05	11.905	12.05	6600
08/25/17	11.93	11.96	11.825	11.8588	17874
08/24/17	12.25	12.31	11.962	12.25	3102
08/23/17	12.545	12.555	12.25	12.555	5282
08/22/17	12.575	12.78	12.55	12.575	20110
08/21/17	12.47	12.47	12.346	12.346	1526
08/18/17	12.4	12.495	12.4	12.425	5784
08/17/17	12.74	12.74	12.575	12.62	4190
08/16/17	12.779	12.865	12.7363	12.865	3806
08/15/17	12.6	12.725	12.6	12.725	8954
08/14/17	12.695	12.7775	12.625	12.65	3228
11/17/08	12.422	12.758	12.38	12.38	2490
10/17/08	12.6	12.76	12.555	12.57	17872
9/17/08	12.3715	12.825	12.3715	12.65	9014
8/17/08	12.8	12.95	12.65	12.76	2996
7/17/08	12.97	12.97	12.9	12.925	4218
4/17/08	13.09	13.09	12.97	12.97	1286
3/17/08	13.06	13.105	12.95	12.95	5500
2/17/08	12.73	12.95	12.73	12.95	3616
1/17/08	12.95	13.135	12.725	13.135	10208
07/31/17	13.035	13.13	13.035	13.13	1726
07/28/17	12.68	12.875	12.68	12.875	3704
07/27/17	13.155	13.155	13.155	13.155	1636
07/26/17	13.11	13.175	12.85	13.175	8420
07/25/17	13.03	13.03	13.03	13.03	1278
07/24/17	13.02	13.04	12.675	12.675	3194
07/21/17	13.095	13.095	13.095	13.095	4470
07/20/17	12.9	13.155	12.9	13.15	4166
07/19/17	13.095	13.1	12.95	13	3084
07/18/17	13.0555	13.125	12.805	13.125	13980
07/17/17	13.105	13.155	12.94	13.155	5348
07/14/17	13.015	13.025	12.75	12.905	5308
07/13/17	12.905	12.905	12.725	12.905	3042
12/17/07	12.5	12.6425	12.5	12.6425	1748
11/17/07	12.493	12.52	12.493	12.52	3202
10/17/07	12.54	12.675	12.5	12.675	3852
7/17/07	12.81	12.81	12.675	12.675	4582
6/17/07	12.752	12.925	12.752	12.925	33764
5/17/07	12.85	13.005	12.575	12.575	9244
3/17/07	13.175	13.175	13	13.09	4332
06/30/17	13.1	13.2	12.85	13.2	22882
06/29/17	12.95	13.1	12.95	13.1	4316
06/28/17	13.091	13.1	12.925	13.0813	10756
06/27/17	12.8601	12.976	12.85	12.95	7508
06/26/17	12.875	13.1	12.875	13.1	6898
06/23/17	12.875	12.875	12.8635	12.875	1966
06/22/17	12.6	12.875	12.6	12.875	5926
06/21/17	12.8465	12.87	12.61	12.81	14656
06/20/17	12.325	12.545	12.25	12.545	21284
06/19/17	12.875	12.875	12.6725	12.6725	2932
06/16/17	12.89	12.89	12.515	12.82	7418
06/15/17	12.71	12.8	12.475	12.795	12492
06/14/17	12.8635	13.21	12.8	12.9375	12694
06/13/17	12.675	13.07	12.675	13.07	200896
12/17/06	12.785	12.935	12.525	12.93	7778
9/17/06	12.9	13.055	12.835	13.025	14500
8/17/06	13.56	13.565	13.35	13.565	8380
7/17/06	13.33	13.33	13.2	13.2	4706
6/17/06	13.53	13.53	13.265	13.53	3774
5/17/06	13.6	13.76	13.6	13.755	2916
2/17/06	13.85	14.06	13.85	14.0295	2650
1/17/06	13.815	14.34	13.81	14.29	7076
05/31/17	14.315	14.315	14.06	14.315	5876
05/30/17	14.125	14.125	13.795	13.795	5610
05/26/17	14.0335	14.065	13.78	14.005	15600
05/25/17	14.17	14.22	13.95	14.22	6294
05/24/17	14.1035	14.2	13.85	13.94	3460
05/23/17	14	14.16	13.585	13.965	4684
05/22/17	14.151	14.3	13.882	14.3	5746
05/19/17	13.574	14.06	13.52	14.06	5754
05/18/17	13.815	13.895	13.7713	13.835	4246
05/17/17	13.82	13.84	13.7855	13.7855	3602
05/16/17	13.2885	13.68	13.245	13.26	5340
05/15/17	13.61	13.61	13.505	13.505	2770
12/17/05	13.6605	13.72	13.6545	13.6545	2822
11/17/05	13.34	13.475	13.165	13.475	3956
10/17/05	13.56	13.595	13.5325	13.565	8778
9/17/05	13.42	13.465	13.42	13.46	12314
8/17/05	13.5	13.52	13.405	13.52	4116
5/17/05	13.44	13.465	13.3875	13.465	4048
4/17/05	13.3125	13.415	13.21	13.21	1600
3/17/05	13.12	13.21	13.12	13.125	13676
2/17/05	13.1775	13.265	13.1775	13.265	4790
1/17/05	13.217	13.355	13.217	13.325	6062
04/28/17	13.06	13.365	13.06	13.365	2228
04/27/17	12.95	13.36	12.95	13.36	5612
04/26/17	13.05	13.1	13.0325	13.1	7990
04/25/17	13.055	13.155	12.96	13.155	5392
04/24/17	13.55	14.06	13.55	14.06	6754
04/21/17	13.7	13.73	13.61	13.73	5208
04/20/17	13.595	13.78	13.595	13.78	3894
04/19/17	13.5	13.57	13.465	13.57	2724
04/18/17	13.46	13.46	13.46	13.46	3370
04/17/17	13.1825	13.46	13.1825	13.46	3690
04/13/17	13.135	13.39	13.135	13.39	1634
12/17/04	13	13.235	12.91	13.15	8806
11/17/04	12.98	12.98	12.875	12.975	4136
10/17/04	12.775	12.8	12.775	12.79	5554
7/17/04	12.465	12.69	12.465	12.68	5340
6/17/04	12.645	12.645	12.64	12.64	8822
5/17/04	12.705	12.765	12.62	12.765	10314
4/17/04	12.37	12.395	12.37	12.395	3778
3/17/04	12.48	12.48	12.35	12.48	2574
03/31/17	12.44	12.67	12.435	12.6475	11320
03/30/17	12.43	12.565	12.365	12.565	7326
03/29/17	12.375	12.375	12.13	12.275	11728
03/28/17	12.525	12.53	12.43	12.52	14192
03/27/17	12.6137	12.655	12.61	12.65	4226
03/24/17	12.43	12.47	12.3688	12.47	5546
03/23/17	12.3967	12.54	12.3967	12.53	8842
03/22/17	12.297	12.41	12.297	12.41	2690
03/21/17	12.31	12.45	12.25	12.25	11034
03/20/17	12.225	12.345	12.225	12.345	3834
03/17/17	12.335	12.335	12.175	12.33	4482
03/16/17	12.3	12.325	12.15	12.15	4890
03/15/17	12	12.285	11.95	12.275	7736
03/14/17	11.96	12.12	11.925	12.12	9668
03/13/17	12.045	12.115	11.9	11.9	2782
10/17/03	11.895	12.065	11.82	11.98	4168
9/17/03	11.965	12.055	11.855	12.045	55556
8/17/03	11.895	11.92	11.75	11.92	37990
7/17/03	11.9	11.9	11.69	11.775	5398
6/17/03	11.6562	11.82	11.5717	11.74	19150
3/17/03	11.77	11.85	11.71	11.85	17956
2/17/03	12.005	12.005	11.9	11.98	10998
1/17/03	12.1	12.15	11.93	12.0225	9736
02/28/17	12.01	12.13	12.01	12.0125	9468
02/27/17	12.105	12.125	12.105	12.125	1824
02/24/17	12.0715	12.09	12.0715	12.09	3228
02/23/17	12.12	12.135	12.12	12.125	2894
02/22/17	12.28	12.295	12.15	12.295	9704
02/21/17	12.25	12.39	12.195	12.39	15138
02/17/17	12.35	12.485	12.35	12.485	1722
02/16/17	12.565	12.595	12.45	12.585	8204
02/15/17	12.5	12.585	12.4	12.585	9186
02/14/17	12.655	12.7	12.55	12.7	12596
02/13/17	12.72	12.72	12.45	12.665	8180
10/17/02	12.535	12.745	12.535	12.745	10166
9/17/02	12.605	12.72	12.6025	12.6025	3632
8/17/02	12.795	12.945	12.795	12.945	14394
7/17/02	12.595	12.8	12.59	12.8	5496
6/17/02	12.415	12.53	12.375	12.525	8218
3/17/02	12.65	12.655	12.485	12.645	12786
2/17/02	12.78	12.78	12.625	12.709	15116
1/17/02	12.655	12.715	12.5925	12.6125	5508
01/31/17	12.58	12.61	12.5	12.61	25662
01/30/17	12.4975	12.64	12.465	12.64	12100
01/27/17	12.6475	12.7065	12.62	12.62	2364
01/26/17	12.4	12.545	12.38	12.5	15206
01/25/17	13.07	13.095	12.975	13.08	41452
01/24/17	12.915	13.055	12.9071	13.055	14138
01/23/17	13.015	13.055	13.015	13.045	12204
01/20/17	12.9367	13	12.885	12.975	25086
01/19/17	12.83	12.89	12.79	12.85	5544
01/18/17	12.795	12.925	12.78	12.78	344910
01/17/17	12.79	12.86	12.765	12.765	260942
01/13/17	12.657	12.745	12.6425	12.725	9378
12/17/01	12.62	12.62	12.522	12.59	9772
11/17/01	12.395	12.545	12.395	12.415	4854
10/17/01	12.425	12.58	12.425	12.58	18986
9/17/01	12.01	12.01	11.921	11.9575	19110
6/17/01	12.28	12.375	12.24	12.375	22620
5/17/01	12.1525	12.34	12.1	12.34	10830
4/17/01	11.935	12.05	11.774	11.9475	27268
3/17/01	11.8025	11.835	11.775	11.8	14842

Historicalprices 2016

Date	Open	High	Low	Close	Volume
12/30/16	11.8175	11.85	11.8175	11.825	5192
12/29/16	11.4975	11.645	11.4975	11.645	3388
12/28/16	11.41	11.41	11.381	11.381	1376
12/27/16	11.725	11.725	11.55	11.6	15592
12/23/16	11.4135	11.725	11.39	11.725	23120
12/22/16	11.56	11.575	11.5246	11.555	100912	Mean	13.0791412121
12/21/16	11.1501	11.33	11.1501	11.33	1706	standard deviation	1.5537504068
12/20/16	11.085	11.375	11.085	11.2427	46788	highest price	16.345
12/19/16	11.2	11.275	11.125	11.275	6860	lowest price	10.6635
12/16/16	11.2345	11.55	11.18	11.18	7442
12/15/16	11.4135	11.4525	11.315	11.3151	6858
12/14/16	11.21	11.285	11.17	11.17	2452
12/13/16	10.89	11.085	10.875	11.064	7266
12/16/12	10.83	10.86	10.71	10.71	4864
9/16/12	11.0355	11.16	11	11.005	5190
8/16/12	10.934	11.05	10.91	11.05	3090
7/16/12	10.98	11.002	10.98	10.985	1954
6/16/12	10.785	10.98	10.72	10.72	5780
5/16/12	10.815	11.075	10.79	10.79	7624
2/16/12	10.86	11.02	10.825	10.825	2966
1/16/12	10.785	10.785	10.685	10.6851	2228
11/30/16	10.811	11.04	10.785	10.785	2698
11/29/16	10.925	11.016	10.85	10.9875	2696
11/28/16	10.91	10.9285	10.91	10.9285	1852
11/23/16	10.835	11.045	10.83	11.035	2108
11/22/16	11.1	11.1	11.1	11.1	2280
11/21/16	10.975	11.21	10.95	10.95	3992
11/18/16	11.131	11.131	11.09	11.1	1668
11/17/16	11.085	11.175	11.085	11.175	1896
11/16/16	10.775	11.11	10.775	10.83	4588
11/15/16	11.17	11.17	11.03	11.03	3402
11/14/16	11.0565	11.0565	11.0565	11.0565	836
11/16/11	10.97	11.1585	10.97	11.1585	2764
10/16/11	10.893	10.893	10.86	10.86	630
9/16/11	11.175	11.175	11.17	11.17	1912
8/16/11	10.87	11.161	10.87	10.885	2144
7/16/11	11.29	11.29	11.25	11.27	2662
4/16/11	11.265	11.265	11.265	11.265	964
3/16/11	11.505	11.505	11.505	11.505	792
2/16/11	11.1855	11.26	11.184	11.2	6336
1/16/11	11.282	11.282	10.98	11.165	1900
10/31/16	11.235	11.235	11.235	11.235	780
10/28/16	11.29	11.3	10.955	10.955	1206
10/27/16	10.6635	10.6635	10.6635	10.6635	1004
10/26/16	11.035	11.05	11.03	11.03	7890
10/25/16	11.46	11.485	11.235	11.485	7246
10/24/16	12.035	12.035	12.035	12.035	946
10/21/16	11.53	11.855	11.53	11.855	1670
10/20/16	11.62	11.923	11.62	11.645	3372
10/19/16	11.82	11.96	11.82	11.875	15476
10/17/16	11.555	11.89	11.55	11.89	5832
10/14/16	11.75	11.945	11.595	11.945	2812
10/13/16	11.655	11.885	11.655	11.885	1942
12/16/10	11.7668	11.91	11.7668	11.91	2444
11/16/10	12.265	12.265	12.01	12.01	1460
10/16/10	11.87	11.875	11.825	11.85	2252
6/16/10	12.47	12.47	12.47	12.47	4886
3/16/10	12.87	12.955	12.7175	12.955	5258
09/30/16	12.88	12.88	12.88	12.88	538
09/29/16	12.79	12.79	12.51	12.51	1206
09/28/16	12.63	12.92	12.63	12.92	2042
09/27/16	12.71	12.875	12.49	12.875	5148
09/21/16	13.345	13.345	13.345	13.345	740
09/19/16	13.64	13.64	13.39	13.39	2246
09/16/16	13.585	13.585	13.495	13.495	1276
09/15/16	13.25	13.75	13.25	13.75	6520
09/14/16	13.505	13.505	13.505	13.505	1928
09/13/16	13.179	13.455	13.179	13.455	1252
9/16/09	13.48	13.48	13.44	13.44	4322
8/16/09	14.42	14.42	14.08	14.21	70612
7/16/09	14.575	14.575	14.365	14.475	523952
6/16/09	14.548	14.655	14.26	14.5	132220
1/16/09	14.355	14.355	14.355	14.355	200
08/26/16	13.975	13.975	13.975	13.975	1826
08/25/16	13.975	13.975	13.975	13.975	200
08/23/16	14	14	14	14	1210
08/22/16	13.82	13.82	13.765	13.765	3100
08/17/16	13.125	13.125	13.125	13.125	2000
9/16/08	13	13	13	13	200
3/16/08	12.52	12.9	12.52	12.9	1626
2/16/08	13.24	13.24	13.24	13.24	2000
07/26/16	12.87	12.87	12.87	12.87	400
07/22/16	12.715	12.715	12.715	12.715	1014
07/18/16	12.6649	12.6649	12.6649	12.6649	400
07/15/16	12.66	12.735	12.4887	12.735	3500
12/16/07	12.47	12.565	12.47	12.565	3440
11/16/07	12.25	12.47	12.175	12.175	5778
8/16/07	12.15	12.15	11.95	12.1062	6762
6/16/07	11.045	11.045	11.045	11.045	26624
5/16/07	11.47	11.53	11.375	11.53	2600
1/16/07	11.765	12.375	11.765	12.375	4400
06/27/16	11.485	11.555	11.31	11.555	7254
06/24/16	13.1	13.635	13	13.635	5842
06/17/16	14.595	14.595	14.595	14.595	12668
10/16/06	15.125	15.125	15.125	15.125	250
6/16/06	15.376	15.376	15.1925	15.1925	550
1/16/06	15.48	15.48	15.48	15.48	200
05/31/16	16	16	16	16	490
05/27/16	16.05	16.05	15.32	15.32	3626
05/24/16	16.08	16.215	16.08	16.215	440
05/23/16	15.37	15.37	15.37	15.37	200
05/16/16	14.525	14.6	14.525	14.6	400
05/13/16	14.44	14.44	14.44	14.44	500
12/16/05	14.3425	14.3425	14.3425	14.3425	200
04/29/16	14.6	14.6	14.6	14.6	3382
04/28/16	15.1	15.1	15.1	15.1	3402
04/27/16	15.005	15.22	15.005	15.22	660
04/26/16	14.59	14.59	14.59	14.59	200
04/25/16	14.455	14.455	14.15	14.325	17500
04/22/16	14.47	14.47	14.47	14.47	1224
04/19/16	13.575	13.575	13.575	13.575	294
04/15/16	13.65	13.65	13.65	13.65	554
12/16/04	13.76	13.76	13.76	13.76	356
8/16/04	13.72	13.72	13.72	13.72	440
7/16/04	13.75	13.75	13.75	13.75	200
4/16/04	14.1568	14.1568	14.1568	14.1568	304
1/16/04	14.395	14.395	14.395	14.395	458
03/29/16	14.47	14.47	14.025	14.025	7458
03/17/16	14.215	14.215	14.215	14.215	430
03/15/16	14.09	14.09	13.534	13.534	770
11/16/03	13.975	13.975	13.975	13.975	542
10/16/03	13.8	13.8	13.8	13.8	580
4/16/03	13.5145	13.5145	13.36	13.37	65134
3/16/03	13.945	13.945	13.945	13.945	1246
2/16/03	14.59	14.59	14.59	14.59	704
1/16/03	13.995	13.995	13.995	13.995	624
02/29/16	13.745	13.995	13.745	13.995	1984
02/26/16	13.535	13.725	13.535	13.725	5626
02/25/16	13.35	13.6	13.23	13.6	11994
02/24/16	13.425	13.56	12.965	13.56	2170
02/23/16	13.555	13.75	13.46	13.46	10332
02/22/16	14.245	14.245	14.1855	14.1855	5922
02/19/16	13.725	14.125	13.725	14.125	1140
02/18/16	14.3555	14.42	14.353	14.42	2096
02/17/16	14.27	14.27	14.2355	14.27	1090
02/16/16	13.875	13.92	13.873	13.92	1540
12/16/02	13.25	13.86	13.25	13.86	7146
11/16/02	13.6275	13.675	13.6275	13.675	670
10/16/02	14.255	14.315	14.255	14.3	4804
9/16/02	13.665	13.775	13.275	13.775	1746
8/16/02	13.31	13.3175	13.1914	13.3175	60670
5/16/02	14.114	14.16	14.114	14.16	1416
4/16/02	14.435	14.465	14.406	14.465	1476
3/16/02	14.23	14.485	14.23	14.485	2228
2/16/02	14.402	14.43	14.15	14.15	1388
1/16/02	14.845	14.961	14.75	14.961	1082
01/29/16	14.6295	14.72	14.6295	14.72	5476
01/28/16	14.575	14.665	14.575	14.665	10826
01/27/16	14.611	14.665	14.55	14.55	1688
01/26/16	14.325	14.435	14.325	14.435	14264
01/25/16	14.35	14.37	14.35	14.37	2862
01/22/16	14.645	14.705	14.583	14.705	11830
01/21/16	14.165	14.345	14.165	14.32	2894
01/20/16	13.945	14.26	13.945	14.26	1708
01/19/16	14.3925	14.425	14.307	14.33	3656
01/15/16	14.52	14.575	14.52	14.575	1034
01/14/16	14.825	14.825	14.7975	14.825	1888
01/13/16	15.0335	15.0335	14.895	14.895	1800
12/16/01	15.3125	15.63	15.3125	15.63	1816
11/16/01	15.675	15.675	15.61	15.675	1218
8/16/01	15.4095	15.4095	15.385	15.385	928
7/16/01	15.56	15.56	15.23	15.23	598
6/16/01	15.825	15.825	15.637	15.675	1344
5/16/01	15.935	16.335	15.935	16.335	2592
4/16/01	16.475	16.485	16.1825	16.345	11326

Historicalprices 2015

Date	Open	High	Low	Close	Volume
12/31/15	16.835	16.835	16.835	16.835	342
12/30/15	16.99	17.085	16.99	17.085	1316
12/29/15	17.03	17.03	17.03	17.03	1050
12/28/15	16.755	16.755	16.755	16.755	1720
12/24/15	17.2	17.375	17.2	17.375	1114
12/23/15	16.8875	16.95	16.8875	16.95	3794	Mean	18.6779045977
12/22/15	16.65	16.65	16.15	16.15	5882	standard deviation	1.3517654657
12/21/15	16.825	16.825	16.669	16.669	2004	highest price	21.325
12/18/15	16.94	16.94	16.72	16.72	1462	lowest price	16.15
12/17/15	17.145	17.145	17.145	17.145	330
12/16/15	17.2	17.2	17.2	17.2	846
12/15/15	17.335	17.335	16.75	16.75	4768
12/14/15	16.665	17.225	16.665	17.225	2548
11/15/12	17.195	17.2	17.1225	17.19	5588
9/15/12	17.465	17.505	17.4	17.505	1454
3/15/12	18.315	18.335	17.625	18.335	1840
2/15/12	18.095	18.175	17.39	18.175	2028
1/15/12	18.17	18.17	18.17	18.17	388
11/30/15	17.53	17.53	17.53	17.53	200
11/27/15	17.195	17.195	17.195	17.195	542
11/25/15	17.1245	17.295	16.625	17.295	3294
11/24/15	16.67	16.67	16.67	16.67	290
11/23/15	16.95	17.335	16.95	17.025	26954
11/20/15	17.625	17.625	16.9401	16.9401	28890
11/19/15	17.82	17.82	17.125	17.7885	1918
11/17/15	17.3	17.765	17.3	17.765	1734
11/13/15	16.925	16.925	16.925	16.925	1270
12/15/11	17.725	18	17.7215	18	4746
11/15/11	18.04	18.04	18.04	18.04	400
10/15/11	17.955	17.955	17.81	17.92	7208
9/15/11	18.215	18.24	17.8435	18.24	3846
6/15/11	18.255	18.83	18.255	18.83	2138
5/15/11	18.655	18.655	18.655	18.655	200
4/15/11	18.85	18.85	18.58	18.81	1764
3/15/11	18.925	19.365	18.925	19.365	5482
2/15/11	19.375	19.79	19.25	19.79	2312
10/30/15	19.571	19.635	19.569	19.635	4536
10/29/15	19.3625	19.405	19.3625	19.405	410
10/28/15	19.13	19.13	19.13	19.13	1326
10/27/15	19.117	19.145	19.117	19.145	666
10/23/15	19.34	19.4165	19.34	19.4165	864
10/21/15	19.14	19.14	19.14	19.14	868
10/19/15	18.17	18.74	18.17	18.74	1188
10/15/15	18.2415	18.2415	18.2415	18.2415	336
10/14/15	18.09	18.105	18.09	18.105	1108
8/15/10	18.92	18.92	18.92	18.92	422
6/15/10	18.05	18.56	18.05	18.56	1768
2/15/10	17.715	18.255	17.715	18.255	794
1/15/10	18.21	18.21	18.21	18.21	412
09/30/15	18.035	18.035	18.035	18.035	832
09/25/15	18.475	18.58	18.475	18.58	2942
09/23/15	17.885	17.885	17.885	17.885	2838
09/21/15	17.765	17.765	17.765	17.765	246
09/18/15	18.59	18.59	18.59	18.59	354
09/15/15	18.12	18.12	18.12	18.12	354
09/14/15	18.26	18.26	18.26	18.26	996
9/15/09	18.37	18.37	17.72	17.72	750
1/15/09	18.41	18.41	18.355	18.355	49948
08/24/15	19.08	19.095	19.08	19.095	546
08/17/15	19.82	20.155	19.82	20.155	882
08/14/15	20.73	20.745	20.73	20.745	934
12/15/08	20.495	20.845	20.455	20.845	1176
7/15/08	20.41	20.41	20.41	20.41	416
5/15/08	20.36	20.81	20.36	20.81	686
4/15/08	20.495	20.72	20.495	20.72	144200
07/30/15	20.495	20.495	20.495	20.495	296
07/15/15	20.115	20.115	20.115	20.115	290
07/14/15	20.71	20.71	20.71	20.71	2012
07/13/15	20.635	20.845	20.635	20.845	778
9/15/07	19.87	19.87	19.87	19.87	698
8/15/07	19.25	19.25	19.25	19.25	1238
2/15/07	20.0908	20.1171	19.83	20.1171	211688
06/22/15	21.205	21.205	21.205	21.205	4000
06/17/15	20.39	20.39	20.39	20.39	3700
2/15/06	19.87	19.87	19.87	19.87	200
05/22/15	20.75	20.75	20.75	20.75	404
05/21/15	21.11	21.11	21.11	21.11	1020
05/15/15	21.36	21.36	21.325	21.325	1600
05/13/15	20.35	20.35	20.35	20.35	400
8/15/05	20.245	20.245	20.245	20.245	200
5/15/05	19.59	19.59	19.59	19.59	404
12/15/03	19.995	19.995	19.995	19.995	200
6/15/03	20.355	20.355	20.355	20.355	204
02/24/15	19.625	19.625	19.625	19.625	600
01/30/15	18.745	18.745	18.745	18.745	200
01/23/15	18.91	18.91	18.91	18.91	216000
9/15/01	18.07	18.07	18.07	18.07	600

Historicalprices 2014

Date	Open	High	Low	Close	Volume
12/22/14	18.305	18.305	18.305	18.305	1000
11/18/14	17.93	17.93	17.93	17.93	200
10/31/14	17.815	17.815	17.815	17.815	200
10/20/14	17.23	17.23	17.23	17.23	400
10/15/14	15.975	16.11	15.975	16.11	2980
10/14/14	16.135	16.135	16.135	16.135	200	Mean	17.4375833333
7/14/10	16.61	16.61	16.61	16.61	304	standard deviation	1.0895511363
09/30/14	17.11	17.11	17.11	17.11	200	highest price	18.885
09/23/14	17.41	17.41	17.41	17.41	2862	lowest price	15.19
09/15/14	17.43	17.43	17.43	17.43	800
08/25/14	18.575	18.77	18.575	18.77	1400
08/18/14	18.385	18.385	18.385	18.385	858
12/14/08	17.99	17.99	17.99	17.99	516
5/14/08	17.895	17.895	17.895	17.895	200
07/28/14	18.4	18.4	18.4	18.4	1200
07/25/14	18.58	18.58	18.54	18.54	400
07/23/14	18.753	18.753	18.753	18.753	600
07/21/14	18.665	18.665	18.665	18.665	286
05/16/14	16.69	16.695	16.405	16.405	1202
05/13/14	17.75	17.75	17.75	17.75	400
12/14/05	17.9	17.9	17.9	17.9	888
04/23/14	17.4	17.4	17.115	17.115	2400
04/15/14	15.99	15.99	15.99	15.99	404
5/14/03	18.885	18.885	18.885	18.885	400
4/14/03	18.635	18.635	18.635	18.635	3030
3/14/03	18.635	18.635	18.635	18.635	1000
02/28/14	18.755	18.755	18.755	18.755	200
02/27/14	17.875	17.875	17.875	17.875	200
02/24/14	17.65	17.65	17.65	17.65	200
02/21/14	17.56	17.56	17.56	17.56	2030
02/14/14	17	17	17	17	200
6/14/02	15.58	15.58	15.58	15.58	200
3/14/02	15.19	15.19	15.19	15.19	200
01/27/14	15.655	15.655	15.655	15.655	3400
01/16/14	16.045	16.045	16.045	16.045	914
7/14/01	15.645	15.645	15.645	15.645	1000

Historicalprices 2013

Date	Open	High	Low	Close	Volume
12/30/13	15.625	15.625	15.625	15.625	200
12/20/13	14.82	14.82	14.82	14.82	200
10/13/12	14.555	14.555	14.535	14.535	4600
9/13/12	14.665	14.665	14.665	14.665	600
3/13/12	14.685	14.685	14.685	14.685	200
11/27/13	14.705	14.705	14.705	14.705	3286	Mean	12.7442
11/26/13	14.305	14.305	14.305	14.305	200	standard deviation	1.8550447434
11/13/13	13.785	13.785	13.785	13.785	1038	highest price	15.625
7/13/11	14.14	14.14	14.14	14.14	366	lowest price	9.72
10/23/13	13.745	13.745	13.74	13.74	872
10/21/13	13.835	13.835	13.835	13.835	200
10/17/13	13.4	13.4	13.4	13.4	200
11/13/10	12.75	12.75	12.75	12.75	832
8/13/10	11.86	11.86	11.785	11.795	3830
9/13/09	12.89	12.9	12.89	12.9	400
9/13/08	12.56	12.56	12.56	12.56	200
8/13/08	12.67	12.67	12.665	12.665	8490
07/30/13	12.375	12.375	12.365	12.365	1898
02/25/13	9.72	9.72	9.72	9.72	2000
7/13/02	10.66	10.66	10.66	10.66	204
6/13/02	10.5	10.5	10.5	10.5	200
01/30/13	10.32	10.32	10.315	10.315	3200
01/18/13	10.055	10.055	10.05	10.05	400
01/17/13	10.05	10.05	10.05	10.05	404
01/15/13	10.035	10.035	10.035	10.035	1000