Question: The correlation between Stocks A and B is -.4794. If you only invest 25% in A and 75% in B, what is your portfolio Standard

The correlation between Stocks A and B is -.4794. If you

The correlation between Stocks A and B is -.4794. If you only invest 25% in A and 75% in B, what is your portfolio Standard Deviation?

Please show your work in excel if possible!

Year Stock A (percent) Stock B (percent) Stock C (percent) Stock D (percent) Consumer Confidence Index 1 11.1 4.2 5.3 3.2 78.5 N 12.4 7.1 8.4 2.5 83.1 3 13.8 5.9 9.1 9.1 85.2 4 6.2 11.2 2.1 6.2 73.3 5 -3.1 8.3 -5.4 6.9 77.3 6 -2.0 12.4 .9 7.1 80.2 7 7.1 15.3 11.2. 79 83.3 00 8 8.7 12.1 8.2 8.1 86.1 9 10.3 1.1 15.3 9.2 90.4 10 11.6 4.5 12.0 6.2 87.4

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!

Christina sells Christmas trees. She has a lot full of trees that she has grown and raised in her pasture. Once grown, she prepares the trees for the "sale season." The best way to describe...

1. You are considering beginning a portfolio. You want to keep it simple however, by only having it contain two assets. Unfortunately, you have narrowed it down to FOUR, not two. So, now you are...

please answer the whole question and explain step by step include formulas and if you are calculating in excel please show all functions and steps 1. You are considering beginning a portfolio. You...

You are considering beginning a portfolio. You want to keep it simple however, by only having it contain two assets. Unfortunately, you have narrowed it down to FOUR, not two. So, now you are going...

You are considering beginning a portfolio. You want to keep it simple however, by only having it contain two assets. Part II. Problems Year 1. You are considering beginning a portfolio. You want to...

The following table,contains annual returns for the stocks of Home Depot (HD) and Lowe's (LOW). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits). Use the...

Stock A's return has a standard deviation of 16%. Stock B's return has a standard deviation of 24%. The correlation between the two stock returns is 1 (i.e., they are perfectly positively...

Please show how to do in Excel with formulas! Don't need to know the long form. Suppose you have $10,000 to invest and you have purchased the following securities. Stock A Stock B $ Amount $4,000...

A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 9%. The...

Suppose you have a portfolio consisting of four stocks: Stock A, Stock B, Stock C, and Stock D. The following amounts are invested in each stock: Stock A = $40,000; Stock B = $30,000; Stock C =...

Given the following information, what is the standard deviation of the returns on a portfolio that is invested 35 percent in both Stocks A and C, and 30 percent in Stock B? Economy Probability Stock...

Even though bonds are debt obligations, investing in them involves risk. What are the sources of risk? What service is available to aid the buyers of debt instruments in selecting a particular bond?

write equations those show the rate of energy transport by mass for flowing and non-flowing fluids, respectively.

Who is correct? Mary: "Depreciation expense is part of the income statement." Thom: "Equipment cost is part of the income statement." Juan: "Depreciation expense is part of the start - up costs."...

discuss "Classification" and the role it plays in data exploration.

Create an Employee class that has properties for the following data: Employee name Employee number Next, create a class named Productionworker that is derived from the employee class. The...

Three balls are dropped randomly into three empty boxes. What is the probability that exactly one box is empty afterward? PLEASE Always determine the sample space and a set-notation for each event,...

Suppose that two weighted (unfair) dice sum to each possible sum-value with an equal probabil- ity. Let us denote the probabilities for the vari- ous sides of the first die by p1, P2, .... P6 and the...

A mechanism utilizing two spur gear and a rack is shown in Figure 4. Carefully examine the components of the mechanism, then do what's required to gain insight into its operation. Figure 4: Rack and...

The main objective of logistics should be to

What is meant by good faith bargaining? Using examples, explain when bargaining is not in good faith.

The WGA did eventually strike. What tactics could the producers have used to fight back once the strike began? What tactics do you think the WGA used?

What other replacements for unions have helped reduce union membership, according to the chapter?