Performing an event study: An exercise for finance students

This exercise helps instructors teach students how to perform a simple event study. The study tests to see if stocks earn abnormal returns when added to the S&P 500. Students select a random sample of stocks that were added to the index between January 2000 and July 2015. The accompanying spreadsheet calculates cumulative abnormal returns and cumulative abnormal trading volume and plots them in separate graphs. Students are asked to analyze the data and draw conclusions. Through this exercise, students learn how to conduct an event study and determine if a statistically significant event has occurred.