can you answer this question for me please and using excel to answer it ?

You are researching stock investments. The risk-free is 5%. The expected return required by the market for a portfolio with a beta of 1 is 8.0%. According to the capital asset pricing model: a. What is the expected return on the market portfolio? (Round your answer to 1 decimal place.) % b. What would be the expected return on a stock with =0 ? io Suppose you consider buying a share of stock at a price of $100. Based on your research, you forecast the stock to pay a dividend of $9 next year and to sell then for $103. The stock risk has been evaluated at =0.5. c-1. Using the expected return-beta relationship of the CAPM, calculate the fair (i.e., CAPM) rate of return for a stock with a =0.5. (Round your answer to 1 decimal place.) c.2. What do you calculate as the expected rate of return based on your forecast for the stock price and dividend for next year. (Round your answer to 2 decimal places.) 8 c-3. Is the stock overpriced or underpriced (Note: relative to the CAPM fair rate of return)? (overpriced or underpriced)