What are the following ratios for Verizon communications for the last 5 years fr

ID: 2790738 • Letter: W

Question

What are the following ratios for Verizon communications for the last 5 years from 2012 to 2016,show working in xl and refer to this link for the source information

https://www.stock-analysis-on.net/NYSE/Company/Verizon-Communications-Inc#Long-Term-Trends

Current ratio

Debt ratio

Times Interest earned

Gross profit margin

Net profit margin

Return on Equity

Price Earnings Ratio

Earnings per share(EPS)

Free Cash flow

Stock price at 12/31 of each year

Dividends per year per share

Rate of return on investment each year

income taxes for each year

preferred stockholders dividends

(net) receivables

Why your company is in good shape financially?explain

If company is not in good shape financially, explain why

What are the key 5 factors company needs to improve on:

(86)

Operating revenue 2016 2015 2014 2013 2012 2011 Service revenue and other $108,468 $114,696 116,112 NOT GIVEN N.G N.G wireless equipment revenue 17,512 16,924 10,957 N.G N.G N.G Total operating revenue 125,980 131,620 127079 120,550 115,846 110,875 Operating expenses cost of services and sales(exclusive of items shown below 29,186 29,438 28,306 44,887 46,275 45,875 wireless cost of equipment 22,238 23,119 21,625 N.G N.G N.G selling and G&A expenses, net 31,569 29,986 41,016 27,089 39,951 35,624 Depreciation & amortization expense 15,928 16,017 16,533 16,606 16,460 16,496 Total Operating Expenses 98,921 98,560 107,480 88,582 102,686 97,995 Operating Income 27,059 33,060 19,599 31,968 13,160 12,880 Equity in (losses) earnings of unconsolidated business (98)

(86)

1780 142 324 444 other income and (expense),net (1599) 186 (1194) (166) (1016) (14) Interest Expense (4,376) (4,920) (4,915) (2,667) (2,571) (2,827) Income before provision for income taxes 20,986 28,240 15,270 29,277 9,897 10,483 provision(benefit) for income taxes (7,378) (9,865) (3,314) (5,730) 660 (285) Net Income 13,608 18,375 11,956 23,547 10,557 10,198 Net Income attributable to noncontrolling interest $481 $496 $2,331 $12,050 $9,682 $7,794 Net income attributable to Verizon 13,127 17,879 9,625 11,497 875 2,404 Net Income $13,608 $18,375 $11,956 $23,547 $10,557 $10,198 Basic Earnings Per Common Share Net income attributable to Verizon $3.22 $4.38 $2.42 $4.01 $.31 $.85 Weighted-
average
shares outstanding (in millions) 4,080 4,085 3,974 2,866 2,853 2,833 Diluted Earnings Per Common Share Net income attributable to Verizon $3.21 $4.37 $2.42 $4.00 $.31 $.85 Weighted-average shares outstanding (in millions) 4,086 4,093 3,981 2,874 2,862 2,839 Net Income $13,608 $18,375 $11,956 $23,547 $10,557 $10,198 Other Comprehensive Income, net of taxes Foreign currency translation adjustments (159) (208) (1,199) 60 69 (119) Unrealized gains (losses) on cash flow hedges 198 (194) (197) 25 (68) 30 Unrealized losses on marketable securities (55) (11) (5) 16 29 (7) Defined benefit pension and postretirement plans 2,139 (148) 154 22 936 316 Other comprehensive income (loss) attributable to Verizon 2,123 (561) (1,247) 123 966 220 Other comprehensive loss attributable to noncontrolling interests -- -- (23) (15) 10 1 Total Comprehensive Income $15,731 $17,814 $10,686 $23,665 $11,533 $10,419 Comprehensive income attributable to noncontrolling interests 481 496 2,308 12,035 9,692 7,795 Comprehensive income attributable to Verizon 15,250 17,318 8,378 11,620 1,841 2,624 Total Comprehensive Income $15,731 $17,814 $10,686 $23,655 $11,533 $10,419 CONSOLIDATED BALANCE SHEET ASSETS Current assets    Cash and cash equivalents $2,880 $4,470 $10,598 $53,528 $3,093 N.G    Short-term investments -- 350 555 601 470    Accounts receivable, net of allowances of $845 and $882 17,513 13,457 13,993 12,439 12,576    Inventories 1,202 1,252 1,153 1,1020 1,075    Assets held for sale 882 792 N.G N.G N.G    Prepaid expenses and other 3,918 2,034 3,324 3,406 4,021 Total current assets 26,395 22,355 29,623 70,994 21,235 Plant, property and equipment 232,215 220,163 230,508 220,865 209,575    Less accumulated depreciation 147,464 136,622 140,561 131,909 120,933 Plant, property and equipment, net 84,751 83,541 89,947 88,956 88,642 Investments in unconsolidated businesses 1,110 796 802 3,432 3,401 Wireless licenses 86,673 86,575 75,341 75,747 77,744 Goodwill 27,205 25,331 24,639 24,634 24,139 Other intangible assets, net 8,897 7,592 5,728 5,800 5,933 Non-current
assets held for sale 613 10,267 N.G N.G N.G Other assets 8,536 7,718 6,628 4,535 4,128 Total assets $ 244,180 $ 244,175 $ 232,708 $ 274,098 $
225,222 Liabilities and Equity Current liabilities    Debt maturing within one year $ 2,645 $ 6,489 $ 2,735 $ 3,933 $
4,369    Accounts payable and accrued liabilities 19,593 19,362 16,680 16,453 16,182    Liabilities related to assets held for sale 24 463    Other 8,078 8,738 8,649 6,664 6,405 Total current liabilities 30,340 35,052 28,064 27,050 26,956 Long-term debt 105,433 103,240 110,536 89,658 47,618 Employee benefit obligations 26,166 29,957 33,280 27,682 34,346 Deferred income taxes 45,964 45,484 41,578 28,639 24,677 Non-current
liabilities related to assets held for sale 6 959 n.g n.g n.g Other liabilities 12,239 11,641 5,574 5,653 6,092 Equity Series preferred stock -- -- -- -- -- Common stock 424 424 424 297 297 Contributed capital 11,182 11,196 11,155 37,939 37,990 Reinvested earnings 15,059 11,246 2,447 1,782 (3,734) Accumulated other comprehensive income 2,673 550 1,111 2,358 2,235 Common stock in treasury, at cost (7,263) (7,416) (3,263) (3,961) (4,071)    Deferred compensation — employee stock ownership plans and other 449 428 424 421 440 Noncontrolling interests 1,508 1,414 1,378 56,580 52,376 Total equity 24,032 17,842 13,676 95,416 85,533 Total liabilities and equity $ 244,180 $ 244,175 $ 232,708 $ 274,098 $
225,222 Cash Flows from Operating Activities Net Income $ 13,608 $ 18,375 $ 11,956 $ 23,547 $ 10,557 Adjustments to reconcile net income to net cash provided by operating activities: Depreciation and amortization expense 15,928 16,017 16,533 16,606 16,460 Employee retirement benefits 2,705 (1,747) 8,130 (5,052) 8,198    Deferred income taxes (1,063) 3,516 (92) 5,785 (952)    Provision for uncollectible accounts 1,420 1,610 1,095 993 972    Equity in losses (earnings) of unconsolidated businesses, net    of dividends received 138 127 (1,743) (102) 77    Changes in current assets and liabilities, net of effects from acquisition/disposition
of businesses    Accounts receivable (5,067) (945) (2,745) (843) (1,717)    Inventories 61 (99) (132) 56 (136)    Other assets 449 942 (695) (143) 306    Accounts payable and accrued liabilities (1,079) 2,545 1,412 925 1,144    Other, net (4,385) (1,411) (3,088) (2,954) (3,423) Net cash provided by operating activities 22,715 38,930 30,631 38,818 31,486 Cash Flows from Investing Activities Capital expenditures (including capitalized software) (17,059) (17,775) (17,191) (16,604) (16,175) Acquisitions of businesses, net of cash acquired (3,765) (3,545) (182) (494) (913) Acquisitions of wireless licenses (534) (9,942) (354) (580) (4,298) Proceeds from dispositions of wireless licenses -- -- 2,367 2,111 363 Proceeds from dispositions of businesses 9,882 48 120 -- -- Other, net 493 1,171 (616) 734 521 Net cash used in investing activities (10,983) (30,043) (15,856) (14,833) (20,502) Cash Flows from Financing Activities Proceeds from long-term borrowings 12,964 6,667 30,967 49,166 4,489 Proceeds from asset-backed
long-term borrowings 4,986 -- -- N.G N.G Repayments of long-term borrowings and capital lease obligations (19,159) (9,340) (17,669) (8,163) (6,403) Decrease in short-term obligations, excluding current maturities (149) (344) (475) (142) (1,437) Dividends paid (9,262) (8,538) (7,803) (5,936) (5,230) Proceeds from sale of common stock 3 40 34 85 315 Purchase of common stock for treasury -- (5,134) -- (153) -- Special distribution to noncontrolling interest N.G N.G -- (3,150) (8,325) Acquisition of noncontrolling interest -- -- (58,886) -- -- Other, net (2,705) 1,634 (3,873) (5,257) (4,662)    Net cash provided by (used in) financing activities (13,322) (15,015) (57,705) 26,450 (21,253) Decrease in cash and cash equivalents (1,590) (6,128) (42,930) 50,435 (10,269) Cash and cash equivalents, beginning of period 4,470 10,598 53,528 3,093 13,362 Cash and cash equivalents, end of period $ 2,880 $ 4,470 $ 10,598 $ 53,528 $ 3,093

Explanation / Answer

Please refer tothe excel below for answers:

2016

2015

2014

2013

2012

2011

Current Ratio = Current assets / current liabilities

0.870

0.638

1.056

2.625

0.788

Debt Ratio = Total liabilities / total assets

0.174

0.191

0.145

0.119

0.147

Times interest earned = EBIT / Interest expense

6.184

6.720

3.988

11.987

5.119

4.556

Gross Profit Margin = Gross Profit / Revenue

59.181%

60.069%

60.709%

Net Profit Margin = Net Income / Revenue

10.802%

13.961%

9.408%

19.533%

9.113%

9.198%

Return On Equity = Net Income / Shareholders equity

58.995%

77.906%

76.187%

59.111%

33.378%

Price Earnings Ratio = Price / EPS

Price Not Given

Earnings Per Share = Earnings / No of shares

$3.856

$4.361

$2.689

$8.254

$4.042

$3.678

Free Cash Flow = Operating Cash flow - capex

5,656

21,155

13,440

22,214

15,311

Stock Price

Price Not Given

Dividend per share = dividend / no of shares

No Dividends

Rate of Return on Investment = Net Income / Total Investment

51.555%

82.196%

40.361%

33.168%

49.715%

Income Taxes each year = Tax expense / PBT

35.157%

34.933%

21.703%

19.572%

-6.669%

2.719%

Preferred stock holders dividend

No Dividends

Net Receivables = Gross receivables - doubtful accounts

17,513

13,457

13,993

12,439

12,576

2016

2015

2014

2013

2012

2011

Current Ratio = Current assets / current liabilities

0.870

0.638

1.056

2.625

0.788

Debt Ratio = Total liabilities / total assets

0.174

0.191

0.145

0.119

0.147

Times interest earned = EBIT / Interest expense

6.184

6.720

3.988

11.987

5.119

4.556

Gross Profit Margin = Gross Profit / Revenue

59.181%

60.069%

60.709%

Net Profit Margin = Net Income / Revenue

10.802%

13.961%

9.408%

19.533%

9.113%

9.198%

Return On Equity = Net Income / Shareholders equity

58.995%

77.906%

76.187%

59.111%

33.378%

Price Earnings Ratio = Price / EPS

Price Not Given

Earnings Per Share = Earnings / No of shares

$3.856

$4.361

$2.689

$8.254

$4.042

$3.678

Free Cash Flow = Operating Cash flow - capex

5,656

21,155

13,440

22,214

15,311

Stock Price

Price Not Given

Dividend per share = dividend / no of shares

No Dividends

Rate of Return on Investment = Net Income / Total Investment

51.555%

82.196%

40.361%

33.168%

49.715%

Income Taxes each year = Tax expense / PBT

35.157%

34.933%

21.703%

19.572%

-6.669%

2.719%

Preferred stock holders dividend

No Dividends

Net Receivables = Gross receivables - doubtful accounts

17,513

13,457

13,993

12,439

12,576

Navigate

What are the following examples of Passive Transport? Can you check if this is r

What are the following? 1. 2. 3. 4. which letters in the diagram are affiliated

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

What are the following ratios for Verizon communications for the last 5 years fr

Question

Explanation / Answer

Related Questions

Navigate