please answer using excel snd show work

Hi-Tek is a young start-up company that is currently retaining all of its earnings. The company plans to pay a $2 per share dividend in Year 7 and increase that dividend by 2.2 percent per year thereatter. What is the current share price if the required return is 16 percent? Pricetoday Determine the price of the 7 th year with the sth year dividend) Dividend at 7 th year Price at the 7th year