Excel is required for this question. The data for the relevant period and relevant calculations must be included in an Excel file as supporting evidence. [Note: While the Excel file will not be marked, penalty applies for lack of supporting evidence.] You are interested to learn more about The a2 Milk Company Limited (ATM.NZ) share prices and returns. a. Conduct a search online for this company's daily stock price (use 'adjusted' stock price if available) from March 12th,2018 to March 12th,2023. Download the above stock's daily closing price for the specified period. Save the data in an Excel file to perform the following calculations. ( 0.5 mark) Click here to enter text b. Using the above data, calculate the daily rates of return (daily holding period rates of return) of the downloaded stock prices; express the calculated rates as percentages, in two decimal places. Evidence of calculations must be included in the Excel submission as supporting evidence [Mark deduction applies far lack of supporting evidence]. In your Word answer file space below, present the formula for calculating the rate of return. (0.5 mark) Click here to enict text. [Note: A 'daily' rate of return (rate of change) refers to the rate of change in closing prices from one trading day to another. For instance, the closing prices on Jantary 13ti and January 14ti 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 ( (a1) daily rates of change.] Suggested Excel table: To calculate the daily rate of return, set up your Excel table column? as specified below. Show respective closing prices and rates below each column. c. Next, sort the rate of change from smallest to largest order. [Note: in Excel, before performing the sort function, it is better to first highlight rate of return column, copy and paste this column into a new column tsing "paste special" as "values". This way you will only have the rate of return values (and not formulas).] Now you are ready to use Excel's Data/Sort function to sort the dates and the calculated daily rate of retum (the pasted as 'values' column) from "smallest to largest". Identify the biggest negative rate of change (in percentage) and the corresponding date. Include these sorted values in the Excel submission as supporting ovidence [Mark dediction applies for lack of supporting evidence]. In this Word answer file, clearly present the biggest negative percentage and the date in the space below. ( 1 mark) Cliek here to enter text. d. Based on your search results in the previous part, conduct an online search for documented news or announcements that are most likely to have influenced the relevant stock price change. In your own words, describe the major cause(s) of this negative rate of return. State the source(s) and website(s). [Mark deduction applies if reference and source are not provided. The discussion must be in your own words. Quoted text from another source is not acceptable. Word limit: 50 words; answers beyond the word limit will not be marked]. (1 mark) Present your answer here [The discussion must be in your own words.]: Click here to enter text. e. If you bought the stock on January 5,2022 for $5.90 and sold it one year tater on January 5hh,2023 for $7.61, what was your holding period rate of return? Clearly show your work, including the formula used and the final answer in percentage. Did the stock pay any dividend during this period? Would you consider this particular trade a good investment? Why or why not? [Word limit: 50 words; answers beyond the word limit will not be marked.] (I mark) Click here to enter text. Excel is required for this question. The data for the relevant period and relevant calculations must be included in an Excel file as supporting evidence. [Note: While the Excel file will not be marked, penalty applies for lack of supporting evidence.] You are interested to learn more about The a2 Milk Company Limited (ATM.NZ) share prices and returns. a. Conduct a search online for this company's daily stock price (use 'adjusted' stock price if available) from March 12th,2018 to March 12th,2023. Download the above stock's daily closing price for the specified period. Save the data in an Excel file to perform the following calculations. ( 0.5 mark) Click here to enter text b. Using the above data, calculate the daily rates of return (daily holding period rates of return) of the downloaded stock prices; express the calculated rates as percentages, in two decimal places. Evidence of calculations must be included in the Excel submission as supporting evidence [Mark deduction applies far lack of supporting evidence]. In your Word answer file space below, present the formula for calculating the rate of return. (0.5 mark) Click here to enict text. [Note: A 'daily' rate of return (rate of change) refers to the rate of change in closing prices from one trading day to another. For instance, the closing prices on Jantary 13ti and January 14ti 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 ( (a1) daily rates of change.] Suggested Excel table: To calculate the daily rate of return, set up your Excel table column? as specified below. Show respective closing prices and rates below each column. c. Next, sort the rate of change from smallest to largest order. [Note: in Excel, before performing the sort function, it is better to first highlight rate of return column, copy and paste this column into a new column tsing "paste special" as "values". This way you will only have the rate of return values (and not formulas).] Now you are ready to use Excel's Data/Sort function to sort the dates and the calculated daily rate of retum (the pasted as 'values' column) from "smallest to largest". Identify the biggest negative rate of change (in percentage) and the corresponding date. Include these sorted values in the Excel submission as supporting ovidence [Mark dediction applies for lack of supporting evidence]. In this Word answer file, clearly present the biggest negative percentage and the date in the space below. ( 1 mark) Cliek here to enter text. d. Based on your search results in the previous part, conduct an online search for documented news or announcements that are most likely to have influenced the relevant stock price change. In your own words, describe the major cause(s) of this negative rate of return. State the source(s) and website(s). [Mark deduction applies if reference and source are not provided. The discussion must be in your own words. Quoted text from another source is not acceptable. Word limit: 50 words; answers beyond the word limit will not be marked]. (1 mark) Present your answer here [The discussion must be in your own words.]: Click here to enter text. e. If you bought the stock on January 5,2022 for $5.90 and sold it one year tater on January 5hh,2023 for $7.61, what was your holding period rate of return? Clearly show your work, including the formula used and the final answer in percentage. Did the stock pay any dividend during this period? Would you consider this particular trade a good investment? Why or why not? [Word limit: 50 words; answers beyond the word limit will not be marked.] (I mark) Click here to enter text