2.3 Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the Dividend column. Then calcu- late the dividend yield and place results in the "Yield" column. (a) Which stock had the highest dividend yield? Why do you think this is? (b) Which stock had the highest P/E ratio? Dividend Yield P/E Microsoft Kellogg Duke Energy Wells Fargo Pfizer ($) Price ($) Earnings (EPS) Dividend Payout 96.36 3.66 0.43 60.19 4.24 0.50 73.80 4.97 0.70 53.70 3.84 0.40 35.64 2.16 0.59