Stock Analysis on Net

Twenty-First Century Fox Inc. (NASDAQ:FOX)

This company has been moved to the archive! The financial data has not been updated since February 6, 2019.

Analysis of Reportable Segments 

Microsoft Excel

Segment Profit Margin

Twenty-First Century Fox Inc., profit margin by reportable segment

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 34.40% 34.72% 34.23% 33.75% 35.91% 38.39%
Television 7.01% 15.83% 14.57% 14.67% 16.65% 17.59%
Filmed Entertainment 11.00% 12.76% 12.76% 15.17% 14.03% 15.14%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

Segment profitability ratio Reportable segment The company
Segment profit margin Cable Network Programming Cable Network Programming segment profit margin ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.
Television Television segment profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Filmed Entertainment Filmed Entertainment segment profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment Profit Margin: Cable Network Programming

Twenty-First Century Fox Inc.; Cable Network Programming; segment profit margin calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Segment OIBDA 6,173 5,601 5,145 4,648 4,407 4,177
Revenues 17,946 16,130 15,029 13,773 12,273 10,881
Segment Profitability Ratio
Segment profit margin1 34.40% 34.72% 34.23% 33.75% 35.91% 38.39%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment profit margin = 100 × Segment OIBDA ÷ Revenues
= 100 × 6,173 ÷ 17,946 = 34.40%

Segment profitability ratio Reportable segment The company
Segment profit margin Cable Network Programming Cable Network Programming segment profit margin ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Segment Profit Margin: Television

Twenty-First Century Fox Inc.; Television; segment profit margin calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Segment OIBDA 362 894 744 718 882 855
Revenues 5,162 5,649 5,105 4,895 5,296 4,860
Segment Profitability Ratio
Segment profit margin1 7.01% 15.83% 14.57% 14.67% 16.65% 17.59%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment profit margin = 100 × Segment OIBDA ÷ Revenues
= 100 × 362 ÷ 5,162 = 7.01%

Segment profitability ratio Reportable segment The company
Segment profit margin Television Television segment profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment Profit Margin: Filmed Entertainment

Twenty-First Century Fox Inc.; Filmed Entertainment; segment profit margin calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Segment OIBDA 962 1,051 1,085 1,445 1,358 1,308
Revenues 8,747 8,235 8,505 9,525 9,679 8,642
Segment Profitability Ratio
Segment profit margin1 11.00% 12.76% 12.76% 15.17% 14.03% 15.14%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment profit margin = 100 × Segment OIBDA ÷ Revenues
= 100 × 962 ÷ 8,747 = 11.00%

Segment profitability ratio Reportable segment The company
Segment profit margin Filmed Entertainment Filmed Entertainment segment profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment Return on Assets (Segment ROA)

Twenty-First Century Fox Inc., ROA by reportable segment

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 23.97% 22.48% 20.60% 20.00% 19.65% 23.43%
Television 5.34% 13.20% 10.69% 10.80% 13.68% 13.33%
Filmed Entertainment 9.04% 10.19% 11.33% 15.87% 13.03% 13.90%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

Segment profitability ratio Reportable segment The company
Segment ROA Cable Network Programming Cable Network Programming segment ROA improved from 2016 to 2017 and from 2017 to 2018.
Television Television segment ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Filmed Entertainment Filmed Entertainment segment ROA deteriorated from 2016 to 2017 and from 2017 to 2018.

Segment ROA: Cable Network Programming

Twenty-First Century Fox Inc.; Cable Network Programming; segment ROA calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Segment OIBDA 6,173 5,601 5,145 4,648 4,407 4,177
Assets 25,756 24,913 24,979 23,235 22,422 17,830
Segment Profitability Ratio
Segment ROA1 23.97% 22.48% 20.60% 20.00% 19.65% 23.43%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment ROA = 100 × Segment OIBDA ÷ Assets
= 100 × 6,173 ÷ 25,756 = 23.97%

Segment profitability ratio Reportable segment The company
Segment ROA Cable Network Programming Cable Network Programming segment ROA improved from 2016 to 2017 and from 2017 to 2018.

