Please use excel and/or excel functions to supplement my learning. Be as clear as possible. Thank you

Bath Communications's stock has a beta of -0.29. Treasuries yield 1.75% and the S&P 500 is expected to rise by 6.25% more than that. What is the expected return for Bath Communications's stock? Suppose Worcester Industrial's stock has a beta of -0.59 and has a target stock price of $505.00 in one year and to pay a dividend of $12.50 at that time. How much is the stock worth today if the expected return for the stock market is 9.00% and treasuries yield 4.25%