Version Notes
1.0 Original
1.01 Fixed VBA code for explanations of results form
1.5 Added: mortality improvement, explanations of methods, new Social Security table (not that different from before), p
1.6 Looking at projection scale G
1.7 Implemented projection scale G, looking at calculation comparisons
1.8 Removed projection scale G stuff, explanation sheet wording edited, cleaning up VBA
1.8.1 Fixed text areas on "Printable Explanations" sheet and ExplanationForm user form
2.0 Switched out 2000 Soc. Sec. Table, replaced with 2010 table; explanations updated; input changed
able (not that different from before), printable explanations sheet
dated; input changed
Input Life expectanc
#NAME?
Number of
Mortality Improvement Future Years
#NAME?
Age: 55 Sex: F #NAME?
#NAME?
55 M #NAME?
#NAME?
Table source: Social Security 2010 tables with 1% morta
Explanation Printable Change
of Results Results Display
Click here for disclaimer
Created by Mary Pat Campbell, FSA, updated July 2010
ife expectancy
#NAME?
Probability of
Survival
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
ocial Security 2010 tables with 1% mortality improvement
Change
Mortality
Tables
Simple Life Expectancy Calculator
Results for an individual: The calculations presented in this tool are
intended for educational purposes, as most
Age: 55 Sex: Female
people do not have a good feel for how long they
may live in retirement. The calculations
presented are based on public mortality tables,
Mortality tables used: Social Security Calendar Year 2010 which were developed with certain populations in
Mortality improvement: 1% per year mind, and reflect probabilities based on averages
in large populations.
Life expectancy: #NAME?
An individual's survival probabilities are
Survival probabilities for set number of years dependent on factors such as family history,
Number of future years Probability of survival personal lifestyle (such as smoking or diet),
10 #NAME? existing disease (such as diabetes), and the like;
15 #NAME? one needs to take that into consideration when
20 #NAME? trying to consider how to use these numbers for
25 their own retirement planning.
#NAME?
30 #NAME? All probabilities and averages are computed
taking into account your age and sex, using the
Number of Future Years for set percentiles Social Security Calendar Year 2010 mortality
Number of future years Probability of survival table, with mortality rates assumed to decline by
#NAME? #NAME? 1% per year.
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME?
Description of Social Security Mortality Tables:
The Social Security 2010 tables are a calendar year mortality table for
the general U.S. population, reflecting mortality patterns by age and sex in
the year 2010. As these tables were developed with the entire U.S.
population in mind, the underlying numbers include people who have
severe disabilities and chronic disease; someone who is actively working
and in good health likely has better survival probabilities than the broad #NAME?
population. This table was developed in 2005 by the Office of the Chief
Actuary of the SSA, using mortality patterns and trends observed and Explanation of Mortality Improvement
projected. A mortality improvement option is provided for
extra conservatism in estimating life expectancy.
Description of Society of Actuaries Annuity-2000 Mortality Tables: Mortality rates do not remain static; with
improved medical treatment, improved safety
The Society of Actuaries Annuity-2000 table was developed from a regulations, improvement in lifestyles (most
population of people buying individual immediate annuities. Those who buy especially a reduction in smoking), probabilities
annuities tend to have longer life expectancies than the broad population; of death for a given age and sex tends to decline
an important reason for buying an annuity is to prevent outliving one's from year to year. According to the 2003
retirement savings, so those who are in ill health or have other reasons to Technical Panel on Assumptions and Methods
believe they will not be long-lived generally do not buy annuities. As with for the Social Security Advisory Board, the U.S.
the Social Security tables, these tables are by age and sex and reflect population has seen about a 1% improvement in
mortality rates in the year 2000; also, there will have been some mortality mortality per year over the past 50 years. It is
improvement in the annuitant population since this table was published. difficult to project how mortality is likely to
improve in the future, as much depends on
breakthroughs yet to come, but it is prudent to
Click here for disclaimer assume some improvement in mortality when
Created by Mary Pat Campbell, FSA, updated July 2010 trying to plan for how long one's retirement
income needs to last.
Explanation of cals:
All probabilities and averages are computed taking into account your age and sex, using
The life expectancy is the average number of years until death.
Explanation of calcs for single: #NAME?
The ages and probabilities displayed indicate the probability of surviving to that many yea
#NAME?
All probabilities and averages are computed taking into account your ages and sexes, us
The life expectancy is the average number of years until the last death in the couple.
Explanation of calcs for Couple: #NAME?
The ages and probabilities displayed indicate the probability of at least one member of th
#NAME?
Table name: Social Security Calendar Year 2010
the Social Security Calendar Year 2010
Begin table source: Table source: Social Security 2010 tables
mortality improvement: 1%
mortality improvement phrase: with mortality rates assumed to decline by 1% per year
Table footnote: Table source: Social Security 2010 tables with 1% mortality improvement
Explanation of methods:
The calculations presented in this tool are intended for educational purposes, as most people do not have a good feel for how l
An individual's survival probabilities are dependent on factors such as family history, personal lifestyle (such as smoking or diet
Explanation of Social Security Table
The Social Security 2010 tables are a calendar year mortality table for the general U.S. population, reflecting mortality patterns
Source:
http://www.ssa.gov/OACT/NOTES/pdf_studies/study120.pdf
Explanation of Society of Actuaries Table
The Society of Actuaries Annuity-2000 table was developed from a population of people buying individual immediate annuities.
Source:
http://www.soa.org/library/research/transactions-reports-of-mortality-moribidity-and-experience/1990-99/1995/january/TSR9510
Explanation of mortality improvement:
A mortality improvement option is provided for extra conservatism in estimating life expectancy. Mortality rates do not remain st
Source:
http://www.ssab.gov/documents/mort.projection.ssab.pdf
Click here for disclaimer
Created by Mary Pat Campbell, FSA, 2007
account your age and sex, using the Social Security Calendar Year 2010 mortality table, with mortality rates assumed to decline by 1% per y
bility of surviving to that many years.
account your ages and sexes, using the Social Security Calendar Year 2010 mortality table, with mortality rates assumed to decline by 1% pe
the last death in the couple.
bility of at least one member of the couple surviving to that age.
ality improvement
do not have a good feel for how long they may live in retirement. The calculations presented are based on public mortality tables, which were
ifestyle (such as smoking or diet), existing disease (such as diabetes), and the like; one needs to take that into consideration when trying to
tion, reflecting mortality patterns by age and sex in the year 2010. As these tables were developed with the entire U.S. population in mind, th
g individual immediate annuities. Those who buy annuities tend to have longer life expectancies than the broad population; an important reas
/1990-99/1995/january/TSR9510.pdf
y. Mortality rates do not remain static; with improved medical treatment, improved safety regulations, improvement in lifestyles (most especia
ates assumed to decline by 1% per year.
ty rates assumed to decline by 1% per year.
on public mortality tables, which were developed with certain populations in mind, and reflect probabilities based on averages in large populat
hat into consideration when trying to consider how to use these numbers for their own retirement planning.
he entire U.S. population in mind, the underlying numbers include people who have severe disabilities and chronic disease; someone who is
broad population; an important reason for buying an annuity is to prevent outliving one's retirement savings, so those who are in ill health or
provement in lifestyles (most especially a reduction in smoking), probabilities of death for a given age and sex tends to decline from year to y
s based on averages in large populations.
nd chronic disease; someone who is actively working and in good health likely has better survival probabilities than the broad population. Th
ings, so those who are in ill health or have other reasons to believe they will not be long-lived generally do not buy annuities. As with the Soc
d sex tends to decline from year to year. According to the 2003 Technical Panel on Assumptions and Methods for the Social Security Adviso
bilities than the broad population. This table was developed in 2005 by the Office of the Chief Actuary of the SSA, using mortality patterns an
do not buy annuities. As with the Social Security tables, these tables are by age and sex and reflect mortality rates in the year 2000; also, the
ethods for the Social Security Advisory Board, the U.S. population has seen about a 1% improvement in mortality per year over the past 50 y
the SSA, using mortality patterns and trends observed and projected.
tality rates in the year 2000; also, there will have been some mortality improvement in the annuitant population since this table was published
mortality per year over the past 50 years. It is difficult to project how mortality is likely to improve in the future, as much depends on breakthr
ulation since this table was published.
uture, as much depends on breakthroughs yet to come, but it is prudent to assume some improvement in mortality when trying to plan for ho
in mortality when trying to plan for how long one's retirement income needs to last.
setback setback
years months Table set ss
Male mortality
table: SSM 0 0
Female
mortality table: SSF 0 0
Type Assumption
Interpolation
choice: lin linear uniform distribution of deaths
exponentialconstant force of mortality
Show: pct harmonic hyperbolic; Balducci's assumption
Percentiles to
show: 1 2 3 4 5
50% 60% 70% 80% 90%
Years to
show: 1 2 3 4 5
individual 10 15 20 25 30
couple 10 15 20 25 30
stribution of deaths
orce of mortality
c; Balducci's assumption
Couple? FALSE TRUE
person1 in range 1.00%
mortality improvement rate
2nd entered? TRUE TRUE
person2 in range improvement
projected future1.00%
Person 1 Person2
Year Age Qx
mort improvement factor
S(x) Age Qy S(y)
mort improvement factor
0 55 0.01 #NAME? 1 0
1 56 0.01 #NAME? #NAME? 0
2 57 0.01 #NAME? #NAME? 0
3 58 0.01 #NAME? #NAME? 0
4 59 0.01 #NAME? #NAME? 0
5 60 0.01 #NAME? #NAME? 0
6 61 0.01 #NAME? #NAME? 0
7 62 0.01 #NAME? #NAME? 0
8 63 0.01 #NAME? #NAME? 0
9 64 0.01 #NAME? #NAME? 0
10 65 0.01 #NAME? #NAME? 0
11 66 0.01 #NAME? #NAME? 0
12 67 0.01 #NAME? #NAME? 0
13 68 0.01 #NAME? #NAME? 0
14 69 0.01 #NAME? #NAME? 0
15 70 0.01 #NAME? #NAME? 0
16 71 0.01 #NAME? #NAME? 0
17 72 0.01 #NAME? #NAME? 0
18 73 0.01 #NAME? #NAME? 0
19 74 0.01 #NAME? #NAME? 0
20 75 0.01 #NAME? #NAME? 0
21 76 0.01 #NAME? #NAME? 0
22 77 0.01 #NAME? #NAME? 0
23 78 0.01 #NAME? #NAME? 0
24 79 0.01 #NAME? #NAME? 0
25 80 0.01 #NAME? #NAME? 0
26 81 0.01 #NAME? #NAME? 0
27 82 0.01 #NAME? #NAME? 0
28 83 0.01 #NAME? #NAME? 0
29 84 0.01 #NAME? #NAME? 0
30 85 0.01 #NAME? #NAME? 0
31 86 0.01 #NAME? #NAME? 0
32 87 0.01 #NAME? #NAME? 0
33 88 0.01 #NAME? #NAME? 0
34 89 0.01 #NAME? #NAME? 0
35 90 0.01 #NAME? #NAME? 0
36 91 0.01 #NAME? #NAME? 0
37 92 0.01 #NAME? #NAME? 0
38 93 0.01 #NAME? #NAME? 0
39 94 0.01 #NAME? #NAME? 0
40 95 0.01 #NAME? #NAME? 0
41 96 0.01 #NAME? #NAME? 0
42 97 0.01 #NAME? #NAME? 0
43 98 0.01 #NAME? #NAME? 0
44 99 0.01 #NAME? #NAME? 0
45 100 0.01 #NAME? #NAME? 0
46 101 0.01 #NAME? #NAME? 0
47 102 0.01 #NAME? #NAME? 0
48 103 0.01 #NAME? #NAME? 0
49 104 0.01 #NAME? #NAME? 0
50 105 0.01 #NAME? #NAME? 0
51 106 0.01 #NAME? #NAME? 0
52 107 0.01 #NAME? #NAME? 0
53 108 0.01 #NAME? #NAME? 0
54 109 0.01 #NAME? #NAME? 0
55 110 0.01 #NAME? #NAME? 0
56 111 0.01 #NAME? #NAME? 0
57 112 0.01 #NAME? #NAME? 0
58 113 0.01 #NAME? #NAME? 0
59 114 0.01 #NAME? #NAME? 0
60 115 0.01 #NAME? #NAME? 0
61 116 0.01 #NAME? #NAME? 0
62 117 0.01 #NAME? #NAME? 0
63 118 0.01 #NAME? #NAME? 0
64 119 0.01 #NAME? #NAME? 0
65 120 0.01 #NAME? #NAME? 0
66 121 0.01 #NAME? #NAME? 0
67 122 0.01 #NAME? #NAME? 0
68 123 0.01 #NAME? #NAME? 0
69 124 0.01 #NAME? #NAME? 0
70 125 0.01 #NAME? #NAME? 0
71 126 0.01 #NAME? #NAME? 0
72 127 0.01 #NAME? #NAME? 0
73 128 0.01 #NAME? #NAME? 0
74 129 0.01 #NAME? #NAME? 0
75 130 0.01 #NAME? #NAME? 0
76 131 0.01 #NAME? #NAME? 0
77 132 0.01 #NAME? #NAME? 0
78 133 0.01 #NAME? #NAME? 0
79 134 0.01 #NAME? #NAME? 0
80 135 0.01 #NAME? #NAME? 0
81 136 0.01 #NAME? #NAME? 0
82 137 0.01 #NAME? #NAME? 0
83 138 0.01 #NAME? #NAME? 0
84 139 0.01 #NAME? #NAME? 0
85 140 0.01 #NAME? #NAME? 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
#NAME?
life expectancy: Percentiles prob prob
where occurs
0.5 0.5 0 1
S(x,y) death prob S-bar(x,y) e-circle bit 0.6 0.4 0 1
0 0 1 #NAME? 0.7 0.3 0 1
#NAME? #NAME? #NAME? #NAME? 0.8 0.2 0 1
#NAME? #NAME? #NAME? #NAME? 0.9 0.1 0 1
#NAME? #NAME? #NAME? #NAME? Years survival prob
#NAME? #NAME? #NAME? #NAME? 10 #NAME?
#NAME? #NAME? #NAME? #NAME? 15 #NAME?
#NAME? #NAME? #NAME? #NAME? 20 #NAME?
#NAME? #NAME? #NAME? #NAME? 25 #NAME?
#NAME? #NAME? #NAME? #NAME? 30 #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? future yearsDisplay? Display current option?
#NAME? #NAME? #NAME? #NAME? 65 TRUE #NAME?
#NAME? #NAME? #NAME? #NAME? 70 TRUE #NAME?
#NAME? #NAME? #NAME? #NAME? 75 TRUE #NAME?
#NAME? #NAME? #NAME? #NAME? 80 TRUE #NAME?
#NAME? #NAME? #NAME? #NAME? 85 TRUE #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? Display?
future percentile
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
0 1 0 #NAME?
prob next actually where
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
Display current option?
Min age: 0363 0364 0373 SSM
5 A-2000 Male A-2000 Female A-2000 MGM Soc. Sec. 2010-Male
Max age: 5 0.000291 0.000171 0.000232533 0.00016
95 6 0.000270 0.000141 0.000207145 0.00015
7 0.000257 0.000118 0.000189268 0.00014
Number Table name 8 0.000294 0.000118 0.000208232 0.00012
0363 A-2000 Male 9 0.000325 0.000121 0.000225578 0.0001
0364 A-2000 Female 10 0.000350 0.000126 0.000240819 0.00009
0373 A-2000 MGM 11 0.000371 0.000133 0.000254982 0.0001
SSM Soc. Sec. 2010-Male 12 0.000388 0.000142 0.000268068 0.00015
SSF Soc. Sec. 2010-Female 13 0.000402 0.000152 0.000280102 0.00025
14 0.000414 0.000164 0.000292087 0.0004
15 0.000425 0.000177 0.000304047 0.00056
16 0.000437 0.000190 0.000316519 0.00071
17 0.000449 0.000204 0.000329479 0.00084
18 0.000463 0.000219 0.000343952 0.00095
19 0.000480 0.000234 0.000359962 0.00104
20 0.000499 0.000250 0.000377482 0.00113
21 0.000519 0.000265 0.000395026 0.00121
22 0.000542 0.000281 0.000414593 0.00126
23 0.000566 0.000298 0.000435159 0.00125
24 0.000592 0.000314 0.000456258 0.0012
25 0.000616 0.000331 0.00047682 0.00114
26 0.000639 0.000347 0.000496381 0.00109
27 0.000659 0.000362 0.000513917 0.00106
28 0.000675 0.000376 0.000528918 0.00107
29 0.000687 0.000389 0.000541384 0.00111
30 0.000694 0.000402 0.000551294 0.00116
31 0.000699 0.000414 0.000559695 0.00121
32 0.000700 0.000425 0.000565563 0.00128
33 0.000701 0.000436 0.000571433 0.00137
34 0.000702 0.000449 0.000578284 0.00148
35 0.000704 0.000463 0.000586136 0.0016
36 0.000719 0.000481 0.000602589 0.00174
37 0.000749 0.000504 0.000629151 0.00189
38 0.000796 0.000532 0.00066684 0.00206
39 0.000864 0.000567 0.000718676 0.00224
40 0.000953 0.000609 0.000784653 0.00244
41 0.001065 0.000658 0.000865787 0.00264
42 0.001201 0.000715 0.000963069 0.00286
43 0.001362 0.000781 0.001077489 0.0031
44 0.001547 0.000855 0.001208033 0.00335
45 0.001752 0.000939 0.001353622 0.00363
46 0.001974 0.001035 0.00151369 0.00392
47 0.002211 0.001141 0.00168622 0.00418
48 0.002460 0.001261 0.001871632 0.00438
49 0.002721 0.001393 0.00206893 0.00457
50 0.002994 0.001538 0.002278596 0.00478
51 0.003279 0.001695 0.002500126 0.00504
52 0.003576 0.001864 0.002733507 0.00538
53 0.003884 0.002047 0.002979205 0.0058
54 0.004203 0.002244 0.003237213 0.00632
55 0.004534 0.002457 0.003509019 0.00691
56 0.004876 0.002689 0.003795595 0.00757
57 0.005228 0.002942 0.004097434 0.00828
58 0.005593 0.003218 0.004417055 0.00906
59 0.005988 0.003523 0.004766023 0.00991
60 0.006428 0.003863 0.005154862 0.01086
61 0.006933 0.004242 0.005595587 0.01192
62 0.007520 0.004668 0.006100641 0.01311
63 0.008207 0.005144 0.006680435 0.01444
64 0.009008 0.005671 0.007342305 0.0159
65 0.009940 0.006250 0.008095 0.01753
66 0.011016 0.006878 0.008943152 0.01932
67 0.012251 0.007555 0.009893731 0.02122
68 0.013657 0.008287 0.010955033 0.02323
69 0.015233 0.009102 0.012139807 0.02538
70 0.016979 0.010034 0.013464355 0.02785
71 0.018891 0.011117 0.014943145 0.03059
72 0.020967 0.012386 0.016592402 0.03343
73 0.023209 0.013871 0.01842812 0.03633
74 0.025644 0.015592 0.020473672 0.03942
75 0.028304 0.017564 0.022752263 0.04299
76 0.031220 0.019805 0.025288014 0.04715
77 0.034425 0.022328 0.028103239 0.05184
78 0.037948 0.025158 0.031224368 0.05711
79 0.041812 0.028341 0.034686025 0.06305
80 0.046037 0.031933 0.038527137 0.06978
81 0.050643 0.035985 0.042784624 0.07738
82 0.055651 0.040552 0.047498695 0.08596
83 0.061080 0.045690 0.052709976 0.09557
84 0.066948 0.051456 0.058460064 0.10625
85 0.073275 0.057913 0.064795678 0.118
86 0.080076 0.065119 0.071759466 0.13083
87 0.087370 0.073136 0.079398857 0.14473
88 0.095169 0.081991 0.08773902 0.15973
89 0.103455 0.091577 0.096715785 0.17584
90 0.112208 0.101758 0.106245258 0.19307
91 0.121402 0.112395 0.116236827 0.21141
92 0.131017 0.123349 0.126600577 0.23086
93 0.141030 0.134486 0.137246919 0.25138
94 0.151422 0.145689 0.148097151 0.27296
95 0.162179 0.156846 0.159077388 0.29443
96 0.173279 0.167841 0.170107929 0.31547
97 0.184706 0.178563 0.181114036 0.33577
98 0.196946 0.189604 0.192639577 0.35496
99 0.210484 0.201557 0.205228214 0.37271
100 0.225806 0.215013 0.219422251 0.39134
101 0.243398 0.230565 0.235764775 0.41091
102 0.263745 0.248805 0.254798042 0.43146
103 0.287334 0.270326 0.277066689 0.45303
104 0.314649 0.295719 0.303114873 0.47568
105 0.346177 0.325576 0.333491512 0.49947
106 0.382403 0.360491 0.368749995 0.52444
107 0.423813 0.401054 0.409446709 0.55066
108 0.470893 0.447860 0.456147124 0.57819
109 0.524128 0.501498 0.509419364 0.6071
110 0.584004 0.562563 0.569843148 0.63746
111 0.651007 0.631645 0.638002812 0.66933
112 0.725622 0.709338 0.714493017 0.7028
113 0.808336 0.796233 0.799915092 0.73794
114 0.899633 0.892923 0.894878466 0.77483
115 1.000000 1.000000 1 0.81358
116 1.000000 1.000000 1 0.85425
117 1.000000 1.000000 1 0.89697
118 1.000000 1.000000 1 0.94182
119 1.000000 1.000000 1 0.98891
120 1.000000 1.000000 1 1.000000
121 1.000000 1.000000 1 1.000000
122 1.000000 1.000000 1 1.000000
123 1.000000 1.000000 1 1.000000
124 1.000000 1.000000 1 1.000000
125 1.000000 1.000000 1 1.000000
126 1.000000 1.000000 1 1.000000
127 1.000000 1.000000 1 1.000000
128 1.000000 1.000000 1 1.000000
129 1.000000 1.000000 1 1.000000
130 1.000000 1.000000 1 1.000000
131 1.000000 1.000000 1 1.000000
132 1.000000 1.000000 1 1.000000
133 1.000000 1.000000 1 1.000000
134 1.000000 1.000000 1 1.000000
135 1.000000 1.000000 1 1.000000
136 1.000000 1.000000 1 1.000000
137 1.000000 1.000000 1 1.000000
138 1.000000 1.000000 1 1.000000
139 1.000000 1.000000 1 1.000000
140 1.000000 1.000000 1 1.000000
SSF
Soc. Sec. 2010-Female
0.00012
0.00012
0.00012
0.00011
0.0001
0.0001
0.0001
0.00012
0.00016
0.00021
0.00028
0.00034
0.00038
0.0004
0.0004
0.00041
0.00041
0.00042
0.00043
0.00044
0.00045
0.00046
0.00049
0.00052
0.00055
0.0006
0.00064
0.0007
0.00077
0.00086
0.00094
0.00104
0.00113
0.00124
0.00134
0.00146
0.00158
0.00169
0.0018
0.0019
0.00201
0.00214
0.00229
0.00244
0.00261
0.00281
0.00304
0.00332
0.00365
0.00403
0.00447
0.00495
0.00547
0.00604
0.00666
0.00734
0.00811
0.00895
0.00987
0.01088
0.01201
0.01325
0.01456
0.01594
0.01742
0.01912
0.02103
0.02303
0.02511
0.02736
0.02998
0.03305
0.03649
0.04031
0.04462
0.04965
0.05542
0.06182
0.06888
0.07674
0.08559
0.09561
0.10691
0.11955
0.13354
0.14886
0.16549
0.18337
0.20245
0.22268
0.24316
0.26357
0.28359
0.30287
0.32105
0.34031
0.36073
0.38237
0.40531
0.42963
0.45541
0.48274
0.5117
0.5424
0.57495
0.60944
0.64601
0.68477
0.72585
0.76941
0.81358
0.85425
0.89697
0.94182
0.98891
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
1.000000
Table name:
Table number:
Table type:
Usage:
Contributor:
Country:
Source of data:
Volume of data:
Observation period:
Unit of observation:
Construction method:
Published reference:
Comments:
Minimum age:
Maximum age:
Number of decimal places:
Table values:
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
104
105
106
107
108
109
110
111
112
113
114
115
1983 US IAM Basic, Male
824
Aggregate
Annuitant mortality
Roger Scott Lumsden 75147,2620
US
SOA Intercompany study on individual annuities and settlement options
Male+Female there were exposures of 612,356 contract years and $547 million annual income years
Deaths of 35,000 contract years for $25.6 million annual income years
TSA 1979 Reports pp 120-219 attempt to explain the volume,
as a rough guess, it's 2/3 female
1971 to 1976
Annual Income
1973 Basic experience projected 9.5 years.
Scale for projection I called Scale F (p 693)
Then a Jenkins smoothing and a cubic to close.
The official table runs from ages 5+, unofficial extension
values for ages 0-4 were added by R.S.Lumsden
using the standard extension of a-1949 as a base.
TSA XXXIII, pp 695
Experience table underlying 1983 IAM before 10% margin.
IAM stands for Individual Annuity Mortality
0
115
6
values for ages 0-4 were added by R.S.Lumsden
0.002988
0.001172
0.000652
0.000528
0.000462
0.000419
0.000389
0.000370
0.000391
0.000409
0.000424
0.000438
0.000450
0.000461
0.000472
0.000483
0.000495
0.000508
0.000523
0.000540
0.000559
0.000581
0.000605
0.000632
0.000661
0.000692
0.000724
0.000756
0.000788
0.000819
0.000850
0.000881
0.000913
0.000945
0.000980
0.001023
0.001077
0.001146
0.001232
0.001341
0.001476
0.001641
0.001842
0.002079
0.002352
0.002657
0.002988
0.003343
0.003718
0.004110
0.004518
0.004938
0.005370
0.005811
0.006260
0.006718
0.007184
0.007658
0.008146
0.008671
0.009266
0.009961
0.010787
0.011769
0.012920
0.014248
0.015761
0.017467
0.019373
0.021486
0.023810
0.026353
0.029120
0.032123
0.035398
0.038986
0.042930
0.047272
0.052054
0.057325
0.063132
0.069523
0.076547
0.084229
0.092498
0.101261
0.110424
0.119894
0.129609
0.139643
0.150099
0.161082
0.172699
0.185049
0.198219
0.212291
0.227346
0.243467
0.260903
0.279903
0.300716
0.323592
0.348780
0.376529
0.407088
0.440707
0.477634
0.518120
0.562412
0.610760
0.663417
0.720626
0.782640
0.849708
0.922077
1.000000
0.372086
0.405278
0.442277
0.483406
0.528989
0.579351
0.634814
0.695704
0.762343
0.835056
0.914167
1.000000
Table name: 1996 US Annuity 2000 Basic, Male
Table number: 885
Table type: Aggregate
Usage: Annuitant mortality
Contributor: Robert Johansen, FSA
Country: US
Construction method: 1983 IAM Basic experience projected 17 years on quin ages 7+
nnual income years Scale for projection is Scale G Male.
Then a Jenkins smoothing and a cubic to close from 95+
The calculated mortality rates were adjusted to
remove a small dip in the mortality rates in ages 33-35.
The official table runs from ages 5+, unofficial extension
values for ages 0-4 were added by R.S.Lumsden
using the standard extension of a-1949 as a base.
Published reference: TSA XLVII, pp 236-249
NAIC Life and Health Actuarial Subscription - Sept 1996, Attachment 7
Minimum age: 0
Maximum age: 115
Number of decimal places: 6
Table values: Scale G male
1983 IAM Basic Male projected
0 0.002311 0 0.002988 0.0150 0.002311
1 0.000906 1 0.001172 0.0150 0.000906
2 0.000504 2 0.000652 0.0150 0.000504
3 0.000408 3 0.000528 0.0150 0.000408
4 0.000357 4 0.000462 0.0150 0.000357
5 0.000324 5 0.000419 0.0150 0.000324
6 0.000301 6 0.000389 0.0150 0.000301
7 0.000286 7 0.000370 0.0150 0.000286
8 0.000328 8 0.000391 0.0125 0.000316
9 0.000362 9 0.000409 0.0100 0.000345
10 0.000390 10 0.000424 0.0075 0.000373
11 0.000413 11 0.000438 0.0050 0.000402
12 0.000431 12 0.000450 0.0025 0.000431
13 0.000446 13 0.000461 0.0024 0.000443
14 0.000458 14 0.000472 0.0023 0.000454
15 0.000470 15 0.000483 0.0022 0.000465
16 0.000481 16 0.000495 0.0021 0.000478
17 0.000495 17 0.000508 0.0020 0.000491
18 0.000510 18 0.000523 0.0018 0.000507
19 0.000528 19 0.000540 0.0016 0.000525
20 0.000549 20 0.000559 0.0014 0.000546
21 0.000573 21 0.000581 0.0012 0.000569
22 0.000599 22 0.000605 0.0010 0.000595
23 0.000627 23 0.000632 0.0010 0.000621
24 0.000657 24 0.000661 0.0010 0.00065
25 0.000686 25 0.000692 0.0010 0.00068
26 0.000714 26 0.000724 0.0010 0.000712
27 0.000738 27 0.000756 0.0010 0.000743
28 0.000758 28 0.000788 0.0023 0.000758
29 0.000774 29 0.000819 0.0036 0.00077
30 0.000784 30 0.000850 0.0049 0.000782
31 0.000789 31 0.000881 0.0062 0.000793
32 0.000789 32 0.000913 0.0075 0.000803
33 0.000790 33 0.000945 0.0100 0.000797
34 0.000791 34 0.000980 0.0125 0.000791
35 0.000792 35 0.001023 0.0150 0.000791
36 0.000794 36 0.001077 0.0175 0.000798
37 0.000823 37 0.001146 0.0200 0.000813
38 0.000872 38 0.001232 0.0200 0.000874
39 0.000945 39 0.001341 0.0200 0.000951
40 0.001043 40 0.001476 0.0200 0.001047
41 0.001168 41 0.001641 0.0200 0.001164
42 0.001322 42 0.001842 0.0200 0.001307
43 0.001505 43 0.002079 0.0195 0.001488
44 0.001715 44 0.002352 0.0190 0.001698
45 0.001948 45 0.002657 0.0185 0.001934
46 0.002198 46 0.002988 0.0180 0.002194
47 0.002463 47 0.003343 0.0175 0.002476
48 0.002740 48 0.003718 0.0175 0.002754
49 0.003028 49 0.004110 0.0175 0.003044
50 0.003330 50 0.004518 0.0175 0.003347
51 0.003647 51 0.004938 0.0175 0.003658
52 0.003980 52 0.005370 0.0175 0.003978
53 0.004331 53 0.005811 0.0170 0.004342
54 0.004698 54 0.006260 0.0165 0.004718
55 0.005077 55 0.006718 0.0160 0.005107
56 0.005465 56 0.007184 0.0155 0.005509
57 0.005861 57 0.007658 0.0150 0.005923
58 0.006265 58 0.008146 0.0150 0.0063
59 0.006694 59 0.008671 0.0150 0.006706
60 0.007170 60 0.009266 0.0150 0.007167
61 0.007714 61 0.009961 0.0150 0.007704
62 0.008348 62 0.010787 0.0150 0.008343
63 0.009093 63 0.011769 0.0150 0.009102
64 0.009968 64 0.012920 0.0150 0.009993
65 0.010993 65 0.014248 0.0150 0.01102
66 0.012188 66 0.015761 0.0150 0.01219
67 0.013572 67 0.017467 0.0150 0.013509
68 0.015160 68 0.019373 0.0145 0.015113
69 0.016946 69 0.021486 0.0140 0.016907
70 0.018920 70 0.023810 0.0135 0.018898
71 0.021071 71 0.026353 0.0130 0.021097
72 0.023388 72 0.029120 0.0125 0.023514
73 0.025871 73 0.032123 0.0125 0.025939
74 0.028552 74 0.035398 0.0125 0.028583
75 0.031477 75 0.038986 0.0125 0.03148
76 0.034686 76 0.042930 0.0125 0.034665
77 0.038225 77 0.047272 0.0125 0.038171
78 0.042132 78 0.052054 0.0125 0.042032
79 0.046427 79 0.057325 0.0125 0.046289
80 0.051128 80 0.063132 0.0125 0.050978
81 0.056250 81 0.069523 0.0125 0.056138
82 0.061809 82 0.076547 0.0125 0.06181
83 0.067826 83 0.084229 0.0125 0.068013
84 0.074322 84 0.092498 0.0125 0.07469
85 0.081326 85 0.101261 0.0125 0.081766
86 0.088863 86 0.110424 0.0125 0.089165
87 0.096958 87 0.119894 0.0125 0.096812
88 0.105631 88 0.129609 0.0120 0.105561
89 0.114858 89 0.139643 0.0115 0.114716
90 0.124612 90 0.150099 0.0110 0.12437
91 0.134861 91 0.161082 0.0105 0.134622
92 0.145575 92 0.172699 0.0100 0.145575
93 0.156727 93 0.185049 0.0100 0.155986
94 0.168290 94 0.198219 0.0100 0.167087
95 0.180245 95 0.212291 0.0100 0.178949
96 0.192565 96 0.227346 0.0100 0.19164
97 0.205229 97 0.243467 0.0100 0.205229
98 0.218683 98 0.260903 0.0080 0.227603
99 0.233371 99 0.279903 0.0060 0.252683
100 0.249741 100 0.300716 0.0040 0.280909
101 0.268237 101 0.323592 0.0020 0.312764
102 0.289305 102 0.348780 0.0000 0.34878
103 0.313391 103 0.376529 0.0000 0.376529
104 0.340940 104 0.407088 0.0000 0.407088
105 0.372398 105 0.440707 0.0000 0.440707
106 0.408210 106 0.477634 0.0000 0.477634
107 0.448823 107 0.518120 0.0000 0.51812
108 0.494681 108 0.562412 0.0000 0.562412
109 0.546231 109 0.610760 0.0000 0.61076
110 0.603917 110 0.663417 0.0000 0.663417
111 0.668186 111 0.720626 0.0000 0.720626
112 0.739483 112 0.782640 0.0000 0.78264
113 0.818254 113 0.849708 0.0000 0.849708
114 0.904945 114 0.922077 0.0000 0.922077
115 1.000000 115 1.000000 0.0000 1
difference
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000012
0.000017
0.000017
0.000011
0.000000
0.000003
0.000004
0.000005
0.000003
0.000004
0.000003
0.000003
0.000003
0.000004
0.000004
0.000006
0.000007
0.000006
0.000002
-0.000005
0.000000
0.000004
0.000002
-0.000004
-0.000014
-0.000007
0.000000
0.000001
-0.000004
0.000010
-0.000002
-0.000006
-0.000004
0.000004
0.000015
0.000017
0.000017
0.000014
0.000004
-0.000013
-0.000014
-0.000016
-0.000017
-0.000011
0.000002
-0.000011
-0.000020
-0.000030
-0.000044
-0.000062
-0.000035
-0.000012
0.000003
0.000010
0.000005
-0.000009
-0.000025
-0.000027
-0.000002
0.000063
0.000047
0.000039
0.000022
-0.000026
-0.000126
-0.000068
-0.000031
-0.000003
0.000021
0.000054
0.000100
0.000138
0.000150
0.000112
-0.000001
-0.000187
-0.000368
-0.000440
-0.000302
0.000146
0.000070
0.000142
0.000242
0.000239
0.000000
0.000741
0.001203
0.001296
0.000925
0.000000
-0.008920
-0.019312
-0.031168
-0.044527
-0.059475
-0.063138
-0.066148
-0.068309
-0.069424
-0.069297
-0.067731
-0.064529
-0.059500
-0.052440
-0.043157
-0.031454
-0.017132
0.000000