# Question 2 The expected returns and standard deviation of returns for two securities are as follows: Security ZSecurity Y Expected Return15%35% Standard Deviation20%40%   The correlation between the returns is +0.25.a) Calculate the expected return and standard deviation for the following portfolios: i) All in Zii) 0.75 in Z and 0.25 in Yiii) 0.5 in Z and 0.5 in Yiv) 0.25 in Z and 0.75 in Yv) All in Yb) Draw the mean-standard deviation frontier. c) Which portfolios might not be held by an investor who likes high expected return and low standard deviation?

Question

Question 2

The expected returns and standard deviation of returns for two securities are as follows:

 Security Z Security Y Expected Return 15% 35% Standard Deviation 20% 40%

The correlation between the returns is +0.25.

a) Calculate the expected return and standard deviation for the following portfolios:

i) All in Z

ii) 0.75 in Z and 0.25 in Y

iii) 0.5 in Z and 0.5 in Y

iv) 0.25 in Z and 0.75 in Y

v) All in Y

b) Draw the mean-standard deviation frontier.

c) Which portfolios might not be held by an investor who likes high expected return and low standard deviation?

Step 1

a.

Calculation of Expected Return of Portfolio:

The Expected Return of Portfolio is calculated using a excel spreadsheet. The excel spreadsheet is shown below:

Step 2

The excel spreadsheet workings is shown below:

Step 3

Calculation of Standard Deviation of Portfolio:

The Standard Deviation of Portfolio is calculated using a excel function =SQRT, which denotes the square root or standard...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in