States Probability Asset M Return Asset N Return Asset O Return Boom 34% 12% 21% 4%...

States	Probability	Asset M Return	Asset N Return	Asset O Return
Boom	34%	12%	21%	4%
Normal	51%	10%	14%	10%
Recession	15%	4%	1%	12%

Benefits of diversification. Sally Rogers has decided to invest her wealth equally across the following three assets:

a. What are her expected returns and the risk from her investment in the three assets? How do they compare with investing in asset M alone?

Hint: Find the standard deviations of asset M and of the portfolio equally invested in assets M, N, and O.

b. Could Sally reduce her total risk even more by using assets M and N only, assets M and O only, or assets N and O only? Use a 50/50 split between the asset pairs, and find the standard deviation of each asset pair.

Expert Solution

FORMULAS USED :-

	E(Ri)	=SUMPRODUCT($B$2:$B$4,C2:C4)	=SUMPRODUCT($B$2:$B$4,D2:D4)	=SUMPRODUCT($B$2:$B$4,E2:E4)
Sd = Proxy for Risk	Standard Deviation	=SQRT(SUMPRODUCT((C2:C4-C5)^2,$B$2:$B$4))	=SQRT(SUMPRODUCT((D2:D4-D5)^2,$B$2:$B$4))	=SQRT(SUMPRODUCT((E2:E4-E5)^2,$B$2:$B$4))


	COVARIANCE	M & N	N &O	O & M
		=SUMPRODUCT($B$2:$B$4,(C2:C4-C5),(D2:D4-D5))	=SUMPRODUCT($B$2:$B$4,(D2:D4-D5),(E2:E4-E5))	=SUMPRODUCT($B$2:$B$4,(E2:E4-E5),(C2:C4-C5))

PORTFOLIO RISK
		M & N	N &O	O & M
STANDARD DEVIATION		=((C6^20.5^2)+(D6^20.5^2)+(2C100.5*0.5))^(1/2)	=((D6^20.5^2)+(E6^20.5^2)+(2D100.5*0.5))^(1/2)	=((E6^20.5^2)+(C6^20.5^2)+(2E100.5*0.5))^(1/2)

jeff jeffy answered 1 year ago

States Probability Asset M Return Asset N Return Asset O Return Boom 27% 10% 21% 2% ...

States Probability Asset M Return Asset N Return Asset O Return Boom 27% 10% 21% 2% Normal 50% 8% 12% 8% Recession 23% 2% 1% 10% a. What is the expected return of investing equally in all three assets M, N, O? b. What is the expected return of investing in asset M alone? c. What is the standard deviation of the portfolio that invests equally in all three assets? d. What is he standard deviation of asset M?

States Probability Asset M Return Asset N Return Asset O Return Boom 32% 13% 23% 5% ...

States Probability Asset M Return Asset N Return Asset O Return Boom 32% 13% 23% 5% Normal 45% 11% 15% 11% Recession 23% 5% 3% 13% a. What is the expected return of investing equally in all three assets M, N, and O? - what is the expected return of investing in asset M alone? - what is the standard deviation of the portfolio that invests equally in all three assets M, N, and O? - what is the standard...

states econ, probability, Asset J, AssetK, Asset L boom. 0.29. 0.055. 0.190

states econ, probability, Asset J, AssetK, Asset L boom. 0.29. 0.055. 0.190. 0.280 growth. 0.36. 0 055. 0.100. 0.190 Stagnant. 0.22. 0.055. 0 040. 0.050 Recession. 0.13. 0.055. -0.080. -0.180 A) what is the expected return of each asset? B) what is the variance and the standard deviation of each asset? C) what is the expected return of a portfolio with 9% in asset K, and 43% in asset L? D) what is the portfolio's variance and standard deviation using...

expected return and standard deviation. stateecon, probability, asset A, asset B, Asset C boom. 0.34. 0.02. &nbs

expected return and standard deviation. stateecon, probability, asset A, asset B, Asset C boom. 0.34. 0.02. 0.22. 0.34 normal. 0.52. 0.02. 0.05. 0.18 recession. 0.14. 0.02. -0.01. -0.25 A) what is the expected return of each asset? B) what is the variance of each Asset? C) what is the standard deviation of each asset?

The probability of state in boom economy is 20%. The rate of stock return is 20%...

The probability of state in boom economy is 20%. The rate of stock return is 20% and the bond rate of return is 10%. The probability of state in normal good growth economy is 25%. The stock rate of return is 10% and the bond rate of return is 5% The probability of state in normal growth economy is 15%. The stock rate of return is 3% and the bond rate of return is 5% The probability of state in...

State of Economy Probability of State Return on Asset A in State Return on Asset B...

State of Economy Probability of State Return on Asset A in State Return on Asset B in State Return on Asset C in State Boom 0.35 0.04 0.21 0.3 Normal 0.5 0.04 0.08 0.2 Recession 0.15 0.04 -0.01 -0.26 a. What is the expected return of each asset? b. What is the variance of each asset? c. What is the standard deviation of each asset?

Stock S is expected to return 12 percent in a boom and 6 percent in a...

Stock S is expected to return 12 percent in a boom and 6 percent in a normal economy. Stock T is expected to return 20 percent in a boom and 4 percent in a normal economy. There is a 40 percent probability that the economy will boom; otherwise, it will be normal. What is the portfolio variance if 30 percent of the portfolio is invested in Stock S and 70 percent is invested in Stock T? A. .002220 B. .008080 C. .006224 D....

Stock S is expected to return 12% in a boom and 6% in a normal economy....

Stock S is expected to return 12% in a boom and 6% in a normal economy. Stock T is expected to return 20% in a boom and 4% in a normal economy. There is a probability of 40% that the economy will boom; otherwise, it will be normal. What is the portfolio variance and standard deviation if 30% of the portfolio is invested in Stock S and 70% is invested in Stock T? Briefly discuss what this means to the...

State of Economy Probability of State Return on Asset J in State Return on Asset K...

State of Economy Probability of State Return on Asset J in State Return on Asset K in State Return on Asset L in State Boom 0.26 0.050 0.230 0.290 Growth 0.37 0.050 0.150 0.210 Stagnant 0.22 0.050 0.020 0.050 Recession 0.15 0.050 −0.150 -0.180 a. What is the expected return of each asset? b. What is the variance and the standard deviation of each asset? c. What is the expected return of a portfolio with 12% in asset J, 48%...

Algorithm problem 4 [3.1-4] Is (2^(n+1))∈O(2^n)? Is (2^(2n))∈O(2^n)?

Question