Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.
Problem 4 Asset о The correlation p between assets A and B is 0.1, and other...
Consider the following data about the expected returns, standard deviations, and correlation between two assets: Asset 1 Asset 2 Expected return 5.3% 6.8% Standard deviation 4.5% 7.8% Correlation coefficient -0.6 Calculate the expected return and standard deviation of a portfolio consisting of a 20% weight in asset 1 and an 80% weight in asset 2. What happens to the expected return and standard deviation of the portfolio when the weight combination changes to 50% in asset 1 and 50% in...
Suppose there are three assets: A, B, and C. Asset A’s expected return and
standard deviation are 1 percent and 1 percent. Asset B has the same expected
return and standard deviation as Asset A. However, the correlation coefficient of
Assets A and B is −0.25. Asset C’s return is independent of the other two assets.
The expected return and standard deviation of Asset C are 0.5 percent and 1
percent.
(a) Find a portfolio of the three assets that...
There are only two risky assets (stocks) A and B in the market. Asset A: Mean = 20% Standard Deviation = 10% Asset B: Mean = 10% Standard Deviation = 5% Returns on Assets have zero correlation. A.Assume that there is no risk-free asset. (i)Plot (sketch) the efficiency frontier (the investment opportunity set). (ii)What is the expected return and the standard deviation of the minimum-variance-portfolio? (iii)An investor would like to construct a portfolio that has a standard deviation of 8%....
The standard deviation of Asset A returns is 36%, while the standard deviation of Asset M returns in 24%. The correlation between Asset A and Asset M returns is 0.4. (a) The average of Asset A and Asset M’s standard deviations is (36+24)/2 = 30%. Consider a portfolio, P, with 50% of funds in Asset A and 50% of funds in Asset M. Will the standard deviation of portfolio P’s returns be greater than, equal to, or less than 30%?...
1. Consider a portfolio P comprised of two risky assets (A and B) whose returns have a correlation of zero. Risky asset A has an expected return of 10% and standard deviation of 15%. Risky asset B has an expected return of 7% and standard deviation of 11%. Assuming a risk-free rate of 2.5%, what is the standard deviation of returns on the optimal risky portfolio? a) 9.18% b) .918% c) .84% d) 8.42%
Asset K has an expected return of 10 percent and a standard deviation of 28 percent. Asset L has an expected return of 7 percent and a standard deviation of 18 percent. The correlation between the assets is 0.40. What are the expected return and standard deviation of the minimum variance portfolio?
Consider a portfolio consisting of the following two risky assets. Asset i Hi, Return on Asset i 7% 7% 0, Risk in Asset i 18% 14% The coefficient of correlation between the returns is p = -100%. (a) State the expected return and associated risk (as measured by the standard deviation) in terms of w if w is the weight allocation of Asset 1 in the portfolio. Hry (w) = 0.07 Or, (w) = sqrt(0.0632w^2-0.C (b) Suppose that the portfolio...
Assume you are considering a portfolio containing two assets, L and M. Asset L will represent 44% of the dollar value of the portfolio, and asset M will account for the other 56%. The projected returns over the next 6 years, 2018 - 2023, for each of these assets are summarized in the following table: Projected Return Year Asset L Asset M 2018 13% 19% 2019 14% 19% 2020 17% 15% 2021 16% 15% 2022 16% 11% 2023 18% 11%...
Assume you are considering a portfolio containing two assets, L
and M. Asset L will represent 39 % of the dollar value of the
portfolio, and asset M will account for the other 61 %. The
projected returns over the next 6 years, 2018-2023, for each of
these assets are summarized in the following table:
LOADING....
a. Calculate the projected portfolio return, r over p, for
each of the 6 years.
b. Calculate the average expected portfolio return, r over...
8. Calculate the PORTFOLIO Expected Return and standard deviation of a 60/40 Portfolio of Asset A and asset B. ASSET A 60% ASSET B 40% Return in State Return in State R (A) R(B) PORTFOLIO Rport in Sate S R(P)i Deviation R(P)i Pr Portfolio (Deviation Portfolio 2 State S Squared Dev*Pr Pr State P 0.4 0.6 E(R) E(R) Portfolio Portfolio Var Portfolio sd - 9. Compare the Risk-Return of the two stocks ALONE and the joint risk in the portfolio...