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 If need be.also financial data provided below

1) Current ratio

2) Debt ratio

3) Times Interest earned

4) Gross profit margin

5) Net profit margin

6) Return on Equity

7) Price Earnings Ratio

8) Earnings per share(EPS)

9) Free Cash flow

10) Stock price at 12/31 of each year

11) Dividends per year per share

12) Rate of return on investment each year income taxes for each year

13) preferred stockholders dividends

14) (net) receivables

15) Is the comapny in good shape financially and why?explain

16) Is the company not in good shape financially and why?explain

17) What the key 5 factors that company has to improve on

Total assets

verizon

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