Segment ROA: Television

Twenty-First Century Fox Inc.; Television; segment ROA calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Segment OIBDA 362 894 744 718 882 855
Assets 6,779 6,775 6,959 6,646 6,449 6,415
Segment Profitability Ratio
Segment ROA1 5.34% 13.20% 10.69% 10.80% 13.68% 13.33%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment ROA = 100 × Segment OIBDA ÷ Assets
= 100 × 362 ÷ 6,779 = 5.34%

Segment profitability ratio Reportable segment The company
Segment ROA Television Television segment ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Segment ROA: Filmed Entertainment

Twenty-First Century Fox Inc.; Filmed Entertainment; segment ROA calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Segment OIBDA 962 1,051 1,085 1,445 1,358 1,308
Assets 10,646 10,312 9,579 9,105 10,419 9,411
Segment Profitability Ratio
Segment ROA1 9.04% 10.19% 11.33% 15.87% 13.03% 13.90%

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment ROA = 100 × Segment OIBDA ÷ Assets
= 100 × 962 ÷ 10,646 = 9.04%

Segment profitability ratio Reportable segment The company
Segment ROA Filmed Entertainment Filmed Entertainment segment ROA deteriorated from 2016 to 2017 and from 2017 to 2018.

Segment Asset Turnover

Twenty-First Century Fox Inc., asset turnover by reportable segment

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 0.70 0.65 0.60 0.59 0.55 0.61
Television 0.76 0.83 0.73 0.74 0.82 0.76
Filmed Entertainment 0.82 0.80 0.89 1.05 0.93 0.92

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

Segment activity ratio Reportable segment The company
Segment asset turnover Cable Network Programming Cable Network Programming segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.
Television Television segment asset turnover ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.
Filmed Entertainment Filmed Entertainment segment asset turnover ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Segment Asset Turnover: Cable Network Programming

Twenty-First Century Fox Inc.; Cable Network Programming; segment asset turnover calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Revenues 17,946 16,130 15,029 13,773 12,273 10,881
Assets 25,756 24,913 24,979 23,235 22,422 17,830
Segment Activity Ratio
Segment asset turnover1 0.70 0.65 0.60 0.59 0.55 0.61

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment asset turnover = Revenues ÷ Assets
= 17,946 ÷ 25,756 = 0.70

Segment activity ratio Reportable segment The company
Segment asset turnover Cable Network Programming Cable Network Programming segment asset turnover ratio improved from 2016 to 2017 and from 2017 to 2018.

Segment Asset Turnover: Television

Twenty-First Century Fox Inc.; Television; segment asset turnover calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Revenues 5,162 5,649 5,105 4,895 5,296 4,860
Assets 6,779 6,775 6,959 6,646 6,449 6,415
Segment Activity Ratio
Segment asset turnover1 0.76 0.83 0.73 0.74 0.82 0.76

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment asset turnover = Revenues ÷ Assets
= 5,162 ÷ 6,779 = 0.76

Segment activity ratio Reportable segment The company
Segment asset turnover Television Television segment asset turnover ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Segment Asset Turnover: Filmed Entertainment

Twenty-First Century Fox Inc.; Filmed Entertainment; segment asset turnover calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Revenues 8,747 8,235 8,505 9,525 9,679 8,642
Assets 10,646 10,312 9,579 9,105 10,419 9,411
Segment Activity Ratio
Segment asset turnover1 0.82 0.80 0.89 1.05 0.93 0.92

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment asset turnover = Revenues ÷ Assets
= 8,747 ÷ 10,646 = 0.82

Segment activity ratio Reportable segment The company
Segment asset turnover Filmed Entertainment Filmed Entertainment segment asset turnover ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Segment Capital Expenditures to Depreciation

