Stock Analysis on Net

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

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity 
Quarterly Data

Twenty-First Century Fox Inc., common-size consolidated balance sheet: liabilities and stockholders’ equity (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
Current borrowings 1.35 1.60 1.96 2.85 1.19 1.36 0.90 0.21 0.16 0.93 0.88 0.96 1.01 0.51 0.49 0.44 0.43 1.49 1.46 1.44 1.66 0.26 0.27 0.23 0.44 0.46
Accounts payable, accrued expenses and other current liabilities 4.91 6.20 6.03 7.37 6.98 7.62 6.80 7.56 6.41 7.07 6.58 7.77 6.98 7.35 7.87 7.50 6.89 8.01 7.63 8.02 8.36 8.95 8.70 8.80 8.38 9.41
Participations, residuals and royalties payable 2.77 3.00 3.25 3.12 3.32 3.08 3.27 3.28 3.28 3.23 3.46 3.77 3.70 3.44 3.26 3.27 3.35 3.06 2.82 3.40 3.36 3.12 3.26 2.80 3.03 3.12
Program rights payable 1.72 2.11 2.54 2.19 2.38 2.36 2.15 2.43 2.60 2.77 2.65 3.08 2.28 2.32 2.00 2.43 2.07 2.95 2.99 3.47 3.04 3.04 2.99 2.59 2.65 2.17
Deferred revenue 1.30 1.40 1.53 1.33 1.36 1.29 1.14 1.23 1.26 1.26 1.04 1.21 1.13 0.95 0.90 0.91 1.01 1.23 1.26 1.23 1.37 1.44 1.33 1.72 1.85 1.68
Current liabilities 12.04% 14.31% 15.31% 16.86% 15.24% 15.71% 14.27% 14.71% 13.72% 15.26% 14.61% 16.80% 15.11% 14.57% 14.51% 14.55% 13.75% 16.74% 16.16% 17.57% 17.80% 16.81% 16.56% 16.14% 16.35% 16.83%
Non-current borrowings 27.81 33.72 34.31 34.20 36.25 36.79 38.36 39.04 40.26 39.14 39.90 39.13 40.03 39.10 37.55 36.64 35.90 35.45 33.32 33.02 31.13 32.69 32.04 23.82 25.79 27.12
Other liabilities 5.84 7.17 6.81 7.04 6.95 7.02 7.13 7.55 7.73 7.77 7.60 6.55 6.63 6.44 6.20 6.52 6.45 6.43 6.40 5.61 6.17 5.98 6.41 6.25 6.69 6.19
Deferred income taxes 2.99 3.58 3.51 3.03 3.07 5.38 5.48 5.41 5.51 5.72 5.97 4.90 4.73 4.75 4.16 4.21 3.38 4.68 4.98 4.92 4.89 5.11 4.48 4.30 3.90 3.90
Non-current liabilities 36.64% 44.46% 44.63% 44.27% 46.27% 49.20% 50.97% 52.00% 53.50% 52.64% 53.48% 50.58% 51.39% 50.28% 47.92% 47.36% 45.73% 46.56% 44.70% 43.55% 42.19% 43.79% 42.92% 34.37% 36.39% 37.21%
Total liabilities 48.68% 58.77% 59.95% 61.12% 61.51% 64.91% 65.24% 66.71% 67.21% 67.90% 68.09% 67.39% 66.50% 64.85% 62.42% 61.91% 59.48% 63.30% 60.87% 61.12% 59.99% 60.59% 59.48% 50.51% 52.74% 54.04%
Redeemable noncontrolling interests 0.87 1.01 1.42 1.41 1.35 1.34 1.37 1.22 1.17 1.14 1.14 1.04 1.28 1.28 1.24 1.24 1.04 0.99 0.99 0.97 0.98 0.98 1.02 0.94 1.03 1.09
Class A common stock, $0.01 par value per share 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.03 0.02 0.03 0.02 0.03 0.03 0.03 0.03 0.03 0.03 0.02 0.02 0.03
Class B common stock, $0.01 par value per share 0.01 0.01 0.01 0.01 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 0.01 0.02 0.02 0.02 0.01 0.01 0.01
Additional paid-in capital 19.08 22.99 23.43 23.21 23.44 23.73 24.46 24.22 24.84 25.16 25.25 25.39 26.14 26.66 26.83 26.50 26.78 27.18 27.45 27.49 28.87 29.29 31.09 23.22 25.34 26.84
Retained earnings 32.32 19.26 16.60 15.05 14.43 11.18 10.48 9.71 9.10 7.69 7.39 7.74 8.01 8.71 10.68 11.98 13.61 3.90 4.36 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Accumulated other comprehensive loss -2.85 -4.32 -3.72 -3.15 -3.12 -3.61 -3.98 -4.33 -4.84 -4.49 -4.43 -3.79 -4.03 -3.58 -3.14 -3.59 -2.80 -1.38 -0.06 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Retained earnings and accumulated other comprehensive income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.05 4.20 3.15 2.23 20.64 19.49 17.13
Total Twenty-First Century Fox, Inc. stockholders’ equity 48.58% 37.97% 36.34% 35.15% 34.79% 31.34% 31.00% 29.63% 29.14% 28.39% 28.25% 29.38% 30.16% 31.84% 34.40% 34.94% 37.63% 29.73% 31.79% 31.58% 33.12% 32.48% 33.37% 43.90% 44.87% 44.01%
Noncontrolling interests 1.87 2.25 2.29 2.32 2.35 2.41 2.40 2.44 2.47 2.57 2.52 2.19 2.06 2.03 1.93 1.91 1.85 5.99 6.36 6.33 5.91 5.95 6.14 4.65 1.36 0.86
Total equity 50.44% 40.22% 38.64% 37.47% 37.14% 33.74% 33.39% 32.07% 31.61% 30.96% 30.77% 31.57% 32.22% 33.87% 36.33% 36.85% 39.48% 35.71% 38.15% 37.91% 39.03% 38.43% 39.50% 48.55% 46.23% 44.87%
Total liabilities and equity 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).


Current borrowings
Current borrowings as a percentage of total liabilities and equity fluctuated between approximately 0.16% and 2.85% over the periods, showing slightly higher volatility in recent quarters with a peak in early 2018 followed by a modest decline.
Accounts payable, accrued expenses and other current liabilities
This category exhibited a general decline over the timeline, starting near 9.41%, decreasing to under 5% by the end of 2018, indicating a gradual reduction in these short-term obligations relative to total liabilities and equity.
Participations, residuals and royalties payable
Values remained relatively stable, fluctuating mildly around the 3% mark, with minor variations but no strong trend, suggesting consistent levels of these payables relative to the company’s capital structure.
Program rights payable
The percentage showed some variation, rising to just above 3% at times but trending downward after 2014, falling to around 1.7% by late 2018, indicating a decrease in this liability component relative to the total.
Deferred revenue
Deferred revenue remained fairly steady, generally slightly above 1% until a slight increase occurred near the end of the timeline, reaching around 1.5%, suggesting modest growth in unearned revenue liabilities.
Current liabilities
Current liabilities fluctuated across the period, peaking close to 17% early on, then generally declining to around 12% by the end of 2018, indicating a reduction in short-term obligations in proportion to the company's total capital base.
Non-current borrowings
Non-current borrowings showed a marked increase from about 23.8% in early 2013 to peak above 40% in 2015-2016, followed by a gradual decline to under 28% at the end of 2018. This pattern reflects significant borrowing activity followed by a deleveraging trend.
Other liabilities
This category showed slight fluctuations mostly between 5.6% and 7.8%, with no clear long-term trend, indicating stable proportions relative to total liabilities and equity.
Deferred income taxes
Deferred income taxes increased from under 4% in 2012 to approximately 5.5%-6% during 2015-2016, then declined to around 3% by late 2018, showing some variability likely related to tax planning or timing differences.
Non-current liabilities
Non-current liabilities rose substantially from about 34% in early 2013 to a high above 53% in 2016, before decreasing sharply to under 37% by the end of 2018, reflecting a significant shift in the long-term debt and other obligations over time.
Total liabilities
Total liabilities peaked at around 67% mid-2016, then showed a steady decline to below 49% by late 2018. This indicates a notable reduction in the company’s leverage or obligations relative to total capitalization during the later years.
Redeemable noncontrolling interests
This metric held steady near 1% across most periods, with a minor peak over 1.4% in early 2018 before declining to under 1% by the end of 2018, showing limited impact on the overall capital structure.
Stock components and capital accounts (Class A and Class B common stock, Additional paid-in capital)
Class A and Class B common stock percentages remained negligible and stable at around 0.01% to 0.03%. Additional paid-in capital peaked near 31% in mid-2013, then gradually decreased to about 19% by late 2018, reflecting changes in equity contributions or reclassifications.
Retained earnings
Retained earnings show a rising trend from the earliest available data point in 2014 (around 4.4%) to over 32% by late 2018, indicating substantial accumulation of profits or earnings retained within the company.
Accumulated other comprehensive loss
The accumulated other comprehensive loss increased in magnitude (negative values growing from around -0.06% to about -4.8%) before receding slightly to approximately -2.85%, indicating volatility in unrealized losses or other comprehensive components.
Total stockholders’ equity and total equity
Total equity as a proportion of total liabilities and equity showed considerable variation, initially near 45% in 2012, dipping below 32% during 2014-2016, and then rising steadily to about 50% by the end of 2018. This trend suggests a strengthening equity position and reduced leverage over time.