Explain overall trend assessment of the company's balance sheet, income statement, and statement of cash flows for the last three years.
Selected ratio and trend analysis.Ratios must include liquidity, asset management, solvency, profitability, and market value ratios.A three-year ratio analysis is the minimum expectation.
Analysis of the company's stock price and EPS trends for the last three years.Analysis must include comparison to key market competitors.
Please SHOW ALL calcuations that would be done in excell and explain any determinations and how they were made. thank you!
|
Cash Flow statement
|
IN thousands
|
|
|
|
|
2015
|
2014
|
2013
|
2012
|
|
Cash from operations
|
1,430,000
|
1,224,000
|
1,140,000
|
989,000
|
|
Cash from investing
|
367,000
|
(313,000)
|
(519,000)
|
(585,000)
|
|
Cash from financing
|
(1,805,000)
|
(933,000)
|
(583,000)
|
(418,000)
|
|
Capital expenditures
|
305,000
|
411,000
|
404,000
|
437,000
|
|
Cash flow per share
|
5.24
|
4.12
|
3.74
|
2.97
|
|
Cash and cash equivalents, beginning of year
|
104,000
|
126,000
|
88,000
|
102,000
|
|
Cash and cash equivalents end of year
|
96,000
|
104,000
|
126,000
|
88,000
|
|
Balance Sheet
|
In thousands
|
|
|
|
|
|
2015
|
2014
|
2013
|
2012
|
|
|
Total Assets
|
6,082,000
|
6,865,000
|
6,794,000
|
6,342,000
|
|
|
Current Assets
|
1,384,000
|
1,921,000
|
1,903,000
|
1,475,000
|
|
|
Total Liabilities
|
9,672,000
|
9,065,000
|
8,209,000
|
7,627,000
|
|
|
Long term debt
|
3,807,000
|
3,457,000
|
3,147,000
|
2,528,000
|
|
|
Stockholders Equity
|
(3,590,000)
|
(2,200,000)
|
(1,415,000)
|
(1,285,000)
|
|
|
Total assets per share
|
23.73
|
24.53
|
22.8
|
20.40
|
|
|
Current liabilities
|
3,233,000
|
3,060,000
|
2,675,000
|
2,773,000
|
|
|
Net assets per share
|
(1401)
|
(7.86)
|
(4.75)
|
(4.13)
|
|
|
|
|
|
|
|
|
Income Statement
|
2015
|
2014
|
2013
|
2012
|
|
|
Total Revenue
|
14,486,000
|
13,796,000
|
12,784,000
|
11,814,000
|
In thousands $
|
|
EBITDA
|
1,509,000
|
1,302,000
|
1,106,000
|
1,075,000
|
|
|
Operating Income
|
1,350,000
|
1,159,000
|
988,000
|
940,000
|
|
|
Net Income
|
859,000
|
753,000
|
626,000
|
571,000
|
|
|
Rev per share
|
54.19
|
47.59
|
41.57
|
36.72
|
|
|
EPS-Net income-Diluted
|
3.15
|
2.54
|
2
|
1.72
|
|
|
Share outstanding
|
3.15
|
2.54
|
2
|
1.72
|
|
|
Weighted average shares-basic
|
256,300
|
279,900
|
298,000
|
310,900
|
|
|
Weighted average shares-diluted
|
267,300
|
289,900
|
305,000
|
322,900
|
|
|
Earnings per share-basic
|
3.22
|
2.6
|
2.05
|
1.77
|