Question

You have been asked for your advice in selecting a portfolio of assets and have been...

You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following​ data:

Projected Return

Year

Asset A

Asset B

Asset C

2018

14​%

14​%

10​%

2019

16​%

12​%

12​%

2020

18​%

10​%

14​%

You have been told that you can create two portfolios-- one consisting of assets A and B and the other consisting of assets A and C-- by investing equal proportions ​(50 %​) in each of the two component assets.

a. What is the average expected​ return, r​, 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 p​, for each of 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, sp, for each​ portfolio?

f. What would happen if you constructed a portfolio consisting of assets​ A, B, and​ C, equally​ weighted? Would this reduce risk or enhance​ return?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

TOO LENGTHY SUM. TOO MANY CALCULATIONS. SO AS PER HOMEWORKLIB POLICY, I SHOULD ANSWER 4 QUESTIONS, I HAVE ANSWERED 5. KINDLY POST REMAINING PART AGAIN, WILL ANSWER SURELY WITHOUT FAIL. THANK YOU

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ в 1 프· ー· 鱼, Δ. :r-ㄧ 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells Y129 IY iz JA JC JD JE JF JG JH JK JL ASSET 112 113 114 115 116 a 2018 2019 2020 14 16 18 14 12 10 10 12 14 EXPECTED RETURN FOR EACH ASSET STANDARD DEVIATION FOR EACH ASSET 16.00 2.00 12.00 12.00 --……… く AVERAGE(JH1 121H114) 2.00 2.00<-STDEV.S(JH112:JH114) 118 119 C 120 121 122 123 124 125 126 127 128 129 14 Sheet1 . Sheet4 . PV FV DIVIDEND , EMV | MEAN STDV EXPECTED RETURN FOR PORTFOLIO 1-50% ASSET A AND 5096 B- 14.00 NOTE ASSET 50%* (ASSET A) + 50%(ASSET B) 2018 2019 2020 14 EXPECTED RETURN FOR PORTFOLIO 2-50% ASSET B AND 50% 14.00 NOTE ASSET 50%*(ASSET B) + 50%(ASSET C) 2018 2019 2020 12 14 16 DEAR Sheet2 TIME SERIEScom REGRESSIONCAMERAEXP RETURN TREND MATRIXIN 14-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ в 1 프· ー· 鱼, Δ. :r-ㄧ 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Y143 IY Font Alignment Number Styles Cells iz JA JB JC JD JE JF JG JH JK JL 130 131 d 132 133 134 e 135 136 137 138 139 140 141 142 143 144 145 146 147 148 4 CORRELATION BETWEEN ASSET A & B = CORRELATION BETWEEN ASSET B &C 1.00 CORREL(JE112:JE114,JF112:JF114) 1.00 CORREL(JF112:JF114,JG112:JG114) STANDARD DEVIATION OF PORTFOLIO STANDARD DEVIATION OF PORTFOLIO 2 0.00 STDEV.S(JB121:JB123) 2.00 STDEV.S(JB127:JB129) SheetiSheet4PV FV DIVIDENDEMV MEAN STDV DEAR Sheet2 TIME SERIEScom REGRESSIONCAMERAEXP RETURN TREND MATRIXIN 14-01-2019

Add a comment
Know the answer?
Add Answer to:
You have been asked for your advice in selecting a portfolio of assets and have been...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have been asked for your advice in selecting a portfolio of assets and have been...

    You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following​ data: Projected Return Year Asset A Asset B Asset C 2018 10​% 15​% 11​% 2019 12​% 13​% 13​% 2020 14​% 11​% 15​% You have been told that you can create two portfolios-- one consisting of assets A and B and the other consisting of assets A and C-- by investing equal proportions ​(50 %​) in each of the two component...

  • You have been asked for your advice in selecting a portfolio of assets and have been...

    You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following​ data:    Projected Return       Year   Asset A   Asset B   Asset C 2021   13%             17%   13% 2022   15%             15%   15% 2023   17%             13%   17% You have been told that you can create two portfolio------ one consisting of assets A and B and the other consisting of assets A and C ---------- by investing equal proportions ​(50 %​)...

  • You have been asked for your advice in selecting a portfolio of assets and have been...

    You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following data: You have been told that you can create two portfolios-one consisting of assets A and B and the other consisting of assets A and C-by investing equal proportions (50%) in each of the two component assets. a. What is the average expected return, r, for each asset over the 3-year period? b. What is the standard deviation, s, for...

  • You have been asked for your advice in selecting a portfolio of assets and have been given the following data: Expected return Year Asset A Assest B Assest C 2019 12% 16% 12% 2020 14% 14% 14% 2021 16%...

    You have been asked for your advice in selecting a portfolio of assets and have been given the following data: Expected return Year Asset A Assest B Assest C 2019 12% 16% 12% 2020 14% 14% 14% 2021 16% 12% 16% You have been told that you can create two portfolios—one consisting of assets A and B and the other consisting of assets A and C—by investing equal proportions (50%) in each of the two component assets. a. What is...

  • e. What is the standard deviation of expected returns, so, for each portfolio? Portfolio AB: %...

    e. What is the standard deviation of expected returns, so, for each portfolio? Portfolio AB: % (Round to two decimal places.) You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following data: You have been told that you can create two portfolios —one consisting of assets A and B and the other consisting assets A and C-by investing equal proportions (50%) in each of the two component assets. a. What...

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

    Projected Return Year Asset A Asset B Asset C 2018 10% 15% 11% 2019 12% 13% 13% 2020 14% 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...

  • 5-12 Portfolio return and standard deviation Jamie Wong is considering building a portfolio containing two assets,...

    5-12 Portfolio return and standard deviation Jamie Wong is considering building a portfolio containing two assets, L and M. Asset L will represent 40% of the dollar value of the portfolio, and asset M will account for the other 60%. The expected returns over the next 6 years, 2004–2009, for each of these assets, are shown in the following table. Expected return Asset L Asset M Year 20% 14% 14 16 2004 2005 2006 2007 2008 2009 17 a. Calculate...

  • Assume you are considering a portfolio containing two​ assets, L and M. Asset L will represent...

    Assume you are considering a portfolio containing two​ assets, L and M. Asset L will represent 44% of the dollar value of the​ portfolio, and asset M will account for the other 56%. The projected returns over the next 6​ years, 2018 - 2023​, for each of these assets are summarized in the following​ table: Projected Return Year Asset L Asset M 2018 13​% 19​% 2019 14​% 19​% 2020 17​% 15​% 2021 16​% 15​% 2022 16​% 11​% 2023 18​% 11​%...

  • Assume you are considering a portfolio containing two assets, L and M Asset L will represent...

    Assume you are considering a portfolio containing two assets, L and M Asset L will represent 37% o the dollar value of the portfolio and asset M will account for the other 63%. The pro ected returns over he next 6 years, 2018-2023, for each of these assets are summarized in the following table: a. Calculate the projected portfollo return, rp for each of the 6 years. b. Calculate the average expected portolio return, rp, over the 6-year period. c....

  • Assume you are considering a portfolio containing two​ assets, L and M. Asset L will represent...

    Assume you are considering a portfolio containing two​ assets, L and M. Asset L will represent 39 % of the dollar value of the​ portfolio, and asset M will account for the other 61 %. The projected returns over the next 6​ years, 2018-2023​, for each of these assets are summarized in the following​ table: LOADING.... a. Calculate the projected portfolio​ return, r over p​, for each of the 6 years. b. Calculate the average expected portfolio​ return, r over...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT