Description
Financial
Concepts
Portfolio
Theory, CAPM Homework
Homework
Exercise 8

Rate of Return 

Year 
Asset A 
Asset B 
Market 
1 
20.0% 
19.0% 
9.0% 
2 
11.0% 
22.0% 
12.0% 
3 
10.0% 
6.0% 
6.0% 
4 
9.0% 
14.0% 
4.0% 
5 
21.0% 
28.0% 
17.0% 
For this exercise, you might want to copy
and paste the table above into Excel and then do all your calculations on that
spreadsheet.
1)
Calculate the expected returns
for Asset A, Asset B and the Market (use
Average function in Excel)
Asset A =
Asset B =
Market =
2)
Calculate the standard deviation of returns,?, for each asset (use STDEVP function)
Asset A =
Asset B =
Market =
3)
Calculate the correlation,?, between Asset A and Asset B (use CORREL function in Excel)
? =
4)
Calculate the expected returns
from the following portfolios:
Use the following formula to calculate the
portfolio standard deviation
?_{P} =? (w_{A}?_{A)}^{2} + (w_{B}?_{B)}^{2} +(2 w_{A}
w_{B}?_{A}?_{B} ?_{(A,B)})
=(((w_{A}*?_{A)} ^ 2) + ((w_{B}^{*?B)^2)+(2 *wA* wB *?A *?B *?(A,B))))^.5}
Where w_{A }and_{wBare the % of assets in Asset A and B respectively}
?_{A} and?_{B} are the
respective standard deviations of return
and
?_{(A,B)}).is the correlation of
returns between asset A and B


Portfolio Expected Return 
Portfolio Std Dev. 
% Asset A 
% Asset B 


0% 
100% 


25% 
75% 


50% 
50% 


75% 
25% 


100% 
0% 


5) Using Portfolio Expected Returns on the Y axis and
Portfolio Standard Deviation in the X axis, draw the efficient frontier for
possible portfolio combinations of Asset A and B. (include 100% A and 100% B as two possibilities). Hint:
Use the Excel Chart Wizard and select the XY(scatter) plot option)
6)
Calculate Beta for Asset A (relative to the Market) and Asset B relative
to the Market) (use SLOPE function)
Beta
for Asset A =
Beta
for Asset B =
7)
Assume that for next year the
Risk Free Rate is expected to be 2% and that the overall Market will realize a
return of 12%. Using the CAPM / SML methodology, calculate the required
returns for Asset A and Asset B.
Required
Return for Asset A =
Required
Return for Asset B =
Reviews
There are no reviews yet.