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.

Reviews

Write a Review

Portfolio Management Questions & Answers

  Portfolio analysis

The stock with the lowest beta (0.76) is Apple Inc. stock. The stock with the highest beta (3.29) is Facebook Inc. stock. Beta for Apple Inc. stock is less that 1, it tells us that stock price is less volatile and risky than mark..

  Provide investment portfolio advice

Provide investment portfolio advice and management to a client.

  Evaluate total number of shares

EBV proposes to structure the investment as 5m shares of CP with FV of $5m, one-to one conversion to common, and no dividends. Total Valuation Estimated from Newco.

  Role of the imf and world bank

Economic and territorial logic of empire are not always aligned. Explain his argument in light of the role of the IMF and World Bank as forms of neo imperialism.

  Prepare a portfolio of stocks

Prepare a portfolio of stocks

  Which critically examines the benefits and risks to company

Which critically examines the benefits and risks to a company, of incorporating corporate debt into a portfolio of equity and debt.

  Compute the variance-covariance matrix

Compute the sample mean, variance, and standard deviation of these shares and compute the variance-covariance matrix V and Plot the daily share prices and daily returns for each individual asset.

  Net nominal rate of interest and net real rate of interest

What bank portfolio can guarantee the rate of return 1 to all type 1 people and the rate of return 1.2 to all type 2 people? How many goods are placed in storage? In capital?

  Right issue to improve financial status

If you are the CEO of a British company that now faces the loss of a lucrative contract in Malaysia because of the dispute. What action should you take and How do you think British government should respond to the Malaysian action?

  Calculate the cost of reinvested profits

Calculate the cost of reinvested profits and the cost of new common shares using the constant-growth DVM - Cost of reinvested profits versus new common shares-DVM

  Calculate the after-tax cost of debt

Cost of debt For each of the following bonds, calculate the after-tax cost of debt. Assume the coupons are paid semi-annually, that the tax rate is 40 percent, and that we are dealing with $1,000 of par value.

  Calculate the overall cost of capital for cartwell products

Calculate the overall cost of capital for Cartwell Products. Which projects should the firm select? Does your answer differ from your answer topart d? If so, explain why.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd