Following are the data derived from the question:-
| 2011 | 2012 | 2013 | 2014 | 2015 | Portfolio %age | |
| Stock A | 10% | 7% | 15% | -5% | 8% | 70% |
| Stock B | 6% | 2% | 5% | 1% | -2% | 30% |
A) Calculate the average annual return for each.
Sol:- Average annual return will be calculate by summing all the return year wide and then divide it by 5.
| 2011 | 2012 | 2013 | 2014 | 2015 | Portfolio %age |
avg annual Return |
|
| Stock A | 10% | 7% | 15% | -5% | 8% | 70% | 7.00% |
| Stock B | 6% | 2% | 5% | 1% | -2% | 30% | 2.40% |
B) Calculate the volatility of return for each.
sol:- Following are the table shown all the calculation and steps to calculate the volatility (Variation).
| 2011 | 2012 | 2013 | 2014 | 2015 | Portfolio %age | avg annual Return |
Summation of all the Deviation Squared/no. of observation |
|
| Stock A | 10% | 7% | 15% | -5% | 8% | 70% | 7.00% | |
| Stock B | 6% | 2% | 5% | 1% | -2% | 30% | 2.40% | |
|
Deviation from avg Return Stock A |
3.00% | 0.00% | 8.00% | -12.00% | 1.00% | |||
|
Deviation from avg Return Stock B |
3.60% | -0.40% | 2.60% | -1.40% | -4.40% | |||
| Deviation Squared Stock A | 0.09% | 0.00% | 0.64% | 1.44% | 0.01% | 0.436% | ||
| Deviation Squared Stock B | 0.13% | 0.00% | 0.07% | 0.02% | 0.19% | 0.082% |
Steps to be followed:-
a) Calculate the average price for the number of periods of observations.
b) Determine each period's deviation.
c) square each period's deviation.
d) sum the squared deviation.
e) divide this sum by number of observation. This will give you the volatility of the particular stock.
f) the standard deviation is the square root of that number.
C) Calculate the range of values we can be 95% sure return will fall within for each.
Sol:-
| 2011 | 2012 | 2013 | 2014 | 2015 | Portfolio %age | avg annual Return |
95% Sure return Data |
|
| Stock A | 10% | 7% | 15% | -5% | 8% | 70% | 7.00% | 6.65% |
| Stock B | 6% | 2% | 5% | 1% | -2% | 30% | 2.40% | 2.28% |
The value for return can be vary for stock A is 7% to 6.65% and for stock B is to 2.40% to 2.28%.
Risk. Suppose you are considering the risk of a portfolio made up of 70% company A...
1. A portfolio contains 3 stocks as outlined below. What is the beta of the portfolio? Stock Weight Beta A 70% 0.77 B 10% 1.17 C 20% 1.77 A. 1.24 B. 1.10 C. 1.07 D. 1.01 2. Two stocks have the following returns. What is their correlation? Year Stock A Stock B 2010 8.00% -8.00% 2011 9.00% -9.00% 2012 10.00% -10.00% 2013 12.00% -12.00% 2014 14.00% -14.00% 2015 16.00% -16.00% A. -1.00 B. 1.00 C. 0.00 D. -.23
Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has learned that investing in a bond market index ETF as well may reduce his/her portfolio risk due to diversification. The annual returns for both ETFs for the last ten years are listed below. Measured by the standard deviation of returns, by how much would PSMI’s portfolio’s historical risk been reduced if PSMI invested 70% in the stock market index ETF and 30% in the...
Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has learned that investing in a bond market index ETF as well may reduce his/her portfolio risk due to diversification. The annual returns for both ETFs for the last ten years are listed below. Measured by the standard deviation of returns, by how much would PSMI’s portfolio’s historical risk been reduced if PSMI invested 60% in the stock market index ETF and 40% in the...
Please help. Need step by step instructions. Given: The excess returns of two stocks X and Y and a market portfolio M in the table below over the past 5 years: Year Stock X-Rf Stock Y-Rf Market M-Rf 2010 14.00% 13.00% 12.00% 2011 19.00% 7.00% 10.00% 2012 -16.00% -5.00% -12.00% 2013 3.00% 1.00% 1.00% 2014 20.00% 11.00% 15.00% What is the beta for Stock X and Stock Y?
REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Stock B's Returns, rs Stock A's Returns, rA Year - 13.50 % -15.00% 2011 19.60 31.75 2012 32.10 12.00 2013 -10.80 -4.00 2014 24.85 27.50 2015 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...
Suppose you had the following information about the CPI in
nation ABC. CPI for each year from 2010-2015 was 85.5, 95.2, 100.0,
108.8, 115.3, and 121.1.
a. Calculate inflation from 2010-2011, 2011-2012, 2012-2013,
2013-2014, and 2014-2015. Calculate the rate of inflation to 3
decimal points. Show all work.
5. Suppose you had the following information about the CPI in nation ABC. CPI for each year from 2010-2015 was 85.5, 95.2, 100.0, 108.8, 115.3, and 121.1. a. Calculate inflation from 2010-2011,...
2. Two stocks have the following returns. What is their correlation? Year Stock A Stock B 2010 8.00% -8.00% 2011 9.00% -9.00% 2012 10.00% -10.00% 2013 12.00% -12.00% 2014 14.00% -14.00% 2015 16.00% -16.00% A. -1.00 B. 1.00 C. 0.00 D. -.23
Stocks A and B have the following historical returns: Year Stock A's Returns, A Stock B's Returns, re 2011 - 23.40% 15.7094 2012 31.50 29.30 2013 17.75 28.40 2014 - 1.50 - 12.80 2015 29.00 24.15 .. 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 two decimal...
REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 24.00% - 12.10% 2012 20.50 23.70 2013 17.75 31.90 2014 - 5.25 - 11.70 2015 25.75 2.95 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...
Stocks A and B have the following historical returns Year Stock A'sReturns, A Stock B's Returns, rB 2011 2012 2013 2014 2015 23.00%, 26.75 15.75 3.50 29.50 1 7.50% 16,80 26.40 10.40 30.20 a. Calculate the average rate of retum for stock A during the period 2011 through 2015. Round your answer to two decimal places. Calculate the average rate of retum for stock 8 during the period 2011 through 2015. Round your answer to two decimal places, b Assume...