Answer Happy

Using EXCEL attempt the following questions: Question 1: (10 marks) Ross Co., Westerfield, Inc., and Jordan Company announced a new agreement to market their respective products in China on July 18, February 12, and October 7, respectively. Given the information below, calculate the cumulative abnormal return (CAR) for these stocks as a group. Assume all companies have an expected return equal to the market return. Graph and interpret your results. Do your results support market efficiency?
Ross Co. Date Market Return Company Return -4 Westerfield, Inc. Jordan Company Date Market Return Company Return Date Market Return Company Return Feb 5 July 12 Oct 1 July 13 .1 3 Feb 9 Oct 2 8 July 16 8 Feb 10 .6 .4 Oct 3 9 1.3 July 17 - 2 Feb 11 . 10 Oct -1 -5 July 18 1.9 1.3 Feb 12 -1 1 Oct 7 -5 July 19 -X -6 Feb 15 1.3 1.4 Oct 8 .3 3 July 20 -1.0 Feb 16 7 Oct 9 --5 July 23 .6 .4 Feb 17 .0 Oct 10 . July 24 . . Feb 18 .5 .4 Oct 13 -6 Question 2: (10 marks) You have to choose one topic from the given list below and write a short essay about it (No more than 15 sentences). In order to score good marks, illustrate your essay with proper graph and explain it. 1- The Crash of 1929 2- The Crash of October 1987 3- The Asian Crash 4- The "Dot-Com" Bubble and Crash 5- The Crash of October 2008 Good Luck