ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJ
1
Note: Unless you start your career with MA+60 or PHD, no one will spend their entire career in one lane, so column totals are still meaningful, but also will not match anyone's actual salary path.
To customize this for yourself, choose File-->Make a Copy and then put your current salary schedule in columns B through H (or the number of lanes your district has).
2
Today's Dollars
(salary schedule will change, but so will inflation, so this is all in today's dollars so you can understand purchasing power)
3
Salary Schedule (today's dollars)
Selected Lanes		Option 1 Yearly Pension Amount (unreduced, 5-year HAS)Selected Yearly Difference in Pension Check
4
Year in
Career		BABA+15BA+30MAMA+15MA+30MA + 45/60
EDS		BABA+15BA+30MAMA+15MA+30MA + 45/60
EDS		BABA+15BA+30MAMA+15MA+30MA + 45/60
EDS
5
1$48,000$49,200$50,430$51,691$52,983$54,308$55,666
6
2$49,200$50,430$51,691$52,983$54,308$55,666$57,058
7
3$50,430$51,691$52,983$54,308$55,666$57,058$58,484
8
4$51,691$52,983$54,308$55,666$57,058$58,484$59,946
9
5$53,629$54,970$56,345$57,753$59,198$60,677$62,194$6,324$6,482$6,644$6,810$6,980$7,155$7,334
10
6$54,970$56,344$57,754$59,197$60,678$62,194$63,749$7,798$7,993$8,192$8,397$8,607$8,822$9,043
11
7$56,344$57,753$59,198$60,677$62,195$63,749$65,343$9,347$9,581$9,821$10,066$10,318$10,576$10,840
12
8$57,753$59,197$60,678$62,194$63,750$65,343$66,977$10,975$11,250$11,531$11,819$12,115$12,418$12,728
13
9$59,197$60,677$62,195$63,749$65,344$66,977$68,651$12,685$13,002$13,328$13,661$14,002$14,352$14,711
14
10$59,197$62,952$64,527$66,140$67,794$69,489$71,225$14,373$14,846$15,218$15,598$15,988$16,388$16,797-$2,424-$1,951-$1,580-$1,199-$809-$410$0
15
11$59,197$64,526$66,140$67,794$69,489$71,226$73,006$16,043$16,781$17,201$17,630$18,071$18,523$18,986-14.43%-11.62%-9.40%-7.14%-4.82%-2.44%0.00%
16
12$59,197$66,139$67,794$69,489$71,226$73,007$74,831$17,672$18,809$19,280$19,762$20,256$20,763$21,281
17
13$59,197$66,139$69,489$71,226$73,007$74,832$76,702$19,239$20,828$21,459$21,996$22,546$23,110$23,687
18
14$59,197$66,139$71,226$73,007$74,832$76,703$78,620$20,719$22,813$23,742$24,336$24,944$25,568$26,207
19
15$59,197$66,139$73,897$75,745$77,638$79,759$81,568$22,199$24,681$26,141$26,795$27,464$28,165$28,855
20
16$59,197$66,139$75,744$77,639$79,579$81,568$83,607$23,679$26,456$28,652$29,368$30,103$30,870$31,626
21
17$59,197$66,139$77,638$79,580$81,568$83,607$85,697$25,159$28,109$31,279$32,062$32,863$33,700$34,526
22
18$59,197$66,139$77,638$81,570$83,607$85,697$87,839$26,639$29,763$33,853$34,879$35,750$36,660$37,560
23
19$59,197$66,139$77,638$83,609$85,697$87,839$90,035$28,119$31,416$36,343$37,824$38,768$39,755$40,731
24
20$59,197$66,139$77,638$86,744$88,911$91,133$93,411$29,599$33,070$38,630$40,914$41,936$42,984$44,059-$14,460-$10,989-$5,429-$3,145-$2,123-$1,074$0
25
21$59,197$66,139$77,638$88,913$91,134$93,411$95,746$31,078$34,723$40,760$44,144$45,246$46,377$47,536-32.82%-24.94%-12.32%-7.14%-4.82%-2.44%0.00%
26
22$59,197$66,139$77,638$91,136$93,412$95,746$98,140$32,558$36,376$42,701$47,517$48,704$49,921$51,169
27
23$59,197$66,139$77,638$93,414$95,747$98,140$100,594$34,038$38,030$44,642$51,039$52,314$53,621$54,961
28
24$59,197$66,139$77,638$93,414$95,747$100,594$103,109$35,518$39,683$46,583$54,435$55,794$57,483$58,920
29
25$59,197$66,139$77,638$93,414$95,747$104,366$106,976$36,998$41,337$48,524$57,536$58,973$61,532$63,071
30
26$59,197$66,139$77,638$93,414$95,747$104,366$106,976$38,478$42,990$50,465$60,423$61,932$65,418$67,053
31
27$59,197$66,139$77,638$93,414$95,747$104,366$106,976$39,958$44,644$52,406$63,054$64,629$69,097$70,825
32
28$59,197$66,139$77,638$93,414$95,747$104,366$106,976$41,438$46,297$54,347$65,390$67,023$72,528$74,342
33
29$59,197$66,139$77,638$93,414$95,747$104,366$106,976$42,918$47,951$56,288$67,725$69,417$75,665$77,558
34
30$59,197$66,139$77,638$93,414$95,747$104,366$106,976$44,398$49,604$58,229$70,061$71,810$78,275$80,232-$35,834-$30,628-$22,004-$10,172-$8,422-$1,958$0
35
31$59,197$66,139$77,638$93,414$95,747$104,366$106,976$45,878$51,258$60,169$72,396$74,204$80,884$82,906-44.66%-38.17%-27.42%-12.68%-10.50%-2.44%0.00%
36
32$59,197$66,139$77,638$93,414$95,747$104,366$106,976$47,358$52,911$62,110$74,731$76,598$83,493$85,581
37
33$59,197$66,139$77,638$93,414$95,747$104,366$106,976$48,838$54,565$64,051$77,067$78,991$86,102$88,255
38
34$59,197$66,139$77,638$93,414$95,747$104,366$106,976$50,317$56,218$65,992$79,402$81,385$88,711$90,930
39
35$59,197$66,139$77,638$93,414$95,747$104,366$106,976$51,797$57,872$67,933$81,737$83,779$91,320$93,604-$41,807-$35,732-$25,671-$11,867-$9,825-$2,284$0
40
36$59,197$66,139$77,638$93,414$95,747$104,366$106,976$53,277$59,525$69,874$84,073$86,172$93,929$96,278-44.66%-38.17%-27.42%-12.68%-10.50%-2.44%0.00%
41
37$59,197$66,139$77,638$93,414$95,747$104,366$106,976$54,757$61,179$71,815$86,408$88,566$96,539$98,953
42
38$59,197$66,139$77,638$93,414$95,747$104,366$106,976$56,237$62,832$73,756$88,743$90,960$99,148$101,627
43
39$59,197$66,139$77,638$93,414$95,747$104,366$106,976$57,717$64,486$75,697$91,079$93,353$101,757$104,302
44
40$59,197$66,139$77,638$93,414$95,747$104,366$106,976$59,197$66,139$77,638$93,414$95,747$104,366$106,976-$47,779-$40,837-$29,338-$13,562-$11,229-$2,610$0
45
-44.66%-38.17%-27.42%-12.68%-10.50%-2.44%0.00%
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