The Company used for the question is Leggett & Platt. The objective is to compute a companys beta with Excel. You must estimate the companys beta with the estimation period from March 1st, 2019 to March 1 st, 2020. Consequently, you must obtain enough daily historical data from finance.yahoo.com; specifically, you will need to: 1. Retrieve the daily close information for your company (from your group project), the S&P 500 (^GSPC in Yahoo!) and the 13-week T-Bill (^IRX in Yahoo!). Keep the Adj Close as the adjusted closing price at the end of the day. 2. Compute daily returns for the series. a. , = (, ,1)/,1 b. Remember that T-Bills are quoted as annual yield. Hence, for the risk-free rate, it is simply a matter of transforming the annual yield into a daily yield. , = (,/100)/ 365 3. Compute the variables used in the Index Model defined as: ri,t rRF,t = i + i * (rMKT,t rRF,t) + i,t Specifically, create two more columns in Excel, calculate the firms and the markets excess returns over risk-free rate. 4. Run the regression to estimate the coefficients Where ri,t rRF,t is the Y variable, and rMKT,t rRF,t is the X variable, and the firms beta is the coefficient of the X variable. 5. Compute and plot the abnormal returns (). a. Compute required return by CAPM: (,) = , + (, , ) b. Compute abnormal return as = (,) 6. Draw the Security Characteristic Line.