Excel is required for this question. Search online for The a2 Milk Company Limited (ATM.NZ) daily...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel is required for this question. Search online for The a2 Milk Company Limited (ATM.NZ) daily stock price from January 3, 2020 to July 22, 2021. a. Download the above stock's daily closing price for the specified period. Save the data in an Excel file to perform the following calculations. The data for the relevant period must be included in the Excel submission as supporting evidence [Mark deduction applies for lack of supporting evidence]. (1 mark) Present the website and link here: b. Using the above data, calculate the daily rates of change (i.e. daily rates of return or daily holding period returns) of the downloaded stock prices; express the calculated rates in two decimal places. Evidence of calculations must be included in the Excel submission as supporting evidence [Mark deduction applies for lack of supporting evidence]. In your Word answer file space below, present the formula for calculating the rate of change. (1 mark) Present the rate of change formula bere [Note: A 'daily' rate of change refers to the rate of change in closing prices from one trading day to another. For instance, the closing prices on July 12, 2021 and July 13, 2021 can be used to calculate one daily rate of change; that is, the prices from two trading days will give you one daily rate of change. If you have closing prices for n days, there will be (n-1) daily rates of change.] Suggested Excel table: To calculate the daily rate of change. set up your Excel table columns as specified below. Show respective closing prices and rates below each column. Calculated daily rate of change s Dute (Adjusted) Daily Clowing Price c. Next, sont the rate of change from smallest to largest onder. (Note in Excel, before performing the sert function, it is better to first highlight rate of change column, copy and paste next to this column using "paste special as "les". Now you are ready to use Excel's Duta Sort function to sert the dates and calculated daily rate of change (the pasted as "values" column) from "smallest to largest Identify the biggest negative rate of change in percentage and the corresponding date. Include this sorted values in the Excel submission as supporting evidence [Mark deduction applies for lack of supporting evidence) In your Word answer file, clearly present in the space below the biggest megative percentage and the date. (1 mark) Excel is required for this question. Search online for The a2 Milk Company Limited (ATM.NZ) daily stock price from January 3, 2020 to July 22, 2021. a. Download the above stock's daily closing price for the specified period. Save the data in an Excel file to perform the following calculations. The data for the relevant period must be included in the Excel submission as supporting evidence [Mark deduction applies for lack of supporting evidence]. (1 mark) Present the website and link here: b. Using the above data, calculate the daily rates of change (i.e. daily rates of return or daily holding period returns) of the downloaded stock prices; express the calculated rates in two decimal places. Evidence of calculations must be included in the Excel submission as supporting evidence [Mark deduction applies for lack of supporting evidence]. In your Word answer file space below, present the formula for calculating the rate of change. (1 mark) Present the rate of change formula bere [Note: A 'daily' rate of change refers to the rate of change in closing prices from one trading day to another. For instance, the closing prices on July 12, 2021 and July 13, 2021 can be used to calculate one daily rate of change; that is, the prices from two trading days will give you one daily rate of change. If you have closing prices for n days, there will be (n-1) daily rates of change.] Suggested Excel table: To calculate the daily rate of change. set up your Excel table columns as specified below. Show respective closing prices and rates below each column. Calculated daily rate of change s Dute (Adjusted) Daily Clowing Price c. Next, sont the rate of change from smallest to largest onder. (Note in Excel, before performing the sert function, it is better to first highlight rate of change column, copy and paste next to this column using "paste special as "les". Now you are ready to use Excel's Duta Sort function to sert the dates and calculated daily rate of change (the pasted as "values" column) from "smallest to largest Identify the biggest negative rate of change in percentage and the corresponding date. Include this sorted values in the Excel submission as supporting evidence [Mark deduction applies for lack of supporting evidence) In your Word answer file, clearly present in the space below the biggest megative percentage and the date. (1 mark)
Expert Answer:
Answer rating: 100% (QA)
a httpsfinanceyahoocomquoteATMNZhistoryperiod11577836800period21626912000interval1d... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Company: The A2 Milk Company Limited (A2M) Research-Based Report Corporate Governance & Risk Management As a new accounting graduate, you have just joined the financial reporting unit of a...
-
Requirements Outside research is required for this paper Your sources must be cited wherever used Each assigned component below must be thoroughly addressed Your paper should be a minimum of seven...
-
This question refers to Problem 23. a. Use Minitab or Excel to compute the fourth differences of the income data in Table P-23. Fourth differences are computed by differencing observations four time...
-
Anon Amus Inc. operates a woodworking shop that makes tables and chairs. He has 25 employees working 40 hours per week and he has 750 hours per week available in machine time. Ralph knows that he...
-
What is virotherapy?
-
A camera is listed for $599 less 30%, 20%, and 5%. (a) What is the net price? (b) What is the total amount of discount allowed? (c) What is the exact single rate of discount that was allowed?
-
Consider the simple linear regression model fit to the oxygen purity data in Problem 2.7. Problem 2.7 The purity of oxygen produced by a fractional distillation process is thought to be related to...
-
Curtiss Construction Company, Inc., entered into a fixed-price contract with Axelrod Associates on July 1, 2011, to construct a four-story office building. At that time, Curtiss estimated that it...
-
Business tax senario: XYZ corporation made a profit of $ 5 0 0 , 0 0 0 . However, after business expenses and deductions, the taxable income is $ 3 0 0 , 0 0 0 . Calculate the corporation's tax...
-
What size loan must we take today with a 6% compound interest rate to have end-of-year payments of $1400, $1320, $1240, $1160, and $1080 for the next five years, respectively? In other words, if you...
-
A high alloy spring has a total of 16 coils and a modulus of elasticity in shear of 85 GPa. Compute for the deflection, in mm. Consider a load of 100 kg, spring outside diameter of 9.66 cm, and wire...
-
Water and oil will form two separate layers when placed in the same container. What is the microscopic explanation for this macroscopic behavior? The strength of the bonds between like molecules is...
-
Unit Conversion and Dimensional Analysis Given the following conversion factors: 454 g = 1 pound 1 meter = 39.37 in 1. How many meters are in 34.2 inches? Im 34.2 in 39.37in 2. How many inches are in...
-
Determine the percent yield. of AgCH302(aq) + Na3PO4(aq) Ag3PO4(s) + NaCH302(aq); 5.298 g of silver acetate produces 1.583 g of silver phosphate KCIO3(s) KCl(s) + O(g) 2.14g of KC1O3 produces 0.67g...
-
A substance which cannot be broken drown furt by chemical reaction by cooling heating or electrolysis is called : NaCl (3) Element CLC Tecno'24 Talent Exploring CLC National Olympiad 2024 (2) Mixture...
-
Mendeleev designed the first periodic table based upon the properties of elements with elements being arranged such that those with similar properties wer In fact, Mendeleev predicted the discovery...
-
eve a b ovo 0/0 d Figure 1 0/1 a/s 2/1 4./0 36 d 1/1 Figure 2 0/0 4,0 Present state b e d e Next state X=0 b b b . X=1 C d C d b original state table X=0 0 ... 1 Output O X=1 O O O O O NO 9/0 9/1 d...
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
True or false: A firm with market power can sell whatever quantity it wishes at whatever price it chooses.
-
The Fed wants to reduce the U.S. money supply using open-market operations. Describe what it would do, and explain how this action would accomplish the Fed's objective.
-
Discuss the following statement: "Because the environment is fragile and natural resources are finite, ultimately economic growth must come to an end."
-
Imagine that a company is converting from conventional mass technology to a highly flexible, computerized, integrated production system. List structural and behavioural problems that the company...
-
Discuss this statement: The effects of advanced information technology on job design and organizational structure are highly predictable.
-
Distinguish among pooled interdependence, sequential interdependence, and _ reciprocal interdependence in terms of the key problem each poses for organizational effectiveness.
Study smarter with the SolutionInn App