Calculate average return and standard deviation for market

Assignment Help Financial Management

Reference no: EM131910429

You are given the following information concerning a stock and the market:

Returns

Year Market Stock

2008 18 % 34 %

2009 11 27

2010 12 3

2011 –14 –21

2012 37 16

2013 15 22

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. Enter your answers as a percent rounded to 2 decimal places. Omit the "%" sign in your response.) Market Stock Average return % % Standard deviation % %

2. 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.) Correlation Beta

Reference no: EM131910429

Questions Cloud

Consolidated omnibus budget reconciliation act : Explain the benefits of the Consolidated Omnibus Budget Reconciliation Act (COBRA).

How business can benefit from well-managed database : How business can benefit from a well-managed database, BI, the Internet, and wireless technology.

How would you counter such charge : Did the IRS err in these cases? To what rights are such groups entitled? What statuses would you---or would you not---confer upon such groups?

Identify a reason to necessitate change in criminal justice : Identify a reason to necessitate change in the criminal justice organization of your choice and discuss the process in which the change will occur.

Calculate average return and standard deviation for market : Calculate the average return and standard deviation for the market and the stock.

Improve the job satisfaction of employees : You work in the HR department of a company that wants to improve the job satisfaction of its employees.

Publicly owned and publicly managed venues versus publicly : Explain the differences between publicly owned and publicly managed venues versus publicly owned and privately managed venues.

Write a childrens book similar to the story told by matar : Write a children's book similar to the story told by Matar from the perspective of different members of his family or outsiders.

Determine the irr for project using financial calculator : An investment project has an initial outlay of 100,000 and is expected to generate annual cash inflows of 28000 for the next 5 years

User Account

All Pages