MSFT_first_half_returns_2000_2026.xlsx

	A	B	C	D	E	F	G	H
1	Year	Jan Close (first trading day)	Jan Date	July Close (as-of Jul 6)	July Date	First-Half Return %	Price Basis	Flag
2	2000	35.86	2000-01-03	24.9	2000-07-06	-30.56	split&div-adj
3	2001	13.35	2001-01-02	20.33	2001-07-06	52.3	split&div-adj
4	2002	20.63	2002-01-02	16.88	2002-07-05	-18.18	split&div-adj
5	2003	16.53	2003-01-02	16.36	2003-07-03	-1.02	split&div-adj
6	2004	17.04	2004-01-02	17.39	2004-07-06	2.08	split&div-adj
7	2005	18.56	2005-01-03	17.25	2005-07-06	-7.05	split&div-adj
8	2006	18.85	2006-01-03	16.61	2006-07-06	-11.88	split&div-adj
9	2007	21.28	2007-01-03	21.5	2007-07-06	1.04	split&div-adj
10	2008	25.44	2008-01-02	18.91	2008-07-03	-25.68	split&div-adj
11	2009	14.95	2009-01-02	17.29	2009-07-06	15.63	split&div-adj
12	2010	23.3	2010-01-04	18.1	2010-07-06	-22.33	split&div-adj
13	2011	21.5	2011-01-03	20.49	2011-07-06	-4.72	split&div-adj
14	2012	21.12	2012-01-03	24.13	2012-07-06	14.26	split&div-adj
15	2013	22.41	2013-01-02	28.18	2013-07-05	25.76	split&div-adj
16	2014	31.06	2014-01-02	35.45	2014-07-03	14.13	split&div-adj
17	2015	40.15	2015-01-02	38.64	2015-07-06	-3.77	split&div-adj
18	2016	48.34	2016-01-04	45.97	2016-07-06	-4.91	split&div-adj
19	2017	56.71	2017-01-03	62.88	2017-07-06	10.87	split&div-adj
20	2018	79.63	2018-01-02	94.57	2018-07-06	18.76	split&div-adj
21	2019	95.31	2019-01-02	130.22	2019-07-05	36.62	split&div-adj
22	2020	153.63	2020-01-02	202.64	2020-07-06	31.9	split&div-adj
23	2021	210.42	2021-01-04	269.63	2021-07-06	28.14	split&div-adj
24	2022	326.29	2022-01-03	260.62	2022-07-06	-20.12	split&div-adj
25	2023	235.71	2023-01-03	337.34	2023-07-06	43.11	split&div-adj
26	2024	368.12	2024-01-02	465.79	2024-07-05	26.53	split&div-adj
27	2025	418.6	2025-01-02	497.5	2025-07-03	18.85	actual (approx)	approx
28	2026	472.93	2026-01-02	386.61	2026-07-06	-18.25	actual
29
30
31
32
33
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