Purchase Solution

Utilizing finance databases to determine required return

Not what you're looking for?

Ask Custom Question

Capital Asset Pricing Model (CAPM) Web Exercise

In this web exercise, we will show how to determine the required rate of return
for a stock using the capital asset pricing model.

In the response, be sure to include your calculations for each one of the organizations listed in Step 9 of the exercise. Im not very good with math and so please show step by step how you obtain the answers.

1. The formula for the capital asset pricing model is:
Ki _ RF _ bi (KM _ RF ) (217)
Ki is the required rate of return that we are solving for; RF is the risk-free
rate, and we shall assume it is 4.6 percent; bi is the systematic risk of a stock
that we will estimate; (KM _ RF ) is the equity risk premium or the amount the
market is assumed to earn over the risk-free rate in the long term. We will use
6.4 percent in this example.

2. Now we are in a position to estimate the beta for a company and compute Ki,
the required rate of return. While Value Line, Bloomberg, and other financial services provide estimates of beta, they are often very different. In this exercise, we are going to
have you eyeball a value for beta. Go to finance.yahoo.com .

3. Enter Oracle (ORCL) in the Enter System box and click Go.

4. Along the left margin, click on Basic Chart.

5. Then on the Range line, click on 2y.

6. Then on the Compare line, select S&P and click Compare.

7. Eyeball the relative volatility of ORCL to the Standard and Poor Index (GSPC)
and estimate a beta (such as 1.1 or 1.3) based on the relative volatility of the
stock versus the index.

8. Use this beta and the previously presented information on RF and (KM _ RF ) to
compute Ki.

9. Follow this procedure for:
a. McDonalds (MCD)
b. Bank of America (BAC)
c. Coca-Cola (KO)

10. What conclusion can you draw between the relationship of beta (bi ), a risk
measure, and the required rate of return (Ki )?

Attachments
Purchase this Solution
Solution Summary

The problem deals with estimating the required rate of return for shares through CAPM.

Solution provided by:
Chidi Ngene, M. Sc.
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

View More Free Quizzes
Related BrainMass Solutions

  • Business Financial Management

    Utilizing this information, organizational leadership would be able to accurately determine the budget that each of these departments would need to work within, in order to effectively complete their work requirements in the upcoming fiscal year.

  • Most important number; which percentages are required

    Though, a firm can raise cash to finance its operations, it takes some time before it can complete the cash cycle. The most important numbers required in percentages are determined.

  • Creating and Selling Securities to Finance

    Weighted Average Because the weighted average is a correct measure of a required return, why do firms not create securities to finance each project and offer them in the capital market in order to accurately determine the required return for project?

  • Tasks that benefit from databases with workflow technology

    182831 Tasks with benefit from databases utilizing workflow technology What types of tasks would benefit from databases utilizing workflow technology? Describe briefly any workflow database that you know of.

  • Company DEF

    93924 Company DEF's policy is to finance its working capital needs by utilizing short-term debt instruments. #2 Company DEF's policy is to finance its working capital needs by utilizing short-term debt instruments.

  • Median Finding Algorithm for Joint Databases

    You'd like to determine the median of this set of 2n values, which we will define here to be the nth smallest value. However, the only way you can access these values is through queries to the databases.

  • After you finish your discussion with the managers and ...

    How would the company's return on equity be impacted by utilizing more debt?

  • Need of Apache Hadoop and its uses.

    In finance, if we want to do portfolio evaluation, risk analysis, assess market sentiment we can use Hadoop to build sophisticated models.

  • Weighted average cost of capital for a firm's assets

    So we are trying to determine the average cost associated with each type of financing to insure that we are gaining the required rate of return to at least cover the cost of the capital associated with the acquisition of the asset(s) in question.

  • Finance questions

    Substittue the appropriate values into the CAPM to determine the firm's current required rate of return. (b) Once this required rate of return is found determine the value of the stock.

View More Related Solutions