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
- Suppose a company is looking to hedge a risk in the derivatives market. What, fundamentally, is...
- Training and Development assignment. Describe the usage of Computer Based Training (CBT) in McDonald's Company training...
- PUT IN JAVA PROGRAMMING LANGUAGE The Rectangle class: Design a class named Rectangle to represent a...
- Journal article summary on inter-group conflict Peer Reviewed Journal article from past 3 years. Please include...
- "Ethical Considerations" Please respond to the following: Reflect upon the responsibilities placed on auditors by the...
- A Japanese company has a bond outstanding that sells for 93 percent of its ¥100,000 par...
- What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and...
ADVERTISEMENT