Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the Dividend column. Then calculate 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? Price Earnings (EPS) Dividend Payout Dividend Yield P/E Microsoft 31.39 2.69 0.30 Verizon 38.26 2.2 0.75 Duke Energy 21.07 1.38 0.70 Wells Fargo 30.86 2.82 0.25 Pfizer 21.97 1.3 0.55