In this article, let's take a look at Consolidated Edison, Inc. (ED, Financial), a $18.13 billion market cap company that is an electric and gas utility holding company that serves parts of New York, New Jersey and Pennsylvania.
Main business
Its main operations are the regulated electric, gas and steam utility operations of Consolidated Edison Co. of New York and the electric and gas utility operations of Orange and Rockland Utilities. Last year, electric revenues accounted for 70.9% of consolidated sales, gas revenues 14.7%; nonutility revenues 8.9%; and steam revenues 5.5%.
Dividend policy
Since 1885, Johnson & Johnson (JNJ, Financial) 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 4.0%, which we consider it very attractive and is ranked higher than 69% of the 820 Companies in the Utilities - Regulated Electric industry. We think the company will continue growing its dividends, because it has raised them each year for 40 years.
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: β =0.26
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]
rED = RF + βED [GGM ERP]
= 4.9% + 0.26 [11.43%]
= 7.87%
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) | 12/31/2013 | 12/31/2012 | 12/31/2011 |
| Cash dividends declared | 721,000 | 712,000 | 704,000 |
| Net income applicable to common shares | 1,062,000 | 1,141,000 | 10,620,000 |
| Net sales | 12,354,000 | 12,188,000 | 12,886,000 |
| Total assets | 40,647,000 | 41,209,000 | 39,214,000 |
| Total Shareholders' equity | 12,245,000 | 11,869,000 | 11,649,000 |
| Ratios | Â | Â | Â |
| Retention rate | 0 | 0.38 | 0.93 |
| Profit margin | 0.09 | 0.09 | 0.82 |
| Asset turnover | 0.30 | 0.30 | 0.33 |
| Financial leverage | 3.37 | 3.50 | 3.42 |
| Â | Â | Â | Â |
| Retention rate = (Net Income – Cash dividends declared) ÷ Net Income = | 0.32 | ||
| Â | Â | Â | Â |
| Profit margin = Net Income ÷ Net sales = | 0.09 | Â | Â |
| Â | Â | Â | Â |
| Asset turnover = Net sales ÷ Total assets = | 0.30 | Â | Â |
| Â | Â | Â | Â |
| Financial leverage = Total assets ÷ Total Shareholders' equity = | 3.32 | Â | |
| Â | Â | Â | Â |
| Averages | Â | Â | Â |
| Retention rate | 0.54 | Â | Â |
| Profit margin | 0.33 | Â | Â |
| Asset turnover | 0.31 | Â | Â |
| Financial leverage | 3.43 | Â | Â |
| Â | Â | Â | Â |
| g = Retention rate × Profit margin × Asset turnover × Financial leverage | Â | ||
| Â | Â | Â | Â |
| Dividend growth rate | 19.32% | Â | Â |
| Â | Â | Â | Â |
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)
= ($62.37 ×7.87% – $2.52) ÷ ($62.37 + $2.52) = 3.68%.
The growth rates are:
| Year | Value | g(t) |
| 1 | g(1) | 19.32% |
| 2 | g(2) | 15.41% |
| 3 | g(3) | 11.50% |
| 4 | g(4) | 7.59% |
| 5 | g(5) | 3.68% |
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 | 2.52 | Â |
| 1 | Div 1 | 3.01 | 2.79 |
| 2 | Div 2 | 3.47 | 2.98 |
| 3 | Div 3 | 3.87 | 3.08 |
| 4 | Div 4 | 4.16 | 3.07 |
| 5 | Div 5 | 4.32 | 2.95 |
| 5 | Terminal Value | 106.82 | 73.14 |
| Intrinsic value | Â | Â | 88.02 |
| Current share price | Â | Â | 62.37 |
Final comment
Using a margin of safety, one should buy a stock when it is worth more than its price on the market (plus a margin: I recommend 20%). We found that intrinsic value is more than 40% higher than share price, so we can conclude that the stock is undervalued and it makes sense to buy the stock if you trust in the model and assumptions.
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 managers Ray Dalio (Trades, Portfolio), David Dreman (Trades, Portfolio), Paul Tudor Jones (Trades, Portfolio) and Jim Simons (Trades, Portfolio) sold out or reduced their positions on 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.
