Question

In: Finance

You have been given the following return data on 3 assets; A, B and C over...

  1. You have been given the following return data on 3 assets; A, B and C over the period of 2013 -2016.

Expected return

Year

Asset A

Asset B

Asset C

2013

16

17

14

2014

17

16

15

2015

18

15

16

2016

19

14

17

Using these assets, you have isolated three investment alternatives:

Option

Investment

1

100% of asset A

2

50% of asset A and 50% of asset B

3

50% of asset A and 50% of asset C

  1. Calculate the portfolio return over the four year period of each of the three alternatives.
  2. Calculate the standard deviation of returns over the four year period for each of the three alternatives.
  1. You have been given the following return data on 3 assets; A, B and C over the period of 2013 -2016.

Expected return

Year

Asset A

Asset B

Asset C

2013

16

17

14

2014

17

16

15

2015

18

15

16

2016

19

14

17

Using these assets, you have isolated three investment alternatives:

Option

Investment

1

100% of asset A

2

50% of asset A and 50% of asset B

3

50% of asset A and 50% of asset C

  1. Calculate the portfolio return over the four year period of each of the three alternatives.
  2. Calculate the standard deviation of returns over the four year period for each of the three alternatives.

PLEASE STATE ALL THE FORMULAS CLEARLY AND DUN ANS IN EXCEL.

Solutions

Expert Solution

Answer a

How to compute Portfolio return in excel is shown below. Other two are also computed in the same way in excel

Statement of Total expected return by using the data of each alternative of Investment
Using Alternative 100% of Asset A
Portfolio value($) Year Investment value($) Investment return rate Investment weight Total expected return
100000 2013 100000 16% 1 0.16
17% 1 0.17
18% 1 0.18
19% 1 0.19
Portfolio expected return 0.7
Using Alternative A and B
Portfolio value Year Investment value Investment return rate Investment weight Total expected return
100000 2013 50000 16% 0.5 0.08
2013 50000 17% 0.5 0.085
2014 17% 0.5 0.085
2014 16% 0.5 0.08
2015 18% 0.5 0.09
2015 15% 0.5 0.075
2016 19% 0.5 0.095
2016 14% 0.5 0.07
Portfolio expected return 0.66
Using Alternative A and C
Portfolio value Year Investment value Investment return rate Investment weight Total expected return
100000 2013 50000 16% 0.5 0.08
2013 50000 14% 0.5 0.07
2014 17% 0.5 0.085
2014 15% 0.5 0.075
2015 18% 0.5 0.09
2015 16% 0.5 0.08
2016 19% 0.5 0.095
2016 17% 0.5 0.085
Portfolio expected return 0.66

Answer B

How to calculate SD in excel is exhibited. The other two are computed in the same way

Statement of satandard deviation of three alternatives
Using Alternative 100% of Asset A
Portfolio value($) Year Investment value($) Investment return rate Investment weight Total expected return Standard deviation
100000 2013 100000 16% 1 0.16
17% 1 0.17
18% 1 0.18
19% 1 0.19 0.012909944
Portfolio expected return 0.7
Using Alternative A and B
Portfolio value Year Investment value Investment return rate Investment weight Total expected return
100000 2013 50000 16% 0.5 0.08
2013 50000 17% 0.5 0.085
2014 17% 0.5 0.085
2014 16% 0.5 0.08
2015 18% 0.5 0.09
2015 15% 0.5 0.075
2016 19% 0.5 0.095
2016 14% 0.5 0.07 0.008017837
Portfolio expected return 0.66
Using Alternative A and C
Portfolio value Year Investment value Investment return rate Investment weight Total expected return
100000 2013 50000 16% 0.5 0.08
2013 50000 14% 0.5 0.07
2014 17% 0.5 0.085
2014 15% 0.5 0.075
2015 18% 0.5 0.09
2015 16% 0.5 0.08
2016 19% 0.5 0.095
2016 17% 0.5 0.085 0.008017837
Portfolio expected return 0.66

jeff jeffy answered 7 months ago
Next > < Previous

Related Solutions

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...
Q3.15You have been given the following return data on three assets: F, G and H and...
Q3.15You have been given the following return data on three assets: F, G and H and the two portfolios – over the period 2013 to 2016: Year Asset F Asset G Asset H Portfolio FG Portfolio FH 2013 16 17 14 16.5 15 2014 17 16 15 16.5 16 2015 18 15 16 16.5 17 2016 19 14 17 16.5 18 Using these assets, you have isolated three investment alternatives: 100% of Asset F   50% of Asset F and 50%...
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 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...
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...
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%...
Question 3 You have been given the following financial data of a research project from the...
Question 3 You have been given the following financial data of a research project from the chief researcher of Balloon Ltd: $ Cost to date (pure research 25%, applied research 75%) 600,000 Cost to develop the product in 2018 900,000 Expected future sales per annum in 2019 3,000,000 Fixed assets purchased in 1 January 2018 for the project: Cost 7,500,000 Estimated useful life 5 years Residual value 120,000 The board of directors considers this project to be similar to other...
Assume that we have 3 Stocks A, B & C. A B C Expected return 8%...
Assume that we have 3 Stocks A, B & C. A B C Expected return 8% 12% 6% Variance 0.012 0.028 0.009 If the covariance between stock A & B return is equal to 0.009159, stock A & C return is equal to -0.005146 and stock B & C return 0.01572 Required Calculate the Standard Deviation for stock A, B & C. which stock is risky and why? Calculate the correlation between every two stocks. What is the indication of...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT