- Question 1 Adjusted Closing Price For Apple Inc Is Provided In The Following Table Adj Adj Adj Date Close Date Close Da 1 (172.73 KiB) Viewed 27 times
Question 1 Adjusted Closing price for Apple Inc is provided in the following table. Adj Adj Adj Date Close Date Close Date Close 01/01/2019 3612.285 01/01/2020 4415.684 01/01/2021 5200.593 01/02/2019 3999.87 01/02/20204314.927 01/02/2021 5771.229 01/03/2019 4371.30101/03/20204549.663 01/03/2021 5905.448 01/04/2019 4126.596 01/04/2020 4742.503 01/04/2021 5511.751 01/05/2019 4657.382 01/05/2020 5079.86 01/05/2021 5614.748 01/06/2019 4569.288 01/06/20204881.908 01/06/20216197.111 01/07/2019 4065.643 01/07/2020 5450.673 01/07/2021 6796.8 01/08/2019 4040.728 01/08/20205385.618 01/08/2021 7044.184 01/09/2019 4477.583 01/09/20205605.773 01/09/2021 7060.597 01/10/2019 4547.165 01/10/2020 5631.156 01/10/2021 7293.973 01/11/2019 4316.734 01/11/2020 5750.548 01/11/2021 7252.16 01/12/2019 4627.59 | 01/12/2020 5521.165 01/12/20217397.047 Calculate the following for your company and provide the screen shot of your answers if you use excel. If you use calculator please show all your calculations: a) Calculate the Holding Period Returns for 2019, 2020 and 2021. [7.5 marks] b) Calculate the Annual Standard Deviations for 2019, 2020 and 2021. [7.5 marks] c) Assuming an annual Risk-Free Rate of 1.5%, what was the Risk Premium for each of the three years? [7.5 marks] d) What was the Sharpe Ratio in each of the three years? [7.5 marks] e) Calculate and explain the results of your allocated company's Capital Allocation Line over the full 3-year period. [10 marks]