ABCDEFGHIJKLMNOPQRSTUVWXY
1
Note: Unless you start your career at MA+60 or PHD (in this school district example), 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		Cumulative SumSelected Years Differences
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$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$97,200$99,630$102,121$104,674$107,291$109,974$112,724
7
3$50,430$51,691$52,983$54,308$55,666$57,058$58,484$147,630$151,321$155,104$158,982$162,957$167,032$171,208
8
4$51,691$52,983$54,308$55,666$57,058$58,484$59,946$199,321$204,304$209,412$214,648$220,015$225,516$231,154
9
5$53,629$54,970$56,345$57,753$59,198$60,677$62,194$252,950$259,274$265,757$272,401$279,213$286,193$293,348
10
6$54,970$56,344$57,754$59,197$60,678$62,194$63,749$307,920$315,618$323,511$331,598$339,891$348,387$357,097
11
7$56,344$57,753$59,198$60,677$62,195$63,749$65,343$364,264$373,371$382,709$392,275$402,086$412,136$422,440
12
8$57,753$59,197$60,678$62,194$63,750$65,343$66,977$422,017$432,568$443,387$454,469$465,836$477,479$489,417
13
9$59,197$60,677$62,195$63,749$65,344$66,977$68,651$481,214$493,245$505,582$518,218$531,180$544,456$558,068
14
10$59,197$62,952$64,527$66,140$67,794$69,489$71,225$540,411$556,197$570,109$584,358$598,974$613,945$629,293-$88,882-$73,096-$59,184-$44,935-$30,319$0
15
11$59,197$64,526$66,140$67,794$69,489$71,226$73,006$599,608$620,723$636,249$652,152$668,463$685,171$702,299-14.12%-11.62%-9.40%-7.14%-4.82%0.00%
16
12$59,197$66,139$67,794$69,489$71,226$73,007$74,831$658,805$686,862$704,043$721,641$739,689$758,178$777,130
17
13$59,197$66,139$69,489$71,226$73,007$74,832$76,702$718,002$753,001$773,532$792,867$812,696$833,010$853,832
18
14$59,197$66,139$71,226$73,007$74,832$76,703$78,620$777,199$819,140$844,758$865,874$887,528$909,713$932,452
19
15$59,197$66,139$73,897$75,745$77,638$79,759$81,568$836,396$885,279$918,655$941,619$965,166$989,472$1,014,020
20
16$59,197$66,139$75,744$77,639$79,579$81,568$83,607$895,593$951,418$994,399$1,019,258$1,044,745$1,071,040$1,097,627
21
17$59,197$66,139$77,638$79,580$81,568$83,607$85,697$954,790$1,017,557$1,072,037$1,098,838$1,126,313$1,154,647$1,183,324
22
18$59,197$66,139$77,638$81,570$83,607$85,697$87,839$1,013,987$1,083,696$1,149,675$1,180,408$1,209,920$1,240,344$1,271,163
23
19$59,197$66,139$77,638$83,609$85,697$87,839$90,035$1,073,184$1,149,835$1,227,313$1,264,017$1,295,617$1,328,183$1,361,198
24
20$59,197$66,139$77,638$86,744$88,911$91,133$93,411$1,132,381$1,215,974$1,304,951$1,350,761$1,384,528$1,419,316$1,454,609-$322,228-$238,635-$149,658-$103,848-$70,081-$35,293$0
25
21$59,197$66,139$77,638$88,913$91,134$93,411$95,746$1,191,578$1,282,113$1,382,589$1,439,674$1,475,662$1,512,727$1,550,355-22.15%-16.41%-10.29%-7.14%-4.82%-2.43%0.00%
26
22$59,197$66,139$77,638$91,136$93,412$95,746$98,140$1,250,775$1,348,252$1,460,227$1,530,810$1,569,074$1,608,473$1,648,495
27
23$59,197$66,139$77,638$93,414$95,747$98,140$100,594$1,309,972$1,414,391$1,537,865$1,624,224$1,664,821$1,706,613$1,749,089
28
24$59,197$66,139$77,638$93,414$95,747$100,594$103,109$1,369,169$1,480,530$1,615,503$1,717,638$1,760,568$1,807,207$1,852,198
29
25$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,428,366$1,546,669$1,693,141$1,811,052$1,856,315$1,911,573$1,959,174
30
26$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,487,563$1,612,808$1,770,779$1,904,466$1,952,062$2,015,939$2,066,150
31
27$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,546,760$1,678,947$1,848,417$1,997,880$2,047,809$2,120,305$2,173,126
32
28$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,605,957$1,745,086$1,926,055$2,091,294$2,143,556$2,224,671$2,280,102
33
29$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,665,154$1,811,225$2,003,693$2,184,708$2,239,303$2,329,037$2,387,078
34
30$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,724,351$1,877,364$2,081,331$2,278,122$2,335,050$2,433,403$2,494,054-$769,703-$616,690-$412,723-$215,932-$159,004-$60,651$0
35
31$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,783,548$1,943,503$2,158,969$2,371,536$2,430,797$2,537,769$2,601,030-30.86%-24.73%-16.55%-8.66%-6.38%-2.43%0.00%
36
32$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,842,745$2,009,642$2,236,607$2,464,950$2,526,544$2,642,135$2,708,006
37
33$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,901,942$2,075,781$2,314,245$2,558,364$2,622,291$2,746,501$2,814,982
38
34$59,197$66,139$77,638$93,414$95,747$104,366$106,976$1,961,139$2,141,920$2,391,883$2,651,778$2,718,038$2,850,867$2,921,958
39
35$59,197$66,139$77,638$93,414$95,747$104,366$106,976$2,020,336$2,208,059$2,469,521$2,745,192$2,813,785$2,955,233$3,028,934-$1,008,598-$820,875-$559,413-$283,742-$215,149-$73,701$0
40
36$59,197$66,139$77,638$93,414$95,747$104,366$106,976$2,079,533$2,274,198$2,547,159$2,838,606$2,909,532$3,059,599$3,135,910-33.30%-27.10%-18.47%-9.37%-7.10%-2.43%0.00%
41
37$59,197$66,139$77,638$93,414$95,747$104,366$106,976$2,138,730$2,340,337$2,624,797$2,932,020$3,005,279$3,163,965$3,242,886
42
38$59,197$66,139$77,638$93,414$95,747$104,366$106,976$2,197,927$2,406,476$2,702,435$3,025,434$3,101,026$3,268,331$3,349,862
43
39$59,197$66,139$77,638$93,414$95,747$104,366$106,976$2,257,124$2,472,615$2,780,073$3,118,848$3,196,773$3,372,697$3,456,838
44
40$59,197$66,139$77,638$93,414$95,747$104,366$106,976$2,316,321$2,538,754$2,857,711$3,212,262$3,292,520$3,477,063$3,563,814-$1,247,493-$1,025,060-$706,103-$351,552-$271,294-$86,751$0
45
-35.00%-28.76%-19.81%-9.86%-7.61%-2.43%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