Question

Hellow

please assist with a solution to this question:

Question 1                                                                                                                

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.00%)	(14.50%)
2015	33.00	21.80
2016	15.00	30.50
2017	(0.50)	(7.60)
2018	27.00	26.30

Required:

1. 1. Calculate the average rate of return for each stock during the period 2014 through 2018.                                                                                                                             
   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?                                                                                                                                      
2. 3. Calculate the standard deviation of returns for each stock and for the portfolio
3. 4. Calculate the coefficient of variation for each stock and for the portfolio.         
   5. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Why?                                                                                                

Answer 1

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

Cell reference: