Collect the data from Yahoo Finance and answer the following questions (using the instructions given in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Collect the data from "Yahoo Finance" and answer the following questions (using the instructions given in the next page): a) Collect the market price index (All Ordinaries), Share price for a company (as per 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) separately in two separate tables. (2 marks) b) Calculate the return of share prices (r) and market return (r) (from market price index). Display the calculated returns along with the risk free rate of return (given in a separate excel file) in a table for two sub periods. Calculate and tabulate, (r.-R.) and (r-R₂). (2 marks) c) Calculate the mean, standard deviation, variance and correlation coefficient for (r-R,) and (r.-R.) separately (for two sub-period in a table-see next page) and (2+2-4 marks, 2 for calculation 2 for the comment) comment on the result. d) Estimate beta (2) for your selected company for the two sub-periods. e) Explain the value of beta that you have calculated. f) Provide a brief description of the company. g) Why the estimated value of beta is different for two sub-periods? (1.5+1.5-3 marks-1.5 for each sub-period) (2 marks) (1+1=2 marks) (Note: The assessment should be typed, printed and submitted) Where, r,- Return on Share Price for Company j r=Annual T-Bill rate P=Share Price at time t' (2.5+2.5-5 marks) P-P-1×100% PA R, = Risk free rate of return (given: do not multiply by 100) (Monthly R, 100 Name of the company: Lucapa Diamond Company Limited LOM.AX Code: LOM.AX Answer to part a) and b): Period 1: January 2014 - January 2016 + Date AORD Dec-13 5353.1001 Jan-14 5205.1001 Feb-14 5415.3999 Mar-14 5403 Apr-14 5470.79981 0.1827 May-14 5473.79981 0.23925 Jun-14 5382 Jul-14 5623.1001 Aug-14 5624.6001 Sept-14 5296.79981 Oct-14 5505 Nov-14 5298.1001 Dec-14 5388.6001 Jan-15 5551.6001 Feb-15 5898.5 Mar-15 5861.8999 Apr-15 5773.7002 May-15 5774.8999 Jun-15 5451 2002 Jul-15 5681.7002 Aug-15 5222.1001 Sept-15 5058.6001 Oct-15 5288.6001 Nov-15 5218.2002 LOM.AX R Dec-15 5344.6001 Jan-16 5056.6001 0.1827 0.0058 0.2088 0.0033 0.1827 0.1566 0.435 0.46 0.4 0.385 0.38 0.365 0.32 0.26 0.22 0.19 0.21 0.26 0.2 0.175 0.19 0.42 0.38 0.27 0.28 0.29 0.0042 0.0042 0.0025 0.0025 0.0033 0.0025 0.0025 0.0017 0.0017 0.0017 0.0025 0.0025 0.0017 0.0025 0.0017 0.0017 0.0017 0.0025 0.0058 0.0017 0.0017 0.0100 0.0191 0.0216 r.-R, r-R, Average Standard deviation Variance Livate Windows Correlation coefficient ings to activate Wi Beta Period 2: September 2016 - September 2018 Date AORD LOM.AX RE 5529.3999 5525.2002 Aug-16 Sept-16 Oct-16 5402.3999 Nov-16 5502.3999 Dec-16 5719.1001 Jan-17 Feb-17 Mar-17 5903.79981 5675 5761 Apr-17 5947.6001 May-17 5761.29981 Jun-17 5764 Jul-17 5773.8999 Aug-17 5776.29981 Sept-17 5744.8999 Oct-17 5976.3999 Nov-17 6023.5 Dec-18 6167.29981 Jan-18 6146.5 Feb-18 6117.29981 Mar-18 5868.8999 Apr-18 6071.6001 May-18 6123.5 Jun-18 6289.7002 Jul-18 6366.2002 Aug-18 6427.79981 Sept-18 6325.5 0.34 0.465 0.475 0.45 0.42 0.4 0.405 0.36 0.315 0.305 0.285 0.25 0.245 0.265 0.285 0.245 0.225 0.23 0.235 0.23 0.27 0.27 0.275 0.26 0.26 0.23 0.0250 0.0241 0.0275 0.0374 0.0424 0.0424 0.0432 0.0615 0.0664 0.0739 0.0813 0.0887 0.0838 0.0854 0.0887 0.1019 0.1093 0.1167 0.1299 0.1406 0.1455 0.1537 0.1570 0.1619 0.1676 0.1758 Ym r₂ Average Standard deviation Variance Correlation coefficient Beta rm-RF rj - RE Collect the data from "Yahoo Finance" and answer the following questions (using the instructions given in the next page): a) Collect the market price index (All Ordinaries), Share price for a company (as per 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) separately in two separate tables. (2 marks) b) Calculate the return of share prices (r) and market return (r) (from market price index). Display the calculated returns along with the risk free rate of return (given in a separate excel file) in a table for two sub periods. Calculate and tabulate, (r.-R.) and (r-R₂). (2 marks) c) Calculate the mean, standard deviation, variance and correlation coefficient for (r-R,) and (r.-R.) separately (for two sub-period in a table-see next page) and (2+2-4 marks, 2 for calculation 2 for the comment) comment on the result. d) Estimate beta (2) for your selected company for the two sub-periods. e) Explain the value of beta that you have calculated. f) Provide a brief description of the company. g) Why the estimated value of beta is different for two sub-periods? (1.5+1.5-3 marks-1.5 for each sub-period) (2 marks) (1+1=2 marks) (Note: The assessment should be typed, printed and submitted) Where, r,- Return on Share Price for Company j r=Annual T-Bill rate P=Share Price at time t' (2.5+2.5-5 marks) P-P-1×100% PA R, = Risk free rate of return (given: do not multiply by 100) (Monthly R, 100 Name of the company: Lucapa Diamond Company Limited LOM.AX Code: LOM.AX Answer to part a) and b): Period 1: January 2014 - January 2016 + Date AORD Dec-13 5353.1001 Jan-14 5205.1001 Feb-14 5415.3999 Mar-14 5403 Apr-14 5470.79981 0.1827 May-14 5473.79981 0.23925 Jun-14 5382 Jul-14 5623.1001 Aug-14 5624.6001 Sept-14 5296.79981 Oct-14 5505 Nov-14 5298.1001 Dec-14 5388.6001 Jan-15 5551.6001 Feb-15 5898.5 Mar-15 5861.8999 Apr-15 5773.7002 May-15 5774.8999 Jun-15 5451 2002 Jul-15 5681.7002 Aug-15 5222.1001 Sept-15 5058.6001 Oct-15 5288.6001 Nov-15 5218.2002 LOM.AX R Dec-15 5344.6001 Jan-16 5056.6001 0.1827 0.0058 0.2088 0.0033 0.1827 0.1566 0.435 0.46 0.4 0.385 0.38 0.365 0.32 0.26 0.22 0.19 0.21 0.26 0.2 0.175 0.19 0.42 0.38 0.27 0.28 0.29 0.0042 0.0042 0.0025 0.0025 0.0033 0.0025 0.0025 0.0017 0.0017 0.0017 0.0025 0.0025 0.0017 0.0025 0.0017 0.0017 0.0017 0.0025 0.0058 0.0017 0.0017 0.0100 0.0191 0.0216 r.-R, r-R, Average Standard deviation Variance Livate Windows Correlation coefficient ings to activate Wi Beta Period 2: September 2016 - September 2018 Date AORD LOM.AX RE 5529.3999 5525.2002 Aug-16 Sept-16 Oct-16 5402.3999 Nov-16 5502.3999 Dec-16 5719.1001 Jan-17 Feb-17 Mar-17 5903.79981 5675 5761 Apr-17 5947.6001 May-17 5761.29981 Jun-17 5764 Jul-17 5773.8999 Aug-17 5776.29981 Sept-17 5744.8999 Oct-17 5976.3999 Nov-17 6023.5 Dec-18 6167.29981 Jan-18 6146.5 Feb-18 6117.29981 Mar-18 5868.8999 Apr-18 6071.6001 May-18 6123.5 Jun-18 6289.7002 Jul-18 6366.2002 Aug-18 6427.79981 Sept-18 6325.5 0.34 0.465 0.475 0.45 0.42 0.4 0.405 0.36 0.315 0.305 0.285 0.25 0.245 0.265 0.285 0.245 0.225 0.23 0.235 0.23 0.27 0.27 0.275 0.26 0.26 0.23 0.0250 0.0241 0.0275 0.0374 0.0424 0.0424 0.0432 0.0615 0.0664 0.0739 0.0813 0.0887 0.0838 0.0854 0.0887 0.1019 0.1093 0.1167 0.1299 0.1406 0.1455 0.1537 0.1570 0.1619 0.1676 0.1758 Ym r₂ Average Standard deviation Variance Correlation coefficient Beta rm-RF rj - RE
Expert Answer:
Answer rating: 100% (QA)
To address the questions based on the instructions well follow these steps a Collect data for th... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
According to the law of sales contracts, all parties must act in good faith, which means they must act honestly. True/False
-
Suppose that KMS in Problem 4 decides to initiate a dividend instead, but it wants the present value of the payout to be the same $20 million. If its cost of equity capital is 10%, to what amount per...
-
Brenda Gail Langley is a resident of Tennessee, and on October 20, 1999, she took out a $50,000 life insurance policy. In this policy, she named her three biological childrenKristin Taylor, Edward...
-
Tennessee law imposes durational-residency requirements on persons and companies wishing to operate retail liquor stores, requiring applicants for an initial license to have resided in the state for...
-
Steve Jackson (age 51) is a single taxpayer living at 3215 Pacific Dr., Del Mar, CA 92014. His Social Security number is 465-88-9415. In 2014, Steves earnings and income tax withholding as the...
-
How to convert this Entity-Relationship data model into a relational database model? Contains Inventory Inventory ID Customer Cust_ID Amount Availible Cust LName Must Have Coffee_Type Cust Fname...
-
4. (Chapter 3) Skycell, a major European cell phone manufacturer, is making production plans for the coming year. Skycell has worked with its customers (the service providers) to come up with...
-
2. What is the speed of a simple harmonic oscillator at the time when it has U = K (three times as much kinetic energy as potential energy)? Express your /5 answer in terms of its maximum speed,...
-
What are the implications of continuous and discontinuous change for innovation?
-
Identify the basic characteristics associated with clan, hierarchy, market and adhocracy culture types.
-
Under what situations should you look to source knowledge externally and under what circumstances should it be created internally?
-
Discuss the different roles a subsidiary can play in the roll-out of an innovation.
-
Using an illustrative example, describe the four possible customisation strategies that a firm might adopt.
-
39. A student titrated a 10.0 mL sample of nitric acid with a 1.50 mol/L sodium hydroxide solution in the presence of an indicator. Calculate the concentration in mol/L of the nitric acid using the...
-
2.) Find the Laplace transform of f(t) 7e-St cos 2t +9 sinh2 2t. Use Laplace Table. %3D
-
In 2012, Lou has a salary of $54,000 from her job. She also has interest income of $1,700. Lou is single and has no dependents. During the year, Lou sold silver coins held as an investment for a...
-
William sold Section 1245 property for $25,000 in 2012. The property cost $35,000 when it was purchased 5 years ago. The depreciation claimed on the property was $16,000. a. Calculate the adjusted...
-
Linda and Richard are married and file a joint return for 2012. During the year, Linda, who works as an accountant for a national airline, used $2,100 worth of free passes for travel on the airline;...
-
Solve the Gross-Pitaevskii equation and evaluate the mean field energy, see equations (11.2.21) and (11.2.23), for a uniform Bose gas to show that this method yields precisely equation (11.2.6).
-
Solve the Gross-Pitaevskii equation and evaluate the mean field energy, see equations (11.2.21) and (11.2.23), for an isotropic harmonic oscillator trap with frequency \(\omega_{0}\) for the case \(N...
-
Assuming the Dieterici equation of state \[P(v-b)=k T \exp (-a / k T v)\] evaluate the critical constants \(P_{c}, v_{c}\), and \(T_{c}\) of the given system in terms of the parameters \(a\) and...
Study smarter with the SolutionInn App