You Are Expected To Select A Company And Three Competitors From The Same Industry And Prepare An Analytical Report In Which You Will Critically Evaluate, Analyse, Discuss And Comment On The Key Issues In The Financial Appraisal.

profilepetersharp
Assignment_Sample_2.docx

Running Head: ASSIGNMENT

1

ASSIGNMENT

5

Introduction

This report is delivered in four parts. Part 1 focusses on Level 3 Communications’ current financial situation. Part 2 compares Level 3 Communication against three of its’ major competitors, namely AT&T Inc., General Communications Inc. and Alaska Communications Systems Inc. In light of the December 6, 2016 announcement that CenturyLink Inc. will acquire Level 3 Communications in 2017, Part 3 analyses CenturyLink financial offer to acquire Level 3 Communications Inc. Part 4 addresses the limitations to accounting analysis. The report uses the latest financial performance as well as historical data, to evaluate and critically analyse the performance of Level 3 Communications Inc.

Level 3 Communications Incorporated

Level 3 Communications is a facilities-based provider of communications services, including Internet Protocol (IP) services, data services, transport and fiber services, voice services, collaboration services, colocation and data center services, and wholesale voice services. Level 3 owns and manages its fiber optic network which connects North America, Europe and Latin America. The company was developed as a capital investment spinoff of the construction company Peter Kiewits Sons’ Inc based on its cable television division. Level 3 still identifies with its roots in that it retains a small coal mining sector as a cash generating component of the incorporation. Its first acquisition was Metropolitan Fibre Systems and expanded into the internet market in 1993. (Level 3 Communications/Our History, 2016)

On December 6, 2016, it was publicly announced that level 3 Communications Inc will be acquired by Century Link Inc. (Sherman & Moritz, 2016). Clay Bailey, Senior Vice President of CenturyLink Operational Transformation, has stated that the transition is scheduled to be completed by the third quarter of 2017 (Picker, 2016).

PART 1

This section of the report analyses Level 3’s financial performance based on financial data for the fiscal year ending September 30, 2015.

An analysis of the current business and financial situation of Level 3 Communications

Level 3 has had a history of negative returns (ROA, ROE, ROI) prior to 2014. In 2014, Level 3 realized its first year of positive results in these ratio categories sand continued that growth through 2015. This has been led by Level 3’s debt management where both Long Term and total Debt to Asset ratios have been increasingly positive since 2013.

Level 3’s Return on Capital Employed (ROCE) is relatively low at 10.09% as shown in Figure 1. This must be considered a positive since assets have been used to reduce financial risks and create a stable financial base for the company’s future operations. Level 3’s Asset Management ratios, with the exception of property, plant and equipment turnover (PPE), have been trending to the positive over the previous ten years. The lower PPE ratio is a result of the company divesting itself of some of its coal mining ventures and the associated equipment and resources.

Figure 1- Level 3 ROCE over time (Zacks, 2016)

Level 3’s working capital ($333M) and debt gearings (0.52%) indicated that an increasingly lower proportion of Level 3’s operations were financed by debt. This can be attributed to improvements in Price to Earnings (PE) ratio, Price to Earnings Growth (PEG) ratio and a significant reduction in Total Debt to Equity (TDE) ratio. Of note, the reduction in Working Capital from its 2014 level ($425M) to its 2015 level ($333M) can be explained by Level 3's acquisition of TW Telecom during FY2014 (Krause, 2016).

The result of these changes is that Level 3 has less financial risk and are in a better position to challenge for an increased share of the telecommunications market without creating unmanageable risk for the company.

Current financial situation for Level 3

Level 3 has been able to grow and solidify its position in the highly competitive telecommunications industry over the past decade. Its current strengths lie in its increased returns (ROA, ROE, ROI), improved quick and current ratios, decreased debt to assets ratio and increased cash flow per share rating. Level 3 entered FY2016 in a solid and reliable financial position and was structured and enabled to make significant gains in its industry sector.

PART 2

A researched evaluation of the industry sector and financial competitor analysis for three listed companies in the same sector (using American Telephone and Telegraph (AT&T), Alaska Communications Systems (ACS) and General Communications as a starting point for financial data)

Profitability Ratios

A closer look at the profitability ratios in Table 3, Level 3’s historical ratios, suggest that Level 3 is currently in a very strong financial position in comparison to its competitors: AT&T Inc., General Communications Inc. and Alaska Communications Systems Inc. Of particular importance is Level 3’s Net Profit Margin ratio and Operating Margin ratios. These specific ratios indicate that Level 3 is using its profit generating resources more effectively than ACS and GCI and is competitive with AT&T Inc. Of note, AT&T, an historic company, operates at a scale that is 17 orders of magnitude larger than Level 3 and operates in many more international markets than Level 3. The fact that Level 3 has reduced its TDE ratio coupled with positive trending in operating margins, while its compared competitors generally rose, is a significant indicator of the company’s stable operating position into the future.

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

Total Debt to Equity

ACS

1.24

3.21

3.43

-

-

-

16.13

44.23

5.85

-

AT&T

1.03

0.95

0.82

0.76

0.61

0.59

0.71

0.78

0.56

0.52

GCI

16.05

6.65

7.14

6.09

5.96

4.35

3.28

3.16

2.15

2.01

Level 3

1.09

1.78

5.93

7.46

7.08

-

13.16

7.51

6.41

19.68

Net Profit Margin

ACS

5.56

0.88

44.82

4.73

0.14

8.99

9.83

2.60

37.36

5.72

AT&T

9.09

4.70

14.17

5.70

3.11

15.98

10.19

10.37

10.05

11.67

GCI

2.66

0.83

1.16

1.36

0.86

1.38

0.59

0.32

2.60

3.88

Level 3

41.72

4.63

1.73

6.62

17.45

17.04

16.43

6.74

26.10

22.02

Operating Margin

ACS

0.67

1.93

8.93

16.48

18.05

14.65

10.79

4.08

15.73

14.89

AT&T

16.88

8.87

23.67

10.20

7.27

15.75

17.47

18.59

17.16

16.32

GCI

10.85

15.77

13.91

12.53

13.35

13.59

11.09

8.29

12.00

14.10

Level 3

16.17

14.95

10.55

9.02

1.20

2.47

1.73

0.72

5.65

4.14

Figure 1 - Profitability Ratios (Kimmel, Kieso, & Irvine, 2014)

Long-term solvency

As seen in Table 3, Level 3 continuously lowered it Total Debt to Equity ratio since 2013, thereby creating a stable economic future for the company, which sets its position well for profitable operations going forward. The fact that Level 3 also has a low gearing ratio (Table 1), contributes to an optimistic outlook for profitability in future years.

In terms of interest cover, a closer look at Table 1 shows that Level 3 is in very favourable positions to pay interest on outstanding debt with a debt cover of $26.25. This has been accomplished by increasing revenue and profits at a rate much higher than the corresponding rise in total debt.

Short-term solvency

As can be seen in Figure 2, Level 3’s quick ratios have previously fallen below the accepted benchmark of 1.0:1. This is a cause for concern because it indicated that Level 3 would have had problems meeting its short-term debt obligation. Interestingly, both AT&T and ACS have remained viable even with consistently low quick ratios over time.

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

CURRENT RATIO

ACS

1.27

1.92

1.09

0.99

0.89

1.02

1

1.17

1.53

1.17

AT&T

0.75

0.86

0.66

0.71

0.75

0.59

0.66

0.53

0.63

0.63

GCI

1.45

1.82

2.13

1.61

1.76

1.66

1.97

1.36

1.4

2.2

Level 3

1.24

0.78

1.01

1.02

1.03

1.02

0.83

1.18

1.28

2.57

QUICK RATIO

ACS

0.9

0.56

0.74

0.67

0.56

0.58

0.47

0.4

1

0.9

AT&T

0.45

0.62

0.46

0.55

0.55

0.44

0.51

0.42

0.46

0.46

GCI

1.25

1.26

1.7

1.27

1.38

1.35

1.65

1.18

1.15

1.59

Level 3

1.13

0.68

0.9

0.94

0.94

0.91

0.76

1.09

1.17

2.41

Figure 2 - Current and Quick Ratios (Kimmel, Kieso, & Irvine, 2014)

Altman Z Scores

Figure 3 shows the Altman Z Scores (Altman, 2000) both Z and Z2, for the compared companies since 2006. Z Scores are used primarily for manufacturing companies while Z2 Scores are used for public, noon-manufacturing companies. According to Altman, any Z Score below 2.99 and any Z2 Score below 2.6 should be looked at with caution. Clearly, AT&T, the biggest of the four companies compared, has rejected Altman and has conducted business in Altman’s identified caution range, with continued success. Likewise, General Communications Inc has remained in Altman’s caution range. Using Altman Z2 scoring, all companies have slipped into the caution range since 2014. This may be an indicator of the industries stability and may also be a result of the need to assume risk to remain competitive in this expanding market.

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

ALTMAN Z SCORE

ACS

18.49

17.09

17.05

4.22

6.55

2.52

4.74

1.87

10.76

3.44

AT&T

1.75

1.47

1.73

1.51

1.61

1.81

1.77

1.7

1.81

1.5

GCI

0.66

0.56

0.92

0.69

0.67

0.64

0.59

0.51

0.79

0.72

Level 3

10.24

7.28

5.35

4.03

3.16

19.72

27.57

13.38

46.19

25.43

ALTMAN Z2 Score

ACS

0.4

1.6

0.7

1.1

1

1.2

0.9

0.9

1.7

2.3

AT&T

1.7

1.4

1.8

1.5

1.7

1.9

1.9

1.5

1.8

1.5

GCI

1.22

0.97

1.53

0.78

0.78

0.55

0.75

0.43

0.84

0.19

Level 3

2.17

2.37

3.38

3.08

2.80

3.98

3.39

3.54

2.75

2.71

Figure 3 - Altman Z Scores

A critical appraisal and discussion of the financial strengths and weaknesses of Level compared to listed competitors

Level 3’s strengths lie in its solvency and profitability ratios. With solid returns on equity and investments (ROE, ROI), a low debt to asset ratio and a comparable Operating Margin, coupled with a significant Net Profit Margin, Level 3 has been able to consolidate its place in the telecommunications market and grow its market share against much larger direct competitors.

While Level 3 has made great progress in the past decade in carving out its place in the market, there is no doubt that, being a rapidly expanding and changing industry, Level 3 must remain committed to growth levels that manage risk and debt to be able to sustain that growth in times of economic weakening or reversal. Level 3 has consolidated its position by steady growth coupled with conservative risk and needs to remain with that model to be viable over a protracted period.

PART 3

A recommendation of a suitable price range for the shares of Level 3 to be used in the acquisition process

Background

CenturyLink has completed an agreement to acquire Level 3 Communications Inc for a price of $36M USD (Picker, 2016). Both companies are telecommunications providers and are direct competitors to AT&T and Verizon. The acquisition will make CenturyLink the second largest telecommunications provider, behind AT&T. The acquisition deal will involve a combination of cash and stocks in CenturyLink. The valuation is $26.50 and 1.4286 CenturyLink shares per Level 3 share. This equals $69.92 per Level 3 share. The total transaction value includes the approximate $10.9Billion of Level 3 debt to equal the announced $36M pricing to CenturyLink. This price equals a roughly 50% premium on existing Level 3 stocks. As a result, Level 3 stocks have risen 4% while CenturyLink stocks have fallen 12.5% since the deal was announced (Picker, 2016).

Level 3 Premium analysis

The market value of Level 3 shares over the past 52 weeks has ranged from $41.73 to $57.59 with a close on December 9, 2016 of $56.24. The transaction value of $69.92 as offered by CenturyLink equals a premium of between 21 % (high stock value) and 675 (low stock value) with a median of 41%.

Factoring in Level 3 PEG at 4.68 and the lack of dividends paid in 2015, the valuation of CenturyLink’s offer to Level 3 shareholders is positive and should be accepted.

 

CenturyLink

Level 3

Open

24.13

56.16

Day Low

24.06

56.54

Day High

24.25

41.73

52 Wk. Low

21.94

57.59

52 Wk. High

33.45

2,478,232

Avg. Volume

8,578,284

20.24 B

Market Cap

13.19 B

0

Dividend

2.16 (8.96%)

1.5

Forward PE

9.76

35.13

PEG Ratio

-5.35

4.68

Current Qtr. Est

0.56

0.45

Current Yr. Est

2.47

1.6

Prior Year EPS

2.71

1.8

Expected EPS Growth (3-5yr)

-1.83%

7.50%

Figure 5 - Current Market Comparison (Zacks, 2016)

PART 4

What factors should be looked for in accounts that may impact the valuation?

Determining an acceptable price during an acquisition must account for current share value, future income potential and a risk assessment of the long-term value of the stock. For example, prior to the acquisition Level 3 stock had enjoyed upward market value but was not paying a dividend. Likewise, Level 3’s PEG was positive and indicated potential for increasing share prices. CenturyLink’s share price, PEG and growth were not a positive as Level 3’s but the acquisition is expected to reverse these trends once CenturyLink completes the acquisition and become a n equal scaler competitor in the telecommunications market. Also, CenturyLink has continued to pay dividends so allows shareholders to profit without sale of stocks.

A critical evaluation of the finance techniques applied in the analysis.

All financial and managerial accounting is undertaken using generally accepted accounting techniques (GAAT). I employed these techniques as outlined in two Wiley Publishing Accounting text; Financial Accounting: Tools for Business Decision Making (Kimmel, Kieso, & Irvine, 2014) and Managerial Accounting: Tools for Business Decision Making (Weygant, Kimmel, Kieso, & Aly, 2015). I chose the data from published sources including Mergent Online, Stockopedia and Zacks Online as well as Level 3 Inc’s own website.

The key limiting factor in any accounting analysis is the credibility and reliability of the source data. The data is provided by the same companies that are being analysed and these same companies report the data as legislated by various government laws and regulations. It is recognized that the data may be provided to enhance the best interests of the company, be it to reduce taxation or to enhance the financial image of the company with its current and potential investors. Perhaps the principal limitation of ratio analysis. My use of accounting techniques, while striving to adhere to GAAT, is limited to producing the necessary data for this analysis of the subject industry and companies. As such, any variances in source data accuracy and correctness will be included into and possibly amplified by my analysis.

I must conclude by advising that this analysis is an indication based on past actions and performance. While I attempt to look at potential future accountability, this analysis is in no way a statement on future financial capabilities of the companies, and the industry, contained in the analysis. There are too many unforeseen possibilities, both at the company level, and in the industry involved, for anyone to make concrete statements on future financial results.

References "Stockopedia Features". (2011, April 13). The Altman Z-Score: Is it possible to predict corporate bankruptcy using a formula? . Retrieved from Stockopedia.com: http://www.stockopedia.com Altman, E. (1968). Financial Ratios, Discriminant Analysis and the Prediction of Corporate Bankruptcy. Journal of Finance. Journal of Finance, 24(3), 189-209. Altman, E. (2000, July). Predicting financial distress of comapnies: revisiting the z-score and zeta models. Retrieved from Stern School of Business, NYU: http://pages.stern.nyu.edu Kimmel, P. W., Kieso, D. T., & Irvine, W. (2014). Financial Accounting: Tools for Business Decision Making, 6th Cdn. Ed. Toronto: Wiley. Krause, R. (2016, September 22). Level 3 communications, cogent rated outperform. Retrieved from Investor's Daily News: https://ezproxy.royalroads.ca/login?url=http://search.proquest.com/docview/1714456536?accountid=8056 Level 3 Communications. (2016, December 6). Retrieved from Investor's Business Daily: https://ezproxy.royalroads.ca/login?url=http://search.proquest.com/docview/1721785660?accountid=8056 Level 3 Communications/Our History. (2016, November 16). Retrieved from Level 3 Communications: http://www.level3.com/en/about-us/our-history/ Picker, L. (2016, October 31). CenturyLink, a neywork provider, to acquire Level 3, a rival. Retrieved from New York Times: http://www.nytimes.com Sherman, A., & Moritz, S. (2016, October 31). CenturyLink agrees to buy Level 3 for $34 billion in cash, stock. Retrieved from Bloomberg News: https://www.bloomberg.com Weygant, J., Kimmel, P., Kieso, D., & Aly, I. (2015). Managerial Accounting: Tools for Business Decision Making, 4th ed. Toronto: Wiley. Zacks. (2016, December 9). Stck report: Level 3 Comm (LVLT). Retrieved from Zacks.com: https://www.zacks.com

Appendix A

Ratio Formulae

Working Capital = Current Assets - Current Liabilities

Cash Current Debt Coverage = Net Cash Provided (Used) by Operating Activities / Average Current Liabilities

Debt to Total Assets % = Total Liabilities / Total Assets

Price to Earnings (PE) = Market Price of Common Share / Earnings per Share

Price/Earnings to Growth (PEG) = PE / Earnings per Share

Return on Assets (ROA) = Profit / Average Total Assets

Return on Common Shareholders Equity (ROCE) = (Profits - Preferred Dividends) / Average Common Shareholders' Equity

Return on Investment (ROI) = (Earnings - Initial Investment) / Initial Investment

EBITDA Margin % = EBITDA / Total Revenue

Quick Ratio = (Current Assets - Inventory) / Current Liabilities

Current Ratio = Current Assets / Current Liabilities

Long-term Debt to Equity = Long Term Debt / (Preferred Stock + Common Stock)

Total Debt to Equity = Total Liabilities / Total Stockholders' Equity

Interest Coverage (TIE) = EBIT / Interest Expense

Total Asset Turnover = Net Sales / Average Total Assets

Receivables Turnover (RT) = Net Credit Sales / Average Gross Receivables

Cash Flow per Share = (Operating Cash Flow - Preferred Dividends) / # of Common Shares

Book Value per Share = Total Common Shareholders' Equity / # of Common Shares

Appendix B

TABLE 1 - LEVEL 3 COMMUNICATIONS - ACCOUNTING RATIOS

 

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

Working Capital (Million)

$333

$425

$8

$40

$49

$16

$260

$192

$271

$1,460

Current Ratio

1.24

0.78

1.01

1.02

1.03

1.02

0.83

1.18

1.28

2.57

Cash Current Debt Coverage

0.71

0.48

0.28

0.23

0.22

0.17

0.20

0.28

0.16

0.12

Debt to Total Assets %

58

70

89

91

91

101

95

91

90

92

Price to Earnings Ratio

5.60

40.15

67.69

11.79

3.08

2.58

8.05

0.96

4.11

6.15

PEG

3.84

3.98

138.21

2.68

0.18

1.23

0.92

0.06

0.84

0.53

ROA % (Net)

15.23

1.86

0.83

3.18

7.02

7.14

6.61

2.91

11.01

8.14

ROE % (Net)

41.64

8.08

8.44

35.60

145.95

372.46

90.42

29.72

154.29

0.00

ROI % (Operating)

6.86

7.38

6.77

5.87

0.65

1.36

0.90

0.40

3.08

2.11

EBITDA Margin %

22.64

23.67

20.67

15.93

14.65

17.89

21.24

24.81

5.27

13.26

Quick Ratio

1.13

0.68

0.90

0.94

0.94

0.91

0.76

1.09

1.17

2.41

Current Ratio

1.24

0.78

1.01

1.02

1.03

1.02

0.83

1.18

1.28

2.57

LT Debt to Equity

1.09

1.73

5.90

7.27

7.03

8.38

11.72

7.30

6.39

19.67

Total Debt to Equity

1.09

1.78

5.93

7.46

7.08

8.96

13.16

7.51

6.41

19.68

Interest Coverage

2.08

1.55

1.03

0.79

0.07

0.00

0.00

0.06

0.00

0.00

Total Asset Turnover

0.36

0.40

0.48

0.48

0.40

0.42

0.40

0.43

0.42

0.37

Receivables Turnover

11.02

9.61

9.10

9.34

9.50

12.44

10.55

10.93

11.84

5.84

Cash Flow per Share

5.25

4.56

3.21

2.68

2.83

3.06

3.28

3.95

2.28

3.30

Book Value per Share

28.41

18.64

6.01

5.36

5.74

1.41

4.48

8.12

10.44

4.76

2015 Values

As of December 1st, 2016

Net Operating Margin

0.82

Total Assets per Share

$68.80

Gearing

0.52

Net Assets per Share

$29.81

Interest Cover

$26.25

Cash Flow per Share

$6.47

Current Assets (millions)

$2,789

Current Assets (millions)

$2,457

ROCE

$0.12

TABLE 1 - LEVEL 3 COMMUNICATIONS - ACCOUNTING RATIOS

(currency in millions)

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

Current Assets

$1,749

$1,489

$1,454

$1,842

$1,707

$972

$1,259

$1,244

$1,229

$2,389

Current Assets $ change

$260

$35

$388

$135

$735

$287

$15

$15

$1,160

 

Current Assets % change

17.46%

2.41%

-21.06%

7.91%

75.62%

-22.80%

1.21%

1.22%

-48.56%

 

Current Liabilities

$1,416

$1,914

$1,446

$1,802

$1,658

$956

$1,519

$1,052

$958

$929

Current Liabilities $ Change

$498

$468

$356

$144

$702

$563

$467

$94

$29

 

Current Liabilities % Change

-26.02%

32.37%

-19.76%

8.69%

73.43%

-37.06%

44.39%

9.81%

3.12%

 

EBIT

$283

$238

-$71

-$374

-$786

-$713

-$617

-$284

-$1,136

-$788

EBIT $ Change

$45

$309

$303

$412

$73

$96

$333

$852

$348

 

EBIT % Change

18.91%

435.21%

81.02%

52.42%

10.24%

15.56%

117.25%

75.00%

44.16%

 

EBITDA

$1,863

$1,604

$1,305

$1,016

$635

$653

$799

$1,067

$225

$448

EBITDA $ Change

$259

$299

$289

$381

$18

$146

$268

$842

$223

 

EBITDA % Change

116.15%

122.91%

128.44%

160.00%

97.24%

81.73%

74.88%

474.22%

50.22%

 

Long Term Debt

$10,994

$10,984

$8,331

$8,516

$8,385

$6,268

$5,755

$6,394

$6,832

$7,357

Long Term Debt $ Change

$10

$2,653

-$185

$131

$2,117

$513

-$639

-$438

-$525

 

Long Term Debt % Change

0.09%

31.84%

-2.17%

1.56%

33.77%

8.91%

-9.99%

-6.41%

-7.14%

 

Net Income

$3,433

$314

-$109

-$422

-$756

-$622

-$618

-$290

-$1,114

-$744

Net Income $ Change

$3,119

$423

$313

$334

$134

$4

$328

$824

$370

 

Net Income % Change

993.31%

388.07%

74.17%

44.18%

21.54%

0.65%

113.10%

73.97%

49.73%

 

Total Assets

$24,145

$20,947

$12,874

$13,307

$13,188

$8,355

$9,062

$9,638

$10,245

$9,994

Total Assets $ change

$3,198

$8,073

$433

$119

$4,833

$707

$576

$607

$251

 

Total Assets % change

15.27%

62.71%

-3.25%

0.90%

57.85%

-7.80%

-5.98%

-5.92%

2.51%

 

Total Liabilities

$14,019

$14,584

$11,463

$12,136

$11,995

$8,512

$8,571

$8,762

$9,175

$9,620

Total Liabilities $ change

$565

$3,121

$673

$141

$3,483

$59

$191

$413

$445

 

Total Liabilities % change

-3.87%

27.23%

-5.55%

1.18%

40.92%

-0.69%

-2.18%

-4.50%

-4.63%

 

Total Capital

$10,126

$6,363

$1,411

$1,171

$1,193

$157

$491

$876

$1,070

 

Table 2 - LEVEL 3 HORIZONTAL ANALYSIS

INDUSTRY COMPARISON

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

ALTMAN Z SCORE

ACS

18.49

17.09

17.05

4.22

6.55

2.52

4.74

1.87

