(5) Download the historical data for market index during the same sample period and calculate its holding period returns. Since ^GSPC is not available to download directly on yahoo finance, you can use ^SPY instead, which is an ETF for S&P 500 index. Use SPY's holding period returns as market returns, run a regression to estimate the beta of this stock. Y: stock returns . X: market returns.

(6) Once beta is estimated, calculate the expected return of this stock using CAPM. According to CAPM, Expected return = Rf + beta*(Rm-Rf). In this equation, Rf is risk-free rate, the one-year Treasury bill yield is widely considered as the risk-free rate. Rm is historical annualized market return, which can be calculated using average of daily S&P 500 returns in part (5) multiplied by 252.

please provide answer using excel