12-23 question

part a,b,c

if possible please show on an excel sheet

12-23 The Shrieves Company's most recent EPS was $6.50; EPS was $4.42 five years ago. The company pays out 40 percent of its earnings as dividends, and the stock sells for $36. a. Calculate the past growth rate in earnings. (Hint: This is a five-year growth period.) b. Calculate the next expected dividend per share, D1(D0=0.4($6.50)= $2.60.) Assume that the past growth rate will continue. c. What is the cost of retained earnings, rs, for the Shrieves Company