Can you provide the step by step guide to solve using excel? thank you

Questions and Problems Section

Problem #1 (Page 229)

Stock ValuesFowler, Inc., just paid a dividend of $2.55 per share on its stock. The dividends are expected to grow at a constant rate of 3.9 percent per year, indefinitely. If investors require a return of 10.4 percent on this stock, what is the current price? What will the price be in 3 years? In15 years?

Problem #8

Valuing Preferred StockSmiling Elephant, Inc., has an issue of preferred stock outstanding that pays a $2.85 dividend every year, in perpetuity. If this issue currently sells for $77.32 per share, what is the required return?

Problem #13

Stock Valuation and PE RatioThe Blooming Flower Co. has earnings of $3.68 per share. The benchmark PE for the company is 18. What stock price would you consider appropriate? What if the benchmark PE were 21?