A Expected Return 2 Variance 81 Standard Deviation 9 25.0 20.0 15.0 10.0 5.0 0.0 0...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A Expected Return 2 Variance 81 Standard Deviation 9 25.0 20.0 15.0 10.0 5.0 0.0 0 Standard deviation Asset Correlation -0.68 0.2 0.4 0.6 W(a) B 10 400 20 Portfolio 0.8 1 1.2 E(r) 12.00 10.00 8.00 6.00 4.00 2.00 0.00 H W(a) 0.69 Variance Standard Deviation Expected Value 0.00 Portfolio 5.00 A W(b) 0.31 24.64 5.0 4.5 10.00 15.00 Standard deviaton INSTRUCTIONS: Put the needed formulas into cells i5 - 17. Make sure they depend on the data in cells d3 e7 and the weights in h5 and i5. Then answer the questions below. 20.00 B 25.00 1) When correlation between the assets is perfectly positive the set of possible investments is a 2) When correlation between the assets is perfectly negative the set of possible investments is a 3) When correlation between the assets is zero the set of possible investments is a 4) When correlation between the assets is .5 the set of possible investments is a 5) When the amount invested in asset A is 100% the risk of the portfolio is 6) Decreasing the amount invested in asset A more ofter 7) When correlation between the assets is -1 what is the best amount to invest in asset B? 8) When correlation between the assets is 1 what is the best amount to invest in asset B? A Expected Return 2 Variance 81 Standard Deviation 9 25.0 20.0 15.0 10.0 5.0 0.0 0 Standard deviation Asset Correlation -0.68 0.2 0.4 0.6 W(a) B 10 400 20 Portfolio 0.8 1 1.2 E(r) 12.00 10.00 8.00 6.00 4.00 2.00 0.00 H W(a) 0.69 Variance Standard Deviation Expected Value 0.00 Portfolio 5.00 A W(b) 0.31 24.64 5.0 4.5 10.00 15.00 Standard deviaton INSTRUCTIONS: Put the needed formulas into cells i5 - 17. Make sure they depend on the data in cells d3 e7 and the weights in h5 and i5. Then answer the questions below. 20.00 B 25.00 1) When correlation between the assets is perfectly positive the set of possible investments is a 2) When correlation between the assets is perfectly negative the set of possible investments is a 3) When correlation between the assets is zero the set of possible investments is a 4) When correlation between the assets is .5 the set of possible investments is a 5) When the amount invested in asset A is 100% the risk of the portfolio is 6) Decreasing the amount invested in asset A more ofter 7) When correlation between the assets is -1 what is the best amount to invest in asset B? 8) When correlation between the assets is 1 what is the best amount to invest in asset B? A Expected Return 2 Variance 81 Standard Deviation 9 25.0 20.0 15.0 10.0 5.0 0.0 0 Standard deviation Asset Correlation -0.68 0.2 0.4 0.6 W(a) B 10 400 20 Portfolio 0.8 1 1.2 E(r) 12.00 10.00 8.00 6.00 4.00 2.00 0.00 H W(a) 0.69 Variance Standard Deviation Expected Value 0.00 Portfolio 5.00 A W(b) 0.31 24.64 5.0 4.5 10.00 15.00 Standard deviaton INSTRUCTIONS: Put the needed formulas into cells i5 - 17. Make sure they depend on the data in cells d3 e7 and the weights in h5 and i5. Then answer the questions below. 20.00 B 25.00 1) When correlation between the assets is perfectly positive the set of possible investments is a 2) When correlation between the assets is perfectly negative the set of possible investments is a 3) When correlation between the assets is zero the set of possible investments is a 4) When correlation between the assets is .5 the set of possible investments is a 5) When the amount invested in asset A is 100% the risk of the portfolio is 6) Decreasing the amount invested in asset A more ofter 7) When correlation between the assets is -1 what is the best amount to invest in asset B? 8) When correlation between the assets is 1 what is the best amount to invest in asset B?
Expert Answer:
Answer rating: 100% (QA)
Here are the answers 1 When correlation between the assets is perfectly positive th... View the full answer
Related Book For
Statistics For Business Decision Making And Analysis
ISBN: 9780134497167
3rd Edition
Authors: Robert A. Stine, Dean Foster
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Various statistical software packages tend to provide different measures of association. Use statistical software to calculate the Goodman-Kruskal gamma, Somers D, or Kendalls tau-a for the space...
-
Patrick Sabine, a student, asks for your help in understanding the following characteristics of a corporation: (a) Limited liability of shareholders, (b) Transferable ownership rights, (c) Ability to...
-
The option-adjusted spread measures the yield spread over the Treasury on-the-run yield curve. Explain why you agree or disagree with this statement.
-
Energy in the sun is produced by the fusion of four protons into a helium nucleus. The process involves several steps, but the net reaction is simply \(4 \mathrm{p} ightarrow{ }^{4} \mathrm{He}+\)...
-
The company treasurer is uncertain which of four depreciation methods the firm should use for office furniture that costs $50,000, and has a zero salvage value at the end of a 10-year-depreciable...
-
What are the 3 basic principles in community health nursing?"
-
Explain how a traditional economy is structured based on who answers the three Economic questions. Which Economic goals are largely enhanced with this system? How do you know? Which Economic goals...
-
Consider the following cash flows of two mutually exclusive projects for Spartan Rubber Company. Assume the discount rate for both projects is 9 percent. Year Dry Prepreg Solvent Prepreg 0 $...
-
What is collateral on a loan that remains in the possession of the borrower and not the bank?
-
List the major types of collateral. Discuss the priorities of parties with conflicting interests in collateral when default occurs. PLEASE AVOID PLAGIARISM. "Plagiarized work will not be accepted."
-
4. Now we can use Solver to maximize this expression by changing the weight of the equity input cell. The constraint is that the standard deviation of the portfolio is equal to the standard deviation...
-
What alternative does not describe a type of collateral for a loan?
-
Mining for crystals is a hobby for some, and even a profession for many. Both amateur and professional crystal hunters go digging in search for samples that they suspect to be crystals, and then they...
-
In Problems 718, write the augmented matrix of the given system of equations. f0.01x0.03y = 0.06 [0.13x + 0.10y = 0.20
-
Match the item in the first column with the concept that can be observed, test statistic, or estimate from the second column. Normal quantile plot (a) Similar variances (b) F-statistic (c)...
-
A summary of sales of a department store says that the average retail purchase was $125 with a margin of error equal to $15. What does the margin of error mean in this context?
-
On a sheet of paper, write the numerals 1, 2, 3, and 4 in large print. Ask several friends to pick a number at random. (Dont let anyone see what others pick. We want independent choices.) (a)...
-
Allister Company uses both debt capital and equity capital to fund new projects. The before-tax cost of debt capital is 12 percent. The cost of equity capital is 10 percent. Allister's effective tax...
-
Reconsider the results you obtained for the Allister Company in Problem 4. Assume that Allister's uses the WACC for MARR. a. For each case (a through e), use the estimation equation given in Equation...
-
GeoWorld Systems uses a subset of the following questions during the interview process for new engineers. For each of the following cases, determine if "the project" or "do nothing" is preferred. The...
Study smarter with the SolutionInn App