Question

In: Finance

Ivanhoe, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the...

Ivanhoe, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the next two years, then a growth rate of 17 percent for the following two years. After that, a constant-growth rate of 8 percent is expected. The firm expects to pay its first dividend of $2.63 a year from now. If dividends will grow at the same rate as the firm and the required rate of return on stocks with similar risk is 17 percent, what is the current value of the stock? (Round all intermediate calculations and final answer to 2 decimal places, e.g. 15.20.)

Please explain calculations for excel, I cannot figure this one out. TIA.

Solutions

Expert Solution

Data given can be summarized as below

Year 1 Year 2 Year 3 Year 4 Year 5
Growth rate 30% 30% 17% 17% 8%
Dividend $2.63 $3.42 $4.00 $4.68 $5.05
PV of dividend $2.25 $2.50 $2.50 $2.50
Terminal value $56.16
PV of terminal value $29.97
Intrinsic value $39.71

Dividend in year 2 = dividend in year 1 * (1 + growth rate in year 2) = 2.63 * (1 + 30%) = 3.42

Dividend in year 3 = dividend in year 2 * (1 + growth rate in year 3) = 3.42 * (1 + 17%) = 4.00

Dividend in year 4 = dividend in year 3 * (1 + growth rate in year 4) = 4.00 * (1 + 17%) = 4.68

Dividend in year 5 = dividend in year 4 * (1 + growth rate in year 5) = 4.68 * (1 + 8%) = 5.05

PV of year 1 dividend = year 1 dividend / ((1+discount rate) ^ year) = 2.63 / ((1+17%)^1) = 2.25

PV of year 2 dividend = year 2 dividend / ((1+discount rate) ^ year) = 3.42 / ((1+17%)^2) = 2.50

PV of year 3 dividend = year 3 dividend / ((1+discount rate) ^ year) = 4.00 / ((1+17%)^3) = 2.50

PV of year 4 dividend = year 4 dividend / ((1+discount rate) ^ year) = 4.68 / ((1+17%)^4) = 2.50

Terminal value using dividend discount model = next year's dividend (discount rate - dividend growth rate)

= 4.68 * (1 + 8%) / (17% - 8%) = 56.16

PV of terminal value = 56.16 / (1 + 17%)^4 = 29.97

Intrinsic value = PV of dividends + PV of terminal value = 2.25 + 2.50 + 2.50 + 2.50 + 29.97 = 39.71


Related Solutions

Wildhorse, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the...
Wildhorse, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the next two years, then a growth rate of 17 percent for the following two years. After that, a constant-growth rate of 8 percent is expected. The firm expects to pay its first dividend of $2.45 a year from now. If dividends will grow at the same rate as the firm and the required rate of return on stocks with similar risk is 21 percent,...
Sheridan, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the...
Sheridan, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the next two years, then a growth rate of 17 percent for the following two years. After that, a constant-growth rate of 8 percent is expected. The firm expects to pay its first dividend of $2.75 a year from now. If dividends will grow at the same rate as the firm and the required rate of return on stocks with similar risk is 15 percent,...
Blossom, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the...
Blossom, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the next two years, then a growth rate of 17 percent for the following two years. After that, a constant-growth rate of 8 percent is expected. The firm expects to pay its first dividend of $2.25 a year from now. If dividends will grow at the same rate as the firm and the required rate of return on stocks with similar risk is 15 percent,...
2. Wildhorse, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for...
2. Wildhorse, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the next two years, then a growth rate of 17 percent for the following two years. After that, a constant-growth rate of 8 percent is expected. The firm expects to pay its first dividend of $2.35 a year from now. If dividends will grow at the same rate as the firm and the required rate of return on stocks with similar risk is 22...
2. Wildhorse, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for...
2. Wildhorse, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for the next two years, then a growth rate of 17 percent for the following two years. After that, a constant-growth rate of 8 percent is expected. The firm expects to pay its first dividend of $2.35 a year from now. If dividends will grow at the same rate as the firm and the required rate of return on stocks with similar risk is 22...
Ivanhoe Corp. is a fast-growing company whose management expects it to grow at a rate of...
Ivanhoe Corp. is a fast-growing company whose management expects it to grow at a rate of 23 percent over the next two years and then to slow to a growth rate of 17 percent for the following three years. If the last dividend paid by the company was $2.15. What is the dividend for the 1st year? (Round answer to 3 decimal places, e.g. 15.250.) D1: $______ What is the dividend for the 2nd year? (Round answer to 3 decimal...
Growing Real Fast Company (GRF) is expected to have a 25 percent growth rate for the...
Growing Real Fast Company (GRF) is expected to have a 25 percent growth rate for the next four years (effecting D1, D2, D3, and D4). Beginning in year five, the growth rate is expected to drop to 7 percent per year and last indefinitely. If GRF just paid a $2.00 dividend and the appropriate discount rate is 15 percent, then what is the value of a share of GRE? SOLUTION Excel
Growing Real Fast Company (GRF) is expected to have a 25 percent growth rate for the...
Growing Real Fast Company (GRF) is expected to have a 25 percent growth rate for the next four years (affecting D1, D2, D3, and D4). Beginning in year five, the growth rate is expected to drop to 2.4 percent per year and last indefinitely. If GRF just paid a $4.00 dividend and the appropriate discount rate is 17.5 percent, then what is the value of a share of GRF? Enter your answer to two decimal places.
Growing, Inc. is a firm that is experiencing rapid growth. The firm yesterday paid a dividend...
Growing, Inc. is a firm that is experiencing rapid growth. The firm yesterday paid a dividend of $7.10. You believe that dividends will grow at a rate of 16.0% per year for two years, and then at a rate of 10.0% per year thereafter. You expect the stock will sell for $40.42 in two years. You expect an annual rate of return of 23.0% on this investment. If you plan to hold the stock indefinitely, what is the most you...
Smirnoff & Co is facing a rapid growth in earnings and dividends. Management projects that dividends...
Smirnoff & Co is facing a rapid growth in earnings and dividends. Management projects that dividends will grow at a rate of 12% during year 1, 10% during year 2, and 8% during year 3. After that growth slows down to a normal rate of 5%. Company's required return is 9%. Last dividend paid (Do) was $3.50 per share. Find: a. Horizon stock price; b. Intrinsic stock value today. c. Is the stock overpriced or underpriced if the market price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT