Suppose you know a company's stock currently sells for $70 per share and the required return on the stock is 11%. You also know that the total return on the stock is evenly divided between a capital gains yield and a dividend yield. If it is the company's policy to always maintain a constant growth rate in its dividends, what is the current dividend per year? I'm looking for a way to solve this through Excel?