Hi would you please be able to help me out with these following questions.

Q1.Collect the data from "Yahoo Finance" and answer the following questions (using the Name of the company: Lucapa Diamond Company Limited LOM.AX instructions given in the next page): Code: LOM.AX a) Collect the market price index (All Ordinaries), Share price for a company (as per Answer to part a) and b): instructions given in page 2) and display the data for two sub-periods (Period 1: January 2014 to January 2016; Period 2: September 2016 to September 2018) Period 1: January 2014 - January 2016 separately in two separate tables. (2 marks) Date AORD LOM.AX RE r; I'm - RF r; - RF b) Calculate the return of share prices (r, ) and market return (m ) (from market price Dec-13 5353.1001 0.1827 0.0058 index). Display the calculated returns along with the risk free rate of return (given in a an-14 5205.1001 0.2088 0.0033 separate excel file) in a table for two sub periods. Calculate and tabulate, (r, - RF ) and Feb-14 5415.3999 0.1827 0.0042 Mar-14 5403 0.1566 0.0042 (I'm - RF). (2 marks) Apr-14 5470.79981 0.1827 0.0025 c) Calculate the mean, standard deviation, variance and correlation coefficient for May-14 5473.79981 0.23925 0.0025 (r, -RF) and (I'm - RF ) separately (for two sub-period in a table-see next page) and Jun-14 5382 0.435 0.0033 comment on the result. (2+2=4 marks, 2 for calculation 2 for the comment) Jul-14 5623.1001 0.46 0.0025 Aug-14 5624.6001 0.4 0.0025 d) Estimate beta (9, ) for your selected company for the two sub-periods. Sept-14 5296.79981 0.385 0.0017 (1+1=2 marks) Oct-14 5505 0.38 0.0017 e) Explain the value of beta that you have calculated. Nov-14 5298.1001 0.365 0.0017 (1.5+1.5=3 marks-1.5 for each sub-period) Dec-14 5388.6001 0.32 0.0025 f) Provide a brief description of the company. (2 marks) 5551.6001 0.26 g) Why the estimated value of beta is different for two sub-periods? Jan-15 0.0025 (2.5+2.5=5 marks) Feb-15 5898.5 0.22 0.0017 Mar-15 5861.8999 0.19 0.0025 0.21 0.0017 (Note: The assessment should be typed, printed and submitted) Apr-15 5773.7002 May-15 5774.8999 0.26 0.0017 Jun-15 5451.2002 0.2 0.0017 Jul-15 5681.7002 0.175 0.0025 Where, I, = Return on Share Price for Company j'=-x100% Aug-15 5222.1001 0.19 0.0058 Sept-15 5058.6001 0.42 0.0017 RF = Risk free rate of return (given: do not multiply by 100) (Monthly R. = (1+10.)1 -1 x100 Oct-15 5288.6001 0.38 0.0017 Nov-15 5218.2002 0.27 0.0100 Dec-15 5344.6001 0.28 0.0191 r = Annual T-Bill rate Jan-16 5056.6001 0.29 0.0216 Average P = Share Price at time 't' Standard deviation Variance Correlation coefficient Beta\f