Question

In: Finance

8.) During the past five years, you owned two stocks that had the following annual rates...

8.) During the past five years, you owned two stocks that had the following annual rates of return:

Year   Stock T       Stock B
1   0.16       0.08
2   0.08       0.03
3   -0.12       -0.09
4   -0.03       0.02
5   0.15       0.04

a) compute the arithmetic mean annual rate of return for each stock, which stock is most desirable by this measure?
b) Compute the standard deviation of the annual rate of return for each stock. Which stock is most desirable by this measure?
C) Compute the coefficient of variation for each stock. Which stock is most desirable by this measure?
D) Compute the geometric mean rate of return for each stock. Dicuss the difference between the arithmetic mean and the geometric mean return for each stock.
Discuss the differences in the mean returns relative to the standard deviation of the return for each stock?

Solutions

Expert Solution

a) Arithmetic mean (nothing but average rate of return) annual rate of return for each stock are as below,

FOR Stock T, AM =   (0.16 + +0.08+(-0.12)+(-0.03)+0.15)/ 5 =0.24/5 = 0.048 = 4.8%

FOR Stock B, AM = ( 0.08+0.03+(-0.09)+0.02+0.04)/5 = 0.08/5 = 0.016= 1.6%

Stock T is the most desirable as it gives higher return on average i.e 4.6%

b) Standard Deviation (SD) of the annual rate of return for each stock,

SQRT is nothing but Square root,

FOR Stock T, SD = SQRT [[ (0.16-0.048)^2+(0.03--0.048)^2+(-0.12-0.048)^2+(-0.03-0.048)^2+(0.15-0.048)]/(5-1)]]

= SQRT[ (0.095144)/4)] = SQRT [0.023786] = 0.154227105 = 15.42%

FOR Stock B, SD = SQRT[[ (0.08 -0.016)^2 + (0.03-0.016)^2+(-0.09 -0.016)^2+(0.02-0.016)^2+(0.04-0.016)^2]/(5-1)]

= SQRT[[(0.020216/4)] = SQRT [0.005054] = 0.07109149 = 7.11%

Standard deviation is the measure of the volatility of return, higher the SD, higher the Risk and volatility in the stock. So, Stock B is the most desirable to less risk taking investor since it offers a lower standard deviation

C) Coefficient of variation is nothing but total risk per unit of return of an investment. It is calculated by dividing the standard deviation of an investment by Arithmetic mean or expected rate of return

Coefficient of variation,

FOR STOCK T: = 0.154227105/0.048 = 3.21

FOR STOCK B =  0.07109149 /0.016 = 4.44

Stock T is the most desirable to a risk-averse investor according to this measure as it offers the lowest coefficient of variation.

D) Geometric mean,

FOR STOCK T: = [(1.16*1.08*0.88*0.97*1.15)^(1/5) ] -1 = 1.042 -1 = 0.042 = 4.2%

FOR STOCK B   = [(1.08*1.03*0.91*1.02*1.04)^(1/5) ] -1 =1.0143-1= 0.0143=1.43%

The geometric mean for stock T and B is lower than the arithmetic mean. This is because Arithmetic mean captures some of the variation in return.

The entire problem solution can be find in the below table:

Stock T Stock B
Rt Rb (Rt-AM)^2 (Rb-AM)^2
0.16 0.08 0.0125 0.0041
0.08 0.03 0.0010 0.0002
-0.12 -0.09 0.0282 0.0112
-0.03 0.02 0.0061 0.0000
0.15 0.04 0.0104 0.0006
Total 0.24 0.08 0.0369 0.0041
Mean (AM) 0.048 0.016 Total 0.0951 0.0202
in % 4.8% 1.6% Total/(n-1) 0.0238 0.0051
SD (Standard dev) 0.1542 0.0711 SQRT of [Total/(n-1)]
in % 15.42% 7.11%
Coefficient of variation 3.21 4.44
Stock T Stock B Geometric mean
Rt Rb (1+Rt) (1+Rb)
0.16 0.08 1.16 1.08
0.08 0.03 1.08 1.03
-0.12 -0.09 0.88 0.91
-0.03 0.02 0.97 1.02
0.15 0.04 1.15 1.04
Multiplication 1.22980 1.07383
0.2 0.2
Geometric mean 1.042 1.014
in % 4.22% 1.43%



Related Solutions

