Question

In: Finance

   Projected Return       Year   Asset A   Asset B   Asset C 2018   13%   15%   11% 2019  ...

   Projected Return      
Year   Asset A   Asset B   Asset C
2018   13%   15%   11%
2019   15%   13%   13%
2020   17%   11%   15%
You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following​ data: LOADING.... You have been told that you can create two portfolioslong dashone consisting of assets A and B and the other consisting of assets A and Clong dashby investing equal proportions ​(50 %​) in each of the two component assets. a. What is the average expected​ return, r overbar​, for each asset over the​ 3-year period? b. What is the standard​ deviation, s​, for each​ asset's expected​ return? c. What is the average expected​ return, r overbar Subscript p​, for each of the the​ portfolios? d. How would you characterize the correlations of returns of the two assets making up each of the portfolios identified in part c​? e. What is the standard deviation of expected​ returns, s Subscript p comma for each​ portfolio? f. Which portfolio do you​ recommend? Why?

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.


Related Solutions

Asset A has an expected return of 15% and standard deviation of 20%. Asset B has an expected return of 20% and standard deviation of 15%.
      1. Asset A has an expected return of 15% and standard deviation of 20%. Asset B has an expected return of 20% and standard deviation of 15%. The riskfree rate is 5%. A risk-averse investor would prefer a portfolio using the risk-free asset and _______.            A) asset A            B) asset B            C) no risky asset            D) cannot tell from data provided2. The Sharpe-ratio is useful for            A) borrowing capital for investing            B) investing available capital            C) correctly...
A B C 13 7 9 29 19 54 25 54 5 17 15 11 21...
A B C 13 7 9 29 19 54 25 54 5 17 15 11 21 22 20 a) Construct ANOVA table and test the null hypothesis: μA = μB = μC b) Assume that you have statistically enough evidence to reject the null hypothesis; suggest an approach to find out whether all three means are different than each other or only one of them is different than others (while the other two means are equal) and if the second...
  States Probability Asset M Return Asset N Return Asset O Return   Boom 32​% 13​% 23​% 5​%   ...
  States Probability Asset M Return Asset N Return Asset O Return   Boom 32​% 13​% 23​% 5​%   Normal 45​% 11​% 15​% 11​%   Recession 23​% 5​% 3​% 13​% a. What is the expected return of investing equally in all three assets M, N, and O? - what is the expected return of investing in asset M alone? - what is the standard deviation of the portfolio that invests equally in all three assets M, N, and O? - what is the standard...
Compute the following: (a) 13^2018 (mod 12) (b) 8^11111 (mod 9) (c) 7^256 (mod 11) (d)...
Compute the following: (a) 13^2018 (mod 12) (b) 8^11111 (mod 9) (c) 7^256 (mod 11) (d) 3^160 (mod 23)
15 17 15 18 13 13 15 18 17 11 (i) Use a calculator with sample...
15 17 15 18 13 13 15 18 17 11 (i) Use a calculator with sample mean and standard deviation keys to find x and s. (Round your answers to two decimal places.) x = s =
expected return and standard deviation. stateecon, probability, asset A, asset B, Asset C boom.              0.34.       0.02.     &nbs
expected return and standard deviation. stateecon, probability, asset A, asset B, Asset C boom.              0.34.       0.02.       0.22.       0.34 normal.            0.52.       0.02.       0.05.       0.18 recession.        0.14.      0.02.       -0.01.     -0.25 A) what is the expected return of each asset? B) what is the variance of each Asset? C) what is the standard deviation of each asset?
Consider the following information: Stock Return if Market Return Is: Stock –11% 11% A 0 13...
Consider the following information: Stock Return if Market Return Is: Stock –11% 11% A 0 13 B –13 12 C –33 20 D 10 14 E 21 -8 What is the beta of each of the stocks? (Leave no cells blank - be certain to enter "0" wherever required. Use decimals, not percents, in your calculations. A negative value should be indicated by a minus sign. Round your answers to 1 decimal place.)  
State of Economy Probability of State Return on Asset A in State Return on Asset B...
State of Economy Probability of State Return on Asset A in State Return on Asset B in State Return on Asset C in State Boom 0.35 0.04 0.21 0.3 Normal 0.5 0.04 0.08 0.2 Recession 0.15 0.04 -0.01 -0.26 a.  What is the expected return of each​ asset? b.  What is the variance of each​ asset? c.  What is the standard deviation of each​ asset?
YEAR PROJECT A PROJECT B PROJECT C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000 2020...
YEAR PROJECT A PROJECT B PROJECT C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000 2020 $600,000 $975,000 $925,000 2021 $900,000 $975,000 $1,000,000 2022 $3,000,000 $1,000,000 $950,000 PLEASE calculate the Payback method for each and show me how you got to the answer!!
We observe three well-diversified portfolios A, B and C with a return of 15%, 6%, and...
We observe three well-diversified portfolios A, B and C with a return of 15%, 6%, and 12% respectively in the market. We also know that portfolio A, B and C has a beta of 1.5, 0.5, and 1.0 respectively. Construct an arbitrage strategy, and how much is the arbitrage profit?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT