a)

b)

c)

please use excel and thoroughly show each step/ which formulas to use. im still learning how to use excel so filling in the formulas is a little concusing. please help a sis out. Thank you in advace!!

You are considering investing n a share of Washington Utility preferred stock. The dividend paid each year is $2.25 and you require a rate of 6.71% on the stock. What is the estimated value of this share of preferred stock? Caterpillar Inc paid a yearly dividend this year (time 0) of 1.82; you expect dividends to grow at a rate of 2.4% forever. If you require a rate of 7.9% on Caterpillar stock, what is your estimated price (or value) of a share of Caterpillar stock? McDonald's Corp's common stock paid a dividend of $4.50 in the most recent year (time O). You think McDonald's is in constant growth and expect dividends to grow at a rate of 2.8% forever. If the McDonald's current stock price is $146.77, what rate are investors requiring