Question
In: Finance
Excel Online Structured Activity: Nonconstant growth Computech Corporation is expanding rapidly and currently needs to retain...
Excel Online Structured Activity: Nonconstant growth
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $1.00 coming 3 years from today. The dividend should grow rapidly - at a rate of 43% per year - during Years 4 and 5; but after Year 5, growth should be a constant 9% per year. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
If the required return on Computech is 17%, what is the value of the stock today? Round your answer to the nearest cent. Do not round your intermediate calculations.
$
| Nonconstant growth | ||||||||
| Year 3 Dividend, D3 | $1.00 | |||||||
| Supernormal growth rate, gs | 43.00% | |||||||
| Normal growth rate, gn | 9.00% | |||||||
| Required return, rs | 17.00% | |||||||
| 43.00% | 43.00% | 9.00% | ||||||
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Dividends | 0 | 0 | $1.00 | |||||
| P5 | ||||||||
| Cash flows to common stockholders | 0 | 0 | ||||||
| PV of cash flows to common stockholders | ||||||||
| Stock Price, P0 | ||||||||
| Alternatively, using Excel NPV function: | ||||||||
| Stock Price, P0 |
Solutions
jeff jeffy answered 1 year agoRelated Solutions
NONCONSTANT GROWTH Computech Corporation is expanding rapidly and currently needs to retain all of its earnings;...
NONCONSTANT GROWTH Computech Corporation is expanding rapidly
and currently needs to retain all of its earnings; hence, it does
not pay dividends. However, investors expect Computech to begin
paying dividends, beginning with a dividend of $0.50 coming 3 years
from today. The dividend should grow rapidly—at a rate of 35% per
year—during Years 4 and 5, but after Year 5, growth should be a
constant 7% per year. If the required return on Computech is 13%,
what is the value...
NONCONSTANT GROWTH Computech Corporation is expanding rapidly and currently needs to retain all of its earnings;...
NONCONSTANT GROWTH Computech Corporation is expanding rapidly
and currently needs to retain all of its earnings; hence, it does
not pay dividends. However, investors expect Computech to begin
paying dividends, beginning with a dividend of $0.75 coming 3 years
from today. The dividend should grow rapidly-at a rate of 28% per
year-during Years 4 and 5; but after Year 5, growth should be a
constant 5% per year. If the required return on Computech is 17%,
what is the value...
Nonconstant growth Microtech Corporation is expanding rapidly and currently needs to retain all of its earnings;...
Nonconstant growth
Microtech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Microtech to begin paying dividends,
beginning with a dividend of $1.25 coming 3 years from today. The
dividend should grow rapidly - at a rate of 49% per year - during
Years 4 and 5; but after Year 5, growth should be a constant 6% per
year. If the required return on Microtech is 18%,...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $1.75 coming 3 years from today. The
dividend should grow rapidly - at a rate of 19% per year - during
Years 4 and 5; but after Year 5, growth should be a constant 6% per
year.
If the required return on Computech is 18%, what is...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $1.75 coming 3 years from today. The
dividend should grow rapidly at a rate of 26% per year-during Years
4 and 5; but after Year 5, growth should be a constant 4% per year.
If the required return on Computech is 16%, what is the value of...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $1.50 coming 3 years from today. The
dividend should grow rapidly-at a rate of 35% per year-during Years
4 and 5; but after Year 5, growth should be a constant 8% per year.
If the required return on Computech is 14%, what is the value of
the...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $1.00 coming 3 years from today. The
dividend should grow rapidly at a rate of 50% per year-during Years
4 and 5; but after Year 5, growth should be a constant 4% per year.
If the required return on Computech is 15%, what is the value of...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $0.50 coming 3 years from today. The
dividend should grow rapidly-at a rate of 43% per year-during Years
4 and 5; but after Year 5, growth should be a constant 8% per year.
If the required return on Computech is 18%, what is the value of
the...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $1.50 coming 3 years from today. The
dividend should grow rapidly - at a rate of 46% per year - during
Years 4 and 5; but after Year 5, growth should be a constant 6% per
year. The data has been collected in the Microsoft Excel Online...
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...
Computech Corporation is expanding rapidly and currently needs
to retain all of its earnings; hence, it does not pay dividends.
However, investors expect Computech to begin paying dividends,
beginning with a dividend of $1.75 coming 3 years from today. The
dividend should grow rapidly - at a rate of 24% per year - during
Years 4 and 5; but after Year 5, growth should be a constant 5% per
year. The data has been collected in the Microsoft Excel Online...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Discuss database constraints: Primary key, check, and referential integrity constraints? Give an example for each. What...
- Can this code be rewritten but keeping the same functions as the original and with detailed...
- Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects for A-Z Motorcars....
- Write your thoughts on this discussion In regard to this week’s forum post and the information...
- C# ( asp.net ) 2019 visual studio I have a dropdown option. If I choose "date"...
- Describe and discuss the main elements of the Entity-Relationship (E-R) model. Include an example. Briefly describe...
- 1. One of the biggest social changes to affect the future of management is the fact...
ADVERTISEMENT