In: Finance
Your company has decided to investment in the stock market. Management has tasked you to conduct and assessment of the two stocks listed below
Year |
Stock A Ra |
Stock B Rb |
2014 |
(18%) |
(14,50%) |
2015 |
33 |
21,8 |
2016 |
15 |
30,5 |
2017 |
(0,5) |
(7,6) |
2018 |
27 |
26,3 |
1.1 Calculate the average rate of return for each stock during the period 2014 through 2018.
1.2 Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realised rate of return on the portfolio have been each
year? What would the average return on the portfolio have been during this period?
1.3 Calculate the standard deviation of returns for each stock and for the portfolio.
1.4 Calculate the coefficient of variation for each stock and for the portfolio.
1.5 Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.