I BOND CALCULATIONS.xlsx

	A	B	C	D	E	F	G	H	I
1	CPI-U Readings that will feed into next I Bond rate
2		Sep 21	Oct 21	Nov 21	Dec 21	Jan 22	Feb 22	Mar 22	Sep-March %

3	inflation index	274.310	276.589	277.948	278.802	281.148	283.716	287.504
4	mom% change	0.300	0.800	0.500	0.300	0.800	0.900	1.3	4.810%
5	12-mo% change	5.4	6.2	6.8	7.0	7.5	7.9	8.5
6
7						2.49	3.315%	4.810%	4.178%
8							Lowest estimate	Average estimate	High estimate
9
10
11							283.716	285.418	286.269
12
13							0.00%	0.60%	0.90%
14
15
16					Fixed Rate	If average estimate	If lowest estimate	If high estimate
17					0.0	4.810%	3.315%	4.178%
18
19					Composite rates	9.62%	6.63%	8.36%
20
21
22
23
24
25
26
27
28
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