Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You can use either Excel or manually calculate returns, standard deviations, covariance, and correlation coefficient using the formulas illustrated on PowerPoint slides. However, you need
You can use either Excel or manually calculate returns, standard deviations, covariance, and correlation coefficient using the formulas illustrated on PowerPoint slides. However, you need to show the calculation procedures for all questions listed here. Only showing final answers will not get any credit. I strongly recommend you to manually calculate them and use Excel to verify your answers. Keep at least 4 decimal digits to the right of the decimal point for all calculations. a. Calculate the expected return and the standard deviation for Stock 1 and Stock 2 respectively. (6 pts) b. What is the expected return for a portfolio with an investment of $7,000 in Stock 1 and $3,000 in Stock 2? [Hint: Calculate portfolio weights, W1 and W2, first.] (2 pts) c. Calculate the standard deviation for this portfolio using three methods: (12 pts) 1. Use Formulas (5) and (6) 2. Use Formula (7) and (10) 3. Use Formula (8) and (11) Remember that you need to show the calculation procedures for all questions listed here. Only showing final answers will not get any credit. For each state of economy (s =1,2,n), get E(Rp,s)=i=1mwiE(Ri,s) p=s=1n[ps(E(Rp,s)E(Rp)2] Covariance of two securities, 1 and 2: Cov(R1,R2)=s=1nps[E(R1,s)E(R1)][E(R2,s)E(R2)] Correlation coefficient of two securities, 1 and 2: Corr(R1,R2)=12=12Cov(R1,R2) Two-Risky-Assets Portfolio with two securities 1 and 2: E(RP)=w1E(R1)+w2E(R2)p=(w11)2+(w22)2+2w1w2Cov(R1,R2)p=(w11)2+(w22)2+2w1w212Corr(R1,R2)w1(min)=12+2221212221212w1(optimal)=[E(R1)rf]22+[E(R2)rf]12[E(R1)rf+E(R2)rf]1212[E(R1)rf]22[E(R2)rf]1212
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started