Twenty-First Century Fox Inc., capital expenditures to depreciation by reportable segment

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 0.83 0.50 0.42 0.36 0.56 0.45
Television 0.81 0.64 0.64 0.67 0.86 1.11
Filmed Entertainment 1.01 0.60 0.55 0.42 0.46 0.48

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Cable Network Programming Cable Network Programming segment capital expenditures to depreciation ratio improved from 2016 to 2017 and from 2017 to 2018.
Television Television segment capital expenditures to depreciation ratio improved from 2016 to 2017 and from 2017 to 2018.
Filmed Entertainment Filmed Entertainment segment capital expenditures to depreciation ratio improved from 2016 to 2017 and from 2017 to 2018.

Segment Capital Expenditures to Depreciation: Cable Network Programming

Twenty-First Century Fox Inc.; Cable Network Programming; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Capital expenditures 293 169 132 106 131 88
Depreciation and amortization 351 337 311 294 232 197
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.83 0.50 0.42 0.36 0.56 0.45

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 293 ÷ 351 = 0.83

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Cable Network Programming Cable Network Programming segment capital expenditures to depreciation ratio improved from 2016 to 2017 and from 2017 to 2018.

Segment Capital Expenditures to Depreciation: Television

Twenty-First Century Fox Inc.; Television; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Capital expenditures 89 73 75 77 90 103
Depreciation and amortization 110 114 118 115 105 93
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.81 0.64 0.64 0.67 0.86 1.11

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 89 ÷ 110 = 0.81

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

Segment Capital Expenditures to Depreciation: Filmed Entertainment

Twenty-First Century Fox Inc.; Filmed Entertainment; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Capital expenditures 89 48 45 45 61 63
Depreciation and amortization 88 80 82 107 133 132
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.01 0.60 0.55 0.42 0.46 0.48

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).

1 2018 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 89 ÷ 88 = 1.01

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Filmed Entertainment Filmed Entertainment segment capital expenditures to depreciation ratio improved from 2016 to 2017 and from 2017 to 2018.

Revenues

Twenty-First Century Fox Inc., revenues by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 17,946 16,130 15,029 13,773 12,273 10,881
Television 5,162 5,649 5,105 4,895 5,296 4,860
Filmed Entertainment 8,747 8,235 8,505 9,525 9,679 8,642
Direct Broadcast Satellite Television 2,112 6,030 4,439
Other, Corporate and Eliminations (1,455) (1,514) (1,313) (1,318) (1,411) (1,147)
Total 30,400 28,500 27,326 28,987 31,867 27,675

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).


Segment OIBDA

Twenty-First Century Fox Inc., segment oibda by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 6,173 5,601 5,145 4,648 4,407 4,177
Television 362 894 744 718 882 855
Filmed Entertainment 962 1,051 1,085 1,445 1,358 1,308
Direct Broadcast Satellite Television 234 424 397
Other, Corporate and Eliminations (465) (373) (377) (323) (356) (476)
Total 7,032 7,173 6,597 6,722 6,715 6,261

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).


Depreciation and amortization

Twenty-First Century Fox Inc., depreciation and amortization by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 351 337 311 294 232 197
Television 110 114 118 115 105 93
Filmed Entertainment 88 80 82 107 133 132
Direct Broadcast Satellite Television 202 657 355
Other, Corporate and Eliminations 35 22 19 18 15 20
Total 584 553 530 736 1,142 797

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).


Capital expenditures

Twenty-First Century Fox Inc., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 293 169 132 106 131 88
Television 89 73 75 77 90 103
Filmed Entertainment 89 48 45 45 61 63
Direct Broadcast Satellite Television 95 368 344
Other, Corporate and Eliminations 80 87 11 101 28 24
Total 551 377 263 424 678 622

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).


Assets

Twenty-First Century Fox Inc., assets by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Cable Network Programming 25,756 24,913 24,979 23,235 22,422 17,830
Television 6,779 6,775 6,959 6,646 6,449 6,415
Filmed Entertainment 10,646 10,312 9,579 9,105 10,419 9,411
Direct Broadcast Satellite Television 9,144 8,636
Other, Corporate and Eliminations 6,538 4,822 2,985 6,536 3,500 4,948
Investments 4,112 3,902 3,863 4,529 2,859 3,704
Total 53,831 50,724 48,365 50,051 54,793 50,944

Based on: 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30).