Financial management

Part C (Total 20 marks) Below is the monthly share price data for Coles Group Lid (ASX code COL.AX) 2021 - 2022 financial year (Source: https://finance.yahoo.com) PAGE 10 OF 16 FIN700 FINANCIAL MANAGEMENT T322 V2.0 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD @ ABN: 72 132 629 979 CRICOS 03171A FIN700 "KOI King's Own Institute Months Open Close July 17.11 17.49 Aug 17.66 18.08 Sep 18.00 16.99 Oct 16.75 17.14 Nov 17.49 18.02 Dec 17.97 17.94 Jan 17.94 16.20 Feb 16.34 17.38 Mar 17.64 17.91 Apr 17.79 18.70 May 18.55 17.53 June 17.63 17.81 Coles paid fully franked dividends of $0.28 on August 26, 2021 and $0.33 on March 3, 2022. 1. Calculate the 2021 - 2022 monthly percentage returns for Coles Group Limited (including the dividends paid). (Show answer correct to six decimal places.) (8 marks) 2. Calculate the average monthly return (%) for Coles. (Show answer correct to six decimal places) (2 marks) 3. Calculate the risk measured by the standard deviation for Coles. (Show answer correct to six decimal places) (5 marks) 4. If the standard deviation for the market is 6.3239%, how does this compare with Coles' standard deviation calculated in Q.3? Explain your conclusions