Pension Details
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
This information is not guaranteed to be correct use at your own risk
Note: The actual TPS calculation works out the average salary at the point you leave using the best 3 from last 10 years. Uses that to work out the pension and lump sum
2
Only the white boxes need to be completed.
and then applies the CPI increase to both of those figures. It should give the same result (e.g. x times y times z = z times x times y)
3
To use this sheet SAVE a copy for yourself (File - Make a copy)
4
Multiplier Tables Source: https://www.gov.uk/government/publications/public-service-pensions-increase-2019
5
As of 21 March 2019
Enter your actual salary and dates in the white boxes below (only last 10 years needed)
3 Years =
6
FromToMultiplierFromToSalaryMultiplier
Revalued Salary
No. Days
Salary (Revalued)
1095 Average1095 day list
Best 3 Year Average
7
26/01/200025/02/20001.61601/09/200931/03/2010£42,648.001.2273£52,341.89212£52,341.89No value until01/09/2009£51,352.52
8
26/02/200025/03/20001.614601/04/201031/08/2010£42,681.001.2119£51,725.10153£52,341.891095 days later02/09/20093 Years from:
9
26/03/200024/04/20001.613101/09/201031/03/2011£43,693.001.1904£52,012.15212£52,341.8903/09/200901/09/2009
10
25/04/200024/05/20001.608901/04/201131/08/2011£43,726.001.1658£50,975.77153£52,341.8904/09/2009
11
25/05/200024/06/20001.604501/09/201131/03/2012£44,699.001.1315£50,576.92213£52,341.8905/09/2009Service
12
25/06/200024/07/20001.600301/04/201231/08/2012£44,732.001.1213£50,157.99153£52,341.8906/09/2009YearsDaysService Total
13
25/07/200024/08/20001.595901/09/201231/03/2013£45,728.001.1072£50,630.04212£52,341.8907/09/20093214232.3890411
14
25/08/200024/09/20001.591701/04/201328/02/2014£45,761.001.0805£49,444.76334£52,341.8908/09/2009
15
25/09/200024/10/20001.587301/03/201431/03/2014£45,728.001.0781£49,299.3631£52,341.8909/09/2009
Full Pension at NPA 60
16
25/10/200024/11/20001.583101/04/201431/05/2014£45,728.001.0759£49,198.7661£52,341.8910/09/2009
Pension (Service/80) x Avg Salary
Lump SumTax Rate20%
17
25/11/200024/12/20001.578801/06/201431/08/2014£45,728.001.0727£49,052.4392£52,341.8911/09/2009£20,790.73£62,372.20Tax Allowance£12,000.00
18
25/12/200024/01/20011.574501/09/201431/03/2015£45,728.001.0653£48,714.04212£52,341.8912/09/2009
19
25/01/200124/02/20011.570201/04/201531/08/2015£45,728.001.0653£48,714.04153£52,341.8913/09/2009
Compared to @60 (assume tax-rate of 20% and allowance of £12000)
20
25/02/200124/03/20011.565901/09/201531/03/2016£46,186.001.0653£49,201.95213£52,341.8914/09/2009
Early Retirement Section
Money received by 60
21
25/03/200123/04/20011.561601/04/201631/08/2016£46,186.001.0608£48,994.11153£52,341.8915/09/2009Age at retirementAAB Pension Section
Pension Difference
No. Years to
22
24/04/200123/05/20011.559401/09/201631/03/2017£46,649.001.0547£49,200.70212£52,341.8916/09/2009YearsMonthsDecimal AgeFactorAAB PensionLump SumDecimal Years
Pension (Gross)
After TaxGrossAfter Tax (all)Overtake AAB
23
24/05/200123/06/20011.557301/04/201731/08/2017£46,649.001.0419£48,603.59153£52,341.8917/09/200956056.00000.863£17,942.40£53,827.214.0000£71,769.61£67,015.69£2,848.33£2,278.6625.66007443
24
24/06/200123/07/20011.555101/09/201731/03/2018£47,116.001.024£48,246.78212£52,341.8918/09/2009
25
24/07/200123/08/20011.552801/04/201805/04/2018£47,116.001.024£48,246.785£52,341.8919/09/2009
Factors (Source: https://www.teacherspensions.co.uk/-/media/Documents/Member/Documents/Factors/Retirement/TPS%20Early%20retirement%20factor%20guidance%2010%20February%202015.ashx)
26
24/08/200123/09/20011.550706/04/201831/08/2018£47,116.001.014£47,775.62148£52,341.8920/09/2009Age
27
24/09/200123/10/20011.548501/09/201831/03/2019£47,588.001.002£47,683.18212£52,341.8921/09/2009YearsMonthsAge (decimal)Factor
28
24/10/200123/11/20011.546401/04/201905/04/2019£47,588.001.002£47,683.185£52,341.8922/09/200955055.00000.833
Disposable Income - Tax, NI, Pension deductions etc
29
24/11/200123/12/20011.544206/04/201931/08/2019£47,588.001.002£47,683.18148£52,341.8923/09/200955155.08330.836Gross Salary£47,500.00
30
24/12/200123/01/20021.54210£0.000£52,341.8924/09/200955255.16670.838Income Tax£7,000.00
31
24/01/200223/02/20021.53980£0.000£52,341.8925/09/200955355.25000.841National Insurance£4,664.64
32
24/02/200223/03/20021.53760£0.000£52,341.8926/09/200955455.33330.843Pension£4,845.00
33
24/03/200222/04/20021.53550£0.000£52,341.8927/09/200955555.41670.846Take Home£30,990.36
34
23/04/200222/05/20021.53340£0.000£52,341.8928/09/200955655.50000.848
35
23/05/200222/06/20021.53120£0.000£52,341.8929/09/200955755.58330.851
36
23/06/200222/07/20021.52910£0.000£52,341.8930/09/200955855.66670.853
Income Tax Rates 2019
National Insurance
Pension
37
23/07/200222/08/20021.52690£0.000£52,341.8901/10/200955955.75000.856£12,500.000.00%£8,628.000.00%£0.007.40%
38
23/08/200222/09/20021.52480£0.000£52,341.8902/10/2009551055.83330.858£50,000.0020.00%£50,004.0012.00%£27,697.998.60%
39
23/09/200222/10/20021.52260£0.000£52,341.8903/10/2009551155.91670.861£150,000.0040.00%More2.00%£37,284.999.60%
40
23/10/200222/11/20021.52050£0.000£52,341.8904/10/200956056.00000.863More45.00%£44,208.9910.20%
41
23/11/200222/12/20021.51840£0.000£52,341.8905/10/200956156.08330.866£58,590.9911.30%
42
23/12/200222/01/20031.51630£0.000£52,341.8906/10/200956256.16670.868£79,895.9911.70%
43
23/01/200322/02/20031.5140£0.000£52,341.8907/10/200956356.25000.871
44
23/02/200322/03/20031.51190£0.000£52,341.8908/10/200956456.33330.874
45
23/03/200327/04/20031.50980£0.000£52,341.8909/10/200956556.41670.876
46
28/04/200327/05/20031.50640£0.000£52,341.8910/10/200956656.50000.879
47
28/05/200327/06/20031.50290£0.000£52,341.8911/10/200956756.58330.882
48
28/06/200327/07/20031.49950£0.000£52,341.8912/10/200956856.66670.884
49
28/07/200327/08/20031.49610£0.000£52,341.8913/10/200956956.75000.887
50
28/08/200327/09/20031.49260£0.000£52,341.8914/10/2009561056.83330.889
51
28/09/200327/10/20031.48920£0.000£52,341.8915/10/2009561156.91670.892
52
28/10/200327/11/20031.48590£0.000£52,341.8916/10/200957057.00000.895
53
28/11/200327/12/20031.48230£0.000£52,341.8917/10/200957157.08330.898
54
28/12/200327/01/20041.4790£0.000£52,341.8918/10/200957257.16670.900
55
28/01/200427/02/20041.47560£0.000£52,341.8919/10/200957357.25000.903
56
28/02/200427/03/20041.47210£0.000£52,341.8920/10/200957457.33330.906
57
28/03/200426/04/20041.46870£0.000£52,341.8921/10/200957557.41670.909
58
27/04/200426/05/20041.4650£0.000£52,341.8922/10/200957657.50000.912
59
27/05/200426/06/20041.46130£0.000£52,341.8923/10/200957757.58330.914
60
27/06/200426/07/20041.45770£0.000£52,341.8924/10/200957857.66670.917
61
27/07/200426/08/20041.4540£0.000£52,341.8925/10/200957957.75000.920
62
27/08/200426/09/20041.45030£0.000£52,341.8926/10/2009571057.83330.923
63
27/09/200426/10/20041.44660£0.000£52,341.8927/10/2009571157.91670.925
64
27/10/200426/11/20041.44290£0.000£52,341.8928/10/200958058.00000.928
65
27/11/200426/12/20041.43920£0.000£52,341.8929/10/200958158.08330.931
66
27/12/200426/01/20051.43560£0.000£52,341.8930/10/200958258.16670.934
67
27/01/200526/02/20051.43190£0.000£52,341.8931/10/200958358.25000.937
68
27/02/200526/03/20051.42820£0.000£52,341.8901/11/200958458.33330.940
69
27/03/200525/04/20051.42450£0.000£52,341.8902/11/200958558.41670.943
70
26/04/200525/05/20051.42150£0.000£52,341.8903/11/200958658.50000.946
71
26/05/200525/06/20051.41830£0.000£52,341.8904/11/200958758.58330.949
72
26/06/200525/07/20051.41520£0.000£52,341.8905/11/200958858.66670.952
73
26/07/200525/08/20051.4120£0.000£52,341.8906/11/200958958.75000.955
74
26/08/200525/09/20051.4090£0.000£52,341.8907/11/2009581058.83330.958
75
26/09/200525/10/20051.40580£0.000£52,341.8908/11/2009581158.91670.961
76
26/10/200525/11/20051.40270£0.000£52,341.8909/11/200959059.00000.964
77
26/11/200525/12/20051.39960£0.000£52,341.8910/11/200959159.08330.967
78
26/12/200525/01/20061.39650£0.000£52,341.8911/11/200959259.16670.970
79
26/01/200625/02/20061.39330£0.000£52,341.8912/11/200959359.25000.973
80
26/02/200625/03/20061.39030£0.000£52,341.8913/11/200959459.33330.976
81
26/03/200624/04/20061.38710£0.000£52,341.8914/11/200959559.41670.980
82
25/04/200624/05/20061.38310£0.000£52,341.8915/11/200959659.50000.983
83
25/05/200624/06/20061.3790£0.000£52,341.8916/11/200959759.58330.986
84
25/06/200624/07/20061.3750£0.000£52,341.8917/11/200959859.66670.989
85
25/07/200624/08/20061.3710£0.000£52,341.8918/11/200959959.75000.992
86
25/08/200624/09/20061.3670£0.000£52,341.8919/11/2009591059.83330.995
87
25/09/200624/10/20061.3630£0.000£52,341.8920/11/2009591159.91670.998
88
25/10/200624/11/20061.3590£0.000£52,341.8921/11/200960060.00001.000
89
25/11/200624/12/20061.35490£0.000£52,341.8922/11/2009
90
25/12/200624/01/20071.35090£0.000£52,341.8923/11/2009
91
25/01/200724/02/20071.34690£0.000£52,341.8924/11/2009
92
25/02/200724/03/20071.34290£0.000£52,341.8925/11/2009
93
25/03/200722/04/20071.33890£0.000£52,341.8926/11/2009
94
23/04/200722/05/20071.33480£0.000£52,341.8927/11/2009
95
23/05/200722/06/20071.33050£0.000£52,341.8928/11/2009
96
23/06/200722/07/20071.32640£0.000£52,341.8929/11/2009
97
23/07/200722/08/20071.32210£0.000£52,341.8930/11/2009
98
23/08/200722/09/20071.3180£0.000£52,341.8901/12/2009
99
23/09/200722/10/20071.31370£0.000£52,341.8902/12/2009
100
23/10/200722/11/20071.30960£0.000£52,341.8903/12/2009
Loading...