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...
Carla Vista, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent for...
Carla Vista, 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.26 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...
Nonconstant growth: Tre-Bien, Inc., is a fast-growing technology company. Management projects rapid growth of 30 percent...
Nonconstant growth: Tre-Bien, 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...
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT