Stock Analysis on Net

Time Warner Cable Inc. (NYSE:TWC)

This company has been moved to the archive! The financial data has not been updated since April 28, 2016.

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Time Warner Cable Inc., profit margin by reportable segment

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Residential Services 44.76% 46.75% 47.21% 47.93%
Business Services 60.51% 60.57% 58.43% 59.02%
Other Operations 38.89% 44.41% 52.00% 57.95%

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Residential Services Residential Services segment profit margin ratio deteriorated from 2013 to 2014 and from 2014 to 2015.
Business Services Business Services segment profit margin ratio improved from 2013 to 2014 but then slightly deteriorated from 2014 to 2015.
Other Operations Other Operations segment profit margin ratio deteriorated from 2013 to 2014 and from 2014 to 2015.

Segment Profit Margin: Residential Services

Time Warner Cable Inc.; Residential Services; segment profit margin calculation

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
OIBDA 8,489 8,623 8,688 8,712
Revenue 18,966 18,446 18,402 18,175
Segment Profitability Ratio
Segment profit margin1 44.76% 46.75% 47.21% 47.93%

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Segment profit margin = 100 × OIBDA ÷ Revenue
= 100 × 8,489 ÷ 18,966 = 44.76%

Segment profitability ratio Reportable segment The company
Segment profit margin Residential Services Residential Services segment profit margin ratio deteriorated from 2013 to 2014 and from 2014 to 2015.

Segment Profit Margin: Business Services

Time Warner Cable Inc.; Business Services; segment profit margin calculation

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
OIBDA 1,987 1,719 1,351 1,122
Revenue 3,284 2,838 2,312 1,901
Segment Profitability Ratio
Segment profit margin1 60.51% 60.57% 58.43% 59.02%

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Segment profit margin = 100 × OIBDA ÷ Revenue
= 100 × 1,987 ÷ 3,284 = 60.51%

Segment profitability ratio Reportable segment The company
Segment profit margin Business Services Business Services segment profit margin ratio improved from 2013 to 2014 but then slightly deteriorated from 2014 to 2015.

Segment Profit Margin: Other Operations

Time Warner Cable Inc.; Other Operations; segment profit margin calculation

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
OIBDA 665 787 833 846
Revenue 1,710 1,772 1,602 1,460
Segment Profitability Ratio
Segment profit margin1 38.89% 44.41% 52.00% 57.95%

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Segment profit margin = 100 × OIBDA ÷ Revenue
= 100 × 665 ÷ 1,710 = 38.89%

Segment profitability ratio Reportable segment The company
Segment profit margin Other Operations Other Operations segment profit margin ratio deteriorated from 2013 to 2014 and from 2014 to 2015.

Revenue

Time Warner Cable Inc., revenue by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Residential Services 18,966 18,446 18,402 18,175
Business Services 3,284 2,838 2,312 1,901
Other Operations 1,710 1,772 1,602 1,460
Intersegment eliminations (263) (244) (196) (150)
Total consolidated 23,697 22,812 22,120 21,386

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).


OIBDA

Time Warner Cable Inc., oibda by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Residential Services 8,489 8,623 8,688 8,712
Business Services 1,987 1,719 1,351 1,122
Other Operations 665 787 833 846
Shared functions (3,206) (3,126) (3,011) (2,971)
Total consolidated 7,935 8,003 7,861 7,709

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).