Compare beta values obtained using data and data

Assignment Help Financial Management

Reference no: EM131907425

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.

Reference no: EM131907425

Questions Cloud

What is the attorney-client privilege : What is the attorney-client privilege? Legal assistants and other non-lawyers are prohibited from practicing law. What acts constitute the practice of law?

What are victims bills of rights : What are victims' bills of rights? Name three rights typically included in such a law. According to the Police Code of Conduct promulgated by the International.

What if the result is the release of a violent criminal : Do you believe that a defense attorney should be required to zealously represent a client who has admitted guilt to the lawyer?

What factors should an officer consider to arrest : Do you believe that police officers should arrest every violator they encounter, discover, or are made aware of? Support your answer.

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

What are the disadvantages of such a system : In some nations, prosecutors are required to file a criminal charge if sufficient evidence exists. What are the advantages of such a system?

Should such a method be employed in the United States : In some nations, individual victims are permitted to file a criminal charge against the person(s) who committed the alleged act(s).

Equity valuation and firm or business valuation : Explain the main differences between equity valuation and firm or business valuation.

Discuss the four constitutional rights : What four constitutional rights are likely to be invoked by suspects during the pretrial identification stage? Briefly discuss how each applies to lineups.

User Account

All Pages