In the table below are the monthly share prices for global resource giant BHP and the ASX All Ordinaries index for the year 1/10/2019 to 30/09/2020.
Bb S-ACC515_202090_SM_| Accoux Course Hero X G BHP paid fully franked dividenc x Basics of Franking Credits (+Ce x ] G Calculate the Future Value of J. X + X C A interact2.csu.edu.au/webapps/csu-serviceslink-BB5c1c4db3261aa/link?type=msi&course_id=_50615_1&mode=view G Apps G Gmail @ YouTube V Maps APA REFRENCES, C... S StuDocu - Free sum... T. The 22 Best Free O. Course Hero @ 123movies PeerWise - Home . ImmiAccount Time 10 Question 3 (50 marks) This question relates to material covered in Topics 1-5. This question addresses the 181, 20 and 3" subject learning outcomes. In the table below are the monthly share prices for global resource giant BHP and the ASX All Ordinaries index for the year 1/10/2019 to 30/09/2020. BHP Open Close ALL ORDS Open Close Oct 2019 36.59 35.95 Oct 2019 6,800.60 6,772.90 Nov 2019 35.95 38.23 Nov 2019 6,772.90 6,948.00 Dec 2019 38.23 38.92 Dec 2019 6,948.00 6,802.40 Jan 2020 38.92 39.40 Jan 2020 6,802.40 7,121.20 Feb 2020 39.40 33.60 Feb 2020 7,121.20 6,511.50 Mar 2020 33.60 28.98 Mar 2020 6,511.50 5,110.60 Apr 2020 28.98 32.35 Apr 2020 5,110.60 5,597.70 May 2020 32.35 34.64 May 2020 5,597.70 5,872.20 Jun 2020 34.64 35.82 Jun 2020 5,872.20 6,001.30 Jul 2020 35.82 36.75 Jul 2020 6,001.30 6,058.30 Aug 2020 36.75 37.91 Aug 2020 6,058.30 6,245.90 Sep 2020 37.91 35.60 Sep 2020 6,245.90 6,009.30 BHP paid fully franked dividends of $0.9940 on March 5, 2020 and $0.7657 on September 3, 2020. i. Calculate the grossed-up value of the two fully franked dividends paid by BHP (5 marks). ii. Calculate the monthly holding period returns (in both $ and 9%) for BHP (including the grossed-up amount of the dividends paid) for the year of data provided above (5 marks). iii. Calculate the average monthly return (9%) for BHP (2.5 marks). iv. Calculate the annual holding period return (in both $ and 96) for BHP (including the grossed-up amount of the dividends paid) (2.5 marks). v. Calculate the risk of BHP as measured by its standard deviation for the year (5 marks). vi. Calculate the monthly holding period returns (9%) for the ALL ORDS (5 marks). vii. Calculate the annual holding period return (96) for the ALL ORDS (2.5 marks). viii. Calculate the average monthly return (9%) for the ALL ORDS (2.5 marks). ix. Calculate the risk of ALL ORDS as measured by its standard deviation for the year (5 marks). X. Using Excel, prepare a line graph showing the monthly holding returns for both BHP and the ALL ORDS index (5 marks). xi. If you had $10,000 to invest today would you invest in BHP shares or in an index fund that matched the return of the ALL ORDS index? Give a full explanation of your conclusions including the use of historical risk and return (10 marks). Question 4 (20 marks) Type here to search O e W 7:10 PM 16-Dec-20
