Estimate the stock beta for company

Assignment Help Financial Management

Reference no: EM131995596

NETFLIX

(i) Estimate the stock beta for a company. Select a publicly traded company (preferably large firms) and download the monthly closing prices for 5 years into Excel. Choose a market index (e.g. S&P 500) and download the monthly closing values for 5 years into Excel. Calculate the monthly returns for the selected company and the market index. Using the regression function in Excel, regress the stock return on the market index return.

(ii) Compare and contrast the stock beta you estimated with two other sources (e.g. Yahoo! Finance, CNBC, etc.).

Reference no: EM131995596

Questions Cloud

Can you think of any legitimate justification : Can you think of any legitimate justification for the organization's actions with 2 examples? Explain and justify your explanation.

Atc when free flight is implemented : How does Next Gen work and could it take place with respect to ATC when Free Flight is implemented?

Historical development of aviation : How are the concerns by aviation professionals on the transition to Next Gen and how does the historical development of aviation relate to the future technology

What are some recommendations that would help a project team : What are some recommendations that would help a project team to be able to stay on top of risks as they evolve throughout a project?

Estimate the stock beta for company : Estimate the stock beta for a company. Select a publicly traded company (preferably large firms) and download the monthly closing prices for 5 years into Excel.

Demonstrating mastery of the competency : You will be demonstrating mastery of the competency associated with your emphasis (field of study).

What should be duration of assets for bank balance sheet : What should be the duration of assets for the bank’s balance sheet to be immunized against the interest rate risk?

Conduct an online job search in health care administration : Conduct an online job search in Health Care Administration. Try to find at least 3 positions for which you will be qualified and that interest you.

Write a personal narrative paper on an instance : Write a personal narrative paper on an instance of personal learning. Provide detail about the following: what was learned (what changed from start to finish).

User Account

All Pages