Calculate the correlation between the two stocks

Assignment Help Corporate Finance
Reference no: EM131288191

Assignment

You are to select two stocks and collect five years of month-end stock price data for each stock (December 31, 2010 - January 31, 2016).

Please use Yahoo! Finance adjusted closing prices.

Please complete the following, using the related Excel functions to answer questions 2-5:

1. Calculate monthly returns for each stock.

2. Calculate the arithmetic average monthly rate of return for each stock.
Excel Function: =Average(monthly returns array)

3. Calculate the geometric average monthly rate of return for each stock.

a. First add ‘1' to each monthly return
b. Excel Function: =geomean(monthly returns array) - 1

4. Calculate the standard deviation of monthly returns for each stock.
Excel Function: =stdev(monthly returns array)

5. Calculate the correlation between the two stocks.
Excel Function: =correl(Stock 1 monthly returns array, Stock 2 monthly returns array)

What to turn in:

1. One Excel spreadsheet with:

a. The following columns with the appropriate titles in Row A. Make sure that the latest month is listed first:

Column 1: Month, Year
Column 2: Adjusted Closing Prices for stock 1
Column 3: Adjusted Closing Prices for stock 2
Column 4: Monthly Returns (calculated) for stock 1 - format to percentage
Column 5: Monthly Returns (calculated) for stock 2 - format to percentage

b. Your answers to the questions 2- 5 above. This should be immediately below monthly prices and returns on your spreadsheet. Please label each answer appropriately.

Reference no: EM131288191

Questions Cloud

What is nation cash inflow or outflow on its current account : What is a nation's cash inflow or outflow on its current account given the following information? Which of the following best explains a potential disadvantage of leaving securities in street name?
Write the process to take an interview : Write the Process to take an Interview.Write a paper from your perspective, on how that process occurred, what happened, what the leader would do again, and what mistakes he or she may have made.
What is the amount of goods available for sale : At the beginning of the year, Kelly Sales had $2,400 of merchandise inventory. During the year, Kelly purchased $22,000 of inventory. At the end of the year, a count of the inventory revealed that Kelly had $1,600 of inventory on hand. What is the am..
Sufficient capacity for the additional production : Head Pops Inc. manufactures two models of solar powered noise-canceling headphones: Sun Sound and Ear Bling models. The company is operating at less than full capacity. Market research indicates that 20,000 additional Sun Sound and 40,000 additional ..
Calculate the correlation between the two stocks : Calculate the standard deviation of monthly returns for each stock. Calculate the correlation between the two stocks. Excel Function: =correl(Stock 1 monthly returns array, Stock 2 monthly returns array)
Income from operations would increase other income : Income tax expense is shown as part of operating expenses. Income from operations would increase other income. Gains and losses on the sales of investments are included in nonoperating income (loss).
The most difficult decisions for the international marketer : Why is choosing the most appropriate market entry and development strategy one of the most difficult decisions for the international marketer?
What does providing too many choices do to a consumer : This Ted video was produced in 2003. While the general message is still the same and noteworthy, what new developments add to the way businesses and individuals spread ideas? (there are two MAJOR developments at a minimum)
University accessibility guidelines : Why is it important that faculty comply with the University's Accessibility Guidelines? When linking to a video, what should a faculty member do to ensure the video is accessible?

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Lasting impressions company lasting impressions li company

lasting impressions company lasting impressions li company is a medium-sized commercial printer of promotional

  Firm a has 20000 in assets entirely financed with

firm a has 20000 in assets entirely financed with equity.firm b also has 20000 in assets financed by 10000 in debt with

  Compute the operating income for each of the five customers

What problems might Handy-Man Services encounter in accurately estimating the operating costs of each customer?  (five points)

  A perform a sensitivity analysis to see how npv is affected

a. perform a sensitivity analysis to see how npv is affected by changes in the number of procedures per day average

  Financial scandal

If a financial institution is caught up in a financial scandal, would one expect its value to fall by more or less than the amount of any fines and settlement payments?

  Make out statement of affairs as regards creditors

The particulars were extracted from the books of X Ltd. on 31 April 2011, the day on which a winding up order was made - Make out statement of affairs as regards creditors and contributories and (ii) deficiency account.

  What kind of effects on income from hedging foreign currency

What is meant by an entity's functional currency and what are the economic indicators indentified by the FASB to provide guidance in selecting the functional currency? Why is this an important question?

  Assume a project has the following forecasted cash

assume a project has the following forecasted cash flowsyearamount in 0-400015002400360045005750answer the

  Growth ratesmitech corps stock price has been growing at

growth ratesmitech corps stock price has been growing at approximate 8 for several years and is now 30. based on past

  Calculate effect on equilibrium interest rate in market

How does the Federal Reserve policy affect the bond supply equation and calculate the effect on the equilibrium interest rate in this market, as a result of the Federal Reserve action.

  What will be the expected cost of the rail cars

What will be the expected cost of the rail cars and how much would the money market hedge return in six months assuming Plains States reinvests the proceeds at the U.S. investment rate?

  Prepare for the benefit of the companys management

Prepare for the benefit of the company's management an income statement for October and a balance sheet at 31 October x1.

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