Old MathJax webview

Old MathJax webview

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? PLEASE SOLVE IT IN EXCEL WITH FORMULA

solve it in excel with formula and read question carefully

with graph

Ross Co. Westerfield, Inc. Jordan Company Date Market Return Company Return Date Market Return Company Return Date Market Return Company Return July 12 Feb 8 Oct 1 July 13 Feb 9 Oct 2 July 16 .6 Feb 10 Oct 3 1.3 July 17 Feb 11 10 Oct 6 July 18 19 1.3 Feb 12 . Oct 7 -24 July 19 - 6 Feb 15 1.3 1.4 Oct 8 3 July 20 -LO Feb 16 .7 .7 Oct 9 July 23 .6 .4 Feb 17 Oct 10 .. July 24 Feb 18 Oct 13 0 Ross Co. Westerfield, Inc. Jordan Company Date Market Return Company Return Date Market Return Company Return Date Market Return Company Return July 12 Feb 8 Oct 1 July 13 Feb 9 Oct 2 July 16 .6 Feb 10 Oct 3 1.3 July 17 Feb 11 10 Oct 6 July 18 19 1.3 Feb 12 . Oct 7 -24 July 19 - 6 Feb 15 1.3 1.4 Oct 8 3 July 20 -LO Feb 16 .7 .7 Oct 9 July 23 .6 .4 Feb 17 Oct 10 .. July 24 Feb 18 Oct 13 0