Question: Using the Excel function CORREL, calculate the correlation between the return on San Tome Mining and each of the other four stocks mentioned in problem

Using the Excel function CORREL, calculate the correlation between the return on San Tome Mining and each of the other four stocks mentioned in problem 7. Which stock offers the best diversification benefit?
Problem 7

National Central Railway, 64 Million Minerva Shipping, 38 Million San Tome Sulaco Market, 42 Million Mining, 184 Azuera, Inc., 16 Million Million* 2010 21.45 82.50 55.10 80.00 135.00 115.52 151.22 58.15 24.04 2011 144.62 26.53 2012 58.45 135.93 138.90 166.99 149.42 2013 52.43 74.61 23.53 212.02 52.50 174.62 75.01 32.46 177.27 2014

Step by Step Solution

★★★★★

3.38 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The correlation coefficients between the 4 annual rates of return on San Tome Mining STM and e... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1351-B-A-A-A-M(189).docx

120 KBs Word File

Students Have Also Explored These Related Advanced Accounting Questions!

The following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period. Compute the following. a. Average monthly rate of return Ri for each stock b....

Using the data in problem 7, calculate the average rate of return and standard deviation of return for each stock as well as for an equal-weighted portfolio of all the stocks using Excel. Do you...

Fill in the spreadsheet below and answer the following questions. Calculate answers to three decimal places. a. Calculate Total Returns (TRs) and Return Relatives (RRs) for McDonald's for the 10...

Risk & Return Assignment Introduction This exercise requires you to perform a series of caleulations using the data contained in the Excel file RiskReturnAssgn.zlsz. The worksheet in this file...

Problem 11-5 Using the data in the following table, estimate (a) the average return and volatility for each stock, (b) the covariance between the stocks, and (c) the correlation between these two...

Use either finance.yahoo.com or Bloomberg and download five years of monthly closing prices for eight stocks and the S&P 500 Index (ticker symbol ?GSPC?). Download the data into an Excel file and use...

Part B: RISK AND RETURN (15 marks) Using historical prices of the TSAI index and four Saudi listed companies traded on Saudi Stock Exchange, answer the following questions: a. Using the Saudi Stock...

Hi, could you please help me to solve Part A question, which is Risk and Return. It mentioned a, b, c and d four types of questions.I was really confused and don't really understand the first three...

DEAR TUTOR:could you help explain the question d and e ,thank you ,feel so confuse! Part A: RISK AND RETURN (30 marks) Use historical prices of the Australia market index All Ordinaries (^AORD) and...

I need a little help this week in my FINC 600 class. Please provide answers in the excel attachment, each tab requires answers. Problem 11-49 Consider a portfolio consisting of the following three...

Write a flask code snippet to perform the following tasks: 1. Perform simple math: For example, if a user visits the URL /sub/5/1 the application should compute 5-1 and display 5+1=4 2. Generate an...

A Japanese company, Asahi, sold parts to a Taiwanese company that then sold finished products in the United States. One of the products, claimed to be defective, injured a consumer who sued the...

1 Why is quality important to Executive Holloware?

Ann lives in Princeton, New Jersey, and commutes by train each day to her job in New York City (20 round trips per month). When the price of a round trip goes up from $10 to $20, she responds by...

Stock Values Stairway Corporation will pay a $3.60 per share dividend next year. The company pledges to increase its dividend by 4.5 percent per year indefinitely. If you require an 11 percent return...

Stock Valuation Listen Close Co. is expected to maintain a constant 6.5 percent growth rate in its dividends indefinitely. If the company has a dividend yield of 3.6 percent, what is the required...

Stock Valuation Suppose you know that a companys stock currently sells for $60 per share and the required return on the stock is 12 percent. You also know that the total return on the stock is evenly...

Which of the following statements is True? Select one: The floating rate regularly adjusts to a reference rate. O b. None of the options are correct. O c. The term 'spot loan' refers to a loan that...

Please answer question 2 in excel, with cell reference please! If a firm has a payout ratio of 6 5 % and a ROE on projects of 1 1 % , what is the growth rate for the firm? Assume a firm has a cost of...

HELP PLEASE (Individual or component costs of capital) Compute the cost of capital for the firn for the folowing a. Currently bonds with a simlar credt rating and matunty as the firris cutatanding...