Using the Market Price to Calculate Implicit Return in a Multi-Stage Dividend Discount Model
I showed how to estimate the expected annual return implied by the current stock price for the Gordon growth model and the H-model. For more complicated models the return cannot be derived from a single formula, but a spreadsheet model can help an investor quickly figure it out through trial and error.
Back in August I used a three-stage dividend discount model to value Rockwell Automation (ROK). In the model:
The 14% consensus 5-year growth rate was assumed to be a market assumption for the five-year first stage
The growth rate was expected to decline at a linear rate (the H-Model) for 10 years, with a terminal growth rate of 7% (the long-term S&P 500 average growth rate.)
The investor’s required return is 10% and the initial dividend is $1.16. The resulting valuation of $63.25 was fairly close to the $69.00 market price, indicating that those assumptions may be quite close to the expectations of the average investor. We can estimate how close by reversing the model to calculate any input – in this case, we want to see the implied return an investor will earn assuming the growth assumptions are correct.
By plugging in the dividend stream and the formula used to estimate r from the H-model into a spreadsheet, we can first check our math by inputting a 10% return estimate. It comes out to the $63.25 we got the first time, so the math checks.
Since the estimated value is lower than the $69.00 market price, buying at $69 would mean we would earn less than 10%. If we plug in 9%, though, we way overshoot. It gives an present value of $96.24. Obviously the market expectation is much closer to 10% than to 9%.
Let’s try 9.8%.
Getting close, but back on the low side. 9.7%?
Almost there. How about 9.75%?
Virtualy on the nose. If our assumptions that growth will be 14% for five years, then decline linearly for 10 years to a final stable rate of 7% are correct, we can expect to earn about 9.75% per year if we pay $69.00 for ROK.
Posted on 15th October 2007
Under: Investing in Stocks, Valuation | No Comments »




