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. → Adjust the Raw Beta using the formula: Adjusted Beta =(0.67× Raw Beta )+0.33 2. The Risk-Free Rate of Return Use the 10-year Australian Government bond yield as the Risk-Free Rate. This yield can be found on Eikon page AU10YT=RR. Take the current Bid yield (do not use the bond price). 3. The Market Return Use this estimate of the market return E(RM):8.90% (Source: Canstar) → The CAPM required return should be used as the discount rate in your valuation models