10.76

3.44

AT&T

1.75

1.47

1.73

1.51

1.61

1.81

1.77

1.7

1.81

1.5

GCI

0.66

0.56

0.92

0.69

0.67

0.64

0.59

0.51

0.79

0.72

Level 3

10.24

7.28

5.35

4.03

3.16

19.72

27.57

13.38

46.19

25.43

ALTMAN Z2 Score

ACS

0.4

1.6

0.7

1.1

1

1.2

0.9

0.9

1.7

2.3

AT&T

1.7

1.4

1.8

1.5

1.7

1.9

1.9

1.5

1.8

1.5

GCI

1.22

0.97

1.53

0.78

0.78

0.55

0.75

0.43

0.84

0.19

Level 3

2.17

2.37

3.38

3.08

2.80

3.98

3.39

3.54

2.75

2.71

CURRENT RATIO

ACS

1.27

1.92

1.09

0.99

0.89

1.02

1

1.17

1.53

1.17

AT&T

0.75

0.86

0.66

0.71

0.75

0.59

0.66

0.53

0.63

0.63

GCI

1.45

1.82

2.13

1.61

1.76

1.66

1.97

1.36

1.4

2.2

Level 3

1.24

0.78

1.01

1.02

1.03

1.02

0.83

1.18

1.28

2.57

QUICK RATIO

ACS

0.9

0.56

0.74

0.67

0.56

0.58

0.47

0.4

1

0.9

AT&T

0.45

0.62

0.46

0.55

0.55

0.44

0.51

0.42

0.46

0.46

GCI

1.25

1.26

1.7

1.27

1.38

1.35

1.65

1.18

1.15

1.59

Level 3

1.13

0.68

0.9

0.94

0.94

0.91

0.76

1.09

1.17

2.41

ROE %

ACS

9.00

2.10

317.60

-

-

474.10

147.60

23.30

584.50

-

AT&T

12.80

7.00

20.00

7.30

3.60

18.60

12.70

12.10

10.40

8.60

GCI

20.40

4.70

6.00

6.10

3.30

3.80

1.30

0.70

5.40

7.60

Level 3

41.64

8.08

8.44

35.60

145.90

372.50

90.42

29.70

154.30

-

ROI %

ACS

0.30

1.10

5.60

11.60

12.00

9.10

6.50

2.90

13.20

12.40

AT&T

11.90

7.00

18.60

7.80

5.30

11.10

12.50

13.10

11.50

7.90

GCI

7.60

11.20

9.40

8.00

8.30

8.00

6.00

5.10

8.20

9.20

Level 3

6.90

7.40

6.80

5.90

0.70

1.40

0.90

0.40

3.10

2.10

Total Debt to Equity

ACS

1.24

3.21

3.43

-

-

-

16.13

44.23

5.85

-

AT&T

1.03

0.95

0.82

0.76

0.61

0.59

0.71

0.78

0.56

0.52

GCI

16.05

6.65

7.14

6.09

5.96

4.35

3.28

3.16

2.15

2.01

Level 3

1.09

1.78

5.93

7.46

7.08

-

13.16

7.51

6.41

19.68

Net Profit Margin

ACS

5.56

0.88

44.82

4.73

0.14

8.99

9.83

2.60

37.36

5.72

AT&T

9.09

4.70

14.17

5.70

3.11

15.98

10.19

10.37

10.05

11.67

GCI

2.66

0.83

1.16

1.36

0.86

1.38

0.59

0.32

2.60

3.88

Level 3

41.72

4.63

1.73

6.62

17.45

17.04

16.43

6.74

26.10

22.02

Operating Margin

ACS

0.67

1.93

8.93

16.48

18.05

14.65

10.79

4.08

15.73

14.89

AT&T

16.88

8.87

23.67

10.20

7.27

15.75

17.47

18.59

17.16

16.32

GCI

10.85

15.77

13.91

12.53

13.35

13.59

11.09

8.29

12.00

14.10

Level 3

16.17

14.95

10.55

9.02

1.20

2.47

1.73

0.72

5.65

4.14

TABLE 3 - INDUSTRY COMPARISON