Excel Functions in EAC ToolsExcel Functions in EAC Tools\Life expectancy and survival functionsLife expectancy and survival functions\ProbSurvivalPPA

ProbSurvivalPPA

ProbSurvivalPPA calculates the probability of survival from current age 𝑥 to future age 𝑥 + 𝑛, based on one of the published IRS static mortality tables under 430(h) or 417(e).

Syntax

ProbSurvivalPPA (CurrentAge, FutureAge, Year, MortTableType, [Sex])

Parameter Name

Description

CurrentAge

Current age 𝑥. May be provided as an integer, or as a fractional amount (e.g. years & months).

FutureAge

Future age 𝑥 + 𝑛.

CalcYear

Year of desired IRS table; not before 2008.

MortTableType

This is to select the type of IRS static mortality table under 417(e) or 430(h).

Option

Type of Mortality Table

“ann”

annuitant Table

“non”

non-annuitant Table

“com” (or “small”)

optional combined table for small plans

“app”

applicable table for distributions subject to 417(e)(3)

 

Sex

“m” or “f”; not used if type of table is “Applicable Table” because this is a unisex table.