Question

In: Finance

You have been given the expected return data shown in the first table on three assets—F,...

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

a. Find the expected return, variance, std dev and coefficient of variation for each asset.

b. Now consider a portfolio that consists of 25% of F, 50% of G and 25% of H. Find the expected return, variance, std, dev and coefficient of variation for this portfolio.

Solutions

Expert Solution

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

Cell reference -


Related Solutions

You have been given the expected return data shown in the first table on three assets—F,...
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 Find the expected return, variance, std dev and coefficient of variation for each asset. Now consider a portfolio that consists of 25% of F, 50% of G and 25% of H. Find the expected return,...
You have been given the expected return data shown in the first table on three assets—F,...
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 Find the expected return, variance, std dev and coefficient of variation for each asset. Now consider a portfolio that consists of 25% of F, 50% of G and 25% of H. Find the expected return,...
You have been given the expected return data shown in the first table on three assets—F,...
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 Find the expected return, variance, std dev and coefficient of variation for each asset. Now consider a portfolio that consists of 25% of F, 50% of G and 25% of H. Find the expected return,...
 You have been given the expected return data shown in the first table on three assets—​F,...
 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 18​% 19​%     16​%     2017 19​% 18​% 17​% 2018 20​% 17​% 18​% 2019 21​% 16​% 19​% Using these​ assets, you have isolated the three investment alternatives shown in the following​ table: Alternative Investment 1 100% of asset F 2 ​50% of asset F and​ 50% of asset G...
You have been given the expected return data shown in the first table on three assets-A,B...
You have been given the expected return data shown in the first table on three assets-A,B and C- over the period 2021-2024. Expected return Year Asset A Asset B Asset C 2021 6% 10% 4% 2022 8% 8% 6% 2023 10% 6% 8% 2024 12% 4% 10% Using these assets, you have isolated the three investment alternatives shown in the following table: Alternative Investment 1 100% of asset A 2 55% of asset A and 45% of asset B 3...
You have been given the expected return data shown in the first table on the three...
You have been given the expected return data shown in the first table on the three assets - F, G, and H - over the period 2016-2019 Expected Return Expected Return Expected Return Year Asset F Asset G Asset H 2016 16% 17% 14% 2017 17 16 15 2018 18 15 16 2019 19 14 17 Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 1 100% of asset F 2 50%...
You have been given the expected return data shown in the first table on three assetslong...
You have been given the expected return data shown in the first table on three assetslong dash—​F, ​G, and Hlong dash—over the period​ 2016-2019: lick on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.) Expected Return Year Asset F Asset G Asset H 2016 11​% 12%     9​%     2017 12​% 11% 10​% 2018 13% 10​% 11​% 2019 14​% 99% 12​% . Using these​ assets, you have isolated the...
you have been given the expected return data shown in the first table on three assetslong...
you have been given the expected return data shown in the first table on three assetslong dash—​F, ​G, and H long dash—over the period​ 2016-2019: Expected Return Year Asset F Asset G Asset H 2016 16​% 17​%     14​%     2017 17​% 16​% 15​% 2018 18​% 15​% 16​% 2019 19​% 14​% 17​% Using these​ assets, you have isolated the three investment alternatives shown in the following​ table Alternative Investment 1 ​100% of asset F 2 ​50% of asset F and​ 50% of...
you have been given the expected return data shown in the first table on three assetslong...
you have been given the expected return data shown in the first table on three assetslong dash—​F, ​G, and H long dash—over the period​ 2016-2019: Expected Return Year Asset F Asset G Asset H 2016 16​% 17​%     14​%     2017 17​% 16​% 15​% 2018 18​% 15​% 16​% 2019 19​% 14​% 17​% Using these​ assets, you have isolated the three investment alternatives shown in the following​ table Alternative Investment 1 ​100% of asset F 2 ​50% of asset F and​ 50% of...
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:
 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: Using these assets, you have isolated the three investment alternatives shown in the following table: a. Calculate the expected return over the 4-year period for each of the three altermatives. 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 to calculate the coefficient...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT