Question

Question Four: Mini Research on Stock and Return

Search online for Auckland International Airport's (AIA.NZ) daily stock price for the most recent twelve months (for example from April 28, 2019 to April 28, 2020).

a) Download Auckland International Airport's (AIA.NZ) daily closing price (you could use the "adjusted closing price") for the most recent twelve months. Save the data in an Excel file to perform the following calculations.

b) Clearly state the data source and weblink.

State the source link here:

c) Calculate the daily return (rate of change) of the above downloaded stock prices.

Present the formula here (save Excel sheet for the task in Part (d) and then insert it in Part (d)):

d) Based on calculated daily rate of return from Part (c), identify the largest rate of negative change (in percentage; that is, of highest volatility). In your Excel spreadsheet, highlight this row/cell with a yellow shade.

Insert the Excel sheet here (this should include your calculation from Part (c)):

Clearly state here the date, beginning price and ending price, and the percentage of change:

Date: __________

Beginning price: __________

Ending price: __________

Change in percentage: __________

e) identify and discuss the possible major cause(s) of this negative return.

Present answer and discussion here: