Estimating cost of equity using DGM

Estimating Dividend Growth

Year Dividend (from Yahoo) Growth 1+g

Year 2013$0.40

Year 2014$0.50 25.00% 1.2500

Year 2015$0.60 20.00% 1.2000

Year 2016$0.85 41.67% 1.4167

Year 2017$0.65 -23.53%0.7647

Average 15.78% 1.1578

Current Price$10.73

Expected Dividend?

Growth Estimate?

Cost of equity?

This data is for FORD MOTOR. The dividends and growth rate I know is correct. I need help finding EXPECTED DIVIDEND, GROWTH ESTIMATE, and COST OF EQUITY please?

Could this be shown in Excel

Thank you