Hi, i have a finance problem that i cannot fix. Heres the issue:

Colgate-Palmolive Company has just paid an annual dividend of $0.96. Analysts are predicting an 11% per year growth rate in earnings over the next five years. After then, Colgate's earnings are expected to grow at the current industry average of 5.2% per year. If Colgate's equity cost of capital is 8.5% per year and its dividend payout ratio remains constant, what price does the dividend-discount model predict Colgate stock should sell for?

Im trying to solve it in excel. Hope u can help.

Frederik