Question

In: Finance

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.

Solutions

Expert Solution

Ans 50.00

Year Project Cash Flows (i) DF@ 15% DF@ 15% (ii) PV of Project A ( (i) * (ii) )
1 1.40 1/((1+15%)^1) 0.870                               1.22
2 1.57 1/((1+15%)^2) 0.756                               1.19
3 1.52 1/((1+15%)^3) 0.658                               1.00
4 1.51 1/((1+15%)^4) 0.572                               0.86
4 79.98 1/((1+15%)^4) 0.572                             45.73
PV                             50.00

Related Solutions

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%...
As an investor, discuss which company Home Depot or Lowes would choose to invest in and...
As an investor, discuss which company Home Depot or Lowes would choose to invest in and provide a rationale for your decision. Support your conclusions, why or why not?
As an investor, discuss which company Home Depot or Lowes would choose to invest in and...
As an investor, discuss which company Home Depot or Lowes would choose to invest in and provide a rationale for your decision. Support your conclusions, why or why not?
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?
Home Depot has been buying back a lot of it's stock.. Please explain why and do...
Home Depot has been buying back a lot of it's stock.. Please explain why and do you think this is a good move by Home Depot?
Home Depot has been presented with an investment opportunity that will yield end-of-year cash flows of...
Home Depot has been presented with an investment opportunity that will yield end-of-year cash flows of $45,000 per year in years 1 through 4, $38,000 per years 5 through 9, and $42,000 in year 10. This investment will cost the firm $185,000 today, and the firm's cost of capital is 6%. What is the NPV for this investment? Please include formula and numbers used.
You purchased shares in Home Depot at the beginning of the year for $55 a share....
You purchased shares in Home Depot at the beginning of the year for $55 a share. Home Depot paid a $3 dividend throughout the year, and its share price ended the year at $50. If inflation that year was 3%, what was the real holding-period return for the year? Multiple Choice -6.44% -6.36% -11.74% -3.64%
Home & Gardening Depot makes decorative flower pots using three consecutive processes: Moulding, Baking & Spraying....
Home & Gardening Depot makes decorative flower pots using three consecutive processes: Moulding, Baking & Spraying. Costs incurred in the Baking Department during June are summarized as follows: June 1 bAL $0 ........................................... From Moulding 2000 665,200 Direct Material Added 195,200 Direct Manufacturing wages 204,240 Manufacturing Overhead Applied 306,360 Normal losses are estimated to be 5% of input during the period. Inspection takes place during the processing operation, at which point bad units are separated from good units and sold...
Home & Gardening Depot makes decorative flower pots using three consecutive processes: Moulding, Baking & Spraying....
Home & Gardening Depot makes decorative flower pots using three consecutive processes: Moulding, Baking & Spraying. Costs incurred in the Baking Department during June are summarized as follows: WIP – Process 2 A/C Debit Credit June 1 bAL $0 From Moulding    2000 $665,200 Direct Material Added    $195,200 Direct Manufacturing wages    $204,240 Manufacturing Overhead Applied    $306,360 Normal losses are estimated to be 5% of input during the period. Inspection takes place during the processing operation, at which...
What is the YTM of a Home Depot bond that has a 3.5% coupon, 10 years...
What is the YTM of a Home Depot bond that has a 3.5% coupon, 10 years to maturity, is priced at $981.50 and pays interest annually. please show steps in excel
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT