1. Consider that 2 investment funds exist. ABC Fund(invested in 50% normal stock and 50% risky bonds) and 123 Fund(invested in 25% High risk stock and 75% normal bonds). Assume you have the following historical data of annual returns: Return S.D. Normal Stock 8% 20% Risky Bonds High Risk Stock 10% 35% 14% 40% Normal Bonds 6% 10% A. If Normal Stock and Risky Bonds have a correlation coefficient of 0.4 and High Risk Stock and Normal Bonds have correlation coefficient of 0 .2. Find the expected return and standard deviation of each Fund. B. Find the optimal risky portfolio if you could only use these two funds; assume the two funds have a correlation coefficient of 0.3. (To do this use excel and create 101 different combination of the two funds, where allocation or "w" for fund ABC is 0, then.01, then .02 and so forth until w=1. For each of these points calculate the Sharpe ratio. Graph these results with returns on the y axis and S.D on the x axis. Remember to report the return and standard deviation of the optimal risky portfolio.) The risk free rate is .02. (Turn in graph) C. No need to show any work, just explain you reasoning. If the correlation coefficient was .4 would that lead to a better or a worse optimal risky portfolio? If another fund was added would this make things better or worse?
1. Consider that 2 investment funds exist. ABC Fund(invested in 50% normal stock and 50% risky bonds) and 123 Fund(invested in 25% High risk stock and 75% normal bonds). Assume you have the following historical data of annual returns: Return S.D. Normal Stock 8% 20% Risky Bonds High Risk Stock 10% 35% 14% 40% Normal Bonds 6% 10% A. If Normal Stock and Risky Bonds have a correlation coefficient of 0.4 and High Risk Stock and Normal Bonds have correlation coefficient of 0 .2. Find the expected return and standard deviation of each Fund. B. Find the optimal risky portfolio if you could only use these two funds; assume the two funds have a correlation coefficient of 0.3. (To do this use excel and create 101 different combination of the two funds, where allocation or "w" for fund ABC is 0, then.01, then .02 and so forth until w=1. For each of these points calculate the Sharpe ratio. Graph these results with returns on the y axis and S.D on the x axis. Remember to report the return and standard deviation of the optimal risky portfolio.) The risk free rate is .02. (Turn in graph) C. No need to show any work, just explain you reasoning. If the correlation coefficient was .4 would that lead to a better or a worse optimal risky portfolio? If another fund was added would this make things better or worse?
Chapter8: Analysis Of Risk And Return
Section: Chapter Questions
Problem 21P
Related questions
Question
A and B only
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT