  The following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period. MonthMadison CookiesSophie Electric1-0.040.0720.06-0.023-0.07-0.1040.120.155-0.02-0.0660.050.02 Compute the following:a. Average monthly rate of return, Ri, for each stockb. Standard deviation of returns for each stockc. Covariance between the rates of returnd. The correlation coefficient between the rates of returnWhat level of correlation would you have expected before performing your calculations? How did your expectations compare with the computed correlation? Would these two stocks be good choices for diversification? Why or why not?

Question
 The following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period.

 Month Madison Cookies Sophie Electric 1 -0.04 0.07 2 0.06 -0.02 3 -0.07 -0.10 4 0.12 0.15 5 -0.02 -0.06 6 0.05 0.02

 Compute the following: a. Average monthly rate of return, Ri, for each stock
 b. Standard deviation of returns for each stock
 c. Covariance between the rates of return
 d. The correlation coefficient between the rates of return
 What level of correlation would you have expected before performing your calculations? How did your expectations compare with the computed correlation? Would these two stocks be good choices for diversification? Why or why not?
Step 1

a.

Calculation of Average Monthly Rate of Return for each stock:

The Average Monthly Rate of Return is calculated using an excel function =AVERAGE, which provides the average. The excel spreadsheet with excel function is shown below:

Step 2

The excel spreadsheet with workings is shown below:

Step 3

b.

Calculation of Standard Deviation of Return for each stock:

To calculate the standard deviation of each stock, it is required to calculate the variance for each stock. The variance is calculated using ...

Want to see the full answer?

See Solution

Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in 