Dyer Furniture is expected to pay a dividend of D1 = $1.25 per share at the end of the year, and that dividend is expected to grow at a constant rate of 6.00% per year in the future. The company's beta is 1.15, the market risk premium is 5.50%, and the risk-free rate is 4.00%. What is Dyer's current stock price? Answer: 28.90

I NEED TO SEE EACH AND EVERY STEP USING EXCEL PLEASE SHOW ME WHICH FORMULA TO USE AND HOW TO INPUT