Perfect Fit: Current Market Price Equals Intrinsic Value

Author's Avatar
Dec 17, 2014

In this article, let's take a look at Mattel, Inc. (MAT, Financial), a $10.34 billion market cap company that designs, manufactures and markets toy products through sales to its customers and directly to consumers.

Future plans

The company plans to continue building its core brands and a key action is the innovation of popular toys. Moreover, licensing arrangements and strategic partnerships should help with this objective. Key drivers for the future are new products, expanding in emerging markets as well as making strategic acquisitions.

Returning value to shareholders

Since 1990, the firm has a dividend policy showing its commitment to return cash to investors in the form of dividends as it generates healthy cash flow on a regular basis. The current dividend yield is 5%, which is considered very attractive for dividend investors.

Now, turning our attention to the future direction of the stock, let's take a look at the intrinsic value of this company and try to explain to investors the reasons why it is a good buy or not. In this article, we present a model that is by no means the be-all and end-all for valuation. The purpose is to force investors to evaluate different assumptions about growth and future prospects.

Valuation

In stock valuation models, dividend discount models (DDM) define cash flow as the dividends to be received by the shareholders. Extending the period indefinitely, the fundamental value of the stock is the present value of an infinite stream of dividends according to John Burr Williams.

Although this is theoretically correct, it requires forecasting dividends for many periods, so we can use some growth models like: Gordon (constant) growth model, the Two or Three stage growth model or the H-Model (which is a special case of a two-stage model).With the appropriate model, we can forecast dividends up to the end of the investment horizon where we no longer have confidence in the forecasts and then forecast a terminal value based on some other method, such as a multiple of book value or earnings.

To start with, the Gordon Growth Model (GGM) assumes that dividends increase at a constant rate indefinitely.

This formula condenses to: V0=(D0 (1+g))/(r-g)=D1/(r-g)

where:

V0 = fundamental value

D0 = last year dividends per share of Exxon's common stock

r = required rate of return on the common stock

g = dividend growth rate

LetĀ“s estimate the inputs for modeling:

Required Rate of Return (r)

The capital asset pricing model (CAPM) estimates the required return on equity using the following formula: required return on stockj = risk-free rate + beta of j x equity risk premium

Assumptions:

Risk-Free Rate: Rate of return on LT Government Debt: RF = 2.67%. This is a very low rate because of todayĀ“s context. Since 1900, yields have ranged from a little less than 2% to 15%; with an average rate of 4.9%. So I think it is more appropriate to use this rate.

Beta: ƎĀ² =1.27

GGM equity risk premium = (1-year forecasted dividend yield on market index) +(consensus long-term earnings growth rate) ā€“ (long-term government bond yield) = 2.13% + 11.97% - 2.67% = 11.43%[1]

rMAT = RF + ƎĀ²MAT [GGM ERP]

= 4.9% + 1.27 [11.43%]

= 19.42%

Dividend growth rate (g)

The sustainable growth rate is the rate at which earnings and dividends can grow indefinitely assuming that the firmĀ“s debt-to-equity ratio is unchanged and it doesnĀ“t issue new equity.

g = b x ROE

b = retention rate

ROE=(Net Income)/Equity= ((Net Income)/Sales).(Sales/(Total Assets)).((Total Assets)/Equity)

The ā€œPRATā€ Model:

g= ((Net Income-Dividends)/(Net Income)).((Net Income)/Sales).(Sales/(Total Assets)).((Total Assets)/Equity)

LetĀ“s collect the information we need to get the dividend growth rate:

Financial Data (USD $ in millions) 31/12/2013 31/12/2012 31/12/2011
Cash dividends declared 494,371 423,000 317,000
Net income applicable to common shares 904,000 776,000 769,000
Net sales 6,484,892 6,420,881 6,266,037
Total assets 6,439,626 6,526,785 5,671,338
Total Shareholders' equity 3,251,559 3,067,044 2,610,603
Ratios Ƃ Ƃ Ƃ
Retention rate 0 0,45 0,59
Profit margin 0,14 0,12 0,12
Asset turnover 1,01 0,98 1,10
Financial leverage 2,04 2,30 2,16
Ƃ Ƃ Ƃ Ƃ
Retention rate = (Net Income ā€“ Cash dividends declared) Ć· Net Income = 0,45
Ƃ Ƃ Ƃ Ƃ
Profit margin = Net Income Ć· Net sales = 0,14 Ƃ Ƃ
Ƃ Ƃ Ƃ Ƃ
Asset turnover = Net sales Ć· Total assets = 1,01 Ƃ Ƃ
Ƃ Ƃ Ƃ Ƃ
Financial leverage = Total assets Ć· Total Shareholders' equity = 1,98 Ƃ
Ƃ Ƃ Ƃ Ƃ
Averages Ƃ Ƃ Ƃ
Retention rate 0,50 Ƃ Ƃ
Profit margin 0,13 Ƃ Ƃ
Asset turnover 1,03 Ƃ Ƃ
Financial leverage 2,17 Ƃ Ƃ
Ƃ Ƃ Ƃ Ƃ
g = Retention rate Ɨ Profit margin Ɨ Asset turnover Ɨ Financial leverage Ƃ
Ƃ Ƃ Ƃ Ƃ
Dividend growth rate 14,24% Ƃ Ƃ
Ƃ Ƃ Ƃ Ƃ

Because for most companies, the GGM is unrealistic, letĀ“s consider the H-Model which assumes a growth rate that starts high and then declines linearly over the high growth stage, until it reverts to the long-run rate. A smoother transition to the mature phase growth rate that is more realistic.

Dividend growth rate (g) implied by Gordon growth model (long-run rate)

With the GGM formula and simple math:

g = (P0.r - D0)/(P0+D0)

= ($30.58 Ɨ19.42% ā€“ $1.52) Ć· ($30.58 + $1.52) = 13.76%.

The growth rates are:

Year Value g(t)
1 g(1) 14,24%
2 g(2) 14,12%
3 g(3) 14,00%
4 g(4) 13,88%
5 g(5) 13,76%

G(2), g(3) and g(4) are calculated using linear interpolation between g(1) and g(5).

Calculation of Intrinsic Value

Year Value Cash Flow Present value
0 Div 0 1,52 Ƃ
1 Div 1 1,74 1,45
2 Div 2 1,98 1,39
3 Div 3 2,26 1,33
4 Div 4 2,57 1,27
5 Div 5 2,93 1,21
5 Terminal Value 58,88 24,24
Intrinsic value Ƃ Ƃ 30,89
Current share price Ƃ Ƃ 30,58

Final comment

The valuation model indicates there exists a equilibrium, the actual market price equals the intrinsic value, so investors are indifferent between buying or selling a stock. We have covered just one valuation method and investors should not be relied on alone in order to determine a fair (over/under) value for a potential investment.

For the coming years, we continue expecting a promising outlook for this industry. Despite Mattel could become more exposed to a challenging environment, I feel confident on my bullish sentiment.

Hedge fund managers Paul Tudor Jones (Trades, Portfolio), Jim Simons (Trades, Portfolio), Sarah Ketterer (Trades, Portfolio), Joel Greenblatt (Trades, Portfolio), John Hussman (Trades, Portfolio), Jeremy Grantham (Trades, Portfolio), Tom Gayner (Trades, Portfolio) and Brian Rogers (Trades, Portfolio) have added the stock in the third quarter of 2014.

Disclosure: Omar Venerio holds no position in any stocks mentioned.


[1] These values were obtained from BloombergĀ“s CRP function.