Calculating the Required Rate of Return using Bloomberg

Calculate the required rate of return for your stock. 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&P 500, which has a ticker of ^GSPC). Insert the market adjusted close prices into the same Excel file to the left of your company’s stock prices.
    • Next, calculate the daily returns for both your company and the market (create two additional columns for this).
    • Highlight these returns and insert a scatter plot into Excel.
    • Appropriately label the graph (title, x and y axes).
    • Then put in the Characteristic line: Add Chart Element, Trendline – and make sure that “display equation” is checked. You should now have your estimate of beta. Use this for the remainder of the project.
  • Find the most recent return on a 10-year Treasury security. You can find this directly from the US Treasury Data site or another source. Be careful about units (percent).
  • For the market risk premium, use 5%. This is the recently reported market risk premium as calculated by Damodaran Online (NYU).
  • Calculate the required rate of return for your company using the data that you collected. Explain your results and show all calculations. What does this number mean? Does it seem reasonable?
  • . Be sure to include a text box to answer all questions (previous bullet).
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.