Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed.

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%
5% -496 39% 1596 109% -5% 10% S&P 500 Returns 2% y 0.5099x-0.0011 R2 0.06808 39% 5% -496 39% 1596 109% -5% 10% S&P 500 Returns 2% y 0.5099x-0.0011 R2 0.06808 39%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Economics Of Money Banking And Finance

Authors: Keith Bain, Peter Howells

1st Edition

0582278007, 9780582278004

More Books

Students also viewed these Finance questions

Question

Identify several ways to make better decisions about retirement.

Answered: 1 week ago