1. Assume the current selling price of a firms stock is: $55. Using the Excel file Dividend Data, compute the firms cost of equity using the Gordon dividend model:
   1. Using all of the dividend dat
   2. Using the last 3 years of the dividend data.

Date	Dividend per share
5-May-09	0.120
5-Aug-09	0.150
4-Nov-09	0.150
3-Feb-10	0.155
5-May-10	0.165
4-Aug-10	0.170
3-Nov-10	0.176
3-Feb-11	0.181
4-May-11	0.191
3-Aug-11	0.210
3-Nov-11	0.215
3-Feb-12	0.227
3-May-12	0.235
3-Aug-12	0.240
5-Nov-12	0.248
5-Feb-13	0.256
3-May-13	0.280
3-Aug-13	0.284
5-Nov-13	0.297
5-Feb-14	0.303
3-May-14	0.335
3-Aug-14	0.342
5-Nov-14	0.355
5-Feb-15	0.364
3-May-15	0.380
3-Aug-15	0.386
5-Nov-15	0.393
5-Feb-16	0.407
3-May-16	0.430
3-Aug-16	0.450
5-Nov-16	0.475
5-Feb-17	0.515
3-May-17	0.535