Project Tasks: Part 2 1. After you have received your instructor'...

  1. Home
  2. Homework Library
  3. Business
  4. Finance
  5. Project Tasks: Part 2 1. After you have received your instructor'...


Project Tasks:
Part 2
1. After you have received your instructor's approval for Part 1, use the return data to calculate a beta estimate based upon your 60-month return data for each common stock by using the follow ing MS Excel function:

-SLOPE(Y values, x values)

For each com m on stock, the Y and x values in the SLOPE function will be stock returns and S& P 500 index returns, respectively.

2. Compare your beta estimates, using the SLOPE function, with the beta estimates from http://Finance.yahoocom or any other website and answer the following questions:
fi Discuss why the estimates may differ.
fi Which stock appears to have the highest and lowest level of system at ic risks?
fi How do these system at ic risk levels relate to the standard definitions of the stock returns calculated in Part: I7
fi Rank the stocks by their beta risks and total risk n standard deviations. Are the rankings identical? Discuss your findings.

3. If the risk-free rate over the 60-month data period averaged D .2 percent per month (0.002), calculate the difference between the average monthly return for each common stock and the S&P 500 index over or below the risk-free rate.

4. Use CAPM and beta estimates for each stock, as well as the average return on the S&P index to estimate the Expected Monthly Return for each stock over the 60-month data period. Then, answer the follow ing questions:

fi How dil the actual performance of the stocks compare with the Expected Monthly Returns?
fi Based on CAPM, which stocks outperform ed the stock index and by how much?
fi Calculate the average abnormal monthly returns for each stock over the 60-month period.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.docx and Solution.xlsx.

    50% discount

    $48.00 $24.00
    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Finance Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats