GETMORTRATE

Returns mortality rates for the Actuarial Equivalence Definition of a specified Annuity Factor Definition.

Formula Syntax

GETMORTRATE("DefName", CalculationDate, AgePart, Type, AgeCA (optional))

"DefName": the name of the Annuity Factor Definition that includes the mortality table to use. Note that this name must be contained in quotes.

CalculationDate: date upon which the rate is to be determined (applicable for floating 417 basis or definitions that include projections).

AgePart: the age of the participant for looking up the rate.

Type: 0: Participant mortality, 1: Beneficiary mortality, 2: joint mortality (probability both participant and beneficiary die).

AgeCA (optional): the age of the beneficiary at which point the rate should be determined. Leave blank or zero if not determining joint life mortality.

Examples

GETMORTRATE("LSFactor", CALCDATE, 55, 0): Will return the participant mortality rate of the table used in the Actuarial Equivalence Definition, LSFactor at age 55.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com