Stock Analysis on Net
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.

Common-Size Balance Sheet: Assets 
Quarterly Data

Twenty-First Century Fox Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012
Cash and cash equivalents 32.30 12.99 14.16 13.66 10.99 13.26 12.15 10.99 9.21 9.63 9.15 10.14 8.93 12.15 16.84 18.01 19.09 8.51 9.88 9.98 11.91 12.60 13.07 13.61 12.44 20.12
Receivables, net 12.27 13.44 13.23 12.79 14.29 12.72 12.77 14.24 14.19 12.54 12.94 13.72 14.23 12.57 11.81 12.32 12.67 11.61 11.80 11.42 12.06 10.57 10.72 10.42 12.37 11.12
Inventories, net 5.97 6.98 6.82 6.75 5.93 5.49 6.11 6.74 7.13 6.79 6.80 7.15 6.87 6.22 5.49 5.95 6.13 6.19 5.64 6.13 6.22 6.18 5.46 5.08 5.23 4.79
Other 1.09 1.68 1.71 1.37 1.72 1.20 1.07 1.04 1.39 1.73 2.02 0.71 0.80 0.71 0.57 0.71 0.60 1.02 0.73 0.78 1.19 1.85 1.31 1.25 1.43 1.29
Current assets 51.63% 35.09% 35.91% 34.57% 32.92% 32.67% 32.11% 33.02% 31.92% 30.69% 30.91% 31.72% 30.83% 31.65% 34.72% 36.99% 38.49% 27.33% 28.06% 28.30% 31.38% 31.20% 30.56% 30.36% 31.47% 37.31%
Receivables, net 1.30 1.64 1.34 1.36 1.38 1.31 1.07 1.06 1.00 0.96 0.80 0.94 0.85 0.80 0.79 0.81 0.88 0.88 0.83 0.82 0.78 0.85 0.86 0.63 0.72 0.78
Investments 1.26 8.51 7.64 7.88 8.26 7.82 7.69 7.26 7.35 8.05 7.99 8.44 8.43 9.16 9.05 8.62 8.40 6.82 5.22 5.26 6.74 7.17 7.27 9.67 11.86 7.92
Inventories, net 12.34 14.24 13.97 14.82 15.20 15.41 14.69 15.24 15.39 15.21 14.56 14.43 14.17 14.21 12.81 12.48 12.09 12.33 11.76 11.83 11.19 10.79 10.54 7.30 8.01 8.10
Property, plant and equipment, net 2.99 3.58 3.63 3.45 3.48 3.42 3.51 3.34 3.37 3.43 3.50 3.37 3.47 3.47 3.44 3.29 3.26 5.11 5.35 5.32 5.38 5.42 5.55 8.74 9.33 9.77
Intangible assets, net 9.06 11.07 11.33 11.44 11.78 12.09 12.96 12.98 13.48 13.81 14.01 13.62 14.06 13.05 12.63 12.37 12.21 14.31 14.73 15.00 12.32 12.48 9.94 12.16 11.39 11.94
Goodwill 19.36 23.40 23.72 23.70 24.20 24.56 25.22 25.12 25.85 26.20 26.33 25.85 26.44 26.07 25.00 24.28 23.64 32.19 32.95 32.41 31.07 30.73 33.87 29.40 25.30 22.10
Other non-current assets 2.04 2.49 2.45 2.77 2.78 2.72 2.75 1.97 1.65 1.66 1.90 1.63 1.75 1.58 1.57 1.14 1.04 1.03 1.11 1.06 1.14 1.35 1.41 1.73 1.92 2.07
Non-current assets 48.37% 64.91% 64.09% 65.43% 67.08% 67.33% 67.89% 66.98% 68.08% 69.31% 69.09% 68.28% 69.17% 68.35% 65.28% 63.01% 61.51% 72.67% 71.94% 71.70% 68.62% 68.80% 69.44% 69.64% 68.53% 62.69%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-K (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-K (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-K (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-Q (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-K (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-Q (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-K (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-Q (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30).

Cash and cash equivalents
The proportion of cash and cash equivalents relative to total assets displayed notable fluctuations over the observed periods. Starting around 20% in September 2012, it generally declined to below 10% by mid-2014. A significant increase occurred by the end of 2014, reaching over 19%, followed by a gradual decline through 2015 and 2016, stabilizing around 9–13%. Notably, by the end of 2018, there was a sharp increase to 32.3%, indicating a substantial rise in liquid assets.
Receivables, net
Receivables as a percentage of total assets fluctuated between approximately 10% and 14.5% across the measured quarters. The trend shows relative stability with minor cyclical variations, peaking near 14.3% in late 2015 and again in 2017, and slightly declining toward the end of 2018, settling near 12.3%. This suggests steady management in receivables without significant buildup or reduction.
Inventories, net (current)
The net inventories as a percentage of total assets exhibited moderate fluctuations, generally maintaining between 5% and 7% in the early years up to 2015. From 2015 onward, a gradual upward trend is observed, peaking around 7.15% in early 2016, with some decreases afterward but mostly stable around 6–7%, indicating a steady investment in inventory assets.
Other current assets
This category contributed a small portion of total assets throughout the periods, fluctuating modestly between 0.57% and 2%. No clear upward or downward trend stands out, with occasional spikes such as in mid-2016 where the figure reached slightly above 2%, possibly due to short-term operational or strategic activities.
Current assets (total)
Total current assets as a percentage of total assets showed uneven changes, with an initial drop from 37.31% in late 2012 to around 27% by mid-2014. A sharp increase toward the end of 2014 brought the proportion above 38%, followed by gradual decline to about 30% through 2015 and 2016, and a recovery trend leading up to over 35% in late 2018. The pronounced peak at the end of 2018 aligns with the major rise in cash and equivalents, suggesting an emphasis on liquidity.
Receivables, net (non-current)
Non-current receivables remained a minimal portion of total assets, consistently below 2% throughout the periods. A slight upward trend is visible post-2015, with values rising from below 1% to 1.6% by late 2018. This increase could reflect a growing focus on longer-term receivables or financing arrangements.
Investments
The investment portion showed volatility, initially at around 8% in 2012, peaking to nearly 12% by the end of 2012, then generally declining or stabilizing between 5% and 9% from 2013 to 2018, except for a marked decline to 1.26% at the final period in 2018. This sudden decrease suggests a considerable divestment or reclassification of investments near the end of the observation period.
Inventories, net (non-current)
The non-current inventories proportion steadily increased from about 8% in 2012 to a peak near 15.4% in late 2017, before gradually declining to around 12.3% by the end of 2018. This growth phase suggests an accumulation of longer-term inventory holdings, possibly related to production or strategic stockpiling, followed by a moderate drawdown.
Property, plant and equipment, net
This asset category steadily decreased its share of total assets from about 9.8% in 2012 to roughly 3% by the end of 2018. The decline was rapid between 2012 and 2014, followed by relative stability near 3.5% to 3% in subsequent years, suggesting significant disposals or depreciation outpacing additions in fixed assets.
Intangible assets, net
Intangible assets fluctuated between approximately 9% and 15%, with a notable peak around 15% during 2013-2014. Thereafter, a gradual decline is observable through to 2018, ending near 9%, indicating amortization or impairment effects, or possibly divestiture of intangible assets.
Goodwill
Goodwill as a percentage of total assets experienced a marked increase from 22% in late 2012 peaking to nearly 34% mid-2013, then falling sharply to about 24% by late 2017 and continuing downward to 19.36% by the end of 2018. This pattern indicates significant acquisition activity followed by write-downs or disposals of goodwill assets.
Other non-current assets
This category remained relatively minor, fluctuating somewhat between 1% and 2.75%, with increased proportions observed in 2017 before declining toward 2% at the end of 2018. The trend indicates stable minor allocations without major strategic changes.
Non-current assets (total)
Total non-current assets remained the majority of total assets, ranging mainly between approximately 61% and 72% in earlier years, with a decline at the end of the dataset to 48.37%. The initial stability indicates a strong base of long-term assets, while the final decline corresponds with changes in goodwill, investments, and property assets, suggesting notable restructuring or asset sales.
Total assets (constant)
As expected, total assets represented 100% throughout all periods, providing the basis for the relative analysis of asset composition detailed above.