Dxy and Nxy return a commutation function value at joint age 𝑥:𝑦. These functions all share the same syntax:
Syntax
Dxy(AgeX, AgeY, InterestRate, MortalityTableX, [MortalityTableY],
[CalculationMethod], [IssueAge])
Nxy(AgeX, AgeY, InterestRate, MortalityTableX, [MortalityTableY],
[CalculationMethod], [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). |
||||||
|
InterestRate |
The interest rate(s) to discount future
payments to calculate the present value. May be a number, a percentage, a
text string, a named range, or reference to a range. ·
Rates
can be defined using these interest definitions. ·
Note:
A value that is greater than 25% (i.e. 0.25) will be divided by 100; e.g.
if you enter 2.75 it will be treated as .0275 or 2.75%. |
||||||
|
MortalityTableX |
Mortality
table definition text string for primary annuitant 𝑥. |
||||||
|
MortalityTableY |
Mortality
table definition text string for secondary annuitant 𝑦. |
||||||
|
CalculatonMethod |
How to handle fractional ages.
|
||||||
|
IssueAge |
If
using generational mortality projection, age at issue. |