Business, 01.07.2021 15:10 HunchoPoncho

Using the table, plot the opportunity set of risky assets in Excel. Then vary the correlation between stocks and bonds from + 1 to -1 and describe the changes in shape of the efficient frontier as you do so.
Upload the Excel file that contains the table & graph.
Also include in Excel file a description of the efficient frontier's shape as you vary the correlation. A B C D E 1 Return Risk Sharpe Ratio Stock Allocation 0% 2. 3 Bond Allocation 100% 95% 90% 5% 4 10% 5 6 7 15% 20% 85% 80% 25% 8 9 30% 35% 75% 70% 65% 60% 10 11 12 40% 45% 50% 55% 50% 45% 40% 13 14 35% 15 16 17 55% 60% 65% 70% 75% 80% 30% 25% 18 19 85% 20% 15% 10% 5% 20 90% 21 95% 100% 0% 22 23 24 25 26 27 28 29 30 31 32 33Using the graph of the opportunity set of risky assets, answer the following:a) Change the correlation of stocks and bonds back to 0.25 and observe the shape of the efficient frontier. b) Starting at the point that corresponds to 100% Bonds & 0% Stocks, describe what happens to portfolio risk and return as you increase the stock allocation and decrease the bond allocation? Why is this happening?c) Now change the correlation between stocks & bonds to -1. What is the lowest risk achievable?

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 21:00

Which of the following statements is correct? a) due to limited liability, unlimited lives, and ease of ownership transfer, the vast majority of u.s. businesses (in terms of number of businesses) are organized as corporationsb) most businesses (by number and total dollar sales) are organized as proprietorships or corporation. however, if the business gets very large, it becomes advantageous to convert to a corporation, primarily because corporations have important tax advantages over proprietorships and partnerships.c) due to legal considerations related to ownership transfers and limited liability, which affect the ability to attract capital, most business (measured by dollar sales) is conducted by corporations in spite of large corporations' less favorable tax treatmentd) large corporations are taxed more favorably than proprietorshipse) corporate stockholders are exposed to unlimited liability

Answers: 2

Answer

Business, 22.06.2019 11:20

Lusk corporation produces and sells 14,300 units of product x each month. the selling price of product x is $25 per unit, and variable expenses are $19 per unit. a study has been made concerning whether product x should be discontinued. the study shows that $72,000 of the $102,000 in monthly fixed expenses charged to product x would not be avoidable even if the product was discontinued. if product x is discontinued, the annual financial advantage (disadvantage) for the company of eliminating this product should be:

Answers: 1

Answer

Business, 22.06.2019 12:40

Which of the following tasks would be a line cook's main responsibility? oa. frying french fries ob. chopping onions oc. taking inventory of stocked dry goods od. paying invoices

Answers: 2

Answer

Business, 22.06.2019 14:30

The face of a company is often that of the lowest paid employees who meet the customers. select one: true false

Answers: 1

Answer

You know the right answer?

Using the table, plot the opportunity set of risky assets in Excel. Then vary the correlation betwe...

Questions