S&P 500 Model

	B	C	D	E	F	G	H	I	J
1	Hi all, this is a template model for projecting the S&P 500. This is created for the purpose of enabling anyone to reliably estimate
2	the direction of the market using indicators that you can get from free websites. I can't update this regularly but I will try to do so every 3 months
3
4	Date Updated	7 May 2024
5
6	1 Lag		2 Lag		3 Lag
7	Intercept	0.00	Intercept	0.00	Intercept	0.00
8	Mfg PMI	27.30	Mfg PMI	26.48	Mfg PMI	25.63
9	VIX	35.88	VIX	37.79	VIX	38.90
10	3-Month Tbill	398.43	3-Month Tbill	396.17	3-Month Tbill	397.35
11	P.Savings	44.27	P.Savings	48.75	P.Savings	55.06
12
13							Projected S&P 500
14	Real Date	Mfg PMI	VIX	3-Month Tbill	P.Savings	Real S&P 500	1 Lag	2 Lag	3 Lag
15	Jan-23	46.8	19.4	4.69	4.40	4,077
16	Feb-23	47.8	20.7	4.86	4.70	3,970	4,038
17	Mar-23	49.3	18.7	4.80	5.20	4,109	4,191	4,046
18	Apr-23	50.4	15.8	5.10	5.20	4,169	4,160	4,201	4,061
19	May-23	48.5	17.9	5.42	5.30	4,180	4,206	4,168	4,219
20	Jun-23	46.3	13.6	5.32	4.80	4,450	4,361	4,207	4,186
21	Jul-23	49.0	13.6	5.42	4.40	4,589	4,085	4,367	4,220
22	Aug-23	47.0	13.6	5.48	4.40	4,508	4,182	4,082	4,385
23	Sep-23	48.9	17.5	5.48	3.80	4,288	4,148	4,176	4,095
24	Oct-23	50.0	18.1	5.49	4.10	4,194	4,314	4,143	4,184
25	Nov-23	49.4	12.9	5.40	4.10	4,568	4,384	4,312	4,152
26	Dec-23	48.2	12.5	5.35	3.70	4,770	4,146	4,384	4,321
27	Jan-24	50.3	14.4	5.37	3.70	4,849	4,058	4,137	4,394
28	Feb-24	52.2	15.4	5.38	3.60	5,096	4,207	4,047	4,142
29	Mar-24	51.9	13.01	5.36	3.2	5,254	4,280	4,200	4,050
30	Apr-24	50	15.65	5.4	4.3	5,036	4,161	4,271	4,205
31	May-24					5,143	4,269	4,146	4,273
32	Jun-24					5,208		4,210	4,142
33	Jul-24					5,276			4,211
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100