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

LifeExpectJL

LifeExpectJL calculates the life expectancy for two lives 𝑥 and 𝑦, based on the mortality assumption. You can calculate either joint life expectancy or last survivor life expectancy.

Syntax

LifeExpectJL (CurrentAgeX, CurrentAgeY, MortalityTableX, MortalityTableY, [TypeOfCalc])

Parameter Name

Description

AgeX

Current age of the primary annuitant 𝑥 (i.e. the age at the valuation date). May be provided as an integer, or as a fractional amount (e.g. years & months).

AgeY

Current age of the secondary annuitant 𝑦 (i.e. the age at the valuation date). May be provided as an integer, or as a fractional amount (e.g. years & months).

MortalityTableX

Mortality table definition text string for primary annuitant 𝑥.

MortalityTableY

Mortality table definition text string for secondary annuitant 𝑦.
Optional, default = MortalityTableX.

TypeOfCalc

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

Type

Description

0
or
“xy”

complete joint life expectancy

curtate joint life expectancy + 1/2

 + ½

1

curtate joint life expectancy

2

complete last survivor life expectancy

“x”

complete life expectancy for 𝑥

“y”

complete life expectancy for 𝑦