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 Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Twenty-First Century Fox Inc., adjustment to net income attributable to Twenty-First Century Fox, Inc. stockholders

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Net income attributable to Twenty-First Century Fox, Inc. stockholders (as reported) 4,464 2,952 2,755 8,306 4,514 7,097
Add: Unrealized holding gains (losses) on securities 132 (4) (18) (129) (45)
Net income attributable to Twenty-First Century Fox, Inc. stockholders (adjusted) 4,596 2,952 2,751 8,288 4,385 7,052

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).


Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Twenty-First Century Fox Inc., adjusted profitability ratios

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Net Profit Margin
Reported net profit margin 14.68% 10.36% 10.08% 28.65% 14.17% 25.64%
Adjusted net profit margin 15.12% 10.36% 10.07% 28.59% 13.76% 25.48%
Return on Equity (ROE)
Reported ROE 22.82% 18.78% 20.17% 48.23% 25.92% 41.75%
Adjusted ROE 23.49% 18.78% 20.14% 48.13% 25.18% 41.49%
Return on Assets (ROA)
Reported ROA 8.29% 5.82% 5.70% 16.60% 8.24% 13.93%
Adjusted ROA 8.54% 5.82% 5.69% 16.56% 8.00% 13.84%

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).

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Twenty-First Century Fox Inc. adjusted net profit margin ratio improved from 2016 to 2017 and from 2017 to 2018.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Twenty-First Century Fox Inc. adjusted ROE deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Twenty-First Century Fox Inc. adjusted ROA improved from 2016 to 2017 and from 2017 to 2018.

Twenty-First Century Fox Inc., Profitability Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to Twenty-First Century Fox, Inc. stockholders 4,464 2,952 2,755 8,306 4,514 7,097
Revenues 30,400 28,500 27,326 28,987 31,867 27,675
Profitability Ratio
Net profit margin1 14.68% 10.36% 10.08% 28.65% 14.17% 25.64%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to Twenty-First Century Fox, Inc. stockholders 4,596 2,952 2,751 8,288 4,385 7,052
Revenues 30,400 28,500 27,326 28,987 31,867 27,675
Profitability Ratio
Adjusted net profit margin2 15.12% 10.36% 10.07% 28.59% 13.76% 25.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).

2018 Calculations

1 Net profit margin = 100 × Net income attributable to Twenty-First Century Fox, Inc. stockholders ÷ Revenues
= 100 × 4,464 ÷ 30,400 = 14.68%

2 Adjusted net profit margin = 100 × Adjusted net income attributable to Twenty-First Century Fox, Inc. stockholders ÷ Revenues
= 100 × 4,596 ÷ 30,400 = 15.12%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Twenty-First Century Fox Inc. adjusted net profit margin ratio improved from 2016 to 2017 and from 2017 to 2018.

Adjusted Return on Equity (ROE)

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to Twenty-First Century Fox, Inc. stockholders 4,464 2,952 2,755 8,306 4,514 7,097
Total Twenty-First Century Fox, Inc. stockholders’ equity 19,564 15,722 13,661 17,220 17,418 16,998
Profitability Ratio
ROE1 22.82% 18.78% 20.17% 48.23% 25.92% 41.75%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to Twenty-First Century Fox, Inc. stockholders 4,596 2,952 2,751 8,288 4,385 7,052
Total Twenty-First Century Fox, Inc. stockholders’ equity 19,564 15,722 13,661 17,220 17,418 16,998
Profitability Ratio
Adjusted ROE2 23.49% 18.78% 20.14% 48.13% 25.18% 41.49%

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).

2018 Calculations

1 ROE = 100 × Net income attributable to Twenty-First Century Fox, Inc. stockholders ÷ Total Twenty-First Century Fox, Inc. stockholders’ equity
= 100 × 4,464 ÷ 19,564 = 22.82%

2 Adjusted ROE = 100 × Adjusted net income attributable to Twenty-First Century Fox, Inc. stockholders ÷ Total Twenty-First Century Fox, Inc. stockholders’ equity
= 100 × 4,596 ÷ 19,564 = 23.49%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Twenty-First Century Fox Inc. adjusted ROE deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Adjusted Return on Assets (ROA)

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to Twenty-First Century Fox, Inc. stockholders 4,464 2,952 2,755 8,306 4,514 7,097
Total assets 53,831 50,724 48,365 50,051 54,793 50,944
Profitability Ratio
ROA1 8.29% 5.82% 5.70% 16.60% 8.24% 13.93%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income attributable to Twenty-First Century Fox, Inc. stockholders 4,596 2,952 2,751 8,288 4,385 7,052
Total assets 53,831 50,724 48,365 50,051 54,793 50,944
Profitability Ratio
Adjusted ROA2 8.54% 5.82% 5.69% 16.56% 8.00% 13.84%

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).

2018 Calculations

1 ROA = 100 × Net income attributable to Twenty-First Century Fox, Inc. stockholders ÷ Total assets
= 100 × 4,464 ÷ 53,831 = 8.29%

2 Adjusted ROA = 100 × Adjusted net income attributable to Twenty-First Century Fox, Inc. stockholders ÷ Total assets
= 100 × 4,596 ÷ 53,831 = 8.54%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Twenty-First Century Fox Inc. adjusted ROA improved from 2016 to 2017 and from 2017 to 2018.