Lxy, Pxy, Qxy return a mortality table function value at joint age 𝑥:𝑦. These functions all share the same syntax:
In practice, the
constant 𝑘
is generally taken to be some power of 
,
so that 
is not such a large number. For the purposes
of this add-in, we use 
.
Syntax
Lxy(AgeX, AgeY, MortalityTableX, [MortalityTableY],
[IssueAge])
Pxy(AgeX, AgeY, MortalityTableX, [MortalityTableY], [IssueAge])
Qxy(AgeX, AgeY, MortalityTableX, [MortalityTableY], [IssueAge])
|
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 𝑦. |
|
IssueAge |
If using generational mortality
projection, age at issue. |