In: Finance
You are given the returns for the following three stocks:
| 
 Year  | 
 Stock A  | 
 Stock B  | 
 Stock C  | 
| 
 1  | 
 14%  | 
 15%  | 
 -20%  | 
| 
 2  | 
 14%  | 
 20%  | 
 35%  | 
| 
 3  | 
 14%  | 
 13%  | 
 35%  | 
| 
 4  | 
 14%  | 
 8%  | 
 15%  | 
| 
 5  | 
 14%  | 
 14%  | 
 5%  | 
Calculate the arithmetic return, geometric return, and standard deviation for each stock. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Omit the "%" sign in your response.)
Calculation of arithmetic return of Stocks:
Arithmetic return = sum of returns of all years/No.of years
No.of years = 5
Arithmetic return of Stock A= 14%+14%+14%+14%+14%/5
= 70%/5
= 14
Arithmetic return of Stock B= 15%+20%+13%+8%+14%/5
= 70%/5
= 14
Arithmetic return of Stock C = -20%+35%+35%+15%+5%/5
= 70%/5
= 14
Calculation of geometric returns of stocks:
Geometric return= (1+r1)*(1+r2)*(1+r3)*(1+r4)*(1+r5)^1/n-1
r1 = return of 1st year
r2 = return of 2nd year
r3 = return of 3rd year
r4= return of 4th year
r5 = return of 5th year
Geometric return of Stock A = (1.14)*(1.14)*(1.14)*(1.14)*(1.14)^1/5-1
= (1.14)^5*1/5-1
= 1.14-1
= 0.14
Geometric return of Stock B = (1.15)*(1.2)*(1.13)*(1.08)*(1.14)^1/5-1
= 1.1393-1
= 0.1393 or
= 0.14 (rounded to 2 decimals)
Geometric return of Stock C = (-1.2)*(1.35)*(1.35)*(1.15)*(1.05)^1/5-1
= -1.214-1
= -2.214 or
= -2.21 (rounded to two decimals)
Calculation of Standard deviation of stocks:
Standard deviation of Stock A:
| Year | Return- Expected return (1) | 
 Square of Return-Expected return /Variance(2)  | 
| 1 | 14%-14%=0 | (0)^2 =0 | 
| 2 | 14%-14%=0 | (0)^2=0 | 
| 3 | 14%-14%=0 | (0)^2=0 | 
| 4 | 14%-14%=0 | (0)^2=0 | 
| 5 | 14%-14%=0 | (0)^2=0 | 
| Variance | 0 | 
Standard deviation = Square root of Variance
= Square root of 0
= 0
Standard deviation of Stock B:
Arithmetic return/Expected return = 14% or 0.14
| Year | Return-Expected return (1) | 
 Square of Return-Expected return/Variance (2)  | 
| 1 | 0.15-0.14=0.01 | (0.01)^2 =0.0001 | 
| 2 | 0.20-0.14=0.06 | (0.06)^2=0.0036 | 
| 3 | 0.13-0.14=-0.01 | (-0.01)^2 =0.0001 | 
| 4 | 0.08-0.14=-0.06 | (-0.06)^= 0.0036 | 
| 5 | 0.14-0.14= 0 | (0)^2 =0 | 
| Variance | 0.0074 | 
Standard deviation = Square root of Variance
= Square root of 0.0074
= 0.086
Standard deviation of Stock C:
Arithmetic mean/Expected return = 14% or 0.14
| Year | Return-Expected return (1) | Square of Return-Expected return/Variance (2) | 
| 1 | -0.2-0.14=-0.34 | (-0.34)^2 =0.1156 | 
| 2 | 0.35-0.14=0.21 | (0.21)^2 =0.0441 | 
| 3 | 0.35-0.14=0.21 | (0.21)^2 = 0.0441 | 
| 4 | 0.15-0.14=0.01 | (0.01)^2 = 0.0001 | 
| 5 | 0.05-0.14=-0.09 | (-0.09)^2 = 0.0081 | 
| Variance | 0.212 | 
Standard deviation = Square root of Variance
= Square root of 0.212
= 0.4604