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

  Shares of stock and stock redemption

Kingbird Corporation (E & P of $800,000) has 1,000 shares of stock outstanding. That stock is held by Amata (550 shares) and Esteban (450 shares), who are unrelated individuals. Kingbird redeems 200 of Amata's shares for $1,000 per share. Amata pa..

  Statement of owner equity for the calendar

Prepare the income statement and the statement of owner's equity for the calendar year 2009 and the classified balance sheet at Dec 31, 2009.

  Define the nature of the public accounting market in terms

define the nature of the public accounting market in terms of firms clients regulation in any country that you

  Taxable income-purposes of accumulated earnings tax

Its taxable income in the first year is $300,000. It makes no distribution to its shareholders during that year of during the first 2.5 months of the 2nd year. The only adjustments to taxable income for purposes of the accumulated earnings tax if ..

  How would you respond to proposal

DuHurst Corporation has $4 billion in assets, $3 billion in equity, and earned a profit last year as the economy boomed of $100 million. Senior management proposes paying themselves a large cash bonus in recognition of their performance

  What is happening at youngsborough and why

What is happening at Youngsborough and why? How could this situation beavoided and Drop any product that is unprofitable with the revised cost assignment. Repeat the process, eliminating any unprofitable products at each stage.

  The most probable value to role on two dice is 7 the most

the most probable value to role on two dice is 7. the most probable number of heads in two coin flips is one head. what

  Total amount paid for the merchandise

A company purchased $4,000 worth of merchandise. Transportation costs were an additional $400. The company later returned $445 worth of merchandise and paid the invoice within the 3% cash discount period. The total amount paid for this merchandise..

  The cash account in the general ledger of lyco corporation

the cash account in the general ledger of lyco corporation showed a balance of 21749 at december 31.the companys bank

  Which of the two basic reporting approaches for cash flows

which of the two basic reporting approaches for cash flows from operating activities did the company

  Tri fecta a partnership had revenues of 367000 in its first

tri fecta a partnership had revenues of 367000 in its first year of operations. the partnership has not collected on

  Journal entries for government based on production

Prepare Journal Entries for the government based on the production of fund-based financial statements. Than prepare JE entries in anticipation of preparing governement-wide financial statements. Before each JE state which fund the JE is recorded i..

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