ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
Green cells denote the maximum amount of total collections for each year on the spreadsheet
2
COLA 3.66%Amounts Collected (Annual [L] and Running Total [R])
3
4
70.0%75.0%80.0%86.7%93.3%100%108%116%124%
5
Collects at 62Collects at 63Collects at 64Collects at 65Collects at 66Collects at 67Collects at 68Collects at 69Collects at 70
6
AgeYear
7
622024$8,400.00$8,400.00
8
632025$8,707.44$17,107.44$9,329.40$9,329.40
9
642026$9,026.13$26,133.57$9,670.86$19,000.26$10,315.58$10,315.58
10
652027$9,356.49$35,490.06$10,024.81$29,025.07$10,693.13$21,008.71$11,584.14$11,584.14
11
662028$9,698.94$45,189.00$10,391.72$39,416.78$11,084.50$32,093.21$12,008.11$23,592.25$12,931.45$12,931.45
12
672029$10,053.92$55,242.91$10,772.05$50,188.84$11,490.19$43,583.40$12,447.61$36,039.86$13,404.74$26,336.20$14,362.74$14,362.74
13
682030$10,421.89$65,664.81$11,166.31$61,355.15$11,910.73$55,494.13$12,903.19$48,943.05$13,895.36$40,231.56$14,888.42$29,251.15$16,079.49$16,079.49
14
692031$10,803.33$76,468.14$11,575.00$72,930.15$12,346.66$67,840.80$13,375.45$62,318.51$14,403.93$54,635.48$15,433.33$44,684.49$16,668.00$32,747.49$17,902.66$17,902.66
15
702032$11,198.73$87,666.87$11,998.64$84,928.79$12,798.55$80,639.35$13,864.99$76,183.50$14,931.11$69,566.60$15,998.19$60,682.68$17,278.05$50,025.53$18,557.90$36,460.57$19,837.76$19,837.76
16
712033$11,608.61$99,275.48$12,437.79$97,366.58$13,266.98$93,906.33$14,372.45$90,555.95$15,477.59$85,044.19$16,583.72$77,266.40$17,910.42$67,935.96$19,237.12$55,697.69$20,563.82$40,401.58
17
722034$12,033.48$111,308.96$12,893.02$110,259.60$13,752.55$107,658.88$14,898.48$105,454.43$16,044.07$101,088.26$17,190.69$94,457.09$18,565.94$86,501.90$19,941.20$75,638.89$21,316.45$61,718.03
18
732035$12,473.91$123,782.87$13,364.90$123,624.50$14,255.89$121,914.78$15,443.77$120,898.20$16,631.28$117,719.54$17,819.87$112,276.96$19,245.46$105,747.36$20,671.05$96,309.93$22,096.64$83,814.67
19
742036$12,930.45$136,713.32$13,854.06$137,478.56$14,777.66$136,692.44$16,009.01$136,907.21$17,239.99$134,959.53$18,472.08$130,749.04$19,949.84$125,697.20$21,427.61$117,737.54$22,905.37$106,720.04
20
752037$13,403.71$150,117.03$14,361.12$151,839.67$15,318.52$152,010.96$16,594.94$153,502.15$17,870.97$152,830.50$19,148.15$149,897.19$20,680.01$146,377.21$22,211.86$139,949.40$23,743.71$130,463.75
21
762038$13,894.28$164,011.31$14,886.73$166,726.41$15,879.18$167,890.14$17,202.31$170,704.46$18,525.05$171,355.55$19,848.98$169,746.16$21,436.89$167,814.10$23,024.81$162,974.21$24,612.73$155,076.48
22
772039$14,402.81$178,414.13$15,431.59$182,157.99$16,460.36$184,350.50$17,831.92$188,536.38$19,203.07$190,558.62$20,575.45$190,321.61$22,221.48$190,035.58$23,867.52$186,841.73$25,513.56$180,590.04
23
782040$14,929.96$193,344.08$15,996.38$198,154.38$17,062.81$201,413.31$18,484.57$207,020.95$19,905.90$210,464.51$21,328.51$211,650.12$23,034.79$213,070.38$24,741.07$211,582.80$26,447.35$207,037.39
24
792041$15,476.39$208,820.48$16,581.85$214,736.23$17,687.31$219,100.61$19,161.10$226,182.05$20,634.45$231,098.97$22,109.13$233,759.26$23,877.86$236,948.24$25,646.59$237,229.40$27,415.33$234,452.72
25
802042$16,042.83$224,863.31$17,188.75$231,924.97$18,334.66$237,435.28$19,862.40$246,044.45$21,389.68$252,488.64$22,918.33$256,677.59$24,751.79$261,700.03$26,585.26$263,814.66$28,418.73$262,871.44
26
812043$16,630.00$241,493.30$17,817.85$249,742.83$19,005.71$256,440.99$20,589.36$266,633.81$22,172.54$274,661.18$23,757.14$280,434.72$25,657.71$287,357.74$27,558.28$291,372.94$29,458.85$292,330.30
27
822044$17,238.65$258,731.96$18,469.99$268,212.81$19,701.32$276,142.31$21,342.93$287,976.74$22,984.05$297,645.23$24,626.65$305,061.37$26,596.78$313,954.53$28,566.91$319,939.85$30,537.05$322,867.34
28
832045$17,869.59$276,601.55$19,145.99$287,358.80$20,422.39$296,564.70$22,124.08$310,100.82$23,825.27$321,470.50$25,527.99$330,589.36$27,570.22$341,524.75$29,612.46$349,552.32$31,654.70$354,522.04
29
842046$18,523.62$295,125.17$19,846.73$307,205.53$21,169.85$317,734.54$22,933.83$333,034.65$24,697.27$346,167.78$26,462.31$357,051.67$28,579.29$370,104.04$30,696.28$380,248.60$32,813.26$387,335.31
30
852047$19,201.58$314,326.75$20,573.12$327,778.66$21,944.66$339,679.21$23,773.20$356,807.85$25,601.19$371,768.97$27,430.83$384,482.50$29,625.30$399,729.34$31,819.76$412,068.36$34,014.23$421,349.54
31
862048$19,904.36$334,231.11$21,326.10$349,104.76$22,747.84$362,427.05$24,643.30$381,451.15$26,538.20$398,307.17$28,434.80$412,917.30$30,709.58$430,438.92$32,984.37$445,052.73$35,259.15$456,608.69
32
872049$20,632.86$354,863.96$22,106.63$371,211.39$23,580.41$386,007.46$25,545.25$406,996.40$27,509.50$425,816.66$29,475.51$442,392.81$31,833.55$462,272.48$34,191.59$479,244.32$36,549.63$493,158.32
33
882050$21,388.02$376,251.98$22,915.74$394,127.13$24,443.45$410,450.91$26,480.20$433,476.60$28,516.34$454,333.00$30,554.32$472,947.12$32,998.66$495,271.14$35,443.01$514,687.33$37,887.35$531,045.67
34
892051$22,170.82$398,422.81$23,754.45$417,881.58$25,338.08$435,788.99$27,449.38$460,925.98$29,560.04$483,893.05$31,672.60$504,619.73$34,206.41$529,477.55$36,740.22$551,427.55$39,274.03$570,319.70
35
902052$22,982.27$421,405.08$24,623.87$442,505.44$26,265.46$462,054.45$28,454.03$489,380.01$30,641.94$514,534.98$32,831.82$537,451.55$35,458.37$564,935.92$38,084.91$589,512.46$40,711.46$611,031.16
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