How do I solve this problem? In Excel.

g Calculating dividend yield What dividend yield would be reported in the financial press for a stock that currently pays a $ 060 dividend per quarter and the most recent stock price wa: $ 42.00 ? Quarterly dividend= $ 0.60 Annual dividend=1 Stock price= $ 42.00 Annual dividend rate= | 10.2% a price of h Calculating the expected dividend, assuming market efficiency What is the expected annual dividend per share for a stock that has a required or expected return of $ 43.00, and a constant expected growth rate of 9.8% ? Required returns 10.2% Expected growth rate= 9.8% Current price $ 43.00 Expected dividend