PLEASE PROVIDE ONLY THE EXCEL FORMULAS NEEDED TO ANSWER THESE QUESTIONS Suppose you know that a company's stock currently sells for $$78$ per share and

the required return on the stock is $10\mathrm{.}9$ percent. You also know that the total

return on the stock is evenly divided between a capital gains yield and

a dividend 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?