Answered step by step
Verified Expert Solution
Question
1 Approved Answer
**Please show ALL work and ALL calculations** Caluclate market value ratios. Provide A three-year ratio analysis is the minimum expectation. WHat is the overall trend
**Please show ALL work and ALL calculations**
Caluclate market value ratios.
Provide A three-year ratio analysis is the minimum expectation.
WHat is the overall trend assessment of the company?
Calculate the WACC
Cash FLow STatement
(In Thousands) (USD) | |||||
---|---|---|---|---|---|
2015 | 2014 | 2013 | 2012 | 2011 | |
Cash from Operations | 1,430,000 | 1,224,000 | 1,140,000 | 989,000 | 1,089,000 |
Cash from Investing | 367,000 | (313,000) | (519,000) | (585,000) | (247,000) |
Cash from Financing | (1,805,000) | (933,000) | (583,000) | (418,000) | (1,245,000) |
Capital Expenditures | 305,000 | 411,000 | 404,000 | 437,000 | 183,000 |
Cash Flow per Share | 5.24 | 4.12 | 3.74 | 2.97 | 3.01 |
Cash & Cash Equivalents, Beginning of Year | 104,000 | 126,000 | 88,000 | 102,000 | 505,000 |
Cash & Cash Equivalents, End of Year | 96,000 | 104,000 | 126,000 | 88,000 | 102,000 |
(In Thousands) (USD) | |||||
---|---|---|---|---|---|
Income Statement | 2015 | 2014 | 2013 | 2012 | 2011 |
Total Revenue | 14,486,000 | 13,796,000 | 12,784,000 | 11,814,000 | 12,317,000 |
EBITDA | 1,509,000 | 1,302,000 | 1,106,000 | 1,075,000 | 646,000 |
Operating Income | 1,350,000 | 1,159,000 | 988,000 | 940,000 | 526,000 |
Net Income | 859,000 | 753,000 | 626,000 | 571,000 | 198,000 |
Revenue per Share | 54.19 | 47.59 | 41.57 | 36.72 | 35.28 |
EPS from Continuing Operations | 3.15 | 2.54 | 2.00 | 1.72 | 0.55 |
EPS - Net Income - Diluted | 3.15 | 2.54 | 2.00 | 1.72 | 0.55 |
Share Outstanding | 256,300 | 279,900 | 298,000 | 310,900 | 333,000 |
Weighted Average Shares Outstanding - Basic | 267,300 | 289,900 | 305,000 | 322,600 | 350,100 |
Weighted Average Shares Outstanding - Diluted | 272,800 | 296,800 | 305,000 | 332,900 | 362,300 |
Earnings per Share - Basic | 3.22 | 2.60 | 2.05 | 1.77 | 0.56 |
Balance Sheet
2015 | 2014 | 2013 | 2012 | 2011 | |
---|---|---|---|---|---|
Total Assets | 6,082,000 | 6,865,000 | 6,794,000 | 6,342,000 | 5,910,000 |
Current Assets | 1,384,000 | 1,921,000 | 1,903,000 | 1,475,000 | 1,324,000 |
Total Liabilities | 9,672,000 | 9,065,000 | 8,209,000 | 7,627,000 | 6,691,000 |
Long Term Debt | 3,807,000 | 3,457,000 | 3,147,000 | 2,528,000 | 1,816,000 |
Stockholders' Equity | (3,590,000) | (2,200,000) | (1,415,000) | (1,285,000) | (781,000) |
Total Assets per Share | 23.73 | 24.53 | 22.80 | 20.40 | 17.75 |
Current Liabilities | 3,233,000 | 3,060,000 | 2,675,000 | 2,773,000 | 2,558,000 |
Net Assets per Share | (14.01) | (7.86) | (4.75) | (4.13) | (2.35) |
Dividend info
Declared | Ex-Date | Record | Payable | Amount | Type |
---|---|---|---|---|---|
Feb 10, 2017 | Feb 22, 2017 | Feb 24, 2017 | Mar 31, 2017 | 0.3000 | U.S. Currency |
Total dividends in 2017: | 0.3000 | ||||
Nov 10, 2016 | Nov 21, 2016 | Nov 24, 2016 | Dec 30, 2016 | 0.3000 | U.S. Currency |
Sep 13, 2016 | Sep 21, 2016 | Sep 23, 2016 | Sep 30, 2016 | 0.3000 | U.S. Currency |
May 6, 2016 | May 18, 2016 | May 20, 2016 | Jun 30, 2016 | 0.3000 | U.S. Currency |
Feb 11, 2016 | Feb 23, 2016 | Feb 25, 2016 | Mar 31, 2016 | 0.2500 | U.S. Currency |
Total dividends in 2016: | 1.1500 | ||||
Nov 5, 2015 | Nov 17, 2015 | Nov 19, 2015 | Dec 28, 2015 | 0.2500 | U.S. Currency |
Aug 6, 2015 | Aug 18, 2015 | Aug 20, 2015 | Sep 25, 2015 | 0.2500 | U.S. Currency |
May 8, 2015 | May 20, 2015 | May 22, 2015 | Jun 26, 2015 | 0.2500 | U.S. Currency |
Feb 12, 2015 | Feb 25, 2015 | Feb 27, 2015 | Mar 27, 2015 | 0.2000 | U.S. Currency |
Total dividends in 2015: | 0.9500 | ||||
Nov 6, 2014 | Nov 18, 2014 | Nov 20, 2014 | Dec 26, 2014 | 0.2000 | U.S. Currency |
Aug 7, 2014 | Aug 19, 2014 | Aug 21, 2014 | Sep 26, 2014 | 0.2000 | U.S. Currency |
May 9, 2014 | May 21, 2014 | May 23, 2014 | Jun 27, 2014 | 0.2000 | U.S. Currency |
Feb 14, 2014 | Feb 26, 2014 | Feb 28, 2014 | Mar 28, 2014 | 0.1700 | U.S. Currency |
Total dividends in 2014: | 0.7700 | ||||
Nov 7, 2013 | Nov 19, 2013 | Nov 21, 2013 | Dec 27, 2013 | 0.1700 | U.S. Currency |
Aug 8, 2013 | Aug 20, 2013 | Aug 22, 2013 | Sep 27, 2013 | 0.1700 | U.S. Currency |
May 10, 2013 | May 22, 2013 | May 24, 2013 | Jun 28, 2013 | 0.1700 | U.S. Currency |
Feb 15, 2013 | Feb 27, 2013 | Mar 1, 2013 | Mar 29, 2013 | 0.1300 | U.S. Currency |
Total dividends in 2013: | 0.6400 | ||||
Nov 8, 2012 | Nov 20, 2012 | Nov 23, 2012 | Dec 28, 2012 | 0.1300 | U.S. Currency |
Aug 9, 2012 | Aug 21, 2012 | Aug 23, 2012 | Sep 14, 2012 | 0.1300 | U.S. Currency |
May 4, 2012 | May 16, 2012 | May 18, 2012 | Jun 22, 2012 | 0.1300 | U.S. Currency |
Feb 10, 2012 | Feb 22, 2012 | Feb 24, 2012 | Mar 30, 2012 | 0.1000 | U.S. Currency |
Total dividends in 2012: | 0.4900 | ||||
Nov 10, 2011 | Nov 25, 2011 | Nov 29, 2011 | Jan 6, 2012 | 0.1000 | U.S. Currency |
Aug 4, 2011 | Aug 16, 2011 | Aug 18, 2011 | Sep 16, 2011 | 0.0955 | U.S. Currency |
May 6, 2011 | May 18, 2011 | May 20, 2011 | Jun 24, 2011 | 0.0955 | U.S. Currency |
Feb 11, 2011 | Feb 23, 2011 | Feb 25, 2011 | Apr 1, 2011 | 0.0836 | U.S. Currency |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started