Stock Valuation Question

Suppose you know that a company's stock currently sells for $67 per share and the required return on the stock is 10.8 percent. You also know that the total return on the stock is evenly divided between capital gains yield and divided yield. If it's the company's policy to always maintain a constant growth rate in its dividends, what is the current dividend per share?

I need an excel solution for this question