Please solve using EXCEL and show the formulas. The answers are shown. I need to understand the formuals

A company just paid a dividend of $3.21 a share. The dividend is expected to grow at 8% a year for the next 5 years and then at 4% afterwards.

Solution:
Div_5	4.72
Div_8	5.31

If the required return on the stock is 12%, what is the estimated market price of the stock?

Solution:
Div_6	4.91
HV_5	61.32
Price	49.20