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 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 steck had the highest P/E ratio? (Jones. 2016-02-29, p. 52) e) Repeat using current information (finance.yahoo.com). What items stand out to you when comparing the older market data with more current market data? Specilially, discuss the changes and levels of the earnings, dividends, yields, and both ratius. a) and b) Yield 2.57% P/E Ratio 11.67 Stack Microsoft Verizon Duke Enery Wells Fargo Pfizer Price $31.39 S38.26 S21.07 $30.86 $21.97 Dividend Earnings Payout Ratio Dividend $2.69 30.0% S0.81 $2.20 75.0% $1.38 70.0% $2.82 25.0% $1.30 55.0% c) Price Dividend Earnings Payout Ratio Dividend $4.50 40.89% SL.84 Yaek 1.35% PE Rates 30,32 $136.42 Stock Microsoft Verizon Duke Energy Wells Fargo Pfizer 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 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 steck had the highest P/E ratio? (Jones. 2016-02-29, p. 52) e) Repeat using current information (finance.yahoo.com). What items stand out to you when comparing the older market data with more current market data? Specilially, discuss the changes and levels of the earnings, dividends, yields, and both ratius. a) and b) Yield 2.57% P/E Ratio 11.67 Stack Microsoft Verizon Duke Enery Wells Fargo Pfizer Price $31.39 S38.26 S21.07 $30.86 $21.97 Dividend Earnings Payout Ratio Dividend $2.69 30.0% S0.81 $2.20 75.0% $1.38 70.0% $2.82 25.0% $1.30 55.0% c) Price Dividend Earnings Payout Ratio Dividend $4.50 40.89% SL.84 Yaek 1.35% PE Rates 30,32 $136.42 Stock Microsoft Verizon Duke Energy Wells Fargo Pfizer