ABCDEFGHIJKL
1
Only change the Yellow cells (otherwise it breaks, and other people can't use it). Thanks, Ed
2
3
Partner #1Partner #2It is currently 2025. Her is 32 and Travis is 58. You want to retire when Travis is 65.
4
NameHerTravisThat means that Her will be 65 and Travis will be 58. That will happen in , which is 33 years away.
5
Date of Birth1992/12/081967/01/13At the time you retire, Her is expected to live until 89.4 and Travis is expected to live until 90910.
6
SexFemaleMale#NUM!
7
#NUM!
8
Current Age3258
9
Working Life Start2022
10
11
Retire whenTravisHer
12
Is6565
13
14
Reitrement Age6558
15
Chance of making it to retirement94%#DIV/0!
16
17
Expected Age of Death at Retirement Age89.490,910
18
Education2022
19
Working life so far1236
20
Working life left330
21
Years in retirement24.490,852
22
23
Year of retirement
24
Year of death2081#NUM!
25
Years in Retirement2081#NUM!
26
27
Current Age – Number Alive in Cohort97,019
28
Future Age – Number Alive in Cohort90,910
29
75% Chance8448,216
30
25% Chance95
31
32
33
34
35
36
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