Help with Excel/paper

klbrbe

FIN320ModuleFourExcelAssignment.xls

Home >Business & Finance homework help >Accounting homework help >Help with Excel/paper

Sheet: 2015-2017 Balance Sheet

Sheet: 2015-2017 Income Statement

Sheet: 2015 -2017 Cash Flow

Sheet: Verizon stock History

Verizon Communications Inc (NYS: VZ)

Balance Sheet

Exchange rate used is that of the Year End reported date

As Reported Annual Balance Sheet

Report Date

12/31/2017

42735.0

12/31/2015

Currency

USD

Audit Status

Not Qualified

Consolidated

Yes

Scale

Thousands

2880000.0

4470000.0

Assets

350000.0

Current assets

1.8358E7

1.4339E7

Cash & cash equivalents

2079000.0

845000.0

882000.0

Short-term investments

1.7513E7

1.3457E7

Accounts receivable, gross

2.4432E7

1202000.0

1252000.0

Less: allowances - accounts receivable

939000.0

882000.0

792000.0

Accounts receivable, net

2.3493E7

3918000.0

1959000.0

Inventories

1034000.0

2.6395E7

2.228E7

Assets held for sale

667000.0

709000.0

Prepaid expenses & other current assets

3307000.0

2.7117E7

2.5587E7

Total current assets

2.9913E7

1.36737E8

1.29201E8

Land

806000.0

4.429E7

Buildings & equipment

2.8914E7

4.5639E7

Central office & other network equipment

1.45093E8

7627000.0

7104000.0

Cable, wiring & conduit

5710000.0

4907000.0

Cable, poles & conduit

4.7972E7

8718000.0

8365000.0

Leasehold improvements

8394000.0

2.32215E8

2.20163E8

Work in progress

6139000.0

1.47464E8

1.36622E8

Furniture, vehicles & other plant, property & equipment

9180000.0

8.4751E7

8.3541E7

Plant, property & equipment

2.46498E8

1110000.0

796000.0

Less: accumulated depreciation

1.5793E8

8.6673E7

8.6575E7

Plant, property & equipment, net

8.8568E7

2.7205E7

2.5331E7

Investments in unconsolidated businesses

1039000.0

8897000.0

8338000.0

Wireless licenses

8.8417E7

613000.0

1.0267E7

Goodwill

2.9172E7

8536000.0

7512000.0

Other intangible assets, net

1.0247E7

2.4418E8

2.4464E8

Non-current assets held for sale

2477000.0

6325000.0

Other assets

9787000.0

168000.0

158000.0

Total assets

2.57143E8

6000.0

2645000.0

6489000.0

Liabilities and Equaity

7084000.0

6391000.0

Current liabilities

5717000.0

5281000.0

Long-term debt maturing within one year

3303000.0

3813000.0

4107000.0

Short-term notes payable

150000.0

1463000.0

1529000.0

Commercial paper & other short-term debt

1516000.0

2054000.0

Debt maturing within one year

3453000.0

1.9593E7

1.9362E7

Accounts payable

7063000.0

24000.0

463000.0

Accrued expenses

6756000.0

2914000.0

2969000.0

Accrued vacation, salaries & wages

4521000.0

2375000.0

2323000.0

Interest payable

1409000.0

2789000.0

3446000.0

Taxes payable

1483000.0

8078000.0

8738000.0

Accounts payable & accrued liabilities

2.1232E7

3.034E7

3.5052E7

Liabilities related to assets held for sale

1.05305E8

1.10325E8

Advance billings & customer deposits

3084000.0

525000.0

686000.0

Dividends payable

2429000.0

1208000.0

2454000.0

Other current liabilities

2839000.0

1432000.0

Other current liabilities

8352000.0

1102000.0

Total current liabilities

3.3037E7

5005000.0

950000.0

957000.0

Notes payable & other long-term debt

1.12901E8

-5716000.0

-5824000.0

Assumed notes

234000.0

-469000.0

Debentures

796000.0

1.0791E8

1.1003E8

Debentures & other long-term debt

2477000.0

6325000.0

Notes payable, debentures & other long-term debt

748000.0

1.05433E8

1.03705E8

Asset-backed debt

8913000.0

2.6166E7

2.9957E7

Capital lease obligations

1020000.0

4.5964E7

4.5484E7

Unamortized discount, net of premium

-7133000.0

6000.0

959000.0

Unamortized debt issuance costs

-534000.0

1.2239E7

1.1641E7

Long-term debt, including current maturities

1.16945E8

Less: long-term debt maturing within one year

3303000.0

424000.0

Long-term debt

1.13642E8

1.1182E7

1.1196E7

Employee benefit obligations

2.2112E7

1.5059E7

1.1246E7

Deferred income taxes

3.1232E7

-713000.0

-554000.0

Non-current liabilities related to assets held for sale

-80000.0

-278000.0

Other liabilities

1.2433E7

46000.0

101000.0

Total long-term liabilities

1.79419E8

3420000.0

1281000.0

2673000.0

550000.0

Equity

7263000.0

7416000.0

Common stock

424000.0

-449000.0

-428000.0

Contributed capital

1.1101E7

1508000.0

1414000.0

Retained earnings (accumulated deficit)

3.5635E7

2.4032E7

1.7842E7

Foreign currency translation adjustments

-468000.0

Unrealized gain (loss) on cash flow hedges

-111000.0

Unrealized gain (loss) on marketable securities

32000.0

Defined benefit pension & postretirement plans

3206000.0

Accumulated other comprehensive income (loss)

2659000.0

Common stock in treasury, at cost

7139000.0

Deferred compensation - employee stock ownership plans & other

-416000.0

Noncontrolling interest

1591000.0

Total equity

4.4687E7

Reference

MergentOnline.(2018)Verizon retrieved September 21, 2018 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=36979&period=Annuals&dataarea=BS&range=3&currency=AsRep&scale=AsRep&Submit=Refresh

Verizon Communications Inc (NYS: VZ)

Income Statement

Exchange rate used is that of the Year End reported date

As Reported Annual Income Statement

Report Date

43100.0

12/31/2016

12/31/2015

Currency

USD

Audit Status

Not Qualified

Consolidated

Yes

Scale

Thousands

1.08468E8

1.14696E8

Operating Revenues

1.7512E7

1.6924E7

Service revenues & other revenues

1.07145E8

1.2598E8

1.3162E8

Wireless equipment revenues

1.8889E7

2.9186E7

2.9438E7

2.2238E7

2.3119E7

Total operating revenues

1.26034E8

3.1569E7

2.9986E7

Operating Expenses

1.5928E7

1.6017E7

Cost of services (exclusive of items shown below)

2.9409E7

9.8921E7

9.856E7

Wireless cost of equipment

2.2147E7

2.7059E7

3.306E7

Selling, general & administrative expense, net

3.011E7

-98000.0

-86000.0

Depreciation & amortization expense

1.6954E7

59000.0

115000.0

-1658000.0

71000.0

Total operating expenses

9.862E7

-1599000.0

186000.0

Operating income

2.7414E7

4376000.0

4920000.0

Equity in earnings (losses) of unconsolidated businesses

-77000.0

2.0047E7

2.7639E7

Interest income

82000.0

939000.0

601000.0

Other income (expense), net

-2092000.0

2.0986E7

2.824E7

Other income & (expense), net

-2010000.0

7451000.0

5476000.0

Interest expense

4733000.0

148000.0

70000.0

842000.0

803000.0

Income before provision (benefit) for income taxes - domestic

1.9645E7

8441000.0

6349000.0

Income before provision (benefit) for income taxes - foreign

949000.0

-933000.0

3377000.0

Income before provision (benefit) for income taxes

2.0594E7

-2000.0

9000.0

Current provision (benefit) for income taxes - federal

3630000.0

-128000.0

130000.0

Current provision (benefit) for income taxes - foreign

200000.0

-1063000.0

3516000.0

Current provision (benefit) for income taxes - state & local

677000.0

7378000.0

9865000.0

Total current provision (benefit) for income taxes

4507000.0

1.3608E7

1.8375E7

Deferred provision (benefit) for income taxes - federal

-1.436E7

-481000.0

-496000.0

Deferred provision (benefit) for income taxes - foreign

-66000.0

1.3127E7

1.7879E7

Deferred provision (benefit) for income taxes - state & local

-37000.0

4080000.0

4085000.0

Total deferred provision (benefit) for income taxes

-1.4463E7

4086000.0

4093000.0

Provision (benefit) for income taxes

-9956000.0

4076684.0

4073175.0

Net income (loss)

3.055E7

3.22

4.38

Net income attributable to noncontrolling interest

-449000.0

3.21

4.37

Net income (loss) attributable to Verizon Communications Inc.

3.0101E7

2.285

2.23

Weighted average shares outstanding - basic

4084000.0

160900.0

177700.0

Weighted average shares outstanding - diluted

4089000.0

690741.0

602700.0

Year end shares outstanding

4079476.372

-159000.0

-208000.0

Net earnings (loss) per share - basic

7.37

Net earnings (loss) per share - diluted

7.36

Dividends declared

2.335

Total number of employees

155400.0

Total number of stockholders

659979.0

Foreign currency translation adjustments

245000.0

Referance

Mergent Online. (2018) Verizon Retrieved September 21, 2018 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=36979&period=Annuals&dataarea=PL&range=3&currency=AsRep&scale=AsRep&Submit=Refresh

Verizon Communications Inc (NYS: VZ)

Cash Flow

Exchange rate used is that of the Year End reported date

As Reported Annual Cash Flow

Report Date

12/31/2017

12/31/2016

12/31/2015

Currency

USD

Audit Status

Not Qualified

Consolidated

Yes

Scale

Thousands

1.3608E7

1.8375E7

1.5928E7

1.6017E7

Cash Flows from Operating Activities

2705000.0

-1747000.0

Net income (loss)

3.055E7

-1063000.0

3516000.0

Depreciation & amortization expense

1.6954E7

1420000.0

1610000.0

Employee retirement benefits

440000.0

138000.0

127000.0

Deferred income taxes

-1.4463E7

-5067000.0

-945000.0

Provision for uncollectible accounts

1167000.0

61000.0

-99000.0

Equity in losses (earnings) of unconsolidated businesses, net of dividends received

117000.0

449000.0

942000.0

Accounts receivable

-5436000.0

-1079000.0

2545000.0

Inventories

168000.0

Other assets

656000.0

Accounts payable & accrued liabilities

-335000.0

-4385000.0

-1411000.0

Discretionary contribution to qualified pension plans

-3411000.0

2.2715E7

3.893E7

Net gain on sale of divested businesses

-1774000.0

-1.7059E7

-1.7775E7

Other operating activities, net

672000.0

-3765000.0

-3545000.0

Net cash flows from operating activities

2.5305E7

-534000.0

-9942000.0

Cash Flows from Investing Activities

9882000.0

48000.0

Capital expenditures (including capital software)

-1.7247E7

493000.0

1171000.0

Acquisitions of investments & businesses, net of cash acquired

-5928000.0

-1.0983E7

-3.0043E7

Acquisitions of wireless licenses

-583000.0

1.2964E7

6667000.0

Proceeds from disposition of businesses

3614000.0

4986000.0

Other investing activities, net

772000.0

-1.9159E7

-9340000.0

Net cash flows from investing activities

-1.9372E7

Cash Flows from Financing Activities

-149000.0

-344000.0

Proceeds from long-term borrowings

2.7707E7

-9262000.0

-8538000.0

Proceeds from asset-backed long-term borrowings

4290000.0

3000.0

40000.0

Repayments of long-term borrowings & capital lease obligations

-2.3837E7

-5134000.0

Repayments of asset-backed long-term borrowings

-400000.0

-2705000.0

1634000.0

Decrease (increase) in short-term obligations, excluding current maturities

-170000.0

-1.3322E7

-1.5015E7

Dividends paid

-9472000.0

-1590000.0

-6128000.0

Proceeds from sale of common stock

4470000.0

1.0598E7

Purchase of common stock for treasury

