menu
bartleby
search
close search
Hit Return to see all results

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? 
check_circleAnswer
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:

fullscreen
Step 2

The excel spreadsheet with workings is shown below:

fullscreen
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 ...

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Business

Finance

Related Finance Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Instead of solving for a zero NPV as is usual in setting a bid price, the company president requires...

A: Click to see the answer

question_answer

Q: Your son has come to you for advice. He is about to enter college and has two options open to him. H...

A: As a first step, let's calculate the NPV of Pharmacy / MBA option making use of the cash flows. We w...

question_answer

Q: NOTE: You already replied on this question with the answers as indicated below. Unfortunately, all a...

A: Part (a)All financials below are in $ mn.The net cash flow at time 0 if the old equipment is replace...

question_answer

Q: Romagnoli Company is considering a 3-year investment project that involves the purchase of a new man...

A: Since we have to handle multiple variables here, we will use Microsoft Excel to get the final answer...

question_answer

Q: Is it possible to view a firm's equity as an option? What could be the implications?

A: Let's recall the following two points:Basic accounting equation: Assets, A = Equity, E + Liabilities...

question_answer

Q: The following problem refers to the stock table for ABC Inc.​ (a tire​ company) given below. Use the...

A: A.The amount of shares traded yesterday is nothing but the total volume of shares which is 591,500 s...

question_answer

Q: Dave's Lumber earned $120 million last year and retained $72 million. A. What is his payout ratio?

A: Calculating the value of dividend paid. We have,Value of dividend paid = Total Earnings – Retained E...

question_answer

Q: Deb and Rusty have just gotten married and wish to buy a home. They both work in Boston and have a c...

A: Let the largest amount they can use for a down payment be $ A.Cost of the house, C  = $ 350,000Hence...

question_answer

Q: The level of the Syldavian market index is 21,300 at the start of the year and 25,800 at the end. Th...

A: Part (a)As a first step let's assign a symbol to all the information we have in the question.I0 = In...

Sorry about that. What wasn’t helpful?