User Account

All Pages

Monthly adjusted closing price for target corp

Assignment Help Finance Basics
Reference no: EM13839765

Assignment 1:

Download the monthly Adjusted Closing Price for Target Corp. (Ticker = TGT) from Yahoo website from October 31, 2009 to October 31, 2014 and calculate following:

1. Average monthly return

2. Variance of returns

3. Standard deviation of returns.

Note that Adjusted Closing Price column from Yahoo already adjusts for dividends and stock splits.

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 "expand the selection" is selected, then click on SORT and sort by Date and order by 'Oldest to Newest').

Calculating 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.  

Ret(t) = P(t)/P(t-1) - 1

Assignment 2

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. 1 1 = - t- t t P P R

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: EM13839765

Questions Cloud

How is a partnership created : How is a partnership created? How are partnerships taxed, and what sort of liability do they have? Can you see reasons for choosing another entity form over a partnership
Explain what is meant by evaluate nontax implications : Conflict Is there a possibility that during one's tax research, the answers from different sources conflict? If so, how does one handle a conflict
Justify an exception to the employment-at-will rule : KU pointed out that there was no evidence that it actually violated the regulation during Jasper's period of employment. Shouldn't an employer have to "act" before any public policy concerns justify an exception to the employment-at-will rule
What is the coefficient of sliding friction : What is the coefficient of sliding friction
Monthly adjusted closing price for target corp : Download the monthly Adjusted Closing Price for Target Corp. (Ticker = TGT) from Yahoo website from October 31, 2009 to October 31, 2014 and calculate following:
Describe the critical role of operations management plays : Describe the critical role of operations/logistics management plays in business organisations. Evaluate the characteristics of various operations and logistics environments and assess their impact on business.
Express the probability as a decimal : Express the probability as a decimal
Which phrase describes the parts of a basic music staff? : Which phrase describes the parts of a basic music staff?
Find the kinetic energy at takeoff : Find the kinetic energy at takeoff

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the present value of an annuity of 200 per year

what is the present value of an annuity of 200 per year for five years if the required rate of return is 8? what is the

  You could earn 55 on your money in other investments with

you have a chance to buy an annuity that pays 2500 at the end of each year for 3 years. you could earn 5.5 on your

  Abc company bonds have 4 years left to maturity

ABC company bonds have 4 years left to maturity. Interest is paid annually, and the bonds have a $1,000 par value and a coupon rate of 9%. What is the yield to maturity at a current market price of (1) $829 and (2) $1,104?

  The risk-free rate is 3 per annum the risk-premium is 5

a corporate bond with a beta of 0.2 will pay off next year with 99 probability. the risk-free rate is 3 per annum the

  You want to have 80000 in your savings account 11 years

you want to have 80000 in your savings account 11 years from now and youre prepared to make equal annual deposits into

  Once you have identified the 3 stocks you need to find the

you need to find alice 3 stocks to invest in from different segments of the market. the stocks should come from 3

  Find the total cost to the firm of issuing the securities

The firm's stock price increased 17.5 percent on the first day. What was the total cost to the firm of issuing the securities?

  Assume that the beta of the underlying assets is 2 how does

assume that a firm will always have enough money to pay off its bonds so the beta of its bonds is 0. the rate of return

  What is the company cost of equity

Chandeliers Corp. has no debt but can borrow at 6.7 percent. The firm's WACC is currently 8.5 percent, and the tax rate is 35 percent. What is the company's cost of equity?

  Research assistant from prospectuses

Assume these are financial data that have been extracted by your research assistant from prospectuses of New Zealand Non-bank Financial Institutions (NBFIs). The data are organized by alphabet in the blue sheet tabs A-G etc.

  Debt an obstacle to continued prosperity

The accumulated government deficits over the history of the United States have added up to such a large total. In your opinion, is the size of this debt an obstacle to continued prosperity? Why or why not?

  Calculate the eac for old and new computer

a. Calculate the EAC for old and new computer. b. What is the NPV of the decision to replace the computer now?

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