Question: 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

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

Hi would you please be able to help me out withHi would you please be able to help me out with
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!