Question

Only part e please

Assume you've generated the following information about the stock of Ben's Banana Splits: The company's latest dividends of $1.68 a share are expected to grow to $1.80 next year, to $1.93 the year after that, and to $2.07 in year 3. After that, you think dividends will grow at a constant 5% rate. a. Use the variable growth version of the dividend valuation model and a required return of 12% to find the value of the stock. b. Suppose you plan to hold the stock for three years, selling it immediately after receiving the $2.07 dividend. What is the stock's expected selling price at that time? As in part a, assume a required return of 12%. c. Imagine that you buy the stock today paying a price equal to the value that you calculated in part a. You hold the stock for three years, receiving dividends as described above. Immediately after receiving the third dividend, you sell the stock at the price calculated in part b. Use the IRR approach to calculate the expected return on the stock over three years. Could you have guessed what the answer would be before doing the calculation? d. Suppose the stock's current market price is actually $24.72. Based on your analysis from part a, is the stock overvalued or undervalued? e. A friend of yours agrees with your projections of Ben's Banana Splits future dividends, but he believes that in three years, just after the company pays the $2.07 dividend, the stock will be selling in the market for $55.10. Given that belief, along with the stock's current market price from part d, calculate the return that your friend expects to earn on the stock over the next three years. a. Using the variable growth version of the dividend valuation model and a required return of 12%, the value of the stock is $ 26.72 (Round to the nearest cent.) b. The stock's expected selling price immediately after receiving the $2.07 dividend is $ 31.02. (Round to the nearest cent.) c. Using the IRR approach, the expected return on the stock over three years is 12 %. (Round to the nearest whole percent.) d. If the stock's current market price is actually $24.72, then the stock is undervalued (Select from the drop-down menu.) %. (Round to the nearest whole percent.) e. The return that your friend expects to earn on the stock over the next three years is

Answer 1

PV of Price =24.72
FV or Price after 3 years =55.10
Dividend year 1 (D1) =1.80
D2 =1.93
D3 =2.07
Total cash flow in year 3 =2.07+55.10 =57.17
Using Financial calculator to calculate rate of return
CF0 =-24.72; CF1=1.80;CF2=1.93;CF=57.17;CPT IRR =36.72%

Rate of return =36.72%

If holding period return is required then =(55.10-24.72+1.80+1.93+2.07)/24.72 =146.36%