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%

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%