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.

Dividend Discount Model (DDM)

Microsoft Excel

In discounted cash flow (DCF) valuation techniques the value of the stock is estimated based upon present value of some measure of cash flow. Dividends are the cleanest and most straightforward measure of cash flow because these are clearly cash flows that go directly to the investor.

Intrinsic Stock Value (Valuation Summary)

Twenty-First Century Fox Inc., dividends per share (DPS) forecast

US$

Microsoft Excel
Year Value DPSt or Terminal value (TVt) Calculation Present value at 15.47%
0 DPS01 0.36
1 DPS1 0.45 = 0.36 × (1 + 26.00%) 0.39
2 DPS2 0.56 = 0.45 × (1 + 23.16%) 0.42
3 DPS3 0.67 = 0.56 × (1 + 20.32%) 0.44
4 DPS4 0.79 = 0.67 × (1 + 17.48%) 0.44
5 DPS5 0.91 = 0.79 × (1 + 14.64%) 0.44
5 Terminal value (TV5) 124.29 = 0.91 × (1 + 14.64%) ÷ (15.47% – 14.64%) 60.54
Intrinsic value of Twenty-First Century Fox Inc. common stock (per share) $62.67
Current share price $49.43

Based on: 10-K (reporting date: 2018-06-30).

1 DPS0 = Sum of the last year dividends per share of Twenty-First Century Fox Inc. common stock. See details »

Disclaimer!
Valuation is based on standard assumptions. There may exist specific factors relevant to stock value and omitted here. In such a case, the real stock value may differ significantly form the estimated. If you want to use the estimated intrinsic stock value in investment decision making process, do so at your own risk.

Required Rate of Return (r)

Microsoft Excel
Assumptions
Rate of return on LT Treasury Composite1 RF 4.82%
Expected rate of return on market portfolio2 E(RM) 13.46%
Systematic risk of Twenty-First Century Fox Inc. common stock βFOX 1.23
 
Required rate of return on Twenty-First Century Fox Inc. common stock3 rFOX 15.47%

1 Unweighted average of bid yields on all outstanding fixed-coupon U.S. Treasury bonds neither due or callable in less than 10 years (risk-free rate of return proxy).

2 See details »

3 rFOX = RF + βFOX [E(RM) – RF]
= 4.82% + 1.23 [13.46% – 4.82%]
= 15.47%

Dividend Growth Rate (g)

Dividend growth rate (g) implied by PRAT model

Twenty-First Century Fox Inc., PRAT model

Microsoft Excel
Average Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (US$ in millions)
Dividends declared 667 668 586 586 568 398
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
Total assets 53,831 50,724 48,365 50,051 54,793 50,944
Total Twenty-First Century Fox, Inc. stockholders’ equity 19,564 15,722 13,661 17,220 17,418 16,998
Financial Ratios
Retention rate1 0.85 0.77 0.79 0.93 0.87 0.94
Profit margin2 14.68% 10.36% 10.08% 28.65% 14.17% 25.64%
Asset turnover3 0.56 0.56 0.56 0.58 0.58 0.54
Financial leverage4 2.75 3.23 3.54 2.91 3.15 3.00
Averages
Retention rate 0.86
Profit margin 17.26%
Asset turnover 0.57
Financial leverage 3.09
 
Dividend growth rate (g)5 26.00%

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 Retention rate = (Net income attributable to Twenty-First Century Fox, Inc. stockholders – Dividends declared) ÷ Net income attributable to Twenty-First Century Fox, Inc. stockholders
= (4,464 – 667) ÷ 4,464
= 0.85

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

3 Asset turnover = Revenues ÷ Total assets
= 30,400 ÷ 53,831
= 0.56

4 Financial leverage = Total assets ÷ Total Twenty-First Century Fox, Inc. stockholders’ equity
= 53,831 ÷ 19,564
= 2.75

5 g = Retention rate × Profit margin × Asset turnover × Financial leverage
= 0.86 × 17.26% × 0.57 × 3.09
= 26.00%

Dividend growth rate (g) implied by Gordon growth model

g = 100 × (P0 × r – D0) ÷ (P0 + D0)
= 100 × ($49.43 × 15.47% – $0.36) ÷ ($49.43 + $0.36)
= 14.64%

where:
P0 = current price of share of Twenty-First Century Fox Inc. common stock
D0 = the last year dividends per share of Twenty-First Century Fox Inc. common stock
r = required rate of return on Twenty-First Century Fox Inc. common stock

Dividend growth rate (g) forecast

Twenty-First Century Fox Inc., H-model

Microsoft Excel
Year Value gt
1 g1 26.00%
2 g2 23.16%
3 g3 20.32%
4 g4 17.48%
5 and thereafter g5 14.64%

where:
g1 is implied by PRAT model
g5 is implied by Gordon growth model
g2, g3 and g4 are calculated using linear interpoltion between g1 and g5

Calculations

g2 = g1 + (g5 – g1) × (2 – 1) ÷ (5 – 1)
= 26.00% + (14.64% – 26.00%) × (2 – 1) ÷ (5 – 1)
= 23.16%

g3 = g1 + (g5 – g1) × (3 – 1) ÷ (5 – 1)
= 26.00% + (14.64% – 26.00%) × (3 – 1) ÷ (5 – 1)
= 20.32%

g4 = g1 + (g5 – g1) × (4 – 1) ÷ (5 – 1)
= 26.00% + (14.64% – 26.00%) × (4 – 1) ÷ (5 – 1)
= 17.48%