7-11 assumed that the average firm in your company's industry is expected to grow at a constant rate of 6% and if its dividend yield is 7%. Your company is about as risky as the average firm in the industry, but 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 = D0 (1+g) = D0 x (1.50)) this year and 25% the following year, after which growth should return to the 6% industry average. If the last dividend paid (D0) was $1.00, what is the value per share of your firm's stock?

please answer in excel

below is the format the professor used

P 8-12

D₀

g₁

g₂

g_n

k

D₁

D₂

D₃

P₂= D₃/(k-g)

P₀