1. Expected Return for A and M A= 16.2 M= 13 2. Standard Deviation for A and M (
ID: 3130976 • Letter: 1
Question
1. Expected Return for A and M A= 16.2 M= 13
2. Standard Deviation for A and M (Population) A = 4.1425 M = 2.5690
3. Covariance (A,M) Cov= -.6
4. Correlation (A,M) CORR = -.0564
5. Expected return on a portfolio consisting of 30% and 70% M. P= 13.96
6. Standard deviation of a portfolio consisting of 30% A and 70% M. P = 2.1275
7. The Beta of A. (assume that M is the market) BET = -.0909
8. The portfolio weights for the minimum risk portfolio. W(A) = .2885 W(M) = .7115
Solve the portfolio using excel. create a general spreadsheet for 8 computations and change some or all of the following: Portfolio Weights, Probabilities, Asset Returns
State Probability % Return A % Return M Good .3 20 16 Normal .4 18 10 Bad .3 10 14Explanation / Answer
% Return A % Return M A*prob M*prob A^2*p M^2*p AM 20 16 6 4.8 120 76.8 36 18 10 7.2 4 129.6 40 51.84 10 14 3 4.2 30 58.8 9 Mean 16.2 13 279.6 175.6 E(X^2) 279.6 175.6 Var(x) 17.16 6.6 Std dev 4.142463 2.569047 E(XY) 96.84 Cov = E(xy)-E(x) E(y) -0.06 Correlation coefficient -0.0564
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.