Start your valuation analysis with the estimation of expected return using CAPM You need 3 inputs to calculate the CAPM expected return 1. An Estimate of the company's Beta Use the daily closing price data for the company and the market index (provided on Canvas) to calculate daily holding period yields for the most recent five years. Using this data, you can estimate raw beta by using regression analysis from functions in Excel. Attach details of your work as an Appendix. Adiust the Raw Beta usina the formula: Adiusted Beta =(0.67 Raw Beta )+0.33 Start your valuation analysis with the estimation of expected return using CAPM You need 3 inputs to calculate the CAPM expected return 1. An Estimate of the company's Beta Use the daily closing price data for the company and the market index (provided on Canvas) to calculate daily holding period yields for the most recent five years. Using this data, you can estimate raw beta by using regression analysis from functions in Excel. Attach details of your work as an Appendix. Adiust the Raw Beta usina the formula: Adiusted Beta =(0.67 Raw Beta )+0.33