During the past five years, you owned two stocks that had the following annual rates of...
During the past five years, you owned two stocks that had the following annual rates of returns yearStock xStock y10.190.0820.080.033-0.12-0.094-0.030.0250050.04a) Compute arithmetic mean annual rate of return for each stock. Which stock is most desirable by this measure? b) Compute the standard deviation of the annual rate of return for each stock. By this measure, which is the peferable stock? c) Compute the coefficient of variation for each stock By this relative measure of risk, which stock is preferable d) Compute the geometric mean...
During the past five years, you owned two stocks that had the following annual rates of...
During the past five years, you owned two stocks that had the following annual rates of return: Year Stock T Stock B 1 0.17 0.10 2 0.06 0.02 3 -0.06 -0.12 4 -0.04 0.04 5 0.11 0.06 Compute the arithmetic mean annual rate of return for each stock. Round your answers to one decimal place. Stock T:   % Stock B:   % Which stock is most desirable by this measure? -Select-Stock TStock BItem 3 is more desirable because the arithmetic mean annual rate...
During the past five years, you owned two stocks that had the following annual rates of return:
Problem 1-05 During the past five years, you owned two stocks that had the following annual rates of return: YearStock TStock B10.190.0620.090.063-0.06-0.074-0.030.0250.140.03a. Compute the arithmetic mean annual rate of return for each stock. Round your answers to one decimal place. Stock T: _______ % Stock B: _______ % Which stock is most desirable by this measure? _______ , is more desirable because the arithmetic mean annual rate of return is _______ . b. Compute the standard deviation of the annual...
You have owned the following two stocks over the past 5 years Year Sock A's Price...
You have owned the following two stocks over the past 5 years Year Sock A's Price Stock B's Price 2014 67 31 2013 46 25 2012 44 23 2011 50 18 2010 34 19 a. What is the standard deviation of a portfolio's return in which 50% of your portfolio is in each stock? ( Hint: Calculate the holding period return first) Please show all work and finance formulas.
The annual returns of three stocks for the past seven years are given in the following...
The annual returns of three stocks for the past seven years are given in the following table: Year Stock X Stock Y Stock Z 2011 3.00% 14.00% 19.00% 2012 9.00% 7.00% 11.00% 2013 12.00% 19.00% 5.00% 2014 19.00% 13.00% 12.00% 2015 23.00% -7.00% 11.00% 2016 5.00% -3.00% 7.00% 2017 10.00% 9.00% 14.00% Determine the average return and the standard deviation of returns for each stock. Which stock has the highest expected return and which one has the highest risk? Determine...
The following data on annual rates of return were collected from five stocks listed on the...
The following data on annual rates of return were collected from five stocks listed on the New York Stock Exchange (“the big board”) and five stocks listed on NASDAQ. Assume the population standard deviations are the same. At the .10 significance level, can we conclude the annual rates of return are higher on the big board? NYSE                  17.16                   17.08                 15.51                  8.43                     25.15 NASDAQ             15.80                  16.28                  16.21                  17.97                   7.77 Really important: Use Excel as described in “How...
As a new analyst you have calculated the following annual rates of return for the stocks...
As a new analyst you have calculated the following annual rates of return for the stocks of both Lauren Corporation and Raleigh Industries Year Lauren rate of return Kayleigh rate of return 2015 5 5 2016 12 15 2017 -11 5 2018 10 7 2019 12 -10 Compute average return, standard deviations, coefficient of variation co-variances and correlations of the two stocks Would a combination of Lauren and Kaleigh be good for diversification? Graph risk return relationship Identify minimum variance...
As a new analyst, you have calculated the following annual rates of return for the stocks...
As a new analyst, you have calculated the following annual rates of return for the stocks of both Lauren Corporation and Kayleigh Industries. Year Lauren’s Rate of Return Kayleigh’s Rate of Return 2007 5 5 2008 12 15 2009 −11 5 2010 10 7 2011 12 −10 Your manager suggests that because these companies produce similar products, you should continue your analysis by computing their covariance and coefficient of correlation. Calculate covariance and correlation for both companies and explain, would...
The S&P 500 and Nohr Corp had the following returns over the past five years Year   ...
The S&P 500 and Nohr Corp had the following returns over the past five years Year        S&P 500               Nohr .12                     .23 .01                     -.05 .18                     .20 .09                     .12 .10                     .20 a. What was the mean AND standard deviation of returns (population version) for Nohr for the 5 years? b. What was the beta of Nohr relative to the S&P 500?                   c. What was the geometric mean return for Nohr for the 5 years?
Consider two bonds, both with 8% coupon rates (assume annual coupon payments) one with 10 years...
Consider two bonds, both with 8% coupon rates (assume annual coupon payments) one with 10 years to maturity and the other with 20 years to maturity. Assume that current market rates of interest are 8%. Calculate the difference in the change of the price of the two bonds if interest rates decrease to 6% one year after purchasing the bond. Repeat the procedure assuming that interest rates increase to 10% one year after purchase. Explain the major bond pricing principle...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT