P$8\mathrm{.}9$: Estimating Beta Using Monthly Stock Return Data: Exhibit P$8\mathrm{.}1$ presents monthly stock returns and the market capitalization of the equity for four companies, as well as the monthly returns for the S&P $500$ and the three factors of the three$-$factor model.Estimate the CAPM betas for each of the four stocks using regression analysis and $60$ months of stock return data and an equally weighted portfolio of the four stocks.Discuss the various statistics from the regression analysis including the statistical significance and $95\%$ confidence interval of each beta.C$.$ Identify any of the companies that have a beta which is reliably $($at the $95\%$ confidence interval$)$ different from the market beta.P$8\mathrm{.}10$: Alternative CAPM$-$Based Equity Cost of Capital Estimates for the Four Companies in Problem $8\mathrm{.}9$:Calculate the cost of equity capital for the four comparable companies in Problem $8\mathrm{.}9$ using the alternative assumptions used to measure the equity cost of capital in Exhibit $8\mathrm{.}15$; in other words, create a table similar to Exhibit $8\mathrm{.}15$ for the four companies in the previous problem. However, do not use the Mayfield estimate of the market risk premium in this example $($for each company you will have four different cost of capital estimatestwo betas $[$adjusted and unadjusted$]$ and two market risk premium estimates$).$P$8\mathrm{.}10$: Estimating Three$-$Factor Risk Factor Betas and Risk Premiums for the Four Companies in Problem$8\mathrm{.}9$: Use the information in Problem $8\mathrm{.}9$ to estimate the three$-$factor risk factor betas for the four companies in Problem $8\mathrm{.}9.$ Use the assumptions in Exhibit $8\mathrm{.}18$ and the other information for this problem and calculate the three$-$factor risk premiums and the CAPM risk premiums for the four companies. Compare these risk premiums to the risk premiums from the CAPM and Bloomberg adjusted betas estimated in Problem $8\mathrm{.}10.$I would appreciate it if I could see this problem done in excel with everything laid out because I am confused. Also I know the Bloomberg rate is $0\mathrm{.}33*0\mathrm{.}67.$