Question

3. You have been given the expected return data shown in the first table on three...

3. You have been given the expected return data shown in the first table on three assets—F, G, and H—over the period 2015-2018
Year Asset F Asset G Asset H
2015 9 12 15
2016 8 9 16
2017 5 21 19
2018 13 6 11
Using these assets, you have isolated the three investment alternatives shown in the following table.
Alternative Investment
1 100% of asset F
2 25% of asset F and 75% of asset G
3 50% of asset F and 50% of asset H
1. Calculate the expected return over the 4-year period for each of the three alternative
2. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives.
3. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives.
4. On the basis of your findings, which of the three investment alternatives do you recommend? Why?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please find below details solution

3. You have been given the expected return data shown in the first table on three assets—F, G, and H—over the period 2015-2018
Year Asset F Asset G Asset H Variance F Variance G Variance H
2015 9 12 15 0.0625 0 0.0625
2016 8 9 16 0.5625 9 0.5625
2017 5 21 19 14.0625 81 14.0625
2018 13 6 11 18.0625 36 18.0625
Average 8.75 12 15.25
Varaince 32.75 126 32.75
Std deviation 3.304037934 6.480740698 3.304037934
Using these assets, you have isolated the three investment alternatives shown in the following table.
Alternative Investment Return
1 100% of asset F 8.75
2 25% of asset F and 75% of asset G 11.1875 summation of weightage*average return
3 50% of asset F and 50% of asset H 12 summation of weightage*average return
1. Calculate the expected return over the 4-year period for each of the three alternative
The average return' F G H
8.75 12 15.25
2. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives.
Calculated above as Square root of (Variance/n-1) F G H
Std deviation 3.304038 6.480741 3.304038
3. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives.
F&G G&H F&H
2015 0 0 -0.0625
2016 2.25 -2.25 -0.5625
2017 -33.75 33.75 -14.0625
2018 -25.5 25.5 -18.0625
Co-relation (return-mean return Assest1)* (return-mean return Assest2) -19 19 -10.9167
Co-efficient of variation (Co-relation divide by std deviation of both assets) -0.88733 0.887327 -1
4. On the basis of your findings, which of the three investment alternatives do you recommend? Why?
On basis on correlation F& H same so invest in any1 is fine
Add a comment
Answer #2
No answer i have
source: Business finance
answered by: Shagufta malik
Add a comment
Know the answer?
Add Answer to:
3. You have been given the expected return data shown in the first table on three...
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
  • Portfolio analysis You have been given the expected return data shown in the first table on...

    Portfolio analysis You have been given the expected return data shown in the first table on three assets—F, G, and H-over the period 2016-2019: E. Using these assets, you have isolated the three investment alternatives shown in the following table: E. a. Calculate the expected return over the 4-year period for each of the three alternatives. b. Calculate the standard deviation of returns over the 4-vear period for each of the three alternatives c. Use your findings in parts a...

  • Portfolio analysis You have been given the expected return data shown in the first table on...

    Portfolio analysis You have been given the expected return data shown in the first table on three assets-F, G, and over the period 2016-2019: Using these assets, you have isolated the three investment alternatives shown in the following table: a. Calculate the average return over the 4-year period for each of the three alternatives, b. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives, c. Use your findings in parts a and b...

  • Portfolio analysis You have been given the historical return data shown in the first table on...

    Portfolio analysis You have been given the historical return data shown in the first table on three assets-F, G, and H-over the period 2016-2019. 8-14 Historical return Year Asset F Asset G Asset H 2016 16% 2017 17 17% 16 15 14 14% 15 16 17 18 20 2019 18 19 Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 100% of asset F 50% of asset F and 50% of asset...

  • You have been given the following return​ data, Expected Return Year Asset F Asset G Asset...

    You have been given the following return​ data, Expected Return Year Asset F Asset G Asset H 2018 14​% 18​% 15​% 2019 15​% 17​% 16​% 2020 16​% 16​% 17​% 2021 17​% 15​% 18​% ​, on three assets—​F, G, and H—over the period 2018–2021. Using these​ assets, you have isolated three investment​alternatives: Alternative Investment 1 100% of asset F 2 50% of asset F and 50% of asset G 3 50% of asset F and 50% of asset H a. Calculate...

  • Please use excel. I can learn from that!!! Portfolio analysis - You have been given the...

    Please use excel. I can learn from that!!! Portfolio analysis - You have been given the expected return data shown in the first table on three assets - F, G and H, over the period 2016 - 2019. Expected Return Year Asset F Asset G Asset H 2016 11% 12% 9% 2017 12% 11% 10% 2018 13% 10% 11% 2019 14% 9% 12% Using these assets, you have isolated the three investment alternatives shown in the following table: Alternative Investment...

  • F, and H ow Portfolio analysis You have been given the expected return data shown in...

    F, and H ow Portfolio analysis You have been given the expected return data shown in the first table on the Using these sts, you have isolated the three investment alternatives shown in the flowing table the period 2016-2019 Data Table a. Calculate the average retum over the year panied for each of the three anternatives b. Calculate the standard deviation of ourns over the 4-year period for each of the three a maties G. Use your findings in patsaand...

  • and over the period 2016-2019: Portfolio analysis You have been given the expected retum data shown...

    and over the period 2016-2019: Portfolio analysis You have been given the expected retum data shown in the first table on three Using these assets, you have isolated the three investment tomatives shown in the folowing table Data Table . C e gerum over your period for each of the matte b. Calore the standard deviation of returns over the 4-year period for each of the three heatives G. Use your findings in parts and blocate the coeficient of varion...

  • You have been given the following return​ data... on three assets- ​A, ​B, and C- over...

    You have been given the following return​ data... on three assets- ​A, ​B, and C- over the period 2021-2024. Using these​ assets, you have isolated three investment​alternatives: a. Calculate the standard deviation of returns for each of the three alternatives. ROUNDED TO 3 DECIMAL PLACES! Year 2021 2022 2023 2024 Expected Return Asset A Asset B Asset C 6% 12% 6% 8% 10% 8% 10% 8% 10% 12% 6% 12% Alternative Investment 100% of asset A 60% of asset A...

  • p8-15 A-C 333 CHAPTER 8 Risk and Return a. If the returns of assets V and...

    p8-15 A-C 333 CHAPTER 8 Risk and Return a. If the returns of assets V and W are perfectly positively correlated (correlation coefficient = +1), describe the range of (1) expected return and (2) risk associ- ated with all possible portfolio combinations. b. If the returns of assets V and W are uncorrelated (correlation coefficient = 0), describe the approximate range of (1) expected return and (2) risk associated with all possible portfolio combinations c. If the returns of assets...

  • P8-11 2 Integrative: Expected return, standard deviation, and coefficient of variation Three as- sets-F, G, and...

    P8-11 2 Integrative: Expected return, standard deviation, and coefficient of variation Three as- sets-F, G, and H-are currently being considered by Perth Industries. The probability distributions of expected returns for these assets are shown in the following table. 5Y0n Asset F Asset G Asset H i Pr, Return, r Pr, Return, r Pr Return, 1 0.10 40% 0.40 35% 0.10 40% 0.20 0.20 10 0.30 10 20 0,40 0.30 -20 0.40 0 10 0.20 -5 0.20 0 0.10 -10 0.10...

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