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
- What are free cash flows? What is a quick and dirty method for figuring out free...
- If we are building application that provides service for drivers. I want financial analysis of the...
- Be able to explain how s Stack can be used to determine the validity of parentheses...
- How does the structure of accounting and reporting for a state or local government differ from...
- You have been asked to design a network (wired, wireless, or a combination) for a home...
- A large Portland manufacturer wants to forecast demand for a piece of pollution-control equipment. A review...
- Capital Asset Maintenance Programs: Road Maintenance - Describe the objectives of an audit of the effectiveness...
ADVERTISEMENT