Question: I'd really appreciate it if someone could help me out! Thanks! :) 1. Go to finance.yahoo.com and find them monthly rates of return over a

I'd really appreciate it if someone could help me out! Thanks! :)

1. Go to finance.yahoo.com and find them monthly rates of return over a 2 year period for five companies of your choice. Now assume you form each month an equally weighted portfolio of five firms (a portfolio with equal investments in each firm). What is the rate of return each month on your portfolio? Compare the standard deviation of the monthly portfolio return to that of each and to the average standard devation across the five firms. What do you conclude about the portfolio diversification?

2. Return to the monthly returns of the five companies of the five companies you chose in the pervious question.

a. Using the Excel functions for average(AVERAGE) and sample standard deviation(STDEV), calculate the average and the standard deviation of the returns for each of the firms.

b. Using Excel's correlation function (CORREL), find the correlation between each pair of five stocks. What are the highest and lowest correlation?

c. Try finding correlations between pairs of stocks in the same industry. Are the correlations higher than those you found in part (b)? Is this surprising?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Mr. Phillips of Southwest Investment Bankers is evaluating the P/E ratio of Madison Electronics Conveyors (MEC). The firms P/E is currently 17. With earning per share of $2, the stock price is $34....

1) What are the three things you can do to make other people like another person according to the text below? Please discuss how to use them them to influence other people. Please use examples to...

Please read the persuasion transcript below.Please answer the following questions based on the transcript: 1) What are the two moments of power described in the video? Please discuss how you plan to...

Hello, I need your hepl. Please response as soon as possible cuz my homework is gonna due tomorrow morning :(. I really appreciate your hepl. I need your help with SUA 1 in Accounting Information...

Requested to do an integrated summary of these paper by reflecting to the local (Malaysian) Corporate Financial Scenarios. Three views on stock markets and corporate behavior: Tobin, Veblen, and Marx...

Hello, I have been struggling with the problem for a while now. Can someone please assist? I cannot find the data online much less calculate the standard deviation. 1. Go to finance.yahoo.com and...

The forms dont have to be all filled out but would really appreciate it since it will help me see exactly how the process works! Thank you, in advance. ProConnect Tax Devon Bishop, age 45, is single....

CASE STUDY You joined a large accounting firm, KPMJ Partners, as an audit senior. After orientation and training sessions, you were part of a team to audit Tasty Beef Ltd (TBL thereafter) for the...

only numbers 3,4 and 5 thank you TAXES! When it comes to how the American household is taxed, every family is different. We will start with a model suggesting that the average U.S. household earns a...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

ABC Ltd is a company engaged in the manufacturing and selling of metal cans .The following data provided below relate to ABC Ltd for the months October and November 2021. Variable Selling Overhead:...

What cycle time would match capacity and demand if demand is 120 units a day, there are two shifts of 480 minutes each, and workers are given three half- hour breaks during each shift, one of which...

Which statement is generally true about a loan decision? Regardless of loan size, linear processes and programmatic metrics will generally not result in better decisions. The larger the loan or more...

https://media.cheggcdn.com/media/e59/e5900ba1-02b0-44ab-8246-fb980e24e7c1/phpDkQ6Ux

6. Match each of the following characteristics or scenarios with either the term negative externality or the term positive externality. LO4.4 a. Overallocation of resources. b. Tammy installs a very...

2. Use the ideas of consumer surplus and producer surplus to explain why economists say competitive markets are efficient. Why are below- or above-equilibrium levels of output inefficient, according...

5. Use the distinction between the characteristics of private and public goods to determine whether the following should be produced through the market system or provided by government: (a) French...