Question 1 Below table contains the share prices of QUBE Holdings Limited (Ports and Logistics sector) and Australia and New Zealand Banking Group Limited for the 13 months from 1 September 2020 to 1 September 2021 (Price data were downloaded from Yahoo Finance) Date QUBE ANZ Price ($) Price (5) 1/09/2020 2.51 17.22 1/10/2020 2.65 18.81 1/11/2020 2.86 22.64 1/12/2020 2.94 22.70 1/01/2021 2.85 23.71 1/02/2021 3.07 26.17 1/03/2021 2.99 28.18 1/04/2021 3.01 28.74 1/05/2021 3.01 28.71 1/06/2021 3.17 28.15 1/07/2021 2.92 27.71 1/08/2021 3.16 27.85 1/09/2021 3.31 27.59 a) Calculate the monthly holding period returns for QUBE and ANZ (there will be 12 monthly returns for each share). ) b) Calculate the average monthly holding-period returns and the standard deviations of these returns for QUBE and ANZ. c) Assume you have decided to invest 60% of your money in QUBE and 40% in ANZ. Calculate the expected monthly holding-period return and the standard deviation of the return for the two-share portfolio. d) Discuss whether you have gained benefits through the creation of the portfolio of 60% in AUBE and 40% in ANZ. Note: You can use Excel spreadsheet to work on part a, b and C. However, the answers, working process explanation including formula used, and discussion should be in Word document. The spreadsheets are submitted as an appendix