Find the optimal risky portfolio if you could only use these two funds, ABC and 123, 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. ABC 123 Expected return 0.12 0.15 sd 0.2 0.3 Correlation coeffcient betweeen both 0.4 Find the w (the weight in fund ABC) that leads to the highest sharpe ratio (only consider the 101 different combinations, so the final answer will only have no more than two decimal places)

Find the optimal risky portfolio if you could only use these two funds, ABC and 123, 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. ABC 123 Expected return 0.12 0.15 sd 0.2 0.3 Correlation coeffcient betweeen both 0.4 Find the w (the weight in fund ABC) that leads to the highest sharpe ratio (only consider the 101 different combinations, so the final answer will only have no more than two decimal places)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter3: Risk And Return: Part Ii

Section: Chapter Questions

Problem 7MC: Write out the equation for the Capital Market Line (CML), and draw it on the graph. Interpret the...

See similar textbooks

Similar questions

There are two assets 1 and 2, with returns X and Y correspondingly. Return X is a random variable with mean 1 and variance 1; return Y is a random variable with mean 1 and variance 3. We know that the expectation of X*Y is equal to 0. Find the share of asset 1 in the risk-minimizing portfolio.
Assume a Portfolio of two assets A and B whose standard deviations of their returns are 8.6% and 10.8% respectively, while their correlation coefficient of returns is Pas= - 0.61. You are given the right to do portfolio optimization without restrictions. What proportions would you choose and why?
Consider the expected return and standard deviation of the following two assets: Asset 1: E[r1]=0.1 and σ1=0.2 Asset 2: E[r2]=0.3 and σ2=0.4 (a) Draw (e.g. with Excel) the set of achievable portfolios in mean-standard deviation space for the cases: (i) ρ12= -1, (ii) ρ12=0. (b) Suppose ρ12=-1. Which portfolio has the minimal variance? What is the variance and expected return of that portfolio? (c) Derive the formula for the variance of a portfolio with four assets.
f. Assume a Portfolio of two assets A and B whose standard deviations of their returns are 8.6% and 10.8% respectively, while their correlation coefficient of returns is Pas = - 0.61. You are given the right to do portfolio optimization without restrictions. What proportions would you choose and why?
Consider the following information for four portfolios, the market, and the risk-free rate (RFR): Portfolio Return Beta SD A1 0.15 1.25 0.182 A2 0.1 0.9 0.223 A3 0.12 1.1 0.138 A4 0.08 0.8 0.125 Market 0.11 1 0.2 RFR 0.03 0 0 Refer to Exhibit 18.6. Calculate the Jensen alpha Measure for each portfolio. a. A1 = 0.014, A2 = -0.002, A3 = 0.002, A4 = -0.02 b. A1 = 0.002, A2 = -0.02, A3 = 0.002, A4 = -0.014 c. A1 = 0.02, A2 = -0.002, A3 = 0.002, A4 = -0.014 d. A1 = 0.03, A2 = -0.002, A3 = 0.02, A4 = -0.14 e. A1 = 0.02, A2 = -0.002, A3 = 0.02, A4 = -0.14
Consider two assets. Suppose that the return on asset 1 has expected value 0.05 and standard deviation 0.1 and suppose that the return on asset 2 has expected value 0.02 and standard deviation 0.05. Suppose that the asset returns have correlation 0.4.Consider a portfolio placing weight w on asset 1 and weight 1-w on asset 2; let Rp denote the return on the portfolio. Find the mean and variance of Rp as a function of w.
Consider a single-index model economy. The index portfolio M has E(RM ) = 6%, σM = 18%.An individual asset i has an estimate of βi = 1.1 and σ2ei = 0.0225 using the single index modelRi = αi + βiRM + ei. The forecast of asset i’s return is E(ri) = 12%. rf = 4%. a) According to asset i’s return forecast, calculate αi. (b) Calculate the optimal weight of combining asset i and the index portfolio M . (c) Calculate the Sharpe ratio of the index portfolio M and the portfolio optimally combiningasset i and the index portfolio M .
Expected retun and standard deviation. Use the following information to answer the questions: a. What is the expected return of each asset? b. What is the variance and the standard deviation c. What is the expected return of a portfolio with 1 1 Data Table d. What is the portfolio's variance and standard de - X Hint Make sure to round all intermediate calculatio Swers yo (Click on the following icon D in order to copy its contents into a spreadsheet.) a. What is the expected return of asset J? (Round to four decimal places.) Return on Return on Return on Probability of State State of Asset J in Asset Kin State 0.200 0.140 0.040 Asset L in Economy State State Вoom 0.28 0.070 0.260 0.180 Growth 0.37 0.25 0.070 Stagnant 0.070 0.060 -0.210 Recession 0.10 0.070 -0.100 Print Done
A fund manager can invest in any combination of the three assets with the following expected returns and standard deviations: Asset 1: r1 = 2%, σ1 = 2% Asset 2: r2 = 6%, σ2 = 6% Asset 3: r3 = 4%, σ3 = 4% All three assets returns are uncorrelated: p12 = p13 =p 23 = 0 . Find a portfolio consisting of these three assets that achieves an expected return of 4% with the lowest risk possible. Show all steps.
Following is information for the required returns and standard deviations of returns for A, B, and C. The correlation coefficients for each pair also are shown below in a matrix. Which is the portfolio you will recommend AB, AC, or BC, and why? A B C Required Rate of return 7% 10% 20% Standard Deviation 33% 54% 90% Coefficient A,B 0.16 Coefficient A,C 0.19 Coefficient B,C 0.17
Mrs Z's utility function is given by the following equation: Uz(R, o²) = 0.3R – 0.50? Find the overall optimal portfolio for Mrs Z and compute its expected return and the standard deviation of its returns.
Consider the following risk-return characteristics for funds A and B: Expected return Risk Fund A (Equity) 12% 20% Fund B (Debt) 9% 16% The correlation coefficient between the returns of fund A and fund B is 0.4. 1. Which Fund is riskier? Write 1 if your answer is Fund A, write 2 if your answer is Fund B, or write 3 if your answer is undetermined. 2.1 What is the weight of fund A in the minimum variance portfolio? 2.4 What is the risk of the minimum variance portfolio? 2.2 What is the weight of Fund B in the minimum variance portfolio? 2.3 What is the expected return of the minimum variance portfolio?