Please solve using EXEL and please show the formulas. The answers are shown

A fast growing company is expected to begin paying dividends at the end of year 6. The dividend will be $12.50 per share.

Investors expect the dividend to increase by 10% a year for 3 years. Then by 12% a year for 4 years.

Afterwards, investors expect the dividend to grow at a constant rate of 3%.

What dividend will be paid in year 8? Year 10? Year 12? Year 14?

Solution:
Div_8	15.13
Div_10	18.63
Div_12	23.37
Div_14	26.96

If investors required a return of 8% for this company, what should the market price be?

Solution:
Div_14	26.96
HV_13	539.30
Price	267.18