please answer through excel. thanks. will upvote

2. Denali is considering investing in one of two stocks. Each stock currently pays a dividend of $1.75. Firm A is expected to grow dividends at 2%, Firm B is expected to grow dividends at 3%. Beta coefficients are .88 and 1.35 respectively. Current treasury yield is 1.6% and S&P 500 annual return is 5.46%. Firm A stock price is $51 and Firm B is $40. a. Calculate the valuation of A and B. b. Which stock would you recommend, and why