Stock Analysis on Net

Time Warner Inc. (NYSE:TWX)

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

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Time Warner Inc., profit margin by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 37.16% 38.47% 38.57% 28.41% 34.92%
Home Box Office 34.00% 32.55% 33.45% 33.09% 36.63%
Warner Bros. 12.70% 13.30% 10.90% 9.25% 10.75%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Turner Turner segment profit margin ratio deteriorated from 2015 to 2016 and from 2016 to 2017.
Home Box Office Home Box Office segment profit margin ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.
Warner Bros. Warner Bros. segment profit margin ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment Profit Margin: Turner

Time Warner Inc.; Turner; segment profit margin calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Operating income (loss) 4,489 4,372 4,087 2,954 3,486
Revenues 12,081 11,364 10,596 10,396 9,983
Segment Profitability Ratio
Segment profit margin1 37.16% 38.47% 38.57% 28.41% 34.92%

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

1 2017 Calculation
Segment profit margin = 100 × Operating income (loss) ÷ Revenues
= 100 × 4,489 ÷ 12,081 = 37.16%

Segment profitability ratio Reportable segment The company
Segment profit margin Turner Turner segment profit margin ratio deteriorated from 2015 to 2016 and from 2016 to 2017.

Segment Profit Margin: Home Box Office

Time Warner Inc.; Home Box Office; segment profit margin calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Operating income (loss) 2,152 1,917 1,878 1,786 1,791
Revenues 6,329 5,890 5,615 5,398 4,890
Segment Profitability Ratio
Segment profit margin1 34.00% 32.55% 33.45% 33.09% 36.63%

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

1 2017 Calculation
Segment profit margin = 100 × Operating income (loss) ÷ Revenues
= 100 × 2,152 ÷ 6,329 = 34.00%

Segment profitability ratio Reportable segment The company
Segment profit margin Home Box Office Home Box Office segment profit margin ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Segment Profit Margin: Warner Bros.

Time Warner Inc.; Warner Bros.; segment profit margin calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Operating income (loss) 1,761 1,734 1,416 1,159 1,324
Revenues 13,866 13,037 12,992 12,526 12,312
Segment Profitability Ratio
Segment profit margin1 12.70% 13.30% 10.90% 9.25% 10.75%

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

1 2017 Calculation
Segment profit margin = 100 × Operating income (loss) ÷ Revenues
= 100 × 1,761 ÷ 13,866 = 12.70%

Segment profitability ratio Reportable segment The company
Segment profit margin Warner Bros. Warner Bros. segment profit margin ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment Return on Assets (Segment ROA)

Time Warner Inc., ROA by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 16.56% 16.61% 15.99% 11.69% 13.37%
Home Box Office 14.56% 13.10% 13.12% 12.88% 13.09%
Warner Bros. 7.93% 8.05% 6.84% 5.64% 6.60%

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

Segment profitability ratio Reportable segment The company
Segment ROA Turner Turner segment ROA improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.
Home Box Office Home Box Office segment ROA deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.
Warner Bros. Warner Bros. segment ROA improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment ROA: Turner

Time Warner Inc.; Turner; segment ROA calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Operating income (loss) 4,489 4,372 4,087 2,954 3,486
Assets 27,111 26,317 25,559 25,271 26,067
Segment Profitability Ratio
Segment ROA1 16.56% 16.61% 15.99% 11.69% 13.37%

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

1 2017 Calculation
Segment ROA = 100 × Operating income (loss) ÷ Assets
= 100 × 4,489 ÷ 27,111 = 16.56%

Segment profitability ratio Reportable segment The company
Segment ROA Turner Turner segment ROA improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment ROA: Home Box Office

Time Warner Inc.; Home Box Office; segment ROA calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Operating income (loss) 2,152 1,917 1,878 1,786 1,791
Assets 14,777 14,636 14,314 13,869 13,687
Segment Profitability Ratio
Segment ROA1 14.56% 13.10% 13.12% 12.88% 13.09%

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

1 2017 Calculation
Segment ROA = 100 × Operating income (loss) ÷ Assets
= 100 × 2,152 ÷ 14,777 = 14.56%

Segment profitability ratio Reportable segment The company
Segment ROA Home Box Office Home Box Office segment ROA deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Segment ROA: Warner Bros.

Time Warner Inc.; Warner Bros.; segment ROA calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Operating income (loss) 1,761 1,734 1,416 1,159 1,324
Assets 22,193 21,550 20,699 20,559 20,066
Segment Profitability Ratio
Segment ROA1 7.93% 8.05% 6.84% 5.64% 6.60%

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

1 2017 Calculation
Segment ROA = 100 × Operating income (loss) ÷ Assets
= 100 × 1,761 ÷ 22,193 = 7.93%

Segment profitability ratio Reportable segment The company
Segment ROA Warner Bros. Warner Bros. segment ROA improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment Asset Turnover

Time Warner Inc., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 0.45 0.43 0.41 0.41 0.38
Home Box Office 0.43 0.40 0.39 0.39 0.36
Warner Bros. 0.62 0.60 0.63 0.61 0.61

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

Segment activity ratio Reportable segment The company
Segment asset turnover Turner Turner segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.
Home Box Office Home Box Office segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.
Warner Bros. Warner Bros. segment asset turnover ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 not reaching 2015 level.

Segment Asset Turnover: Turner

Time Warner Inc.; Turner; segment asset turnover calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Revenues 12,081 11,364 10,596 10,396 9,983
Assets 27,111 26,317 25,559 25,271 26,067
Segment Activity Ratio
Segment asset turnover1 0.45 0.43 0.41 0.41 0.38

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

1 2017 Calculation
Segment asset turnover = Revenues ÷ Assets
= 12,081 ÷ 27,111 = 0.45

Segment activity ratio Reportable segment The company
Segment asset turnover Turner Turner segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Asset Turnover: Home Box Office

Time Warner Inc.; Home Box Office; segment asset turnover calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Revenues 6,329 5,890 5,615 5,398 4,890
Assets 14,777 14,636 14,314 13,869 13,687
Segment Activity Ratio
Segment asset turnover1 0.43 0.40 0.39 0.39 0.36

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

1 2017 Calculation
Segment asset turnover = Revenues ÷ Assets
= 6,329 ÷ 14,777 = 0.43

Segment activity ratio Reportable segment The company
Segment asset turnover Home Box Office Home Box Office segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Asset Turnover: Warner Bros.

Time Warner Inc.; Warner Bros.; segment asset turnover calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Revenues 13,866 13,037 12,992 12,526 12,312
Assets 22,193 21,550 20,699 20,559 20,066
Segment Activity Ratio
Segment asset turnover1 0.62 0.60 0.63 0.61 0.61

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

1 2017 Calculation
Segment asset turnover = Revenues ÷ Assets
= 13,866 ÷ 22,193 = 0.62

Segment activity ratio Reportable segment The company
Segment asset turnover Warner Bros. Warner Bros. segment asset turnover ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 not reaching 2015 level.

Segment Capital Expenditures to Depreciation

Time Warner Inc., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 1.11 1.03 0.81 0.83 0.91
Home Box Office 1.28 1.32 0.84 0.75 0.49
Warner Bros. 0.77 0.46 0.62 0.94 1.18

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Turner Turner segment capital expenditures to depreciation ratio improved from 2015 to 2016 and from 2016 to 2017.
Home Box Office Home Box Office segment capital expenditures to depreciation ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.
Warner Bros. Warner Bros. segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Segment Capital Expenditures to Depreciation: Turner

Time Warner Inc.; Turner; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Capital expenditures 225 196 157 173 210
Depreciation of property, plant and equipment 202 191 193 209 231
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.11 1.03 0.81 0.83 0.91

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

1 2017 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation of property, plant and equipment
= 225 ÷ 202 = 1.11

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Turner Turner segment capital expenditures to depreciation ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Capital Expenditures to Depreciation: Home Box Office

Time Warner Inc.; Home Box Office; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Capital expenditures 111 98 68 58 45
Depreciation of property, plant and equipment 87 74 81 77 91
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.28 1.32 0.84 0.75 0.49

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

1 2017 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation of property, plant and equipment
= 111 ÷ 87 = 1.28

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Home Box Office Home Box Office segment capital expenditures to depreciation ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment Capital Expenditures to Depreciation: Warner Bros.

Time Warner Inc.; Warner Bros.; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in millions)
Capital expenditures 137 86 122 206 236
Depreciation of property, plant and equipment 179 188 197 218 200
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.77 0.46 0.62 0.94 1.18

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

1 2017 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation of property, plant and equipment
= 137 ÷ 179 = 0.77

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Warner Bros. Warner Bros. segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Revenues

Time Warner Inc., revenues by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 12,081 11,364 10,596 10,396 9,983
Home Box Office 6,329 5,890 5,615 5,398 4,890
Warner Bros. 13,866 13,037 12,992 12,526 12,312
Time Inc. 3,354
Intersegment eliminations (1,005) (973) (1,085) (961) (744)
Total 31,271 29,318 28,118 27,359 29,795

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


Depreciation of property, plant and equipment

Time Warner Inc., depreciation of property, plant and equipment by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 202 191 193 209 231
Home Box Office 87 74 81 77 91
Warner Bros. 179 188 197 218 200
Time Inc. 85
Corporate 29 26 21 27 28
Total 497 479 492 531 635

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


Operating income (loss)

Time Warner Inc., operating income (loss) by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 4,489 4,372 4,087 2,954 3,486
Home Box Office 2,152 1,917 1,878 1,786 1,791
Warner Bros. 1,761 1,734 1,416 1,159 1,324
Time Inc. 337
Corporate (430) (498) (367) (73) (394)
Intersegment eliminations (52) 22 (149) 149 61
Total 7,920 7,547 6,865 5,975 6,605

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


Assets

Time Warner Inc., assets by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 27,111 26,317 25,559 25,271 26,067
Home Box Office 14,777 14,636 14,314 13,869 13,687
Warner Bros. 22,193 21,550 20,699 20,559 20,066
Time Inc. 5,667
Corporate 5,128 3,463 3,276 3,560 2,507
Total 69,209 65,966 63,848 63,259 67,994

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


Capital expenditures

Time Warner Inc., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Turner 225 196 157 173 210
Home Box Office 111 98 68 58 45
Warner Bros. 137 86 122 206 236
Time Inc. 34
Corporate 183 52 76 37 77
Total 656 432 423 474 602

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