Download historical 5 year monthly stock prices of any two, Ask an Expert

Finance

Download historical (5 year, monthly) stock prices of any two companies you choose and the S&P index and do the following:

(a) explore the data by plotting one or two illustrative graphs using excel. Calculate the monthly average return, standard deviation of the monthly return for each of the two companies and the S&P 500 index.

(b) Calculate the beta of the two companies you choose using

(1) Three year of monthly data

(2) five years of monthly data

compare the beta values obtained using data (1) and data (2) and the one reported on the web.

Note 1: You may use finance.yahoo.com, or ft.com, or wsj.com

Note 2: Please just submit ONE Excel file, which includes

(1) the data and your calculation

(2) clear statements of your results and any comments.

Please choose your own companies and data.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92746094

Have any Question?Write your Review or question?

Related Questions in Financial Management

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

Introductionthroughout this course the focus has been on

Introduction Throughout this course, the focus has been on the problem-solving model and learning how to complete the steps. In addition, you learned how to utilize analysis tools to help you with some of the problem-sol ...

Nbspassignmentchapter 4 mini-case - samps air long term

Assignment Chapter 4 mini-case - S&S Air long term financial planning Note: data is based on the S&S Air financial statements S&S Air, INC. 2009 Income Statement Sales $30,499,420 Cost of goods sold $22,224,580 Other ...

Working capital management mini-casesyou may do this case

Working capital management mini-cases You may do this case alone or with up to two others. If you work with others, please submit only one assignment, but be sure it includes all names. Except for cases E and F, each cas ...

Discussion question find an example of a document that

Discussion Question : Find an example of a document that misuses graphics. This can be a document that you have received (please blot out any sensitive information and names) or a document that you find on the Internet. ...

Assignment1 a chemical company manufactures three chemicals

Assignment 1. A chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 unit ...

Use the internet to locate information regarding a

Use the Internet to locate information regarding a negotiation from the past 6 months that you would consider to be integrative in nature. Examine the differences between distributive and integrative negotiation. Determi ...

1 in week four the focus was on analysis tools for

1. In week four, the focus was on analysis tools for determining solutions. In week five, we discussed groups and you also completed an assignment on analysis tools used for groups/teams. This week, one of the topics is ...

Case 1 hedging currency risks at aifsinstructionsplease

Case 1: Hedging Currency Risks at AIFS Instructions: Please download the case and accompanying material from the HBS link that I provided on Canvas. For your analysis of the case, I am asking you put yourself in the shoe ...

Project risk finance and monitoring assignment -

Project risk, finance, and monitoring Assignment - Report Assessment Description - In this assessment in Part A students are asked to imagine they have been engaged by an external client to develop a report on key aspect ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert