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?

Transcribed Image Text:

Microsoft Verizon Duke Energy Wells Fargo Pfizer Price Earnings Payout Dividend Yield P/E 31.392.69 38.26 2.2 21.07 1.38 30.86 2.82 21.97 1.3 0.3 0.75 0.7 0.25 0.55