Assume that the average firm in your companys industry is expected to grow at a constant rate of 6% and that its dividend yield is 7%. Your company is about as risky as the average firm in the industry, but it has just successfully completed some R&D work that leads you to expect that its earnings and dividends will grow at a rate of 50% [D1 = Do (1+g) = Do (1.50)] this year and 25% the following year, after which growth should return to the 6% industry average. If the last dividend paid (Do) was $1, what is the value per share of your firms stock?

Need to do it in excel