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

LifeExpectPPA

LifeExpectPPA calculates the life expectancy for a life 𝑥 based on one of the published IRS static mortality tables under 430(h) or 417(e).

Syntax

LifeExpectPPA (CurrentAge, Year, MortTableType, [Sex], [TypeOfCalc])

Parameter Name

Description

CurrentAge

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

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.

TypeOfCalc

Type of life expectancy calculation.
Optional, default = 0.

Type

Description

0

complete joint life expectancy

curtate joint life expectancy + 1/2

 + 1/2

1

curtate joint life expectancy