Question

In: Finance

You are evaluating Home Depot (HD) stock. The stock is expected to experience supernormal growth in...

You are evaluating Home Depot (HD) stock. The stock is expected to experience supernormal growth in dividends of 10 percent, g_s, over the next five years. Following this period, dividends are expected to grow at a constant rate of 3.5 percent, g. The stock paid a dividend of $5.5 last year, and the required rate of return on the stock is 12.62 percent. The fair present value of the stock is what?

Solutions

Expert Solution

The value is computed as follows:

= Dividend in year 1 / (1 + required rate of return)1 + Dividend in year 2 / (1 + required rate of return)2 + Dividend in year 3 / (1 + required rate of return)3 + Dividend in year 4 / (1 + required rate of return)4 + Dividend in year 5 / (1 + required rate of return)5 + 1 / (1 + required rate of return)5 [ ( Dividend in year 5 (1 + growth rate) / ( required rate of return - growth rate) ]

= ($ 5.5 x 1.10) / 1.1262 + ($ 5.5 x 1.102) / 1.12622 + ($ 5.5 x 1.103) / 1.12623 + ($ 5.5 x 1.104) / 1.12624 + ($ 5.5 x 1.105) / 1.12625 + 1 / 1.12625 x [ ($ 5.5 x 1.105 x 1.035) / (0.1262 - 0.035) ]

= $ 6.05 / 1.1262 + $ 6.655 / 1.12622 + $ 7.3205 / 1.12623 + $ 8.05255 / 1.12624 + $ 8.857805 / 1.12625 + $ 100.5244317 / 1.12625  

= $ 6.05 / 1.1262 + $ 6.655 / 1.12622 + $ 7.3205 / 1.12623 + $ 8.05255 / 1.12624 + $ 109.3822367 / 1.12625

= $ 81.13 Approximately

Do ask in case of any query


Related Solutions

Assume that Bon Temps is expected to experience supernormal growth of 30% for the next 3...
Assume that Bon Temps is expected to experience supernormal growth of 30% for the next 3 years, then to return to its long-run constant growth rate of 6%. What is the stock’s value under these conditions? What are its expected dividend yield and its capital gains yield in Year 1? In Year 4? Assume the same rate of return is 16% Dividend: Year 0 = $2 Year 1 = $2.12 Year 2 = $2.2472 Year 3 = $2.382
You buy one Home Depot (HD) call option and one HD put option, both with a...
You buy one Home Depot (HD) call option and one HD put option, both with a $215 strike price and a June expiration date. The call premium is $9.25 and the put premium is $23.70. Your maximum loss from this position could be ________. At expiration, you break even if the stock price is equal to _____. 2) JPM stock currently sells for $90. A 6-month call option with strike price of $100 sells for $6.00, and the risk free...
​(Using EBIT-EPS​ break-even analysis) Home​ Depot, Inc.​ (HD), had 1244 million shares of common stock outstanding...
​(Using EBIT-EPS​ break-even analysis) Home​ Depot, Inc.​ (HD), had 1244 million shares of common stock outstanding in​ 2016, whereas Lowes​ Companies, Inc.​ (LOW), had 929 million shares outstanding. Assuming Home​ Depot's 2016 interest expense is ​$919 ​million, Lowes' interest expense is ​$552 ​million, and a 35 percent tax rate for both​ firms, what is their​ break-even level of operating income​ (i.e., the level of EBIT where EPS is the same for both​ firms)? The EBIT indifference level is ​$ nothing....
Energy Console is a new alternative energy company that is expected to experience short-term supernormal dividend...
Energy Console is a new alternative energy company that is expected to experience short-term supernormal dividend growth rates of 50% in year 1, 40% in year 2 and 25% in year 3. After 3 years of supernormal growth, this company dividend is expected to grow at a constant rate of 5%. However, today due to the volatility in the technology stocks, analysts have made downward projection on its short-term growth rates to 15% in year 1, 10% in year 2...
AI intelligence, a new artificial intelligent for medical devices company, is expected to experience short-term supernormal...
AI intelligence, a new artificial intelligent for medical devices company, is expected to experience short-term supernormal dividend growth rates of 20% in year 1, 15% in year 2 and 12% in year 3. After 3 years of supernormal growth, this company dividend is expected to grow at a constant rate of 5%. However, today due to an increased demand for medical devices, analysts have made an upward projection on its short-term growth rates to 35% in year 1, 25% in...
AI intelligence, a new artificial intelligent for medical devices company, is expected to experience short-term supernormal...
AI intelligence, a new artificial intelligent for medical devices company, is expected to experience short-term supernormal dividend growth rates of 20% in year 1, 15% in year 2 and 12% in year 3. After 3 years of supernormal growth, this company dividend is expected to grow at a constant rate of 5%. However, today due to an increased demand for medical devices, analysts have made an upward projection on its short-term growth rates to 35% in year 1, 25% in...
What do home depot customers need from a home improvement planning, shopping and buying experience? How...
What do home depot customers need from a home improvement planning, shopping and buying experience? How do home depot store-based customers differ from non-store customers? How can technology help home depot better meet the needs of all their customers? How does home depot compete in terms of positioning itself as THE destination for all home improvement needs? How can it improve? How has merchandising and category management changed at Home Depot over time? How has home depot’s merchandising strategy be...
What is the focus when evaluating Home Depot asset utilization ratios? This category of ratios evaluates...
What is the focus when evaluating Home Depot asset utilization ratios? This category of ratios evaluates how effectively the company is using its investment in assets to generate sales.
The following frequency distribution shows the monthly stock returns (in percent) for Home Depot for the...
The following frequency distribution shows the monthly stock returns (in percent) for Home Depot for the years 2003 through 2007. (You may find it useful to reference the appropriate table: chi-square table or F table) Monthly Returns Observed Frequency Less than ?5 13 ?5 up to 0 16 0 up to 5 20 5 or more 11 n = 60 SOURCE: www.yahoo.finance.com. Over this time period, the following summary statistics are provided: Mean Median Standard Deviation Skewness Kurtosis 0.31% 0.43%...
An investor has examined Home Depot stock and makes the following predictions for the future: YEAR...
An investor has examined Home Depot stock and makes the following predictions for the future: YEAR 1 2 3 4 DIVIDEND $1.40 $1.57 $1.52 $1.51 The investor believes the selling price in four years will be $79.98. If the investor wants a 15.00% return to hold the stock, what intrinsic value does the investor put on Home Depot today? Answer Format: Currency: Round to: 2 decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT