Please show me how you do it on excel as well.

15. A share of Austrana currently costs $67. Its dividend yield is 4.5 percent and its expected capital gains growth rate is 3.5 percent. What is the expected dividend in three years? 16. Analysts expect Danvide, which is shutting down operations over the next 24 months, to pay dividends of $4 in one year, $6 in 18 months, and then finally $12 for their final dividend (in two years). If investors require 15 percent returns, what should be the price of this stock today? 17. BounceHouze will pay a $0.50 dividend at the end of this year. If investors require a 10 percent return and the current stock price is $12, what is the expected long-term growth rate of this company's dividend? 18. A company returns 10 percent annually to shareholders and just paid a dividend of $3. If growth is expected to be constant at 3.5 percent going forward, what price should this stock trade at in six years? 19. A dompany with constant growth is expected to pay a dividend of $4.50 in eight years. If its constant growth rate is 5%, what was its most recent dividend? 20. Two Questions SomeCo will pay its first dividend of $2.50 in one year, after which it will increase its dividends by 3.5 percent per year forever. If required returns are 11 percent 1. What is the current stockprice? 2. What will the price be in two years? 15. A share of Austrana currently costs $67. Its dividend yield is 4.5 percent and its expected capital gains growth rate is 3.5 percent. What is the expected dividend in three years? 16. Analysts expect Danvide, which is shutting down operations over the next 24 months, to pay dividends of $4 in one year, $6 in 18 months, and then finally $12 for their final dividend (in two years). If investors require 15 percent returns, what should be the price of this stock today? 17. BounceHouze will pay a $0.50 dividend at the end of this year. If investors require a 10 percent return and the current stock price is $12, what is the expected long-term growth rate of this company's dividend? 18. A company returns 10 percent annually to shareholders and just paid a dividend of $3. If growth is expected to be constant at 3.5 percent going forward, what price should this stock trade at in six years? 19. A dompany with constant growth is expected to pay a dividend of $4.50 in eight years. If its constant growth rate is 5%, what was its most recent dividend? 20. Two Questions SomeCo will pay its first dividend of $2.50 in one year, after which it will increase its dividends by 3.5 percent per year forever. If required returns are 11 percent 1. What is the current stockprice? 2. What will the price be in two years