Question
Chipotle Mexican Grill (NYSE ticker symbol, CMG) has been disgraced in recent years by the lack of food safety in some of their restaurants. To
Chipotle Mexican Grill (NYSE ticker symbol, CMG) has been disgraced in recent years by the lack of food safety in some of their restaurants. To help bring customers back, senior management had proposed giving away 9 million burritos. Please read the attached article from Reuters for more details. However, at an average price of approximately $7 per burrito, the giveaway amounts to $63 million in lost top-line revenue. Hence, given CMG is a publicly-traded firm, it is of interest to determine how the stock market reacted to this proposed marketing campaign.
I have provided daily returns data for both CMG and the S&P 500 index for the year leading up to the 7 PM press release on 3/16/16 detailing the marketing campaign. The daily returns of CMG, denoted R_CMG in the Excel workbook, represent the dependent variable in the regression model. Daily returns of the S&P 500 index, denoted R_SP500, represent the independent variable in the regression. Use Excel's regression functionality to estimate your causal model. This model actually has a special name in finance as it is a famous paradigm. It is called the Capital Asset Pricing Model or CAPM. Thoroughly interpret your regression results.
Next, create a scatter plot of this data in Excel and try to exactly match my formats in the picture below.
.
Note that I have provided you some check figures for your regression analysis as I inserted the regression line, regression equation, and fit metric into the scatter plot (and you should too).
Finally, using your causal model, forecast the daily return of Chipotle on 3/17/16 given the daily return of the S&P 500 index of 0.66%. Hint: use 0.0066 as the value, not 0.66, to obtain the correct forecast. Note that this is the next trading day immediately following the press release. Since the press release was provided at 7 PM on 3/16/16, the equity market had no opportunity to respond until 3/17/16. Since the actual daily return of Chipotle on 3/17/16 was -5.92%, comment about the error of your forecast. Hint: "actual" minus "forecast" equals "error" or what we call an "abnormal return" in this type of analysis using the CAPM paradigm.
DATA
DATE | R_CMG | R_SP500 |
3/18/2015 | 0.19% | 1.21% |
3/19/2015 | 1.09% | -0.49% |
3/20/2015 | 0.87% | 0.90% |
3/23/2015 | 0.10% | -0.17% |
3/24/2015 | -0.95% | -0.62% |
3/25/2015 | -2.20% | -1.47% |
3/26/2015 | -1.08% | -0.24% |
3/27/2015 | 0.59% | 0.24% |
3/30/2015 | -1.12% | 1.22% |
3/31/2015 | -0.74% | -0.88% |
4/1/2015 | 0.31% | -0.40% |
4/2/2015 | -0.02% | 0.35% |
4/6/2015 | 1.16% | 0.66% |
4/7/2015 | -0.24% | -0.21% |
4/8/2015 | -0.60% | 0.27% |
4/9/2015 | -0.43% | 0.44% |
4/10/2015 | 4.69% | 0.52% |
4/13/2015 | 0.10% | -0.46% |
4/14/2015 | -0.86% | 0.16% |
4/15/2015 | -0.04% | 0.51% |
4/16/2015 | 0.58% | -0.08% |
4/17/2015 | 0.35% | -1.14% |
4/20/2015 | 0.43% | 0.92% |
4/21/2015 | 0.81% | -0.15% |
4/22/2015 | -7.69% | 0.51% |
4/23/2015 | -0.88% | 0.24% |
4/24/2015 | 0.30% | 0.23% |
4/27/2015 | 0.98% | -0.41% |
4/28/2015 | -0.65% | 0.28% |
4/29/2015 | -1.50% | -0.37% |
4/30/2015 | -1.40% | -1.02% |
5/1/2015 | 2.02% | 1.09% |
5/4/2015 | -0.07% | 0.29% |
5/5/2015 | -1.25% | -1.19% |
5/6/2015 | 0.25% | -0.45% |
5/7/2015 | 0.25% | 0.38% |
5/8/2015 | 0.79% | 1.34% |
5/11/2015 | 0.29% | -0.51% |
5/12/2015 | -0.02% | -0.30% |
5/13/2015 | -0.04% | -0.03% |
5/14/2015 | -0.12% | 1.07% |
5/15/2015 | -0.34% | 0.08% |
5/18/2015 | 0.59% | 0.30% |
5/19/2015 | 0.10% | -0.06% |
5/20/2015 | -1.35% | -0.09% |
5/21/2015 | 0.81% | 0.23% |
5/22/2015 | -1.10% | -0.22% |
5/26/2015 | -0.69% | -1.03% |
5/27/2015 | -1.56% | 0.91% |
5/28/2015 | 2.72% | -0.13% |
5/29/2015 | -2.23% | -0.63% |
6/1/2015 | -0.10% | 0.21% |
6/2/2015 | -0.71% | -0.10% |
6/3/2015 | 0.05% | 0.21% |
6/4/2015 | 0.11% | -0.87% |
6/5/2015 | 0.36% | -0.14% |
6/8/2015 | -0.93% | -0.65% |
6/9/2015 | -0.38% | 0.04% |
6/10/2015 | 0.47% | 1.20% |
6/11/2015 | -0.46% | 0.17% |
6/12/2015 | 0.64% | -0.70% |
6/15/2015 | -0.92% | -0.46% |
6/16/2015 | -0.59% | 0.57% |
6/17/2015 | 1.03% | 0.20% |
6/18/2015 | -0.11% | 0.99% |
6/19/2015 | 1.49% | -0.53% |
6/22/2015 | 0.64% | 0.61% |
6/23/2015 | -0.62% | 0.06% |
6/24/2015 | -0.79% | -0.74% |
6/25/2015 | -0.52% | -0.30% |
6/26/2015 | 0.34% | -0.04% |
6/29/2015 | -1.56% | -2.11% |
6/30/2015 | 0.82% | 0.27% |
7/1/2015 | 0.26% | 0.69% |
7/2/2015 | 0.49% | -0.03% |
7/6/2015 | -0.39% | -0.39% |
7/7/2015 | 2.18% | 0.61% |
7/8/2015 | -1.25% | -1.68% |
7/9/2015 | 2.31% | 0.23% |
7/10/2015 | 1.94% | 1.23% |
7/13/2015 | 2.86% | 1.10% |
7/14/2015 | -0.39% | 0.44% |
7/15/2015 | 0.87% | -0.07% |
7/16/2015 | -0.41% | 0.80% |
7/17/2015 | 0.53% | 0.11% |
7/20/2015 | 2.40% | 0.08% |
7/21/2015 | -0.73% | -0.43% |
7/22/2015 | 7.55% | -0.24% |
7/23/2015 | 0.02% | -0.57% |
7/24/2015 | 0.39% | -1.08% |
7/27/2015 | 0.36% | -0.58% |
7/28/2015 | -0.09% | 1.23% |
7/29/2015 | 1.04% | 0.73% |
7/30/2015 | 0.77% | 0.00% |
7/31/2015 | -0.26% | -0.23% |
8/3/2015 | 0.11% | -0.28% |
8/4/2015 | 0.68% | -0.23% |
8/5/2015 | 1.29% | 0.31% |
8/6/2015 | -1.08% | -0.78% |
8/7/2015 | -0.06% | -0.29% |
8/10/2015 | -0.65% | 1.27% |
8/11/2015 | 0.19% | -0.96% |
8/12/2015 | 0.04% | 0.09% |
8/13/2015 | -0.32% | -0.13% |
8/14/2015 | 0.64% | 0.39% |
8/17/2015 | 0.76% | 0.52% |
8/18/2015 | -1.08% | -0.26% |
8/19/2015 | -0.09% | -0.83% |
8/20/2015 | -1.37% | -2.13% |
8/21/2015 | -2.08% | -3.24% |
8/24/2015 | -2.21% | -4.02% |
8/25/2015 | -1.27% | -1.36% |
8/26/2015 | 1.75% | 3.83% |
8/27/2015 | 2.72% | 2.40% |
8/28/2015 | -0.82% | 0.06% |
8/31/2015 | -1.56% | -0.84% |
9/1/2015 | -0.47% | -3.00% |
9/2/2015 | 2.40% | 1.81% |
9/3/2015 | 0.15% | 0.12% |
9/4/2015 | -0.80% | -1.54% |
9/8/2015 | 1.78% | 2.48% |
9/9/2015 | -1.83% | -1.40% |
9/10/2015 | 0.60% | 0.53% |
9/11/2015 | 0.81% | 0.45% |
9/14/2015 | -0.31% | -0.41% |
9/15/2015 | 0.72% | 1.27% |
9/16/2015 | -0.28% | 0.87% |
9/17/2015 | 0.03% | -0.26% |
9/18/2015 | -0.10% | -1.63% |
9/21/2015 | 0.23% | 0.46% |
9/22/2015 | -0.58% | -1.24% |
9/23/2015 | 0.63% | -0.21% |
9/24/2015 | -0.05% | -0.34% |
9/25/2015 | -0.12% | -0.05% |
9/28/2015 | -3.09% | -2.60% |
9/29/2015 | 0.07% | 0.12% |
9/30/2015 | 1.64% | 1.89% |
10/1/2015 | 0.58% | 0.20% |
10/2/2015 | 0.00% | 1.42% |
10/5/2015 | 0.50% | 1.81% |
10/6/2015 | -2.06% | -0.36% |
10/7/2015 | 0.96% | 0.80% |
10/8/2015 | 2.01% | 0.88% |
10/9/2015 | -0.25% | 0.07% |
10/12/2015 | 2.01% | 0.13% |
10/13/2015 | 0.35% | -0.68% |
10/14/2015 | -4.34% | -0.47% |
10/15/2015 | 0.73% | 1.47% |
10/16/2015 | -0.15% | 0.46% |
10/19/2015 | -0.56% | 0.03% |
10/20/2015 | -1.83% | -0.14% |
10/21/2015 | -5.83% | -0.58% |
10/22/2015 | -2.29% | 1.65% |
10/23/2015 | -0.14% | 1.10% |
10/26/2015 | 1.52% | -0.19% |
10/27/2015 | -0.48% | -0.26% |
10/28/2015 | -0.25% | 1.18% |
10/29/2015 | -1.03% | -0.04% |
10/30/2015 | -1.24% | -0.48% |
11/2/2015 | -2.57% | 1.18% |
11/3/2015 | -0.13% | 0.27% |
11/4/2015 | -1.32% | -0.36% |
11/5/2015 | 0.37% | -0.11% |
11/6/2015 | -0.79% | -0.03% |
11/9/2015 | -0.51% | -0.99% |
11/10/2015 | 3.16% | 0.15% |
11/11/2015 | -1.13% | -0.32% |
11/12/2015 | -1.16% | -1.41% |
11/13/2015 | -3.61% | -1.13% |
11/16/2015 | -0.70% | 1.48% |
11/17/2015 | -0.88% | -0.13% |
11/18/2015 | 1.77% | 1.60% |
11/19/2015 | 2.91% | -0.11% |
11/20/2015 | -13.14% | 0.38% |
11/23/2015 | 4.22% | -0.12% |
11/24/2015 | 3.25% | 0.12% |
11/25/2015 | 0.52% | -0.01% |
11/27/2015 | -0.73% | 0.06% |
11/30/2015 | 0.51% | -0.47% |
12/1/2015 | 0.21% | 1.06% |
12/2/2015 | -1.05% | -1.11% |
12/3/2015 | -1.64% | -1.45% |
12/4/2015 | -0.73% | 2.03% |
12/7/2015 | -1.70% | -0.70% |
12/8/2015 | -1.74% | -0.65% |
12/9/2015 | 1.06% | -0.78% |
12/10/2015 | 4.88% | 0.22% |
12/11/2015 | -1.83% | -1.96% |
12/14/2015 | -1.22% | 0.47% |
12/15/2015 | -0.59% | 1.06% |
12/16/2015 | 2.31% | 1.44% |
12/17/2015 | -2.31% | -1.52% |
12/18/2015 | -2.52% | -1.80% |
12/21/2015 | -3.59% | 0.77% |
12/22/2015 | -5.39% | 0.88% |
12/23/2015 | 0.58% | 1.23% |
12/24/2015 | -0.48% | -0.16% |
12/28/2015 | -0.32% | -0.22% |
12/29/2015 | -0.73% | 1.06% |
12/30/2015 | -0.85% | -0.72% |
12/31/2015 | -1.23% | -0.95% |
1/4/2016 | -6.69% | -1.54% |
1/5/2016 | 0.05% | 0.20% |
1/6/2016 | -5.11% | -1.32% |
1/7/2016 | -2.53% | -2.40% |
1/8/2016 | -0.65% | -1.09% |
1/11/2016 | -0.53% | 0.09% |
1/12/2016 | -1.68% | 0.78% |
1/13/2016 | 5.77% | -2.53% |
1/14/2016 | 5.90% | 1.66% |
1/15/2016 | 4.65% | -2.18% |
1/19/2016 | -1.37% | 0.05% |
1/20/2016 | -0.85% | -1.18% |
1/21/2016 | -0.93% | 0.52% |
1/22/2016 | -2.29% | 2.01% |
1/25/2016 | -1.92% | -1.58% |
1/26/2016 | 1.34% | 1.40% |
1/27/2016 | -1.24% | -1.09% |
1/28/2016 | 2.33% | 0.55% |
1/29/2016 | -0.02% | 2.45% |
2/1/2016 | 4.25% | -0.04% |
2/2/2016 | 0.64% | -1.89% |
2/3/2016 | -2.97% | 0.50% |
2/4/2016 | 1.96% | 0.15% |
2/5/2016 | -2.31% | -1.87% |
2/8/2016 | -3.35% | -1.43% |
2/9/2016 | -0.92% | -0.07% |
2/10/2016 | 1.77% | -0.02% |
2/11/2016 | 2.76% | -1.24% |
2/12/2016 | 4.07% | 1.93% |
2/16/2016 | 2.54% | 1.64% |
2/17/2016 | 4.19% | 1.63% |
2/18/2016 | 0.37% | -0.47% |
2/19/2016 | -0.85% | 0.00% |
2/22/2016 | 2.76% | 1.44% |
2/23/2016 | -0.16% | -1.25% |
2/24/2016 | -1.96% | 0.44% |
2/25/2016 | -1.87% | 1.13% |
2/26/2016 | 0.13% | -0.19% |
2/29/2016 | 0.62% | -0.82% |
3/1/2016 | 0.16% | 2.36% |
3/2/2016 | 3.04% | 0.41% |
3/3/2016 | -0.27% | 0.35% |
3/4/2016 | 0.89% | 0.33% |
3/7/2016 | 0.88% | 0.09% |
3/8/2016 | -1.70% | -1.13% |
3/9/2016 | -3.50% | 0.50% |
3/10/2016 | -0.58% | 0.02% |
3/11/2016 | 0.82% | 1.63% |
3/14/2016 | 1.54% | -0.13% |
3/15/2016 | -2.50% | -0.18% |
3/16/2016 | -0.53% | 0.56% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started