Please show me how to do it on Excel.

1. Flowers Specialists pays a current (annual) dividend of $1 and is expected to grow at 30% for the first three years, 15 percent for the following two years, and then at 8% thereafter. If the required return for Flowers Specialists is 10.5%, what is the intrinsic value of Flowers Specialists stock?

2. Millner, Inc., has an odd dividend policy. The company has just paid a dividend of $3 per share and has announced that it will increase the dividend by $5 per share for each of the next five years, and then never pay another dividend. If you require a return of 11 percent on the company's stock, how much will you pay for a share today?

3. Hindsight Bank just issued some new preferred stock. The issue will pay an annual dividend of $20 in perpetuity, beginning 20 years from now. If the market requires a return of 5.8 percent on this investment, how much does a share of preferred stock cost today?

4. FTJ Corporation is expected to pay the following dividends over the next four years: $12, $8, $7, and $2.50. Afterward, the company pledges to maintain a constant 5 percent growth rate in dividends forever. If the required return on the stock is 12 percent, what is the current share price?

1. Flowers Specialists pays a current (annual) dividend of $1 and is expected to grow at 30% for the first three years, 15 percent for the following two years, and then at 8% thereafter. If the required return for Flowers Specialists is 10.5%, what is the intrinsic value of Flowers Specialists stock? 2. Millner, Inc., has an odd dividend policy. The company has just paid a dividend of $3 per share and has announced that it will increase the dividend by $5 per share for each of the next five years, and then never pay another dividend. If you require a return of 11 percent on the company's stock, how much will you pay for a share today? 3. Hindsight Bank just issued some new preferred stock. The issue will pay an annual dividend of $20 in perpetuity, beginning 20 years from now. If the market requires a return of 5.8 percent on this investment, how much does a share of preferred stock cost today? 4. FTJ Corporation is expected to pay the following dividends over the next four years: $12, 58, 57. and $250. Afterward, the company pledges to maintain a constant 5 percent growth rate in dividends forever. If the required return on the stock is 12 percent, what is the current share price