AstraZeneca PLC (NYSE:AZN), a $94.71 billion market cap company is a giant in the drug industry and has a trailing P/E ratio that indicates that the stock is relatively undervalued (22.7x vs 41.8x of industry mean). So in this article, let's take a look at a model which is applicable to stable, mature, dividendpaying firms and try to find the intrinsic value of the stock. Although the model has a number of characteristics that make it useful and appropriate for many applications, is by no means the beall and endall 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 HModel (which is a special case of a twostage 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))/(rg)=D1/(rg)
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 stock j = riskfree rate + beta of j x equity risk premium
Assumptions:
RiskFree 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: β =0.64
GGM equity risk premium = (1year forecasted dividend yield on market index) + (consensus longterm earnings growth rate) – (longterm government bond yield) = 2.13% + 11.97%  2.67% = 11.43%[1]
rAZN = RF + βAZN [GGM ERP]
= 4.9% + 0.83 [11.43%]
= 14.39%
Dividend growth rate (g)
The sustainable growth rate is the rate at which earnings and dividends can grow indefinitely assuming that the firm´s debttoequity ratio is unchanged and it doesn´t issue new equity.
g = b x ROE
b = retention rate
ROE can be estimated using Dupont formula: ROE=(Net Income)/Equity= ((Net Income)/Sales).(Sales/(Total Assets)).((Total Assets)/Equity)
The “PRAT” Model: g= ((Net IncomeDividends)/(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) 
Dec. 2013 
Dec. 2012 
Dec. 2011 
Cash dividends declared 
3,461,000 
3,665,000 
3,764,000 
Net income applicable to common shares 
2,571,000 
6,270,000 
9,950,000 
Net sales 
25,711,000 
27,973,000 
33,591,000 
Total assets 
55,899,000 
53,534,000 
52,830,000 
Total Shareholders' equity 
23,224,000 
23,731,000 
23,240,000 
Ratios 

Retention rate 
0.35 
0.42 
0.62 
Profit margin 
0.10 
0.22 
0.30 
Asset turnover 
0.46 
0.52 
0.64 
Financial leverage 
2.38 
2.28 
2.27 
Retention rate = (Net Income – Cash dividends declared) ÷ Net Income = 
0.35 

Profit margin = Net Income ÷ Net sales = 
0.10 

Asset turnover = Net sales ÷ Total assets = 
0.46 

Financial leverage = Total assets ÷ Total Shareholders' equity = 
2.41 

Averages 

Retention rate 
0.23 

Profit margin 
0.21 

Asset turnover 
0.54 

Financial leverage 
2.31 

g = Retention rate × Profit margin × Asset turnover × Financial leverage 

Dividend growth rate 
5.94% 

Because for most companies, the GGM is unrealistic, let´s consider the HModel which assumes a growth rate that starts high and then declines linearly over the high growth stage, until it reverts to the longrun rate. A smoother transition to the mature phase growth rate that is more realistic.
Dividend growth rate (g) implied by Gordon growth model (longrun rate)
With the GGM formula and simple math: g=(P0.r  D0)/(P0+D0)
= ($74.86 ×14.39% – $3.8) ÷ ($74.86 + $3.8) = 8.86%.
The growth rates are:
Year 
Value 
g(t) 
1 
g(1) 
5.94% 
2 
g(2) 
6.67% 
3 
g(3) 
7.40% 
4 
g(4) 
8.13% 
5 
g(5) 
8.86% 
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 
3.80 

1 
Div 1 
4.03 
3.52 
2 
Div 2 
4.29 
3.28 
3 
Div 3 
4.61 
3.08 
4 
Div 4 
4.99 
2.91 
5 
Div 5 
5.43 
2.77 
5 
Terminal Value 
106.95 
54.61 
Intrinsic value 
70.18 

Current share price 
74.86 
Final Comment
We found that the intrinsic value is 6% lower than the share price, so we can say that the stock is overvalued and it makes sense to sell the stock. But, using a margin of safety (usually 20%), we can conclude the stock is fairly valued.
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.
Hedge fund gurus have also been active in the company. Joel Greenblatt (Trades, Portfolio), John Hussman (Trades, Portfolio), David Dreman (Trades, Portfolio) and Murray Stahl (Trades, Portfolio) have taken long position in the stock in the first quarter of 2014.
Disclosure: Omar Venerio holds no position in any stocks mentioned.
[1] This values where obtained from Blommberg´s CRP function.