Calculate set of returns that correspond to daily price

Assignment Help Portfolio Management

Reference no: EM13923972

You want to evaluate the recent investment performance for two stocks-Walgreens and Exxon Mobil-relative to the S&P 500 index.

a. Under the "Company Analysis" tab, look up the ticker symbols for Walgreens and Exxon Mobil.

b. For each firm, as well as for the S&P 500 index, download daily price information for the past year using the menu options available under the "Prices" tab for each company.

c. For each firm, calculate the set of daily returns that correspond to these daily price series.

d. Using daily returns for the past year, calculate the beta coefficient for Walgreens and Exxon Mobil compared to the S&P 500 index. (Note: You can either build your own spreadsheet model to perform these calculations or use Excel's built-in functions for "Slope" or "Regression.")

e. Based on your results in Part d, which stock appears to be the riskiest?

Reference no: EM13923972

Questions Cloud

Prepare the journal entries for each transactions : Directions. Prepare the journal entries for each of the three transactions, in good form for Wei Asian Imports. You can use the Journal entry page at the end of this document to enter your answers.

Which e-mail security protocols depends upon a web. : Which e-mail security protocol(s) depend(s) upon a "Web of Trust"?

Describe the mix of health care provision in contemporary : Describe the mix of health care provision in contemporary Britain. Evaluate different approaches to the funding of health services in Britain. Identify and evaluate the demographic factors that are likely to affect the NHS in the future. Explain the ..

Degenerative diseases, prior to engaging : Degenerative Diseases. Prior to engaging in this discussion, read "The Experience of Disease: Psychosocial Aspects of Movement Disorder" (Jacopini, 2000), "Caregiver Bodywork: Family Members Experiences of Caring for a Person With Motor Neuron Dis..

Calculate set of returns that correspond to daily price : Calculate the set of daily returns that correspond to these daily price series. Based on your results in Part d, which stock appears to be the riskiest?

Consultant to assist in streamlining the data processing : Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics.

Effectively synthesize information relevant to summary : You have been asked to speak to an audience on the importance of the social factors affecting one's experience of life. For this presentation, create an interesting and educational PowerPoint presentation, which contains a critical narrative that ..

How do beta estimates for walgreens and exxon mobil differ : How do your beta estimates for Walgreens and Exxon Mobil differ when using daily versus weekly data in the estimation process? Does your conclusion change about which stock is the riskiest?

Purchasing the existing business : Determine if it would make more sense to open the new business you describe or to purchase the existing business you selected. Explain your reasoning.

User Account

All Pages