A | B | C | D | E | F | G | |
1 | Year | 0 | 1 | 2 | 3 | 4 | 5 |
2 | Dividend | 0 | 0 | 2 | 2.76 | 3.8088 | 3.99924 |
3 | Formula | (=2*1.38) | (=2*1.38^2) | (=2*1.38^2)*1.05 | |||
4 | Terminal Value | 28.566 | (=3.99924/(18%-4%) | ||||
5 | Total | 0 | 0 | 2 | 2.76 | 32.3748 | |
Price | $19.81 | NPV(18%,C5:G5) | |||||
Price in year 2 | $25.59 | NPV(18%,E5:G5) | |||||
Price in year 3 | $27.44 | NPV(18%,F5:G5) | |||||
Capital Gain | 7.21% | (27.44-25.59)/25.59 | |||||
Dividend Yield | 10.79% | (=18%-7.21%) |
please show excel formulas Computech Corporation is expanding rapidly and currently needs to retain all of...
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 41% 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...
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.25 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 16%, what is...
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 19% 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 15%, what is...
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 28% 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 12%, what is...
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 30% 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 15%, what is...
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 22% per year-during Years 4 and 5; but after Year 5, growth should be a constant 9% per year. If the required return on Computech is 17%, what is the value of the...
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 26% 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 16%, what is...
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 47% per year - during Years 4 and 5, but after Year 5, growth should be a constant 9% per year. If the required return on Computech is 15%, what is...
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 40% 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 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 50% 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 17%, what is...