Question: please only excel. 16. Compute the beta for Stock X. 17. Compute the beta for Stock Y. 10 Daud .. ......canda...funn Year Market Stock X

please only excel.

16. Compute the beta for Stock X. 17. Compute the beta for Stock Y. 10 Daud .. ......canda...funn Year Market Stock X 12% Stock y 8% 1 0% -4% 16% -8% 15% 8% 23% 6 9% 21% 3% 22% 15% 6% 10% 11% 20 -2% 17% 14% 7% 15% 7 0% 18% 20% 8 9 2% 10 12%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Problem 2-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2011 16% 11% 10% 2012 19 7 9 2013 -12 -5 -12 2014...

16. If the Beta for Stock X equals zero, then according to the CAPM a, stock X's required return is equal to the risk-free rate of return. b. stock X has a guaranteed return. c. stock X's required...

You have observed the following returns over time: Year Stock X Stock Y Market 2011 14 % 12 % 10 % 2012 19 5 11 2013 -12 -4 -12 2014 3 2 2 2015 21 8 15 Assume that the risk-free rate is 3% and the...

11. Compute the standard deviation for Stock Y 12. Fill in the blank for the market's return in year 1 and compute the arithmetic mean. 13. Compute the geometric mean for the market. 14. Compute the...

can someone please help me figure this out i want to learn how to solve these step by step please. 1. Scott believed Amazon stock was overpriced at the price of $500. He shorted 100 shares. The...

Data case 2 Econ 670 Show all your work to receive full credit. Completed assignments will include an Excel file. Please use one sheet for each question. Include your answer for Q7 (although done in...

This data case question is divided in 7 part, I need assistance please: Data case 2 Econ 670 Show all your work to receive full credit. Completed assignments will include an Excel file. Please use...

HI, Need assistance with this data case. It does not has to be every single question, any help is much appreciated. Data case 2 Econ 670 Show all your work to receive full credit. Completed...

I need help with this data set, thank you! Data case 2 Econ 670 Show all your work to receive full credit. Completed assignments will include an Excel file. Please use one sheet for each question....

Assertions about account balances and related disclosures include all of the following except: Occurrence. Completeness. Rights and obligations. Classification.

ROC is considering investing $275,000 in order to gain more business for its plagiarism identifying services. The company has come up with two alternatives outlined below: Alternative 1 Build a...

Measuring Risk. Why do investors measure risk? Describe the two common measures of risk. Part 2 Investors want to measure risk to understand the: ( Select the best answer below. ) A . degree of...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...