In: Finance
F-I is the answers I need
Stock A and Stock B produced the following returns during the past five years (Year -1 is one year ago, Year -2 is two years ago, and so forth):
Year Stock A’s Returns, Stock B’s Returns,
-1 –18.00% –14.50%
-2 33.00 21.80
-3 15.00 30.50
-4 –0.50 –7.60
-5 27.00 26.30
Year Stock C’s Return, σ
-1 32.00%
-2 –11.75
-3 10.75
-4 32.25
-5 –6.75
Input these values and calculate the average return, standard deviation, and coefficient of variation for Stock C.
a) Average rate of return for the past 5 years = Sum of Returns/ 5
Therefore, Average return of A = (-18+33+15-0.5+27) / 5 = 11.30%
Therefore, Average return of B = (-14.5+21.8+30.5-7.6+26.30) / 5 = 11.30%
b) If someone had 50% stock A and 50% stock B in their portfolio, then every year the returns would be
For year -1 , the return would be (-18%+ (-14.5%))/2 = -16.25%
For year -2 , the return would be (33%+ 21.8%)/2 = 27.4%
For year -3 , the return would be (15%+ 30.5%)/2 = 22.75%
For year -4 , the return would be (-0.5%+ (-7.6%))/2 = -4.05%
For year -5 , the return would be (27%+ 26.30%)/2 = 26.65%
The Average return on the portfolio = (-16.25+27.4+22.75-4.05+26.65)/5 = 11.30%
c) Standard Deviation is calculated by
where Ri is the Return in period i and
is the average return
So Standard Deviation (A) = sqrt {[{ (-18 -11.30)2 + (33-11.30)2+(15-11.30)2+(-0.5-11.30)2+(27-11.30)2}/4]
=sqrt [{(-29.30)2 + 21.72 +3.72 + (-11.8)2 + 15.72}/4]
=20.79%
& Standard Deviation (B) = sqrt {[{ (-14.5 -11.30)2 + (21.8-11.30)2+(30.5-11.30)2+(-7.6-11.30)2+(26.30-11.30)2}/4]
=sqrt [{(-25.80)2 + 10.52 +19.202 + (-18.9)2 + 152}/4]
=20.78%
& Standard Deviation (portfolio) = sqrt {[{ (-16.25 -11.30)2 + (27.4-11.30)2+(22.75-11.30)2+(-4.05-11.30)2+(26.65-11.30)2}/4]
=20.13%
d) CV (A) = standard Deviation (A) / Average return of A
= 20.79%/11.3% = 1.8398
CV (B) = 20.78%/11.3% = 1.8387
& CV(port) = 20.13%/11.30% = 1.7812
If I am a risk averse investor, I would prefer the portfolio over A or B because of lower Coefficient of Variation (CV)