Question

In: Finance

Table below shows the historical returns for Companies A, B and C Year Company A Company...

Table below shows the historical returns for Companies A, B and C

Year

Company A

Company B

Company C

1

30%

26%

47%

2

7%

15%

-54%

3

18%

-14%

15%

4

-22%

-15%

7%

5

-14%

2%

-28%

6

10%

-18%

40%

7

26%

42%

17%

8

-10%

30%

-23%

9

-3%

-32%

-4%

10

38%

28%

75%

11

27.0%

23.4%

42.3%

12

6.3%

13.5%

-48.6%

13

16.2%

-12.6%

13.5%

14

-19.8%

-13.5%

6.3%

15

-12.6%

1.8%

-25.2%

16

9.0%

-16.2%

36.0%

17

23.4%

37.8%

15.3%

18

-9.0%

27.0%

-20.7%

19

-2.7%

-28.8%

-3.6%

20

34.2%

25.2%

67.5%

1. If one investor has a portfolio consisting of 70% Company A and 30% Company B, what are the average portfolio return and standard deviation? What is Sharpe ratio if the risk- free rate is 3.5%?

2.If another investor has a portfolio consisting of 1/3 Company A, 1/3 Company B and 1/3 Company C, what are the average portfolio return and standard deviation? What is Sharpe ratio if the risk-free rate is 3.5%? 


Solutions

Expert Solution

portfolio average return is calculated using weighted average of individual average returns of investments in portfolio .

portfolio standard deviation is calculated using covariance between company A and company B and company C returns.


Related Solutions

The table below shows the returns and probabilities of 3 different financial assets (A, B, C)....
The table below shows the returns and probabilities of 3 different financial assets (A, B, C). Which financial asset should be preferred according to the Risk-Return analysis? (Coefficient of Change will be calculated over Standard Deviation / Expected Return.). You can use 4 digits after the comma in your calculations. Possibility Return A Return B Return C 0,10 (-)0,09 0,01 (-)0,20 0,35 0,08 0,05 (-)0,10 0,40 0,13 0,10 0,25 0,15 0,20 0,15 0,75
The table below shows the returns and probabilities of 3 different financial assets (A, B, C)....
The table below shows the returns and probabilities of 3 different financial assets (A, B, C). Which financial asset should be preferred according to the Risk-Return analysis? (Coefficient of Change will be calculated over Standard Deviation / Expected Return.). You can use 4 digits after the comma in your calculations. Possibility Return A Return B Return C 0.10 (-)0,09 0,01 (-)0,20 0.35 0,08 0,05 (-)0,10 0,40 0,13 0,10 0,25 0,15 0,20 0,15 0,75 I would appreciate if you show transactions
Consider stocks of two companies A and B, the table below gives their expected returns and...
Consider stocks of two companies A and B, the table below gives their expected returns and standard deviation Expected return for Stock A 10% Expected return for Stock B 25% Standard deviation for Stock A 12% Standard deviation for Stock B 30% Plot the risk and expected return of portfolio of these two stocks for the following correlation coefficient : -1.0,-0.5,0.0,0.5,1.0
EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in...
EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in percentages) for 2 major market indices. For each index, calculate the arithmetic mean return and the geometric mean return of full-year returns from 2005-2015. What is the relationship between the arithmetic and geometric mean returns? 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 Nasdaq Composite Index 1.37 8.59 50.0 -31.5 -21.1 -39.3 85.6 39.6 21.6 22.7 39.9 Dow Jones Industrial Average...
The table below reports the returns of assets A, B and C in four different states...
The table below reports the returns of assets A, B and C in four different states of the world, each equally likely. State of the world              Return A                 Return B              Return C              Probability Boom                                       5%                          0                           5%                   0.25 Growth                                      0                            0                            0                     0.25 Downturn                                  0                            5%                         0                     0.25 Recession                                5%                         5%                         5%                  0.25 a) Calculate the expected return and the variance for all assets and determine the expected return of any portfolio obtained by mixing any of the three assets. b) Calculate the covariance of assets A...
Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012...
Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012 -19.60% -14.00% 2013 20.00 30.00 2014 12.00 35.30 2015 -1.00 -10.20 2016 31.50 1.80 Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 22.40% - 15.60% 2012 27.75 19.70 2013 10.00 37.00 2014 - 5.00 - 9.90 2015 23.75 2.90 a. Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. %_________ Calculate the average rate of return for stock B during the period 2011 through 2015. Round your answer to...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2014 (16.20 %) (13.00 %) 2015 33.50 24.10 2016 15.00 30.90 2017 (1.75 ) (9.60 ) 2018 27.25 25.40 Calculate the average rate of return for each stock during the period 2014 through 2018. Round your answers to two decimal places. Stock A:   % Stock B:   % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B....
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2013 - 19.40% - 17.90% 2014 37.75 23.80 2015 15.25 35.70 2016 - 5.50 - 6.70 2017 26.25 19.45 A. Calculate the average rate of return for stock A during the period 2013 through 2017. Round your answer to two decimal places. % Calculate the average rate of return for stock B during the period 2013 through 2017. Round your answer to...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2014 (18.50 %) (13.50%) 2015 32.50 19.90 2016 16.75 25.50 2017 (5.00 ) (12.70 ) 2018 27.50 34.05 a. Calculate the average rate of return for each stock during the period 2014 through 2018. Round your answers to two decimal places. Stock A: % Stock B: % b. Assume that someone held a portfolio consisting of 50% of Stock A and 50%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT