Question

Your broker offers to sell you some shares of Bahnsen & Co. common stock that paid a dividend of $3.25 yesterday. Bahnsen's dividend is expected to grow at 5% per year for the next 3 years. If you buy the stock, you plan to hold it for 3 years and then sell it. The appropriate discount rate is 9%.

1. Find the expected dividend for each of the next 3 years; that is, calculate D₁, D₂, and D₃. Note that D₀ = $3.25. Round your answer to the nearest cent.
   
   D₁ = $
   D₂ = $
   D₃ = $
   
2. Given that the first dividend payment will occur 1 year from now, find the present value of the dividend stream; that is, calculate the PVs of D₁, D₂, and D₃, and then sum these PVs. Round your answer to the nearest cent. Do not round your intermediate calculations.
   $
   
3. You expect the price of the stock 3 years from now to be $98.76; that is, you expect  to equal $98.76. Discounted at a 9% rate, what is the present value of this expected future stock price? In other words, calculate the PV of $98.76. Round your answer to the nearest cent. Do not round your intermediate calculations.
   $
   
4. If you plan to buy the stock, hold it for 3 years, and then sell it for $98.76, what is the most you should pay for it today? Round your answer to the nearest cent. Do not round your intermediate calculations.
   $
   
5. Use equation below to calculate the present value of this stock.
             
   Assume that g = 5% and that it is constant. Do not round intermediate calculations. Round your answer to the nearest cent.
   $
   
6. Is the value of this stock dependent upon how long you plan to hold it? In other words, if your planned holding period was 2 years or 5 years rather than 3 years, would this affect the value of the stock today, ?
   
   1. No. The value of the stock is not dependent upon the holding period. The value calculated in parts a through d is the value for a 3-year holding period. It is equal to the value calculated in part e. Any other holding period would produce the same value of .
   2. Yes. The value of the stock is dependent upon the holding period. The value calculated in parts a through d is the value for a 3-year holding period. It is not equal to the value calculated in part e. Any other holding period would produce a different value of .
   3. Yes. The value of the stock is dependent upon the holding period due to the fact that the value is determined as the present value of all future expected dividends.
   4. No. The value of the stock is not dependent upon the holding period unless the growth rate remains constant for the foreseeable future.
   5. Yes. The value of the stock is dependent upon the holding period as long as the growth rate remains constant for the foreseeable future.
   
   -Select-

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.