Question: 1. Calculate the average return and standard deviation for the market and the stock. (Use excel to complete the problem. Do not round intermediate calculations.

Calculate the average return and standard deviation for the market and the stock. (Use excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Omit the "%" sign in your response.)

2. Calculate the correlation between the stock and the market, as well as the stocks beta. (Use excel to complete the problem. Do not round intermediate calculations. Round your Correlation answer to 2 decimal places and Beta answer to 4 decimal places.)

1. Calculate the average return and standard deviation for the market

You are given the following information concerning a stock and the market: Calculate the average return and standard deviation for the market and the stock. (Use excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Omit the "%" sign in your response.) Calculate the correlation between the stock and the market, as well as the stock's beta. (Use excel to complete the problem. Do not round intermediate calculations. Round your Correlation answer to 2 decimal places and Beta answer to 4 decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Problem 12-22 Calculating Beta (CFA1) You are given the following information concerning a stock and the market Year 2011 2012 2013 2014 2015 2016 Returns Market Stock 17% 29% 13 13 20 3 -8 -16 35 16...

Stock Y has a beta of 1.05 and an expected return of 15.55 percent. Stock Z has a beta of .90 and an expected return of 6 percent. If the risk-free rate is 4.0 percent and the market risk premium is...

1.) Suppose you observe the following situation: Security Beta Expected Return Peat Co. 1.50 14.5 Re-Peat Co. .75 10.6 Assume these securities are correctly priced. Based on the CAPM, what is the...

You are given the following information concerning a stock and the market: Returns Year Market Stock 2008 17 % 29 % 2009 13 13 2010 20 3 2011 8 16 2012 35 16 2013 15 21 1. Calculate the average...

You are given the following information concerning a stock and the market: Returns Year Market Stock 2008 19 % 31 % 2009 10 16 2010 19 3 2011 15 28 2012 37 16 2013 15 15 1. Calculate the average...

You are given the following information concerning a stock and the market year Market Stock 2008 15% 27% 2009 19% 19% 2010 25% 5% 2011 -12% -22% 2012 35% 16% 2013 15% 27% 1.) Calculate the average...

You are given the following information concerning a stock and the market: Returns Year Market Stock 2008 10 % 25 % 2009 12 28 2010 13 4 2011 14 22 2012 37 16 2013 15 23 1. Calculate the average...

You are given the following information concerning a stock and the market: Returns Year Market Stock 2008 15 % 27 % 2009 19 19 2010 25 5 2011 12 22 2012 35 16 2013 15 27 1. Calculate the average...

You are given the following information concerning a stock and the market: Returns Year Market Stock 2008 15 % 27 % 2009 14 30 2010 15 6 2011 14 24 2012 37 16 2013 15 25 1. Calculate the average...

The International Coffee Association has reported the mean daily coffee consumption for U.S. residents as 1.65 cups. Assume that a sample of 38 people from a North Carolina city consumed a mean of...

The following quote appears in The Wealth of Nations, a very influential economics book published in 1776 by Adam Smith. "It is not from the benevolence of the butcher, the brewer, or the baker that...

On the basis of the two stocks' expected and required returns, which stock would be more attractive to a diversified investor? - Select - Stock XStock Y

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Approaches to Managing Organizations

Do members demonstrate respect for one anotherfor example, by keeping disagreements focused on the issues or positions at hand rather than on personal character?

Communicating Organizational Culture