BUSA326 homework 5 problem

On November 14, Thorogood Enterprises announced that the public and acrimonious battle with its current CEO had been resolved. Under the terms of the deal, the CEO would step down from his position immediately. In exchange, he was given a generous severance package. Given the information below, calculate the cumulative abnormal return (CAR) around this announcement. Assume the company has an expected return equal to the market return. (Negative values should be indicated by a minus sign. Leave no cells blank – be certain to enter “0” wherever required. Do not round intermediate calculations. Round your answers to 1 decimal place. )DateMarket Return (%)Company Return (%)11/71. 8 1. 4 11/81. 6 1. 4 11/9−1. 5 −. 5 11/10−. 6 −. 7 11/112. 6 1. 0 11/14−1. 4 3. 1 11/15. 1 . 1 11/16. 9 2. 0 11/171. 5 . 9 11/18−1. 5 . 0 11/191. 6 . 2 DailyCumulativeDays fromAbnormalAbnormalAnnouncementReturnReturn−5 −4 −3 −2 −1 0 1 2 3 4 5 Ross Co. , Westerfield, Inc. , and Jordan Company announced a new agreement to market their respective products in China on July 18 (7/18), February 12 (2/12), and October 7 (10/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. (Negative values should be indicated by a minus sign. Leave no cells blank – be certain to enter “0” wherever required. Do not round intermediate calculations. Round your answers to 1 decimal place. )Ross Co. Westerfield, Inc. Jordan CompanyDateMarketReturnCompanyReturnDateMarketReturnCompanyReturnDateMarketReturnCompanyReturn7/12-0. 1 -0. 7 2/8-0. 1 -0. 7 10/11. 9 0. 7 7/131. 7 0. 3 2/9-0. 2 -0. 7 10/21. 8 0. 7 7/16-0. 1 0. 4 2/100. 4 0. 6 10/30. 7 1. 3 7/17-0. 6 -0. 2 2/110. 6 2. 6 10/6-0. 1 -0. 2 7/18-0. 3 1. 3 2/12-0. 1 0. 1 10/7-1. 7 -0. 2 7/19-2. 4 -0. 2 2/151. 4 1. 8 10/81. 4 0. 3 7/20-0. 9 -0. 8 2/160. 7 0 10/9-0. 5 -1. 1 7/230. 6 0. 4 2/17-0. 1 0 10/100. 1 -0. 1 7/241. 7 0 2/182. 1 0. 4 10/13-0. 1 -0. 6 Abnormal returns (Ri – R­M)Days from announcementRossW’fieldJordanSumAverage abnormal returnCumulative average residual-4 -3 -2 -1 0 1 2 3 4 Worksheet