User Account

All Pages

Analyze time series of monthly returns

Assignment Help Accounting Basics
Reference no: EM13836753

This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of June 30, 2011 - June 30, 2015 from Yahoo website for

  • S&P 500 Index (ticker: ^GSPC)
  • Merck & Co. Inc (ticker: MRK)
  • Nike (ticker: NKE)

Instructions for downloading the data from Yahoo!:

To obtain the monthly data, click on "Historical Prices" on the left panel. Select Date Range. Make sure Monthly is selected and then click on "Get Prices". Scroll down and click on "Download to Spreadsheet".

Instructions for sorting the data by DATE:

Re-sort the data so that the most previous date is at the bottom of your spreadsheet (i.e. highlight DATE columns and click on SORT, make sure you "Expand the selection" is selected, then click on SORT and sort by Date and order by 'Oldest to Newest').

First Calculate Returns:

Use the 'Adjusted Close' column to obtain returns for each period. Remember that the Adjusted Close column has already adjusted the prices for dividends and stock splits so you do not have to adjust for it again. Just use the adjusted close column to obtain the returns.

895_Calculate Returns.jpg

Solve for the following:

A. Calculate the average, variance and standard deviation for the returns of each series. Comment on the statistics.

B. Calculate the covariance and the correlation coefficient between each of the return series (there should be a total of three correlations and three covariances). Comment on the statistics.

C. If you were to form a portfolio that had 50% of the S&P 500 Index and 50% of Merck, what would be the average returns and the standard deviation of that portfolio? (Ignore the fact that both Merck may already be included in the S&P 500)

D. If you were to add Nike to your portfolio so that you now had 33% S&P 500, 33% Merck, and 34% Nike, what would be the new average returns and standard deviation? (Ignore the fact that both Nike and Merck may already be included in the S&P 500) Is Nike a good addition to your portfolio? Why do you think so?

E. Determine MRK's beta.

F. Determine Nike's beta

Reference no: EM13836753

Questions Cloud

What is the debt-equity ratio : A firm wants a sustainable growth rate of 3.13 percent while maintaining a 27 percent dividend payout ratio and a profit margin of 6 percent. The firm has a capital intensity ratio of 2. What is the debt-equity ratio that is required to achieve the f..
Making monthly deposits into a savings account : Julie wishes to begin making monthly deposits into a savings account which earns 5% interest annually. If she intends to have saved $8,500 by the end of 3 years, how much must she deposit each month?
What is expected value of perfect information about product : Should the product be marketed? Why? What is the expected value of perfect information about the success or failure of the product?
The technology in catching lies in the brain : the technology in Catching lies in the brain could be used to learn more about animal cognition? Make a list of reasons why and why not.
Analyze time series of monthly returns : This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of June 30, 2011 - June 30, 2015 from Yahoo website for
Explain what was the organism that mendel studied : What was the organism that Mendel studied (provide the genus and species name as well as the common name). Why was this organism ideal to study the law of independent assortment
Describe special education services : special education services
John jones is buying a house : John Jones is buying a house for $100,000. John can get a loan for 95% of the purchase price at 8% with monthly payments for a 25-year term. What would his payments be if he borrows under these terms?
How piagets and vygotskys theories complement each other : how Piagets and Vygotskys theories complement each other

Reviews

Write a Review

Accounting Basics Questions & Answers

  Conversions and disclosure requirements

Financial Statements Conversions and Disclosure Requirements

  How should clyde treat payment on his 2010 tax return

This is a tax research problem - Clyde had work for many years as the chief executive of Red Industries, and had also been a major shareholder. Clyde and the company had a falling out, and Clyde was terminated.

  Company a issues a 15 year 2 70000 face amount bond which

company a issues a 15 year 2 70000 face amount bond which pays interest twice a year. at the time the bond issued the

  At the beginning of 2011 robotics inc acquired a

at the beginning of 2011 robotics inc. acquired a manufacturing facility for 12 million. 9 million of the purchase

  Grant desires a 10 rate of return on its investments

grant leasing company agrees to lease machinery to jackson corporation on january 1 2013. the following information

  Journal entries recording employee admission

William and Frank are partners whose capital balances are $400,000 and $300,000 and who share profits 3:2. Due to a shortage of cash, William and Frank agree to admit Sammy to the firm.

  Soobin corporation has coperate taxable income in 2014 or

soobin corporation has coperate taxable income in 2014 or 16000000. use the corporate tax table to calculate the income

  Maximum amount of the stock redemption

The maximum amount of the stock redemption proceeds under Sec. 303 is determined by summing all of the following except

  Classify these costs as prevention appraisal internal

piab enterprises has identified the following as having an impact on the companys quality costs1. inspection of

  Determine cash generated from operations

1) Which financial statement is used to determine cash generated from operations?

  Discuss the importance of cost of goods sold

Describe the alternatives the organisers have in relation to recognizing revenues. Which would you recommend and why - Discuss the importance of Cost of Goods Sold(COGS) in this case. How is it applied?

  Oakland college is considering outsourcing grounds

oakland college is considering outsourcing grounds maintenance. in this regard oakland has received a bid from highline

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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