urgent! how to do it on excell, please.

Equity Valuation - Homework 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