Please show work. It can be done in excel if needed. Expected Return Standard Deviation Correlation...
dont use excel
solve using any equations
1. An investor has a risk aversion of 4. If she wants to invest all her wealth in the stock market that has a standard deviation of 16%. What is the implied risk premium of the market? What is the market risk premium if she has a risk aversion of only 2? 2. There are two stocks: A and B, and Treasury Bill (TB). The parameters of these securities are following: Expected Return...
Ad A z 1 Fonts 5 Paragraph Styles AD11423456 Voice LE TRAIL 5. (35 pts) There are two stocks: A and B, and Treasury Bill (TB). The parameters of these securities are following: Expected Return Standard Deviation Correlation with Stock A Stock A 10% 20% Stock B 15% 0.2 TB 0% 25% (20 pts. If you need an expected retum of 12% and you only have the access to the three securities above, what is your optimal portfolio composition? What...
You have a portfolio with a standard deviation of 24 % and an expected return of 18 % You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20 % of your money in the new stock and 80 % of your money in your existing portfolio, which one should you add? Expected Return Standard Deviation Correlation with Your Portfolio's Returns Stock A 13 24 0.2 Stock B 13...
Please show work on excel with equations. Thank you
16 #5 Expected 17 Stock 18 Correlation with Standard Correlation with Correlation with Duke Energy Return Deviation Microsoft Wal-Mart 19 Duke Energy 14% 6% -1 20 Microsoft 44% 24% -1 0.7 21 Wal-Mart 23% 14% 0.7 22 23 (a) Usin above table, calculate the volatility of a portfolio that is equally invested in Duke Energy and Microsoft. 24 (b) Usin above table, calculate the volatility of a portfolio that is equally...
Show work in excel please An investor can design a risky portfolio based on two stocks, A and B. Stock A has an expected return of 19% and a standard deviation of return of 15.0%. Stock B has an expected return of 15% and a standard deviation of return of 6%. The correlation coefficient between the returns of A and B is 0.80. The risk-free rate of return is 11%. The proportion of the optimal risky portfolio that should be...
3. Consider Table 3 Table 3 Stock Expected Return 10% 5% Standard Deviation 12% 8% Correlation Coefficient 0.40 (a) Consider Table 3. Compute the expected return and standard deviation of return of an equally-weighted portfolio of stocks A and B (b) Consider Table 3. Solve for the composition, expected return and standard deviation of the minimum variance portfolio (c) Consider Table 3. Sketch the set of portfolios comprised of stocks A and B (d) Consider Table 3. Suppose that a...
You have a portfolio with a standard deviation of 26 % and an expected return of 17 %. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20 % of your money in the new stock and 80 % of your money in your existing portfolio, which one should you add? Expected Return Standard Deviation Correlation with your portfolios return Stock A 13% 25% 0.3...
P 12-18 (similar to) 8 You have a portfolio with a standard deviation of 28% and an expected return of 20%. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 25% of your money in the new stock and 75% of your money in your existing portfolio, which one should you add? Expected Return Standard Correlation with Your Portfolio's Returns Deviation Stock A 16% 21% 0.2 Stock B...
You have a portfolio with a standard deviation of 30 % and .an expected return of 15 %. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 30 % of your money in the new stock and 70 % of your money in your existing portfolio, which one should you add? Expected Return: (ER) Standard Deviation:(STNDDEV) Correlation with Your Portfolio's Returns(Corr) Stock A (ER) 15% (STNDDEV)25% (Corr)0.3 Stock...
You have a portfolio with a standard deviation of 20% and an expected return of 20%. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 20% of your money in the new stock and 80% of your money in your existing portfolio, which one should you add? Expected Return Standard Deviation Correlation with Your Portfolio's Returns Stock A 15% 22% 0.4 Stock B 15% 18% 0.6 Standard deviation...