Hello, I have been struggling with the problem for a while now. Can someone please assist?...

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 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?

Expert Solution

Go to finance yahoo's page on any stock, then go to historical data and select time period of 2 years, along with frequency as monthly, and download it as an excel sheet. Make sure no stock splits or bonuses were given out for that time period (otherwise stock prices would need to be adjusted).

For your convenience, i've done Amazon, Microsoft, Twitter, Facebook and Apple.

For portfolio construction, you need to assign equal weights by multiplying each stock's price by 0.2 and adding the sum of each.

The return on each month is given by (price in month - price in preceding month) / price in preceding month.

Once the returns are calculated in percentage terms, just run the standard deviation formulas on each stock along with the portfolio.

See how it looks in excel:

So the standard deviation of returns of portfolio is 5.42% while the average of the stocks individually gives 7.17%.

Thus we can conclude that diversification leads to lowering of risk.

Sources

https://finance.yahoo.com/quote/AMZN/history?period1=1467311400&period2=1532802600&interval=1mo&filter=history&frequency=1mo

https://finance.yahoo.com/quote/AAPL/history?period1=1467311400&period2=1532802600&interval=1mo&filter=history&frequency=1mo

https://finance.yahoo.com/quote/TWTR/history?period1=1467311400&period2=1532802600&interval=1mo&filter=history&frequency=1mo

https://finance.yahoo.com/quote/FB/history?period1=1467311400&period2=1532802600&interval=1mo&filter=history&frequency=1mo

https://finance.yahoo.com/quote/MSFT/history?period1=1467311400&period2=1532802600&interval=1mo&filter=history&frequency=1mo

jeff jeffy answered 2 years ago

Hello - can you assist with this problem please: You have been assigned to be the...

Hello - can you assist with this problem please: You have been assigned to be the audit senior for the Wine Emporium. Based on the client's industry, you have set the inherent risk as low. You are also setting the control risk as low given that the owners of the Wine Emporium, Paul and Linda, have put many robust controls in place since buying the Emporium. You also had good success in auditing controls as well as ending financial statement balances...

Can someone please assist me with this question. The information that I found was not of...

Can someone please assist me with this question. The information that I found was not of help. Discuss how using systems thinking will influence your decision-making. I have to do a full paragraph on this question.

Hello, I'm really struggling with this problem. So far I have calculated 48,000 for preferred and...

Hello, I'm really struggling with this problem. So far I have calculated 48,000 for preferred and 38,000 for common, which I know to be incorrect per my professor. I also calculated 64,703 as the preferred and 41,697 as the common but I know these to be incorrect as well. I'm just not sure how to calculate this. Please see the below. The outstanding capital stock of Skysong Corporation consists of 2,000 shares of $100 par value, 8% preferred, and 5,100 shares...

Hello! Can someone please give me an in depth explanation of a SWOT please? I know...

Hello! Can someone please give me an in depth explanation of a SWOT please? I know the basic 4 but it didn’t go well. My SWOT is on Glossier.

I have a problem with my code. It does not run. Please can someone check the...

I have a problem with my code. It does not run. Please can someone check the code and tell me where I went wrong? This is the question: Program Specification: Write a C program that takes the length and width of a rectangular yard, and the length and width of a rectangular house (that must be completely contained in the yard specified) as input values. Assuming that the yard has grass growing every where that the house is not covering,...

Hello , I'm struggling in the following questions and I need an explanation if it is...

Hello , I'm struggling in the following questions and I need an explanation if it is possible question 1) :A 51.0 mL aliquot of HCl(aq) of unknown concentration was titrated with 0.226 M NaOH(aq). It took 102.4 mL of the base to reach the endpoint of the titration. what the concentration (M) of the acid was ? question 2) :How many moles of BaCl2 are formed in the neutralization of 196.5 mL of 0.095 M Ba(OH)2 with aqueous Hal? question...

Hello I have these questions, Can I please get some assistance, I need not so long...

Hello I have these questions, Can I please get some assistance, I need not so long or short answers please How to decide what job to take. Is that a marginal decision? What is an explicit cost? What is an implicit cost? How is accounting profit calculated? How is economic profit calculated?

Can someone please assist me with the design of a 4.0m column, secured to a foundation...

Can someone please assist me with the design of a 4.0m column, secured to a foundation at the bottom and fixed to 3 beams at the top. The loads are axial and at a magnitude of 1500kN total applied load. The design is based on Eurocode 2. Code to be used when designing: Eurocode 2 concrete strength: C32 steel strength: 460 given dimensions for column: 300mm x 300mm

Hello can someone please explain the is lm curves step by step for me?

Hi, I am taking stats class and I have one question. I have been struggling with...

Hi, I am taking stats class and I have one question. I have been struggling with it for few hours. To investigate the fluid mechanics of swimming, twenty swimmers each swam a specified distance in a water-filled pool and in a pool where the water was thickened with food grade guar gum to create a syrup-like consistency. Velocity, in meters per second, was recorded and the results are given in a table below. The researchers concluded that swimming in guar...

Question