1. You are given the following data Year HPR of Stock A HPR of Stock B HPR of Stock C 2018 12% 20% 12% 2019 16% 16% 16% 2020 20% 12% 20% (1) Calculate expected rate of return for each stock (2) Calculate standard deviation for each stock (3) Calculate coefficient of variation for each stock. If you will choose only one stock for investment, which stock will you choose? Why? (4) How much is correlation coefficient between A and B? between A and C? (Use Excel to find correlation coefficient between two stocks) (5) Calculate expected rate of return and standard deviation for the portfolio A + B. Assume you invest equal proportion (50%) in each stock (6) Calculate expected rate of return and standard deviation for the portfolio A +C. Assume you invest equal proportion (50%) in each stock (7) Which portfolio do you recommend? Why? 2. Currently, the risk-free interest rate (Rp) is 1% and the required market return (rm) is 11%. You consider to buy a stock with a beta (B) of 1.5 and you expect to earn 15% annual rate of return from this stock. (1) Use the Capital Asset Pricing Model (CAPM) to find the required return on this stock (2) Base on your answer from part (1), would you buy this stock? Why or why not? (3) Draw the Security Market Line (SML) using the data above, and determine intercept and slope of the SML. 3. Microsoft Stock has a beta of 1.20. (1) If the market return increased by 10%, what impact would this change be expected to have on Microsoft stock's return? (2) If the market return decreased by 15%, what impact would this change be expected to have on Microsoft stock's return? (3) Would Microsoft stock be considered more or less risky than the market