385 Event Studies
14.4.3 An Event Study: The Grocery Industry
We extend our Safeway study by considering 16 quarterly earnings
announcements by four grocery companies for fi scal year 2006.
9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
ABCDEFGHIJKL M N OP Q
Calendar Date Ticker Consensus Actual
Surprise:
=D3-C3
Starting
Point
Intercept Slope STEXY
Actual
Return
S&P 500
Return
Expected
Return:
=H3+I3*M3
Abnormal
Return:
=L3-N3
T-stat
7-Mar-06 KR 0.36 0.39 0.03 44 0.0003 0.6662 0.0123 1.36% -0.19% -0.09% 1.46% 1.1808 <
--
=O3/J3
20-Jun-06 KR 0.42 0.42 0.00 117 0.0004 0.6063 0.0113 5.05% 0.00% 0.04% 5.01% 4.4355 <
--
=O4/J4
12-Sep-06 KR 0.29 0.29 0.00 175 0.0006 0.5628 0.0108 -5.67% 1.03% 0.64% -6.31% -5.8201 <
--
=O5/J5
5-Dec-06 KR 0.28 0.30 0.02 234 0.0003 0.4483 0.0118 5.08% 0.40% 0.21% 4.87% 4.1297
18-Apr-06 SVU 0.56 0.55 -0.01 73 -0.0008 0.7049 0.0123 -0.28% 1.69% 1.11% -1.39% -1.1313
26-Jul-06 SVU 0.57 0.53 -0.04 142 -0.0003 0.5416 0.0122 -7.09% -0.04% -0.05% -7.03% -5.7632
10-Oct-06 SVU 0.53 0.61 0.08 195 -0.0002 0.6014 0.0128 4.36% 0.20% 0.10% 4.26%
3.3170
9-Jan-07 SVU 0.56 0.54 -0.02 256 0.0003 0.5238 0.0130 -1.70% -0.05% 0.00% -1.70% -1.3061
27-Apr-06 SWY 0.30 0.32 0.02 80 0.0001 1.0139 0.0130 2.88% 0.33% 0.34% 2.54% 1.9473
20-Jul-06 SW Y 0.36 0.42 0.06 138 0.0001 0.9289 0.0118 8.39% -0.85% -0.78% 9.17% 7.7519
12-Oct-06 SWY 0.39 0.39 0.00 197 0.0003 0.7533 0.0134 -1.43% 0.95% 0.75% -2.18% -1.6265
27-Feb-07 SWY 0.60 0.61 0.01 289 0.0012 0.7505 0.0131 -3.95% -3.53% -2.54% -1.41% -1.0814
4-May-06 WFMI 0.35 0.36 0.01 85 0.0006 0.8345 0.0175 12.50% 0.32% 0.33% 12.17% 6.9434
1-Aug-06 WFMI 0.34 0.35 0.01 146 -0.0007 1.2329 0.0164 -12.51% -0.45% -0.63% -11.88% -7.2345
3-Nov-06 WFMI 0.29 0.29 0.00 213 -0.0014 1.3199 0.0195 -26.21% -0.22% -0.43% -25.78%
-13.2186
22-Feb-07 WFMI 0.40 0.38 -0.02 286 -0.0020 1.5321 0.0243 13.13% -0.09% -0.33% 13.46% 5.5465
Positive
surprise
2.65%
None-positive
surprise
-3.24%
EARNINGS ANNOUNCEMENT IN 2006-07 FOR KROGER (KR), SUPERVALU (SVU),
SAFEWAY (SWY), AND WHOLE FOODS (WFMI)
Cell G18 contains formula:
=COUNTIF('Stock Prices'!$A$3:$A$551,"<="&TEXT(A18,"0"))-252
Cell H18 contains formula:
=INTERCEPT(OFFSET('Stock Prices'!$A$2,$G18,10,252,1),OFFSET('Stock
Prices'!$A$2,$G18,2,252,1))
Cell J18 contains formula:
=STEYX(OFFSET('Stock Prices'!$A$2,$G18,10,252,1),OFFSET('Stock
Prices'!$A$2,$G18,2,252,1))
Cell I18 contains formula:
=SLOPE(OFFSET('Stock Prices'!$A$2,$G18,10,252,1),OFFSET('Stock
Prices'!$A$2,$G18,2,252,1))
<
--
=SUMIF($E$3:$E$18,">0",$O$3:$O$
18)/COUNTIF(E3:E18,">0")
<
--
=SUMIF($E$3:$E$18,"<=0",$O$3:$O
$18
/COUNTIF
E3:E18,"<=0"
For each announcement we have determined the intercept and slope
of the market-response regression for the 252 days preceding the
announcement.
10
Following is a specifi c example from the spreadsheet.
9. We only included Kroger, Supervalu, Safeway, and Whole Foods in the sample. This
is obviously an incomplete sample, both in terms of the fi rms covered and the number
of announcements. However, this extended example is meant to impart the fl avor of
a full-bodied event study.
10. The event window is defi ned in column G by the “Starting Point,” which uses Countif
to locate a date 252 business days before the event date in the database of stock
returns. Notice that the “Starting Point” is used in the Intercept, Slope, Rsq formulas
in columns H, I, and J.