Question: PLEASE write the steps how you solve this question. You have observed the following returns over time: Year Stock X Stock Y Market 2011 12

PLEASE write the steps how you solve this question. You have

PLEASE write the steps how you solve this question.

You have observed the following returns over time: Year Stock X Stock Y Market 2011 12 % 12 % 10 % 2012 18 5 8 2013 -15 -6 -10 2014 4 2 1 2015 22 11 14 Assume that the risk-free rate is 3% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. a. What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. b. What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. % What is the required rate of return on Stock Y? Do not round intermediate calculations. Round your answer to one decimal place. c. What is the required rate of return on a portfolio consisting of 80% of Stock X and 20% of Stock Y? Do not round intermediate calculations. 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!

Quantitative solutions can be used to check your work. But, you are expected to develop and show Excel formulas for these solutions. The path to the solution is where you will be evaluated. Problem...

QUESTION 35 The Bradshaw Company's most recent dividend was $7.65. The historical dividend payment by the company shows a constant growth rate of 5 percent per year. What is the maximum you would be...

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...

please solve? does this work? clearer image! Tools N 0 100 IL 11. 9 11. . 14 O 15 O 16 eBook Problem 6-14 Historical Returns: Expected and Repaal of You have observed the following return overline...

Solve This Finance problem. Answer clearly describe the steps. Step by step Answer Thanks in Advance (6-14) Historical Returns: Expected and Required Rates of Return Y ou have observed the following...

2-7: The Relationship between Risk and Return in the Capital Asset Pricing Model Problem 2-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over...

I am posting this questions again please provide me clear answer. Not in Excel sheet. Formulas and Working Thanks (6-14) Historical Returns: Expected and Required Rates of Return You have observed...

You have observed the following returns over time: Stock Year Stock Y Market 2011 1490 11 % 1296 2012 19 7 11 2013 -13 -2 -10 2014 4 2 2015 19 Assume that the risk-free rate is 4% and the market risk...

Please You have observed the following returns over time: Stock Y 15% Year 2015 2016 2017 5 17 -17 3 -2 -10 2018 1 3 2019 18 12 17 Assume that the risk-free rate is 5% and the market risk premium is...

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

Coltrane, CPA, is auditing Jang Wholesaling Companys financial statements and is about to perform substantive audit procedures on Jangs trade accounts payable balances. After obtaining an...

How do you account for Disney management erring so badly, both at the beginning and even for years afterwards? Any suggestions?

Options warrants and rights will be diluted in the termination of earnings per share when the exercise price exceeds the average market price is stock true or false

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...