e) Use SP500 returns from 1/4/16 to 10/3/16 and your estimated results(the regression numbers)forecast monthly returns for JPM from 1/4/16 to 10/3/16. Finally, calculate MAPE of your forecast. Please show excel forumulas and upload excel work book if possible, using external link. If you don't know how to do this please don't say need more information this is all the information given and needed, it slows my answer down, if you can't do it just please pass it by.

Estimated Results from previous problem

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.666203967
R Square	0.443827726
Adjusted R Square	0.420653881
Standard Error	2.325525728
Observations	26
ANOVA
	df	SS	MS	F	Significance F
Regression	1	103.5758804	103.5759	19.1521	0.000203
Residual	24	129.7936779	5.40807
Total	25	233.3695583
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	0.275875942	0.463647873	0.595012	0.557405	-0.68105	1.232798	-0.68105	1.232798
X Variable 1	0.033045114	0.007550906	4.376311	0.000203	0.017461	0.048629	0.017461	0.048629

Returns

	JPM	SP500
1/4/2016	58.18	1940.24
2/1/2016	55.05	1932.23
3/1/2016	57.91	2059.74
4/1/2016	62.26	2065.30
5/2/2016	64.30	2096.95
6/1/2016	61.22	2098.86
7/1/2016	63.51	2173.60
8/1/2016	67.01	2170.95
9/1/2016	66.11	2168.27
10/3/2016	68.13	2139.18