Now calculate the beta for each stock using Excel's Slope or Linest function to use estimate the slope of the linear regression line, which is beta. Use the S&P 500 index as the market portfolio in finding beta. 5. Now use the CAPM/SML Equation to estimate each stock's required return. Use 8.5% as the required market return and the recent 10-year Treasury rate of 0.85% as the risk- free rate. Would you recommend buying BEST BUY and/or Home Depot if your APR average for each stock from #2 is your expected return? Explain your answer. 6. Construct a graph of the Security Market Line given by the parameters in #5. Point out the SML returns you calculated in #5 on your SML. Also, find and plot BEST BUY's and Home Depot's expected returns from the information given below gathered from their recent Yahoo Finance stock quotes against each stock's beta on your SML graph. Would you recommend buying BEST BUY and/or Home Depot based on this information? Explain your answers. Note: you are evaluating each stock individually, not in comparison in one another. Stock Current Price Estimated Price 1 year from now Annual Expected Dividend (D1) BEST BUY $116.00 Home Depot $280.00 $118.59 $2.20 $6.00 $302.72 7. Now, assume that Home Depot's current price is in equilibrium and is a constant growth stock. What is Home Depot's expected constant growth rate based on your CAPM return? Use price and dividend data from #6. 8. Use the variable dividend growth valuation model to value BEST BUY. Here are the projections. Year 1 dividend 2.40 Dividends are projected to grow 12% annually in years 2 through 4 After year 4, dividends have a projected constant growth rate of 10% Using your Best Buy CAPM required return from # 5, what is your valuation of BEST BUY's common stock today? Would you recommend buying BEST BUY's stock today and why? Use current price in #6 to help aid your recommendation.