Help with Excel/paper

klbrbe
FIN320ModuleFourExcelAssignmentweek4.xls

Sheet: 2017 Balance Sheet

Sheet: 2017 Income Statement

Sheet: 2017 Cash Flow

Sheet: 2017 Ratio Analysis

Sheet: 2016 Balance Sheet

Sheet: 2016 Income Statement

Sheet: 2016 Cash Flow

Sheet: 2016 Ratio Analysis

Sheet: 2015 Balance Sheet

Sheet: 2015 Income Statement

Sheet: 2015 Cash Flow

Sheet: 2015 Ratio Analysis

Sheet: Verizon stock History

Sheet: Stock Prices

Verizon Communications Inc (NYS: VZ)

Consolidated Balance Sheets

Year Ended December 31, 2017

Audit Status

Unqualified

All amounts in millions, except per share amount.

$ m

Assets

Current assets

Cash and cash equivalents

2079.0

Short-term investments

0.0

Accounts receivable, net of allowances of $882 and $739

23493.0

Inventories

1034.0

Assets held for sale

0.0

Prepaid expenses and other

3307.0

Total current assets

29913.0

Non-Current assets

Plant, property and equipment

246498.0

Less accumulated depreciation

-157930.0

Net Plant, property and equipment

88568.0

Investments in unconsolidated businesses

1039.0

Wireless licenses

88417.0

Goodwill

29172.0

Other intangible assets, net

10247.0

Non- current assets held for sale

0.0

Deposit for wireless licenses

0.0

Other assets

9787.0

Total assets

257143.0

Liabilities and Equity

Current liabilities

Debt maturing within one year

3453.0

Accounts payable and accrued liabilities

21232.0

Liabilities related to assets held for sale

0.0

Other

8352.0

Total current liabilities

33037.0

Non-Current liabilities

Long-term debt

113642.0

Employee benefit obligations

22112.0

Deferred income taxes

31232.0

Non- current liabilities related to assets held for sale

0.0

Other liabilities

12433.0

Equity

Series preferred stock ($.10 par value; none issued)

0.0

Common stock ($.10 par value; 4,242,374,240 shares issued in each period)

424.0

Contributed capital

11101.0

Reinvested earnings

35635.0

Accumulated other comprehensive income

2659.0

Common stock in treasury, at cost

-7139.0

Deferred compensation — employee stock ownership plans and other

416.0

Noncontrolling interests

1591.0

Total equity

44687.0

Total liabilities and equity

257143.0

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)

Consolidated Statements of Income

Year Ended December 31, 2017

Audit Status

Unqualified

All amounts in millions, except per share amount.

$ million

Operating Revenues

Service revenues and other

107145.0

Wireless equipment revenues

18889.0

Total Operating Revenues

126034.0

Operating Expenses

Cost of services (exclusive of items shown below)

29409.0

Wireless cost of equipment

22147.0

Selling, general and administrative expense

30110.0

Depreciation and amortization expense

16954.0

Total Operating Expenses

98620.0

Operating Income

27414.0

Equity in (losses) earnings of unconsolidated businesses

-77.0

Other income and (expense), net

-2010.0

Interest expense

-4733.0

Income Before Provision For Income Taxes

20594.0

Provision for income taxes

9956.0

Net Income

30550.0

Net income attributable to noncontrolling interests

449.0

Net income attributable to Verizon

30101.0

Net Income

30550.0

Basic Earnings Per Common Share

Net income attributable to Verizon

7.37

Weighted- average shares outstanding (in millions)

4084.0

Diluted Earnings Per Common Share

Net income attributable to Verizon

7.36

Weighted- average shares outstanding (in millions)

4089.0

Net Income

30550.0

Other Comprehensive Income, net of taxes

Foreign currency translation adjustments

245.0

Unrealized gain (loss) on cash flow hedges

-31.0

Unrealized gain (loss) on marketable securities

-14.0

Defined benefit pension and postretirement plans

-214.0

Other comprehensive income attributable to Verizon

-14.0

Other comprehensive income (loss) attributable to noncontrolling interests

0.0

Total Comprehensive Income

30536.0

Comprehensive income attributable to noncontrolling interests

449.0

Comprehensive income attributable to Verizon

30087.0

Total Comprehensive Income

30536.0

Verizon Communications Inc (NYS: VZ)

Consolidated Statements of Cash Flows

Year Ended December 31, 2017

Audit Status

Unqualified

$ million

Cash Flows from Operating Activities

Net Income

30550.0

Adjustments to reconcile net income to net cash provided by operating activities:

Depreciation and amortization expense

16954.0

Employee retirement benefits

440.0

Deferred income taxes

-14463.0

Provision for uncollectible accounts

1167.0

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

117.0

Changes in current assets and liabilities, net of effects from acquisition/disposition of businesses

Accounts receivable

-5436.0

Inventories

168.0

Other assets

656.0

Accounts payable and accrued liabilities

-335.0

Discretionary contribution to qualified pension plans

-3411.0

Net gain on sale of divested businesses

-1774.0

Other, net

672.0

Net cash provided by operating activities

25305.0

Cash Flows from Investing Activities

Capital expenditures (including capitalized software)

-17247.0

Acquisitions of investments and businesses, net of cash acquired

-5928.0

Acquisitions of wireless licenses

-583.0

Proceeds from dispositions of wireless licenses

0.0

Proceeds from dispositions of businesses

3614.0

Other, net

772.0

Net cash used in investing activities

-19372.0

Cash Flows from Financing Activities

Proceeds from long-term borrowings

27707.0

Proceeds from asset-backed long-term borrowings

4290.0

Repayments of long-term borrowings and capital lease obligations

-23837.0

Repayments of asset-backed long-term borrowings

-400.0

Decrease in short-term obligations, excluding current maturities

-170.0

Dividends paid

-9472.0

Proceeds from sale of common stock

0.0

Purchase of common stock for treasury

0.0

Special distribution to noncontrolling interest

0.0

Acquisition of noncontrolling interest

0.0

Other, net

-4852.0

Net cash provided by (used in) financing activities

-6734.0

Increase (decrease) in cash and cash equivalents

-801.0

Cash and cash equivalents, beginning of period

2880.0

Cash and cash equivalents, end of period

2079.0

For the year 2017

1.0

Current Ratio

Current Assets

29913.0

Current Liabilities

33037.0

Current ratio

0.9054393558737174

2.0

Debt/Equity Ratio

Short term Debt

21232.0

Long term Debt

113642.0

Other Fixed Payments

3453.0

Shareholder's Equity

44687.0

Debt/Equity Ratio

3.0954640051916664

3.0

Free cash flow

Operating cash flow

25305.0

Capital Expenditure

17247.0

Free cash flow

8058.0

4.0

Earning per share

Net income

30550.0

Prerference dividend

0.0

Weight av. Shares outstanding

4089.0

Earning per share

7.471264367816092

5.0

Price/earning ratio

Share price

52.93

Earnings per share

7.471264367816092

P/E ratio

7.084476923076923

6.0

Return on equity

Net income

30550.0

Shareholders Equity

44687.0

Return on equity

0.6836440128001432

7.0

Net profit margin

Net income

30550.0

Total revenues

126034.0

Net profit margin

0.24239490931018615

Verizon Communications Inc (NYS: VZ)

Consolidated Balance Sheets

Year Ended December 31, 2016

Audit Status

Unqualified

All amounts in millions, except per share amount.

$ m

Assets

Current assets

Cash and cash equivalents

2880.0

Short-term investments

0.0

Accounts receivable, net of allowances of $882 and $739

17513.0

Inventories

1202.0

Assets held for sale

882.0

Prepaid expenses and other

3918.0

Total current assets

26395.0

Non-Current assets

Plant, property and equipment

232215.0

Less accumulated depreciation

-147464.0

Net Plant, property and equipment

84751.0

Investments in unconsolidated businesses

1110.0

Wireless licenses

86673.0

Goodwill

27205.0

Other intangible assets, net

8897.0

Non- current assets held for sale

613.0

Deposit for wireless licenses

0.0

Other assets

8536.0

Total assets

244180.0

Liabilities and Equity

Current liabilities

Debt maturing within one year

2645.0

Accounts payable and accrued liabilities

19593.0

Liabilities related to assets held for sale

24.0

Other

8078.0

Total current liabilities

30340.0

Non-Current liabilities

Long-term debt

105433.0

Employee benefit obligations

26166.0

Deferred income taxes

45964.0

Non- current liabilities related to assets held for sale

6.0

Other liabilities

12239.0

Equity

Series preferred stock ($.10 par value; none issued)

0.0

Common stock ($.10 par value; 4,242,374,240 shares issued in each period)

424.0

Contributed capital

11182.0

Reinvested earnings

15059.0

Accumulated other comprehensive income

2673.0

Common stock in treasury, at cost

-7263.0

Deferred compensation — employee stock ownership plans and other

449.0

Noncontrolling interests

1508.0

Total equity

24032.0

Total liabilities and equity

244180.0

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)

Consolidated Statements of Income

Year Ended December 31, 2016

Audit Status

Unqualified

All amounts in millions, except per share amount.

$ million

Operating Revenues

Service revenues and other

108468.0

Wireless equipment revenues

17512.0

Total Operating Revenues

125980.0

Operating Expenses

Cost of services (exclusive of items shown below)

29186.0

Wireless cost of equipment

22238.0

Selling, general and administrative expense

31569.0

Depreciation and amortization expense

15928.0

Total Operating Expenses

98921.0

Operating Income

27059.0

Equity in (losses) earnings of unconsolidated businesses

-98.0

Other income and (expense), net

-1599.0

Interest expense

-4376.0

Income Before Provision For Income Taxes

20986.0

Provision for income taxes

-7378.0

Net Income

13608.0

Net income attributable to noncontrolling interests

481.0

Net income attributable to Verizon

13127.0

Net Income

13608.0

Basic Earnings Per Common Share

Net income attributable to Verizon

3.22

Weighted- average shares outstanding (in millions)

4080.0

Diluted Earnings Per Common Share

Net income attributable to Verizon

3.21

Weighted- average shares outstanding (in millions)

4086.0

Net Income

13608.0

Other Comprehensive Income, net of taxes

Foreign currency translation adjustments

-159.0

Unrealized gain (loss) on cash flow hedges

198.0

Unrealized gain (loss) on marketable securities

-55.0

Defined benefit pension and postretirement plans

2139.0

Other comprehensive income attributable to Verizon

2123.0

Other comprehensive income (loss) attributable to noncontrolling interests

0.0

Total Comprehensive Income

15731.0

Comprehensive income attributable to noncontrolling interests

481.0

Comprehensive income attributable to Verizon

15250.0

Total Comprehensive Income

15731.0

Verizon Communications Inc (NYS: VZ)

Consolidated Statements of Cash Flows

Year Ended December 31, 2016

Audit Status

Unqualified

$ million

Cash Flows from Operating Activities

Net Income

13608.0

Adjustments to reconcile net income to net cash provided by operating activities:

Depreciation and amortization expense

15928.0

Employee retirement benefits

2705.0

Deferred income taxes

-1063.0

Provision for uncollectible accounts

1420.0

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

138.0

Changes in current assets and liabilities, net of effects from acquisition/disposition of businesses

Accounts receivable

-5067.0

Inventories

61.0

Other assets

449.0

Accounts payable and accrued liabilities

-1079.0

Discretionary contribution to qualified pension plans

0.0

Net gain on sale of divested businesses

0.0

Other, net

-4385.0

Net cash provided by operating activities

22715.0

Cash Flows from Investing Activities

Capital expenditures (including capitalized software)

-17059.0

Acquisitions of investments and businesses, net of cash acquired

-3765.0

Acquisitions of wireless licenses

-534.0

Proceeds from dispositions of wireless licenses

0.0

Proceeds from dispositions of businesses

9882.0

Other, net

493.0

Net cash used in investing activities

-10983.0

Cash Flows from Financing Activities

Proceeds from long-term borrowings

12964.0

Proceeds from asset-backed long-term borrowings

4986.0

Repayments of long-term borrowings and capital lease obligations

-19159.0

Repayments of asset-backed long-term borrowings

0.0

Decrease in short-term obligations, excluding current maturities

-149.0

Dividends paid

-9262.0

Proceeds from sale of common stock

3.0

Purchase of common stock for treasury

0.0

Special distribution to noncontrolling interest

0.0

Acquisition of noncontrolling interest

0.0

Other, net

-2705.0

Net cash provided by (used in) financing activities

-13322.0

Increase (decrease) in cash and cash equivalents

-1590.0

Cash and cash equivalents, beginning of period

4470.0

Cash and cash equivalents, end of period

2880.0

For the year 2016

1.0

Current Ratio

Current Assets

26395.0

Current Liabilities

30340.0

Current ratio

0.8699736321687541

2.0

Debt/Equity Ratio

Short term Debt

19593.0

Long term Debt

105433.0

Other Fixed Payments

2645.0

Shareholder's Equity

24032.0

Debt/Equity Ratio

5.312541611185087

3.0

Free cash flow

Operating cash flow

22715.0

Capital Expenditure

17059.0

Free cash flow

5656.0

4.0

Earning per share

Net income

13608.0

Prerference dividend

0.0

Weight av. Shares outstanding

4080.0

Earning per share

3.335294117647059

5.0

Price/earning ratio

Share price

53.38

Earnings per share

3.335294117647059

P/E ratio

16.00458553791887

6.0

Return on equity

Net income

13608.0

Shareholders Equity

24032.0

Return on equity

0.5662450066577897

7.0

Net profit margin

Net income

13608.0

Total revenues

125980.0

Net profit margin

0.10801714557866328

Verizon Communications Inc (NYS: VZ)

Consolidated Balance Sheets

Year Ended December 31, 2015

Audit Status

Unqualified

All amounts in millions, except per share amount.

$ m

Assets

Current assets

Cash and cash equivalents

4470.0

Short-term investments

350.0

Accounts receivable, net of allowances of $882 and $739

13457.0

Inventories

1252.0

Assets held for sale

792.0

Prepaid expenses and other

1959.0

Total current assets

22280.0

Non-Current assets

Plant, property and equipment

220163.0

Less accumulated depreciation

-136622.0

Net Plant, property and equipment

83541.0

Investments in unconsolidated businesses

796.0

Wireless licenses

86575.0

Goodwill

25331.0

Other intangible assets, net

8338.0

Non- current assets held for sale

10267.0

Deposit for wireless licenses

0.0

Other assets

7512.0

Total assets

244640.0

Liabilities and Equity

Current liabilities

Debt maturing within one year

6489.0

Accounts payable and accrued liabilities

19362.0

Liabilities related to assets held for sale

463.0

Other

8738.0

Total current liabilities

35052.0

Non-Current liabilities

Long-term debt

103705.0

Employee benefit obligations

29957.0

Deferred income taxes

45484.0

Non- current liabilities related to assets held for sale

959.0

Other liabilities

11641.0

Equity

Series preferred stock ($.10 par value; none issued)

0.0

Common stock ($.10 par value; 4,242,374,240 shares issued in each period)

424.0

Contributed capital

11196.0

Reinvested earnings

11246.0

Accumulated other comprehensive income

550.0

Common stock in treasury, at cost

-7416.0

Deferred compensation — employee stock ownership plans and other

428.0

Noncontrolling interests

1414.0

Total equity

17842.0

Total liabilities and equity

244640.0

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)

Consolidated Statements of Income

Year Ended December 31, 2015

Audit Status

Unqualified

All amounts in millions, except per share amount.

$ million

Operating Revenues

Service revenues and other

114696.0

Wireless equipment revenues

16924.0

Total Operating Revenues

131620.0

Operating Expenses

Cost of services (exclusive of items shown below)

29438.0

Wireless cost of equipment

23119.0

Selling, general and administrative expense

29986.0

Depreciation and amortization expense

16017.0

Total Operating Expenses

98560.0

Operating Income

33060.0

Equity in (losses) earnings of unconsolidated businesses

-86.0

Other income and (expense), net

186.0

Interest expense

-4920.0

Income Before Provision For Income Taxes

28240.0

Provision for income taxes

-9865.0

Net Income

18375.0

Net income attributable to noncontrolling interests

496.0

Net income attributable to Verizon

17879.0

Net Income

18375.0

Basic Earnings Per Common Share

Net income attributable to Verizon

4.38

Weighted- average shares outstanding (in millions)

4085.0

Diluted Earnings Per Common Share

Net income attributable to Verizon

4.37

Weighted- average shares outstanding (in millions)

4093.0

Net Income

18375.0

Other Comprehensive Income, net of taxes

Foreign currency translation adjustments

-208.0

Unrealized gain (loss) on cash flow hedges

-194.0

Unrealized gain (loss) on marketable securities

-11.0

Defined benefit pension and postretirement plans

-148.0

Other comprehensive income attributable to Verizon

-561.0

Other comprehensive income (loss) attributable to noncontrolling interests

0.0

Total Comprehensive Income

17814.0

Comprehensive income attributable to noncontrolling interests

496.0

Comprehensive income attributable to Verizon

17318.0

Total Comprehensive Income

17814.0

Verizon Communications Inc (NYS: VZ)

Consolidated Statements of Cash Flows

Year Ended December 31, 2015

Audit Status

Unqualified

$ million

Cash Flows from Operating Activities

Net Income

18375.0

Adjustments to reconcile net income to net cash provided by operating activities:

Depreciation and amortization expense

16017.0

Employee retirement benefits

-1747.0

Deferred income taxes

3516.0

Provision for uncollectible accounts

1610.0

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

127.0

Changes in current assets and liabilities, net of effects from acquisition/disposition of businesses

Accounts receivable

-945.0

Inventories

-99.0

Other assets

942.0

Accounts payable and accrued liabilities

2545.0

Discretionary contribution to qualified pension plans

0.0

Net gain on sale of divested businesses

0.0

Other, net

-1411.0

Net cash provided by operating activities

38930.0

Cash Flows from Investing Activities

Capital expenditures (including capitalized software)

-17775.0

Acquisitions of investments and businesses, net of cash acquired

-3545.0

Acquisitions of wireless licenses

-9942.0

Proceeds from dispositions of wireless licenses

0.0

Proceeds from dispositions of businesses

48.0

Other, net

1171.0

Net cash used in investing activities

-30043.0

Cash Flows from Financing Activities

Proceeds from long-term borrowings

6667.0

Proceeds from asset-backed long-term borrowings

0.0

Repayments of long-term borrowings and capital lease obligations

-9340.0

Repayments of asset-backed long-term borrowings

0.0

Decrease in short-term obligations, excluding current maturities

-344.0

Dividends paid

-8538.0

Proceeds from sale of common stock

40.0

Purchase of common stock for treasury

-5134.0

Special distribution to noncontrolling interest

0.0

Acquisition of noncontrolling interest

0.0

Other, net

1634.0

Net cash provided by (used in) financing activities

-15015.0

Increase (decrease) in cash and cash equivalents

-6128.0

Cash and cash equivalents, beginning of period

10598.0

Cash and cash equivalents, end of period

4470.0

For the year 2015

1.0

Current Ratio

Current Assets

22280.0

Current Liabilities

35052.0

Current ratio

0.635627068355586

2.0

Debt/Equity Ratio

Short term Debt

19362.0

Long term Debt

103705.0

Other Fixed Payments

6489.0

Shareholder's Equity

17842.0

Debt/Equity Ratio

7.261293576953256

3.0

Free cash flow

Operating cash flow

38930.0

Capital Expenditure

17775.0

Free cash flow

21155.0

4.0

Earning per share

Net income

18375.0

Prerference dividend

0.0

Weight av. Shares outstanding

4085.0

Earning per share

4.498164014687882

5.0

Price/earning ratio

Share price

46.22

Earnings per share

4.498164014687882

P/E ratio

10.275303401360546

6.0

Return on equity

Net income

18375.0

Shareholders Equity

17842.0

Return on equity

1.029873332586033

7.0

Net profit margin

Net income

18375.0

Total revenues

131620.0

Net profit margin

0.13960644278984957

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

Close

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

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)

Last 7 Bussines Day Stock Prices

Date

Close

Rate Of Return

1.86

"The stock had a 1.86 percent return over the period September 12th through September 20th."

Referance

Mergent Online. (2018) Verizon retrieved September 21, 2018 From: http://www.mergentonline.com.ezproxy.snhu.edu/equitypricing.php?pagetype=report&compnumber=36979