Question: Please show formulas on excel Q4: The Return and Risk for Portfolios Date Stcok A Stock B 1/1/15 -3.10% 14.24% 2/1/15 5.49% 7.23% 3/1/15 -1.74%
Please show formulas on excel
| Q4: | The Return and Risk for Portfolios | ||
| Date | Stcok A | Stock B | |
| 1/1/15 | -3.10% | 14.24% | |
| 2/1/15 | 5.49% | 7.23% | |
| 3/1/15 | -1.74% | -2.12% | |
| 4/1/15 | 0.85% | 13.35% | |
| 5/1/15 | 1.05% | 1.77% | |
| 6/1/15 | -2.10% | 1.13% | |
| 7/1/15 | 1.97% | 23.51% | |
| 8/1/15 | -6.26% | -4.34% | |
| 9/1/15 | -2.64% | -0.19% | |
| 10/1/15 | 8.30% | 22.27% | |
| 11/1/15 | 0.05% | 6.22% | |
| 12/1/15 | -1.75% | 1.67% | |
Q4: The Return and Risk for Portfolios Date Stcok A Stock B 1/1/2015 -3.10% 14.24% 2/1/2015 5.49% 7.23% 3/1/2015 -1.74% -2.12% 4/1/2015 0.85% 13.35% 5/1/2015 1.05% 1.77% 6/1/2015 -2.10% 1.13% 7/1/2015 1.97% 23.51% 8/1/2015 -6.26% -4.34% 9/1/2015 -2.64% -0.19% 10/1/2015 8.30% 22.27% 11/1/2015 0.05% 6.22% 12/1/2015 -1.75% 1.67% ? ? mean return variance std ? ? ? ? correlation: ? |Weight of sto 45% ? | The expected return of the portfolio is: average return of the
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
