Using the following 3 securities calculate: 1. Expected return 2. Variance 3. Standard deviation 4. Correlation...
Is it possible to get a example of how to complete these steps? It would be greatly appreciated. Using the following 3 securities calculate: 1. Expected return 2. Variance 3. Standard deviation 4. Correlation between all possible pairs 5. Covariance between all possible pairs Probability Stock A .10 .10 .30 .20 30 5% 5% 12% 6% 18% Stock B 35% 31% 30% 25% 17% Stock C 2% 6% 10% 15% 20% Using the following percentages, calculate the portfolio variance and...
Q1) A stock fund has an expected return of 15% and a standard deviation of 25% and a bond fund has an expected return of 10% and a standard deviation of 10%. The correlation between the two funds is 0.25. The risk free rate is 5%. What is the (a) expected return and (b) standard deviation of the portfolio with 70% weight in the stock portfolio and 30% weight in the bond portfolio? Q2) The variance of Stock A is...
Assume an investment manager is considering to invest in a portfolio composed of Stock (A) and Stock (B). Stock (A) has an expected return of 10% and a Variance of 100 (Standard Deviation=10), while Stock (B) has an expected return of 20% and a Variance of 900 (Standard deviation=30).1- Calculate the expected return and variance of the portfolio if the proportion invested in Sock (A) is (0, .2, .3,.5. .6,.7,1) .The Correlation Coefficient is .4.2- If the Correlation Coefficient is...
With excel formulas please.. D18 Standard deviation of return Expected return 15% 25% 0.0865 33% 46% 2 ABC Covariance(ABCXYZ) 5 Correlation ABC,XYZ) 0.5698 <. -B4/C2'C3) 7 Section a 8 Portfolio allocation 9 Percentage ABC t0 Percentage XYZ 25.00% 75 0096 <..-1-B9 12 Expected return 13 Standard deviation 14 15 Section b Standard deviation of return 16 Percentage of ABC Expected return 0% 10% 30% 40% 50% 60% 70% 80% 90% 100% 20 24 29 Section c 30 Proportion of ABC...
No 3. Consider three securities: Asset I with expected return of 14% and standard deviation of return of 6%, Asset 2 with average return of 8% and standard deviation of returns of 3%, and Asset 3 with mean return of 20% and standard deviation of return of 15%. Further, assume that the correlation coefficient between Asset 1 and Asset 2 is 0.5, between Asset 1 and Asset 3 is 0.2, and between Asset 2 and Asset 3 is 0.4. Finally,...
a. Calculate the expected return for each security. b. Calculate the standard deviation of returns for each security. c. Compare Stock A with Stocks B and C. Is Stock A preferred over the others? d. Using your result in parts a and b, compute the following probabilities: Stock A makes a return more than 18.9% Stock B makes a return less than 1.3% Stock C makes a return between 6.1% and 16.1% 2) You are considering the...
Question 2: Given three securities: Expected Standard Return Deviation Stock 10.15 0.20 Stock 20.20 0.30 Stock 30.08 0.10 Stock 3 Correlation of Returns Stock 1 Stock 2 1.00 0.20 0.30 1.00 0.80 1.00 (a) Find the expected return and standard deviation of a portfolio with 25% in stock 1, 50% in stock 2, and 25% in stock 3. (b) For the portfolio in part (a), find the covariance of its return with the return of an equally weighted portfolio of...
PROBLEM 4. Covariance and Correlation Based on the following information, calculate the expected return and standard deviation of each of the following stocks. Assume each state of the economy is equally likely to happen. What are the covariance and correlation between the returns of the two stocks? State of Economy Return on Stock A Return on Stock B Bear . 108 -.067 Normal .126 .113 Bull .064 .276
1. The universe of available securities includes two risky stock funds, A and B, and T-blls. The data for the universe are as follows Expected Return Standard Deviation A 10% 20% В 30 60 T-bills The correlation coefficient between funds A and B is -0.2. a. Find the optimal risky portfolio, P, and its expected return and standard deviation. b. Find the slope of the CAL supported by T-bills and portfolio P c. How much will an investor with A...
you are considering investing in two securities. Security 1 has a expected return of 12% and a standard deviation of return of 10%. Security 2 has an expected return of 9%and a standard deviation of returns of 8%. The correlation coefficient of returns for the two securities is 0.3. What would the weights be for each of the two securities in the minimum variance portfolio? W1= W2= Given the weights computed in (a), compute the expected return and standard deviation...