CAN YOU PLEASE DO IT IN EXCEL? THANK YOU.

E F G H 1 J K L 1 Q1: Use the Gordon Model to calculate Chrysler's cost of equity at the end-1996 on the basis of dividends only. nmin 00 A B D CHRYSLER CORPORATION (C) Year-end Dividend Year stock per share price 1986 0.40 1987 0.50 1988 0.50 1989 0.60 1990 0.60 1991 0.30 1992 0.30 1993 0.33 1994 0.45 1995 1.00 1996 35.00 1.40 10 11 12 13 14 15 16 17 18 19 20 21