Calculating the Required Rate of Return using Bloomberg

To do this, you will use the Capital Asset Pricing Model. You will need several pieces of publicly available information – risk free rate, company’s beta, and the rate of return on a selected stock index.To calculate the required rate of return for your assigned company, follow the instructions below.
Calculate beta for your company. This process was detailed in class. You can refer back to the posted spreadsheets and lectures. Open Yahoo Finance and put in your company’s ticker. Click on Historical Data and get 3 months of stock prices. Download and keep the date and adjusted close price in the Excel file. Go back and do the same thing for the market (use the S