Life expectancy, or the expectation of life, is the average future lifetime for a person aged 𝑥. It is based on the probability of survival from the current age 𝑥 to each future age from age 𝑥 + 1 to the end of the mortality table.
Excel Functions
|
Function
Name |
Category |
Description |
|
Life expect |
Age at death for a given probability of
survival |
|
|
Life expect |
Expected age at death = age + life exp |
|
|
Life expect |
Expected age at death = age + life exp |
|
|
Life expect |
IRS Table I Single Life Expectancy (for
RMD pre 2022) |
|
|
Life expect |
IRS Table II Joint Life and Last
Survivor Expectancy (for RMD pre 2022) |
|
|
Life expect |
IRS Table III Uniform Lifetime (for RMD
pre 2022) |
|
|
Life expect |
IRS Joint and Last Survivor Table (for
RMD 2022+) |
|
|
Life expect |
IRS Single Life Table (for RMD 2022+) |
|
|
Life expect |
IRS Uniform Lifetime Table (for RMD
2022+) |
|
|
Life expect |
Life expectancy |
|
|
Life expect |
Life expectancy -- joint life |
|
|
Life expect |
Life expectancy (with PPA mortality) |
|
|
Life expect |
Probability of survival = |
|
|
Life expect |
Probability of survival (with PPA
mortality) = |
|
|
Life expect |
Probability of survival due to turnover |
