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.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Twenty-First Century Fox Inc., adjusted current assets

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Current assets 19,333 16,286 14,949 17,376 15,376 15,567
Adjustments
Add: Allowances for returns and doubtful accounts 388 537 576 506 815 899
Less: Current deferred tax assets1 28 9
After Adjustment
Adjusted current assets 19,721 16,823 15,525 17,854 16,191 16,457

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 Current deferred tax assets. See details »


Adjustments to Total Assets

Twenty-First Century Fox Inc., adjusted total assets

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Total assets 53,831 50,724 48,365 50,051 54,793 50,944
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 1,553 1,729 1,506 1,570 3,690 3,454
Add: Allowances for returns and doubtful accounts 388 537 576 506 815 899
Less: Current deferred tax assets2 28 9
Less: Non-current deferred tax assets3 76 197 278 301 61 48
After Adjustment
Adjusted total assets 55,696 52,793 50,169 51,798 59,237 55,240

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Current deferred tax assets. See details »

3 Non-current deferred tax assets. See details »


Adjustments to Current Liabilities

Twenty-First Century Fox Inc., adjusted current liabilities

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Current liabilities 8,244 7,238 7,068 7,262 8,856 8,435
Adjustments
Less: Current deferred tax liabilities1 220
Less: Current deferred revenue 826 580 505 448 690 677
Less: Current restructuring program liabilities 57 110 85 470 34 33
After Adjustment
Adjusted current liabilities 7,361 6,548 6,478 6,124 8,132 7,725

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 Current deferred tax liabilities. See details »


Adjustments to Total Liabilities

Twenty-First Century Fox Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Total liabilities 32,269 33,092 32,932 31,244 33,351 30,300
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,553 1,729 1,506 1,570 3,690 3,454
Less: Current deferred tax liabilities2 220
Less: Non-current deferred tax liabilities3 1,892 2,782 2,888 2,082 2,729 2,280
Less: Deferred revenue 826 580 505 448 690 677
Less: Restructuring program liabilities 88 177 136 529 137 162
After Adjustment
Adjusted total liabilities 31,016 31,282 30,909 29,535 33,485 30,635

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current deferred tax liabilities. See details »

3 Non-current deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Twenty-First Century Fox Inc., adjusted total Twenty-First Century Fox, Inc. stockholders’ equity

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Total Twenty-First Century Fox, Inc. stockholders’ equity 19,564 15,722 13,661 17,220 17,418 16,998
Adjustments
Less: Net deferred tax assets (liabilities)1 (1,816) (2,585) (2,610) (1,973) (2,668) (2,223)
Add: Allowances for returns and doubtful accounts 388 537 576 506 815 899
Add: Deferred revenue 826 580 505 448 690 677
Add: Restructuring program liabilities 88 177 136 529 137 162
Add: Redeemable noncontrolling interests 764 694 552 621 541 519
Add: Noncontrolling interests 1,234 1,216 1,220 966 3,483 3,127
After Adjustment
Adjusted total equity 24,680 21,511 19,260 22,263 25,752 24,605

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 Net deferred tax assets (liabilities). See details »


Adjustments to Capitalization Table

Twenty-First Century Fox Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
As Reported
Current borrowings 1,054 457 427 244 799 137
Non-current borrowings 18,469 19,456 19,298 18,795 18,259 16,321
Total reported debt 19,523 19,913 19,725 19,039 19,058 16,458
Total Twenty-First Century Fox, Inc. stockholders’ equity 19,564 15,722 13,661 17,220 17,418 16,998
Total reported capital 39,087 35,635 33,386 36,259 36,476 33,456
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,553 1,729 1,506 1,570 3,690 3,454
Adjusted total debt 21,076 21,642 21,231 20,609 22,748 19,912
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 (1,816) (2,585) (2,610) (1,973) (2,668) (2,223)
Add: Allowances for returns and doubtful accounts 388 537 576 506 815 899
Add: Deferred revenue 826 580 505 448 690 677
Add: Restructuring program liabilities 88 177 136 529 137 162
Add: Redeemable noncontrolling interests 764 694 552 621 541 519
Add: Noncontrolling interests 1,234 1,216 1,220 966 3,483 3,127
Adjusted total equity 24,680 21,511 19,260 22,263 25,752 24,605
After Adjustment
Adjusted total capital 45,756 43,153 40,491 42,872 48,500 44,517

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Net deferred tax assets (liabilities). See details »


Adjustments to Revenues

Twenty-First Century Fox Inc., adjusted revenues

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
As Reported
Revenues 30,400 28,500 27,326 28,987 31,867 27,675
Adjustment
Add: Increase (decrease) in deferred revenue 98 75 57 (242) 13 (203)
After Adjustment
Adjusted revenues 30,498 28,575 27,383 28,745 31,880 27,472

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


Adjustments to Reported Income

Twenty-First Century Fox Inc., adjusted 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
As Reported
Net income attributable to Twenty-First Century Fox, Inc. stockholders 4,464 2,952 2,755 8,306 4,514 7,097
Adjustments
Add: Deferred income tax expense (benefit)1 (903) 89 466 171 (39) 480
Add: Increase (decrease) in allowances for returns and doubtful accounts (149) (39) 70 (309) (84) (87)
Add: Increase (decrease) in deferred revenue 98 75 57 (242) 13 (203)
Add: Increase (decrease) in restructuring program liabilities (89) 41 (393) 392 (25) (87)
Less: Income (loss) from discontinued operations, net of tax (12) (44) (8) (67) 729 277
Add: Other comprehensive income (loss), net of tax 20 132 (582) (1,750) 407 (616)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 301 280 253 17 254 241
After Adjustment
Adjusted net income 3,754 3,574 2,634 6,652 4,311 6,548

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 Deferred income tax expense (benefit). See details »