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

Please respond to the followinga as a financial manager

Please respond to the following: a) As a financial manager, determine at what point the risk of an investments outweighs the potential reward. Provide support for your rationale. b) Explain whether or not you believe an ...

In red is the hypothesis you chose to write about use the

In red is the hypothesis you chose to write about. Use the hypothesis to write the research paper The Shadow Bank System If the shadow bank system is given a platform to develop, then it will provide a solution to the ba ...

Read through the below post and provide any on of the

Read through the below post and provide any on of the following: APA format 250 Words. . Ask a probing question, substantiated with additional background information, evidence or research. · Share an insight from having ...

Question 1 discuss valuing bonds and how interest rates

Question : 1) Discuss valuing bonds and how interest rates affect their value. Also consider the importance of the yield-to-maturity (YTM). 2) Discuss common stocks and preferred stocks. Also, which common stock valuatio ...

Managerial financenbspplease submit a word document

Managerial Finance: Please submit a Word document including your answers to the 4 questions at the end of the instructions. Johnson Company The Johnson company and wants to increase its sales and would like to seek ad ...

International finance assignment- assignment informationthe

International Finance Assignment- Assignment Information The Economist publishes the Big Mac Index on a regular basis to provide an idea of the difference in purchasing power among different countries. In Australia CommS ...

Assignmentthe purpose of this assignment is to allow you

Assignment The purpose of this assignment is to allow you the chance to evaluate the role of social responsibility in society. After you complete this assignment, you will analyze a written article, be able to ascertain ...

Question under what circumstances are price factors more

Question : Under what circumstances are price factors more important than non-price factors during a source selection? Under what circumstances are non-price factors more important? Use headings to compare and contrast t ...

Assignment introduction to businessdirections be sure to

ASSIGNMENT : Introduction to Business Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure ...

Hedging assignment -your portfolio a stock is currently

Hedging Assignment - Your portfolio: A stock is currently trading at 55. You hold a portfolio of the following instruments: Long 200 shares of stock Long 200 puts with a strike of 50 and maturity of three months (T=13/52 ...

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