Question: yes, excel would be great!! Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Stock Y

yes, excel would be great!!

Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Stock Y Market Stock X Year 12% 15% 15% 2012 2013 18 -10 -18 -5 2014 1 2 2015 13 13 21 2016 Assume that the risk-free rate is 6% and the market risk premium is 7%. Do not round intermediate calculations. a. What is the beta of Stock X? Round your answer to two decimal places. b. What is the beta of Stock Y? Round your answer to two decimal places. C. What is the required rate of return on Stock X? Round your answer to one decimal place. % d. What is the required rate of return on Stock Y? Round your answer to one decimal place. e. What is the required rate of return on a portfolio consisting of 80 % of Stock X and 20 % of Stock Y? Round your answer to one decimal place

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 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: 6. Problem 6-14 eBook Problem 6-14 Historical Returns: Expected and Required...

Excel will work yeah! eBook Problem 6-14 Historical Returns: Expected and required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2012 12% 11% 10% 2013...

Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2012 14% 13% 14% 2013 19 5 12 2014 -12 -8 -12...

Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2012 12% 11% 11% 2013 20 7 12 2014 -17 -3 -14...

Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year Stock x Stock Y Market 2012 12% 12% 2013 12 2014 -14 2015 2016 Assume...

Problem 6-14 Historical Returns: Expected and required Rates of Return You have observed the following returns over time: Year Stock x Stock Y Market 2012 13% 11% 14% 2013 19 5 12 2014 -17 -5 -12...

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

Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2012 15% 12% 12% 2013 18 8 9 2014 -14 -3 -14 2015...

Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year 2012 2013 2014 2015 2016 Stock X 16% 18 18 Market 12% 8 Stock Y 12% -8...

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

The last four years of returns for a stock are as follows: Year 1 2 3 4 Return 4.5% 27.6% 12.1% 4.3% a. What is the average annual return? b. What is the variance of the stock's returns? c. What is...

1 2 3 16.00 17.12 After the three year period, Care4UMed is expected to grow at a constant rate of 7% and its WACC is 13%. Care4UMed has $35 million of debt and $120 million shares of stock...

Knowledge Check If a compary's cost structure shifts to a higher proportion of fowed costs as compared to the prior year, what will occur? The break - even point will increase. Total profit will...

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

3. How much weight should be given to the following: a. Mr. Comos testimony that he did not make the decision to remove Allen b. Ms. Balks testimony that Mr. Allen has restored the burned cabin c....

7. What level of proof should be used in this matter? Why? This matter of arbitration stems from an indictment of Thomas Allen for one count of arson first degree and ten counts of burglary in...

6. Should the Union be allowed to provide character witnesses on behalf of Mr. Allen? If so, why? If not, why not? This matter of arbitration stems from an indictment of Thomas Allen for one count of...