2880000.0

4470000.0

Other financing activities, net

-4852000.0

9577000.0

5293000.0

Net cash flows from financing activities

-6734000.0

4085000.0

4491000.0

Increase (decrease) in cash & cash equivalents

-801000.0

Cash & cash equivalents, beginning of period

2880000.0

Cash & cash equivalents, end of period

2079000.0

Cash paid for income taxes, net of amounts refunded

4432000.0

Cash paid for interest, net of amounts capitalized

4369000.0

Mergent Online. (2018) Verizon Retrieved September 21, 2018 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=36979&period=Annuals&dataarea=CF&range=3&currency=AsRep&scale=AsRep&Submit=Refresh

Verizon Communications Inc (NYS: VZ)

Issue: Verizon Communications Inc(NYS:VZ)

Time Period: 3 years

Frequency: daily

Adjusted Prices

Historical Pricing

Date

Open

High

Low

Volume

Price Move (%)

09/21/2018

09/20/2018

53.317

09/19/2018

09/18/2018

-0.57

09/17/2018

54.79

55.0199

09/14/2018

09/13/2018

09/12/2018

09/11/2018

1.11

09/10/2018

09/07/2018

09/06/2018

09/05/2018

09/04/2018

08/31/2018

08/30/2018

08/29/2018

08/28/2018

08/27/2018

54.651

08/24/2018

08/23/2018

08/22/2018

08/21/2018

08/20/2018

08/17/2018

08/16/2018

53.2031

08/15/2018

08/14/2018

08/13/2018

08/10/2018

08/09/2018

08/08/2018

08/07/2018

08/06/2018

08/03/2018

0.56

08/02/2018

08/01/2018

07/31/2018

07/30/2018

07/27/2018

07/26/2018

07/25/2018

-1.16

07/24/2018

07/23/2018

07/20/2018

07/19/2018

07/18/2018

50.8828

-0.56

07/17/2018

07/16/2018

07/13/2018

07/12/2018

07/11/2018

07/10/2018

07/09/2018

50.6801

07/06/2018

07/05/2018

1.14

07/03/2018

50.296

0.56

07/02/2018

06/29/2018

06/28/2018

06/27/2018

06/26/2018

49.0748

06/25/2018

06/22/2018

2.32

06/21/2018

48.3759

1.12

06/20/2018

06/19/2018

06/18/2018

06/15/2018

06/14/2018

06/13/2018

06/12/2018

06/11/2018

06/08/2018

06/07/2018

06/06/2018

06/05/2018

06/04/2018

06/01/2018

0.29

05/31/2018

05/30/2018

05/29/2018

05/25/2018

05/24/2018

05/23/2018

05/22/2018

05/21/2018

05/18/2018

05/17/2018

47.86

48.0399

05/16/2018

05/15/2018

05/14/2018

05/11/2018

05/10/2018

05/09/2018

05/08/2018

05/07/2018

05/04/2018

05/03/2018

05/02/2018

05/01/2018

04/30/2018

04/27/2018

04/26/2018

04/25/2018

04/24/2018

04/23/2018

04/20/2018

-1.09

04/19/2018

04/18/2018

04/17/2018

04/16/2018

04/13/2018

04/12/2018

04/11/2018

04/10/2018

04/09/2018

46.8032

04/06/2018

04/05/2018

47.6762

04/04/2018

04/03/2018

04/02/2018

47.62

47.9399

03/29/2018

03/28/2018

03/27/2018

47.1

47.9024

03/26/2018

03/23/2018

03/22/2018

47.1

47.5199

03/21/2018

03/20/2018

03/19/2018

03/16/2018

0.56

03/15/2018

03/14/2018

03/13/2018

03/12/2018

03/09/2018

03/08/2018

03/07/2018

03/06/2018

03/05/2018

03/02/2018

03/01/2018

02/28/2018

02/27/2018

02/26/2018

02/23/2018

02/22/2018

02/21/2018

02/20/2018

-2.45

02/16/2018

02/15/2018

02/14/2018

-1.14

02/13/2018

02/12/2018

02/09/2018

02/08/2018

02/07/2018

02/06/2018

02/05/2018

02/02/2018

-2.43

02/01/2018

01/31/2018

53.99

54.4199

01/30/2018

01/29/2018

01/26/2018

01/25/2018

01/24/2018

01/23/2018

01/22/2018

01/19/2018

01/18/2018

01/17/2018

01/16/2018

01/12/2018

51.7801

01/11/2018

01/10/2018

01/09/2018

01/08/2018

01/05/2018

01/04/2018

01/03/2018

-2.05

01/02/2018

1.13

12/29/2017

12/28/2017

0.28

12/27/2017

12/26/2017

12/22/2017

12/21/2017

12/20/2017

12/19/2017

12/18/2017

1.1

12/15/2017

12/14/2017

12/13/2017

-0.56

12/12/2017

12/11/2017

12/08/2017

12/07/2017

12/06/2017

50.65

50.8399

12/05/2017

12/04/2017

12/01/2017

11/30/2017

50.0

51.0944

11/29/2017

11/28/2017

2.43

11/27/2017

11/24/2017

11/22/2017

11/21/2017

46.34

46.4468

11/20/2017

11/17/2017

11/16/2017

11/15/2017

11/14/2017

11/13/2017

-0.29

11/10/2017

11/09/2017

11/08/2017

11/07/2017

45.21

45.5878

11/06/2017

11/03/2017

11/02/2017

11/01/2017

10/31/2017

10/30/2017

10/27/2017

10/26/2017

10/25/2017

10/24/2017

10/23/2017

-1.09

10/20/2017

10/19/2017

1.15

10/18/2017

10/17/2017

10/16/2017

10/13/2017

10/12/2017

10/11/2017

-0.57

10/10/2017

10/09/2017

10/06/2017

48.6555

10/05/2017

49.96

50.0345

10/04/2017

10/03/2017

10/02/2017

09/29/2017

09/28/2017

49.1401

09/27/2017

09/26/2017

09/25/2017

09/22/2017

09/21/2017

48.844

-1.09

09/20/2017

0.28

09/19/2017

09/18/2017

09/15/2017

09/14/2017

09/13/2017

09/12/2017

09/11/2017

09/08/2017

09/07/2017

09/06/2017

09/05/2017

09/01/2017

08/31/2017

48.26

48.399

08/30/2017

08/29/2017

08/28/2017

-0.14

08/25/2017

08/24/2017

08/23/2017

48.1901

-0.14

08/22/2017

08/21/2017

08/18/2017

08/17/2017

08/16/2017

-0.14

08/15/2017

08/14/2017

08/11/2017

08/10/2017

08/09/2017

08/08/2017

08/07/2017

08/04/2017

08/03/2017

08/02/2017

08/01/2017

07/31/2017

07/28/2017

07/27/2017

07/26/2017

44.2774

07/25/2017

07/24/2017

07/21/2017

07/20/2017

07/19/2017

07/18/2017

07/17/2017

43.63

43.859

07/14/2017

07/13/2017

43.0387

07/12/2017

07/11/2017

07/10/2017

07/07/2017

07/06/2017

-2.53

07/05/2017

07/03/2017

06/30/2017

0.56

06/29/2017

06/28/2017

06/27/2017

06/26/2017

06/23/2017

-0.07

06/22/2017

06/21/2017

-1.15

06/20/2017

06/19/2017

06/16/2017

06/15/2017

06/14/2017

06/13/2017

06/12/2017

06/09/2017

1.15

06/08/2017

06/07/2017

46.3639

06/06/2017

06/05/2017

06/02/2017

06/01/2017

-0.28

05/31/2017

05/30/2017

05/26/2017

45.25

45.4366

05/25/2017

05/24/2017

05/23/2017

05/22/2017

05/19/2017

05/18/2017

05/17/2017

05/16/2017

05/15/2017

05/12/2017

05/11/2017

05/10/2017

05/09/2017

05/08/2017

05/05/2017

05/04/2017

05/03/2017

05/02/2017

0.07

05/01/2017

-0.07

04/28/2017

04/27/2017

04/26/2017

