LxPPA, PxPPA, QxPPA

LxPPA, PxPPA, QxPPA return a mortality table value at age 𝑥. These are based on one of the published IRS static mortality tables under 430(h) or 417(e). These functions all share the same syntax:

Syntax

LxPPA (Age, CalcYear, MortTableType, [Sex])
PxPPA (Age, CalcYear, MortTableType, [Sex])
QxPPA (Age, CalcYear, MortTableType, [Sex])

Parameter Name

Description

Age

Current 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.