ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
7%
LT Tax adjusted rate of return
3
 $ 500
monthly savings
INPUT
4
2%
Annual COLA adjustment
5
6
7
8
To refresh:
9
Click chart, go to "Pivot Chart Tools, Anylyze" drop down, click or "refresh"
10
MonthYearCumulative Savings
Monthly Savings BOP
Monthly Savings EOP
Savings Multiplier
COLA increment
11
11 $ 500 $ 500 $502.92 1.01 $ 500
12
21 $ 1,000 $1,002.92 $1,008.77 1.01 $ 500
13
31 $ 1,500 $1,508.77 $1,517.57 1.01 $ 500
14
41 $ 2,000 $2,017.57 $2,029.34 1.01 $ 500
15
51 $ 2,500 $2,529.34 $2,544.09 1.02 $ 500
16
61 $ 3,000 $3,044.09 $3,061.85 1.02 $ 500
17
71 $ 3,500 $3,561.85 $3,582.63 1.02 $ 500
18
81 $ 4,000 $4,082.63 $4,106.44 1.03 $ 500
19
91 $ 4,500 $4,606.44 $4,633.31 1.03 $ 500
20
101 $ 5,000 $5,133.31 $5,163.26 1.03 $ 500
21
111 $ 5,500 $5,663.26 $5,696.29 1.04 $ 500
22
121 $ 6,000 $6,196.29 $6,232.44 1.04 $ 500
23
132 $ 6,510 $6,742.44 $6,781.77 1.04 $ 510
24
142 $ 7,020 $7,291.77 $7,334.30 1.04 $ 510
25
152 $ 7,530 $7,844.30 $7,890.06 1.05 $ 510
26
162 $ 8,040 $8,400.06 $8,449.06 1.05 $ 510
27
172 $ 8,550 $8,959.06 $9,011.32 1.05 $ 510
28
182 $ 9,060 $9,521.32 $9,576.86 1.06 $ 510
29
192 $ 9,570 $10,086.86 $10,145.70 1.06 $ 510
30
202 $ 10,080 $10,655.70 $10,717.86 1.06 $ 510
31
212 $ 10,590 $11,227.86 $11,293.36 1.07 $ 510
32
222 $ 11,100 $11,803.36 $11,872.21 1.07 $ 510
33
232 $ 11,610 $12,382.21 $12,454.44 1.07 $ 510
34
242 $ 12,120 $12,964.44 $13,040.07 1.08 $ 510
35
253 $ 12,640 $13,560.07 $13,639.17 1.08 $ 520
36
263 $ 13,160 $14,159.17 $14,241.76 1.08 $ 520
37
273 $ 13,680 $14,761.76 $14,847.87 1.09 $ 520
38
283 $ 14,200 $15,367.87 $15,457.52 1.09 $ 520
39
293 $ 14,720 $15,977.52 $16,070.72 1.09 $ 520
40
303 $ 15,240 $16,590.72 $16,687.50 1.09 $ 520
41
313 $ 15,760 $17,207.50 $17,307.88 1.10 $ 520
42
323 $ 16,280 $17,827.88 $17,931.87 1.10 $ 520
43
333 $ 16,800 $18,451.87 $18,559.51 1.10 $ 520
44
343 $ 17,320 $19,079.51 $19,190.81 1.11 $ 520
45
353 $ 17,840 $19,710.81 $19,825.79 1.11 $ 520
46
363 $ 18,360 $20,345.79 $20,464.47 1.11 $ 520
47
374 $ 18,890 $20,994.47 $21,116.94 1.12 $ 530
48
384 $ 19,420 $21,646.94 $21,773.21 1.12 $ 530
49
394 $ 19,950 $22,303.21 $22,433.31 1.12 $ 530
50
404 $ 20,480 $22,963.31 $23,097.27 1.13 $ 530
51
414 $ 21,010 $23,627.27 $23,765.09 1.13 $ 530
52
424 $ 21,540 $24,295.09 $24,436.81 1.13 $ 530
53
434 $ 22,070 $24,966.81 $25,112.45 1.14 $ 530
54
444 $ 22,600 $25,642.45 $25,792.03 1.14 $ 530
55
454 $ 23,130 $26,322.03 $26,475.58 1.14 $ 530
56
464 $ 23,660 $27,005.58 $27,163.11 1.15 $ 530
57
474 $ 24,190 $27,693.11 $27,854.66 1.15 $ 530
58
484 $ 24,720 $28,384.66 $28,550.23 1.15 $ 530
59
495 $ 25,260 $29,090.23 $29,259.93 1.16 $ 540
60
505 $ 25,800 $29,799.93 $29,973.76 1.16 $ 540
61
515 $ 26,340 $30,513.76 $30,691.76 1.17 $ 540
62
525 $ 26,880 $31,231.76 $31,413.94 1.17 $ 540
63
535 $ 27,420 $31,953.94 $32,140.34 1.17 $ 540
64
545 $ 27,960 $32,680.34 $32,870.97 1.18 $ 540
65
555 $ 28,500 $33,410.97 $33,605.87 1.18 $ 540
66
565 $ 29,040 $34,145.87 $34,345.06 1.18 $ 540
67
575 $ 29,580 $34,885.06 $35,088.55 1.19 $ 540
68
585 $ 30,120 $35,628.55 $35,836.38 1.19 $ 540
69
595 $ 30,660 $36,376.38 $36,588.58 1.19 $ 540
70
605 $ 31,200 $37,128.58 $37,345.16 1.20 $ 540
71
616 $ 31,750 $37,895.16 $38,116.22 1.20 $ 550
72
626 $ 32,300 $38,666.22 $38,891.77 1.20 $ 550
73
636 $ 32,850 $39,441.77 $39,671.85 1.21 $ 550
74
646 $ 33,400 $40,221.85 $40,456.48 1.21 $ 550
75
656 $ 33,950 $41,006.48 $41,245.68 1.21 $ 550
76
666 $ 34,500 $41,795.68 $42,039.49 1.22 $ 550
77
676 $ 35,050 $42,589.49 $42,837.93 1.22 $ 550
78
686 $ 35,600 $43,387.93 $43,641.02 1.23 $ 550
79
696 $ 36,150 $44,191.02 $44,448.80 1.23 $ 550
80
706 $ 36,700 $44,998.80 $45,261.30 1.23 $ 550
81
716 $ 37,250 $45,811.30 $46,078.53 1.24 $ 550
82
726 $ 37,800 $46,628.53 $46,900.53 1.24 $ 550
83
737 $ 38,360 $47,460.53 $47,737.38 1.24 $ 560
84
747 $ 38,920 $48,297.38 $48,579.12 1.25 $ 560
85
757 $ 39,480 $49,139.12 $49,425.76 1.25 $ 560
86
767 $ 40,040 $49,985.76 $50,277.35 1.26 $ 560
87
777 $ 40,600 $50,837.35 $51,133.90 1.26 $ 560
88
787 $ 41,160 $51,693.90 $51,995.45 1.26 $ 560
89
797 $ 41,720 $52,555.45 $52,862.02 1.27 $ 560
90
807 $ 42,280 $53,422.02 $53,733.65 1.27 $ 560
91
817 $ 42,840 $54,293.65 $54,610.36 1.27 $ 560
92
827 $ 43,400 $55,170.36 $55,492.19 1.28 $ 560
93
837 $ 43,960 $56,052.19 $56,379.16 1.28 $ 560
94
847 $ 44,520 $56,939.16 $57,271.30 1.29 $ 560
95
858 $ 45,090 $57,841.30 $58,178.71 1.29 $ 570
96
868 $ 45,660 $58,748.71 $59,091.41 1.29 $ 570
97
878 $ 46,230 $59,661.41 $60,009.44 1.30 $ 570
98
888 $ 46,800 $60,579.44 $60,932.82 1.30 $ 570
99
898 $ 47,370 $61,502.82 $61,861.58 1.31 $ 570
100
908 $ 47,940 $62,431.58 $62,795.77 1.31 $ 570