Compute daily abnomal returns of MRK and RXDX on the announcement day. Since April 16, 2023 was Sunday (= no trading), use the following trading day, April 17, 2023, as the announcement day for this analysis. Use daily returns on SPY (S&P500 ETF) as benchmark retums during the same period and 0.018% as daily risk free rate. Show your work in Excel to receive any credit. 10 4/12/2023 113.75 11 4/13/2023 115.58 12 4/14/2023 115.31 -0.23% 13 4/17/2023 115.01 -0.26% 4 4/18/2023 114.83 1.12% 1.61% 4/12/2023 112.25 -1.51% 4/13/2023 112.86 0.54% 4/14/2023 114.01 1.02% 4/17/2023 193.51 69.73% 4/12/2023 408.05 -0.41% 4/13/2023 413.47 1.33% -0.16% 4/18/2023 193.5 -0.01% 4/14/2023 412.46 -0.24% 4/17/2023 4/18/2023 414.21 413.94 0.36% 0.07% MRX RXDX SPY

(Computing rates of return) From the following price data, compute the annual rates of return for Asman and Salinas. Time 1 2 3 12 4 14 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? Asman $9 11 Salinas $30 27 32 36 The rate of return you would have earned on Asman stock from time 1 to time 2 is %. (Round to two decimal places.)

(Computing rates of return) From the following price data, compute the annual rates of return for Asman and Salinas. Time Asman $9 11 Salinas $31 2 3 4 10 13 28 32 36 (Click on the icon in order to copy its contents into a spreadsheet.) How would you interpret the meaning of the annual rates of return? The rate of return you would have earned on Asman stock from time 1 to time 2 is The rate of return you would have earned on Asman stock from time 2 to time 3 is The rate of return you would have earned on Asman stock from time 3 to time 4 is The rate of return you would have earned on Salinas stock from time 1 to time 2 is The rate of return you would have earned on Salinas stock from time 2 to time 3 is The rate of return you would have earned on Salinas stock from time 3 to time 4 is %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.)…

3. Excel Question. Download the monthly NASDAQ prices (1985-2023) from Brightspace.What is the simple arithmetic average return over this period?What would have been your annualized HPR if you invested (reinvesting the proceeds)over this period?    Disregard the question above because I cant attach the entire excel file but i will attach a screenshot. Please just tell me and explain to me which column do i use to find the arithmetic average return for this period and also how to calculate the annualized HPR over this period. I am just confused which column and which numbers to use.