(Please Use Excel and show all the work and formulas)

Q12 As the junior analyst of an upstart investment firm, you have been assigned to analyze the following three companies for a client: Amazon (AMZN), Disney (DIS), and Costco (COST). Specifically, the client would like to look at the performances of these three companies during the period from February 15, 2002 to February 15, 2022.

a. Using the series of adjusted closing prices, calculate the monthly returns for the three companies.

b. Calculate the arithmetic average monthly returns for the three companies.

c. Calculate the standard deviation of the monthly returns for the three companies.

d. Determine the coefficient of variation for the three companies using (b) and (c). Discuss your findings.