ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
🏦 UK RETIREMENT PLANNING TOOL - BENEFITS
2
For use by UK individuals | Includes Pension, ISA & GIA projections | Couples & Individuals
3
4
5
ℹ️ Blue cells = inputs (enter your data). Black cells = calculated. All monetary values in £.
6
👤 PERSONAL DETAILS👤 PARTNER DETAILS (leave blank if single)⚙️ PLANNING ASSUMPTIONS
7
Full NameMr SmithFull NameMrs ExampleNet investment growth rate3.0%
8
Date of Birth1/1/1985Date of Birth1/2/1985Effective Tax Rate on Withdrawals15.0%
9
Current Age41Current Age41Income Tax – Basic Rate (for reference only)20.0%
10
Target Retirement Age65Target Retirement Age65Income Tax – Higher Rate (for reference only)40.0%
11
Years to Retirement24Years to Retirement24Comfort factor20.0%
12
Current Income£200,000Current Income£30,000⚙️ MORTGAGE
13
Tax rate45%Tax rate20%Outstanding Balance£500,000
14
State Pension Age67State Pension Age67Remaining Term (Yrs)24
15
State Pension (£/yr)£12,548State Pension – Partner£12,548Interest Rate4%
16
Monthly payments£35,640
17
18
💰 Annual Savings🏠 CURRENT ASSETSMr Smith🏠 CURRENT ASSETS Mrs Example
19
Available annual surplus£60,000Pension Fund Value (£)£100,000Pension Fund Value (£)£25,000
20
Annual increase Mr Pension£2,000Current Pension Contributions£10,000← adjust in Pension Schedule →Current Pension Contributions£5,000
21
Annual increase Mrs Pension£1,000 of which: Personal (£/Yr) Net£10,000 of which: Personal (£/yr)£2,000
22
Defined Benefit income (at retirement)
 of which: Employer (£/yr)£0 of which: Employer (£/yr)£3,000
23
State Pension – P1 (£/yr)£12,548ISA Fund Value (£)£0ISA Fund Value (£)£20,000
24
State Pension – P2 (£/yr)£12,548ISA Annual Contribution (£/yr)£20,000← adjust in ISA Schedule →ISA Annual Contribution (£/yr)£20,000
25
Other Income in retirement£0GIA Fund Value (£)£0GIA Fund Value (£)£0
26
Secured Income in retirement£25,096GIA Annual Contribution (£/yr)£0← adjust in GIA Schedule →GIA Annual Contribution (£/yr)£0
27
28
£ CAPITAL VALUES🚦 SUSTAINABLE INCOME
29
30
Pension Mr£1,186,273Secured Income£25,096
31
Pension Mrs£818,390Pension Income£68,159
32
Total Pension£2,004,662ISA Income£62,584
33
ISA Mr£771,661GIA Income£9,498
34
ISA Mrs£792,936Total Income£165,336.37
35
ISA Total£1,564,597Less comfort factor£132,269.09
36
GIA Mr£279,352
37
GIA Mrs
38
GIA Total£279,352
39
Asset Total£3,848,611
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