How would I calculate this problem in Excel?
According to your research, the growth rate in dividends for Arch Coal for the previous 10 years has been 3.5 percent.
If investors feel this growth rate will continue, what is the required return for Arch Coal stock?