ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Copy this sheet to your own Drive and you can edit the figures 📊
2
Remember - Alpha increases with inflation each year, too 📈 (in 2018, the increase was 3%)
3
Alpha is the pension option that keeps it simple - you don't need to make any investment choices
4
5
Alpha is a "defined benefit" pension - you "accrue" ("get") 2.32% of your salary every year.
6
Another way to think of it: it is your average annual salary X 2.32% X number of years worked.
7
You don't choose how it's invested.
8
You can grow it two ways by working more years, and by getting salary increases.
9
Edit the bits in green
10
11
Year of workAnnual earningsAlpha accrual aka How much is my annual pension going up at the end of this year?Cumulative Alpha accrual aka How much annual pension can I get if I quit at the end of this year?
12
138,0008828820.00%
13
240,0009281,8102.32%You need 2 years in the scheme to get your alpha pension. If you leave the CS before then, you'll be offered your contributions back, or you can transfer into another pension. Before you quit your job, call up CS Pensions on 0300 123 6666 to find out if you've got your two years of service yet
14
340,0009282,7384.64%
15
442,0009743,7126.96%
16
544,0001,0214,7339.28%
17
644,0001,0215,75411.60%
18
745,0001,0446,79813.92%
19
850,0001,1607,95816.24%
20
951,0001,1839,14118.56%
21
1052,0001,20610,34720.88%
22
1154,0001,25311,60023.20%
23
1255,0001,27612,87625.52%
24
1356,0001,29914,17527.84%
25
1457,0001,32215,49830.16%
26
1558,0001,34616,84332.48%
27
1659,0001,36918,21234.80%
28
1760,0001,39219,60437.12%
29
1861,0001,41521,01939.44%
30
1962,0001,43822,45841.76%
31
2063,0001,46223,91944.08%
32
33
34
Total salary1,031,000
35
Average salary£51,550.00
36
Alpha %2.32%
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