Question: Using the data in the following table, answer questions. Year Stock X Stock Y 2012 -11% -5% 2013 15% 25% 2014 10% 15% 2015 -5%

Using the data in the following table, answer questions.

Year	Stock X	Stock Y
2012	-11%	-5%
2013	15%	25%
2014	10%	15%
2015	-5%	-15%
2016	5%	-5%
2017	8%	-2%
2018	7%	10%
2019	5%	15%

Average return
Standard deviation
Correlation between Stock X and Stock Y	0.7567

1.Calculate the standard deviation of returns for Stocks X and Y.

2.For a portfolio that is 75% weighted in Stock X, and 25% weighted in Stock Y, calculate the expected return of the portfolio.

3.Calculate the standard deviation of your portfolio based on the weights of Stocks X and Y stated in part (2).

4.Suppose the correlation between Stocks X and Y has reduced to 0.35, does it increase or reduce the standard deviation of your portfolio based on the weights of Stocks X and Y stated in part (2). Explain your answer.

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!

G H J K L M FY 2012 06/30/2012 FY 2013 06/30/2013 FY 2014 06/30/2014 FY 2015 06/30/2015 FY 2016 06/30/2016 FY 2017 06/30/2017 1,827.2 1,985,8 2,244.6 2,397.0 2,641.8 2,677.3 200.1 246.1 206.9 256.6...

On January 1, 2015, Pym Company acquired 75% interest in the common stock of Stark Company for $350,000 Stark had the following Balance Sheet on the date of acquisition: Assets (5) Accounts...

Your investment advisor believes that recent stock returns should be given more consideration when calculating future returns and risk than older returns. The historical returns for Lately...

Data Table use excel Here is a table with the provided information: | Year | ABC Returns | B Returns | |------|--------------|-----------| | 2005 | -3.5% | 16.1% | | 2006 | 1.1% | -7.8% | | 2007 |...

Question 1 The data below shows the SAT scores of 30 students at Martin Luther King High School in Florida. 1561 1554 1536 1531 1523 1518 1515 1511 1506 1500 1499 1493 1490 1489 1485 1482 1482 1479...

You are required to finish each of these questions, total 40 marks. Please give the solutions in detail, show calculations and submit the solutions to Moodle using a single file, it can be Excel...

Read the case study below and the survey charts. then answer the questions below. CASE STUDY: A DOWNSIZING DECISION AT THE DEPARTMENT OF PUBLIC WORKS. Kathleen Pool is a human resources officer with...

Using the data in the following table, answer parts (i) (v). Year Stock X Stock Y 2012 -11% -5% 2013 15% 25% 2014 10% 15% 2015 -5% -15% 2016 5% -5% 2017 8% -2% 2018 7% 10% 2019 5% 15% Average return...

Solve the following attachments The Pristine River Case The Pristine River has two polluting firms on its banks. Acme Industrial and Creative Chemicals each dump 100 tons of glop into the river each...

Merit is a Company that operates in the Retail business and has a 30 June 2021 year end. The Books of Merit private limited are as follows: Statement of Profit or loss and other comprehensive income...

The following are three situations, all involving nonpublic companies, in which the auditor is required to develop an audit strategy: 1. The client has inventory at approximately 50 locations in a...

instruments of securitization include? a . pass through certificates, b . bonds with no collaterals, c . debentures, d . shares and securities

A random sample of 43 biology students in a science program are selected for a study. Of those selected, only 27 passed the mid term exam. At the 5% significance level, is there sufficient evidence...

Evaluate the impact of technology on HR employee services.

Identify three ways to manage an intergenerational workforce.

Prepare a Porters Five Forces analysis.