show work in excel please

1. This question relates to the computation of a firms cost of equity.
   1. Assume the current selling price of a firms stock is: $125. Using the Excel file Dividend Data, compute the firms annualized cost of equity using the Gordon dividend model.

Semi-Annual Period	Dividend per share
1	$0.55
2	$0.55
3	$0.55
4	$0.83
5	$0.83
6	$0.83
7	$0.83
8	$1.03
9	$1.03
10	$1.23
11	$1.23
12	$1.23
13	$1.48
14	$1.48
15	$1.48
16	$1.48
17	$1.78
18	$1.78
19	$1.78
20	$2.03
21	$2.03
22	$2.03
23	$2.03
24	$2.03
25	$2.25
26	$2.25
27	$2.25
28	$2.25
29	$2.65
30	$2.65
31	$2.65
32	$2.65
33	$2.65
34	$2.65
35	$2.65
36	$2.95
37	$2.95
38	$2.95
39	$2.95
40	$3.30
41	$3.30
42	$3.30
43	$3.30
44	$3.70
45	$3.70
46	$3.70
47	$3.70
48	$4.40
49	$4.40
50	$4.40