Need to organize answers and show work in Excel

1. An issue of 6% preferred stock with a par value of $50.

Calculate the price of one share of such stock when investors require a rate of return of 7%. ___________

2. An issue of $5 preferred stock with a par value of $50.  

Calculate the yield on such stock if its market price is $42. __________

3. An issue of common stock that paid a dividend yesterday of $2.80.

Calculate the value of one share of this stock to an investor who requires a 10.4% rate of return and who forecasts that the company's dividends will grow at a constant annual rate of 4%. ___________