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 excelPlease show formulas on excel Q4: The Return and Risk for Portfolios

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!