1 Two-Stage Dividend Growth Model and H-Model 2 Please use following information and solve the Two-Stage Dividend Discount Model and H-Model Problem 3 Suppose a firm has a current dividend of D(0) = $2.00 which is expected to growth 25% a year for 3 years 4 and thereafter grow at the rate of 5 percent with a discount rate or required rate of return of 15 percent 6 D(0) $2.00 3 7 N 8 G1 9 G2 10 K 25% 5% 15% DK N G1 G2 K 11 12 1 Two-Stage Dividend Discount Model 13 What is the value of the stock? Po 14 P(O) $ 34.07 $34.07 $87.57 Do (1+g₁ k-9₁ 15 16 17 2 H-Model 18 What is the value of the stock? 19 20 Year 1 21 Growth Rate 25.00% Year 2 Year 3 17.50% 9.17% Year 4 0.83% 22 Dividends 23 241 Please do not type any Numbers in the table above You must link the table in Cell A6 to this Table 25 26 First Calculate P(3) $ 34.69 $ 102.88 27 28 PV of D(1) $ 2.17 $ 5.42 29 PV of D(2) $ 2.24 $ 5.57 30 PV of D(3) $ 2.17 $ 5.41 31 PV of P(3) $ 22.81 $ 59.54 32 33 P(0)= $ 29.39 $75.93 34 Show Transcribed Text Need help with formulas, specifically on H model. Correct answers are off to the right side in black (ignore the red). All relevant information is showing. Will thumbs up if answered. Thanks :)

1 Two-Stage Dividend Growth Model and H-Model 2 Please use following information and solve the Two-Stage Dividend Discount Model and H-Model Problem 3 Suppose a firm has a current dividend of D(0) = $2.00 which is expected to growth 25% a year for 3 years 4 and thereafter grow at the rate of 5 percent with a discount rate or required rate of return of 15 percent 6 D(0) $2.00 3 7 N 8 G1 9 G2 10 K 25% 5% 15% DK N G1 G2 K 11 12 1 Two-Stage Dividend Discount Model 13 What is the value of the stock? Po 14 P(O) $ 34.07 $34.07 $87.57 Do (1+g₁ k-9₁ 15 16 17 2 H-Model 18 What is the value of the stock? 19 20 Year 1 21 Growth Rate 25.00% Year 2 Year 3 17.50% 9.17% Year 4 0.83% 22 Dividends 23 241 Please do not type any Numbers in the table above You must link the table in Cell A6 to this Table 25 26 First Calculate P(3) $ 34.69 $ 102.88 27 28 PV of D(1) $ 2.17 $ 5.42 29 PV of D(2) $ 2.24 $ 5.57 30 PV of D(3) $ 2.17 $ 5.41 31 PV of P(3) $ 22.81 $ 59.54 32 33 P(0)= $ 29.39 $75.93 34 Show Transcribed Text Need help with formulas, specifically on H model. Correct answers are off to the right side in black (ignore the red). All relevant information is showing. Will thumbs up if answered. Thanks :)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter11: Determining The Cost Of Capital

Section: Chapter Questions

Problem 5MC

See similar textbooks

Similar questions

Consider the following security: Brous Metalworks Earnings Per Share, Time = 0 $2.00 Dividend Payout Rate 0.250 Return on Equity 0.150 Market Capitalization Rate 0.125 Required: Using the information in the tables above, please calculate the sustainable growth rate, dividends per share, and intrinsic value per share. Then solve for the present value of growth opportunities. (Use cells A5 to B8 from the given information to complete this question.) Brous Metalworks Sustainable Growth Rate Dividends per share (Next Year) Intrinsic Value No-Growth Value Per Share Present Value of Growth Opportunities (PVGO)
1 Two-Stage Dividend Growth Model and H-Model 2 Please use following information and solve the Two-Stage Dividend Discount Model and H-Model Problem 3 Suppose a firm has a current dividend of D(0) = $2.00 which is expected to growth 25% a year for 3 years 4 and thereafter grow at the rate of 5 percent with a discount rate or required rate of return of 15 percent 6 D(0) $2.00 3 7 N 8 G1 9 G2 10 K 25% 5% 15% DK N G1 G2 K 11 12 1 Two-Stage Dividend Discount Model 13 What is the value of the stock? Po 14 P(O) $ 34.07 $34.07 $87.57 Do (1+g₁ k-9₁ 15 16 17 2 H-Model 18 What is the value of the stock? 19 20 Year 1 21 Growth Rate 25.00% Year 2 Year 3 17.50% 9.17% Year 4 0.83% 22 Dividends 23 241 Please do not type any Numbers in the table above You must link the table in Cell A6 to this Table 25 26 First Calculate P(3) $ 34.69 $ 102.88 27 28 PV of D(1) $ 2.17 $ 5.42 29 PV of D(2) $ 2.24 $ 5.57 30 PV of D(3) $ 2.17 $ 5.41 31 PV of P(3) $ 22.81 $ 59.54 32 33 P(0)= $ 29.39 $75.93 34 Show…
Using the discounted devident model answer this question Safaricom's dividend in year 6 is estimated to be 4.5. The return on equity is 10% with a constant dividend growth rate of 5%. Calculate the current market price.
3. A rapidly growing firm is currently paying a dividend of $2.95. The dividend growth rate is expected to be 8% for the next 3 years, 6% for the following 2 years, and 4% annually thereafter. The expected return on the market is 10%, the risk-free rate is 5% and the firm's Beta is 1.20. MULTIPLE GROWTH RATE SCENARIOS EXERCISE 6 CHAPTER 3 a. Calculate the estimated price (intrinsic value) for a share of this firm's stock. b. Use Goal Seek to determine what the current dividend would need to be to yield an estimated price (intrinsic value) of $70.
Dividend (Div) Required return (r) Growth rate (g) Div r-g Now we can try this by introducing constant growth in dividends. A. Dividend is $1.00 per year. Investors require a 10% return. Initially, it is thought there will be 0% dividend growth. B. Dividend is $1.00. Required return is still 10% but investors now expect the dividend will grow 2% per annum. C. Dividend is $1.00 per year. Market optimism drives the required return down to 8% while at the same time a new growth strategy boosts the expected dividend growth rate to 6%. 11 =
Reizenstein Technologies (RT) has just developèd a solar panel capable of generating 200% more electricity than any solar panel currently ón the market. As. result, RT is expected to experience a 15% annual growth rate for the next 5 vear By the end of 5 years, other firms will have developed comparable technology, and RT's growth rate will slow to 5% per year indefinitely. Stockholders require a return of 12% on RT's stock. The most recent annual dividend (Do), which was paid yesterday, was $1.75 per share. a. Calculate RT's expected dividends for t 1, t 2, t 3, t = 4, and t 5. b. Calculate the estimated intrinsic value of the stock today, Po. Proceed by finding the present value of the dividends expected at t 1, t 2, t 3, t = 4, and t = 5 plus the present value of the stock price that should exist at t = 5, P,. The Ps stock price can %3D
Start with the partial model in the file Ch07 P27 Build a Model.xlsx on the textbook’s Web site. Hamilton Landscaping’s dividend growth rate is expected to be 30% in the next year, drop to 15% from Year 1 to Year 2, and drop to a constant 5% for Year 2 and all subsequent years. Hamilton has just paid a dividend of $2.50, and its stock has a required return of 11%. What is Hamilton’s estimated stock price today? If you bought the stock at Year 0, what are your expected dividend yield and capital gains for the upcoming year? What are your expected dividend yield and capital gains for the second year (from Year 1 to Year 2)? Why aren’t these the same as for the first year?
What is the required rate of return on a share whose value is Kshs 62.50, its upcoming dividend is Kshs 5 and the growth rate is 4%?
Case Study 1. Should stockholder wealth maximization be thought of as a long-term or a short-term goal?For example, if one action increases a firm’s stock price from a current level of P40 to P45in 6 months and then to P50 in 5 years but another action keeps the stock at P40 forseveral years but then increases it to P70 in 5 years, which action would be better?
b. Now assume that TTC's period of supernormal growth is to last for 5 years rather than 2 years. How would this affect its price, dividend, yield, and capital gains yield? 1. Find the price today. D₂ 2 2 Year Dividend PV of dividends $1.7455 $1.9041 $2.0772 $2.2661 $2.4721 $1.60 10.0% $59.5547+ $70.0197 - P Dividend yield- Dividend yield- Dividend yield $1.60 Part 2. Finding the expected dividend yield. Dividend yield- Dividend yield- Dividend yield- D₁ $1.920 2.74% Short-run g; for Years 1-5 only. Long-run g; for Year 6 and all following years. 10.0% 7.26% $1.92 Part 3. Finding the expected capital gains yield. Cap. Gain yield-Expected return Cap. Gain yield Cap. Gain yield- Cap. Gain yield Expected return Cap. Gain yield Cap. Gain yield 1 $2.30 " 1 P₁ $70.020 105.5048 Terminal value = Ps= Dividend yield 2.74% 3 $2.76 P. 4 $3.32 Dividend yield 5 $3.98 4.2202 c. What will be TTC's dividend yield and capital gains yield once its period of supernormal growth ends? We used the 5 year…
Using the constant dividend growth model, determine the price change in a share when the required rate of return decreases from 15 to 13 per cent combined with an increase in the dividend growth rate from 5 to 6 per cent. Select one: a. fall more than 50% b. rise less than 50% C. fall less than 50% d. rise more than 50%
a. Determine average annual dividend growth rate over the past 5 years. Using that growth rate, what dividend would you expect the company to pay next year? b. Determine the net proceeds, N, that the firm will actually receive. c. Using the constant-growth valuation model, determine the required return on the company's stock, rg, which should equal the cost of retained earnings, r,. d. Using the constant-growth valuation model, determine the cost of new common stock, r,.