04/25/2017

04/24/2017

04/21/2017

04/20/2017

04/19/2017

-0.57

04/18/2017

04/17/2017

04/13/2017

04/12/2017

04/11/2017

04/10/2017

04/07/2017

04/06/2017

04/05/2017

04/04/2017

04/03/2017

03/31/2017

03/30/2017

-0.14

03/29/2017

03/28/2017

03/27/2017

-1.09

03/24/2017

03/23/2017

-0.14

03/22/2017

03/21/2017

03/20/2017

03/17/2017

03/16/2017

03/15/2017

03/14/2017

03/13/2017

03/10/2017

0.14

03/09/2017

49.22

49.4499

03/08/2017

-0.57

03/07/2017

03/06/2017

03/03/2017

03/02/2017

03/01/2017

02/28/2017

02/27/2017

02/24/2017

0.58

02/23/2017

02/22/2017

02/21/2017

02/17/2017

02/16/2017

02/15/2017

02/14/2017

-0.58

02/13/2017

02/10/2017

02/09/2017

02/08/2017

02/07/2017

02/06/2017

-1.13

02/03/2017

02/02/2017

02/01/2017

01/31/2017

01/30/2017

01/27/2017

01/26/2017

01/25/2017

01/24/2017

01/23/2017

01/20/2017

01/19/2017

01/18/2017

01/17/2017

01/13/2017

01/12/2017

01/11/2017

-0.57

01/10/2017

01/09/2017

-1.09

01/06/2017

-2.53

01/05/2017

01/04/2017

01/03/2017

12/30/2016

12/29/2016

0.56

12/28/2016

12/27/2016

-0.07

12/23/2016

12/22/2016

12/21/2016

-0.28

12/20/2016

12/19/2016

12/16/2016

12/15/2016

12/14/2016

12/13/2016

1.16

12/12/2016

12/09/2016

12/08/2016

12/07/2016

2.03

12/06/2016

12/05/2016

12/02/2016

12/01/2016

11/30/2016

11/29/2016

11/28/2016

11/25/2016

11/23/2016

11/22/2016

11/21/2016

11/18/2016

11/17/2016

11/16/2016

11/15/2016

11/14/2016

-1.09

11/11/2016

11/10/2016

11/09/2016

11/08/2016

11/07/2016

11/04/2016

11/03/2016

11/02/2016

11/01/2016

10/31/2016

10/28/2016

48.56

48.772

10/27/2016

10/26/2016

10/25/2016

10/24/2016

10/21/2016

10/20/2016

10/19/2016

50.3471

10/18/2016

10/17/2016

10/14/2016

10/13/2016

10/12/2016

10/11/2016

-0.58

10/10/2016

10/07/2016

10/06/2016

10/05/2016

10/04/2016

10/03/2016

09/30/2016

09/29/2016

09/28/2016

52.31

52.439

09/27/2016

09/26/2016

09/23/2016

09/22/2016

09/21/2016

09/20/2016

0.14

09/19/2016

09/16/2016

09/15/2016

09/14/2016

09/13/2016

09/12/2016

09/09/2016

09/08/2016

09/07/2016

09/06/2016

09/02/2016

09/01/2016

08/31/2016

08/30/2016

08/29/2016

08/26/2016

08/25/2016

52.326

08/24/2016

08/23/2016

08/22/2016

08/19/2016

08/18/2016

-0.56

08/17/2016

08/16/2016

08/15/2016

-0.07

08/12/2016

08/11/2016

08/10/2016

0.28

08/09/2016

08/08/2016

08/05/2016

08/04/2016

53.826

08/03/2016

08/02/2016

08/01/2016

55.58

55.8195

07/29/2016

07/28/2016

07/27/2016

07/26/2016

07/25/2016

07/22/2016

07/21/2016

07/20/2016

-0.14

07/19/2016

55.5503

07/18/2016

07/15/2016

07/14/2016

-0.29

07/13/2016

07/12/2016

07/11/2016

07/08/2016

07/07/2016

07/06/2016

07/05/2016

07/01/2016

06/30/2016

06/29/2016

06/28/2016

06/27/2016

0.57

06/24/2016

06/23/2016

06/22/2016

06/21/2016

06/20/2016

06/17/2016

06/16/2016

06/15/2016

52.97

53.2136

-0.28

06/14/2016

06/13/2016

52.233

06/10/2016

06/09/2016

06/08/2016

06/07/2016

2.05

06/06/2016

06/03/2016

06/02/2016

06/01/2016

05/31/2016

0.55

05/27/2016

05/26/2016

05/25/2016

49.63

50.0078

05/24/2016

05/23/2016

05/20/2016

05/19/2016

05/18/2016

05/17/2016

05/16/2016

0.57

05/13/2016

05/12/2016

05/11/2016

05/10/2016

05/09/2016

05/06/2016

50.6137

0.55

05/05/2016

50.6327

05/04/2016

05/03/2016

05/02/2016

04/29/2016

04/28/2016

04/27/2016

50.46

51.8099

04/26/2016

04/25/2016

04/22/2016

04/21/2016

04/20/2016

04/19/2016

04/18/2016

04/15/2016

04/14/2016

0.14

04/13/2016

04/12/2016

04/11/2016

-1.09

04/08/2016

04/07/2016

04/06/2016

53.616

04/05/2016

04/04/2016

04/01/2016

03/31/2016

0.07

03/30/2016

03/29/2016

03/28/2016

03/24/2016

03/23/2016

53.13

53.2299

-0.56

03/22/2016

03/21/2016

03/18/2016

03/17/2016

03/16/2016

03/15/2016

52.24

52.7401

03/14/2016

03/11/2016

03/10/2016

03/09/2016

03/08/2016

03/07/2016

03/04/2016

03/03/2016

03/02/2016

03/01/2016

02/29/2016

-0.57

02/26/2016

02/25/2016

0.57

02/24/2016

02/23/2016

02/22/2016

02/19/2016

02/18/2016

02/17/2016

02/16/2016

02/12/2016

02/11/2016

02/10/2016

50.19

50.3236

02/09/2016

-1.16

02/08/2016

02/05/2016

02/04/2016

02/03/2016

02/02/2016

02/01/2016

01/29/2016

01/28/2016

01/27/2016

01/26/2016

01/25/2016

01/22/2016

2.55

01/21/2016

01/20/2016

01/19/2016

01/15/2016

01/14/2016

01/13/2016

01/12/2016

01/11/2016

0.58

01/08/2016

01/07/2016

-0.55

01/06/2016

01/05/2016

01/04/2016

12/31/2015

12/30/2015

12/29/2015

46.8436

12/28/2015

12/24/2015

12/23/2015

12/22/2015

12/21/2015

12/18/2015

12/17/2015

12/16/2015

12/15/2015

12/14/2015

12/11/2015

-1.1

12/10/2015

12/09/2015

12/08/2015

12/07/2015

12/04/2015

12/03/2015

12/02/2015

45.45

45.551

12/01/2015

0.29

11/30/2015

11/27/2015

11/25/2015

11/24/2015

11/23/2015

11/20/2015

11/19/2015

45.44

45.8701

11/18/2015

45.08

45.4273

11/17/2015

11/16/2015

44.1849

11/13/2015

11/12/2015

11/11/2015

11/10/2015

11/09/2015

11/06/2015

11/05/2015

11/04/2015

11/03/2015

11/02/2015

10/30/2015

10/29/2015

10/28/2015

10/27/2015

46.19

46.296

46.0143

10/26/2015

46.1468

10/23/2015

10/22/2015

2.3

10/21/2015

10/20/2015

10/19/2015

10/16/2015

0.07

10/15/2015

10/14/2015

10/13/2015

0.14

10/12/2015

10/09/2015

10/08/2015

10/07/2015

10/06/2015

0.14

10/05/2015

10/02/2015

-0.28

10/01/2015

09/30/2015

43.2845

09/29/2015

09/28/2015

-1.09

09/25/2015

0.29

09/24/2015

09/23/2015

09/22/2015

44.43

44.533

09/21/2015

44.62

44.8867

Reference