Parameter Name

Description

WhatFunction

What commutation function to calculate. The following items are valid:

“Cx”, “Dx”, “Mx”, “Nx”, “Rx”, “Sx” (or “C”, “D”, “M”, “N”, “R”, “S”)

Age

Age 𝑥. 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%.

MortalityTable

Mortality table definition text string.
Optional, default = none

Frequency/InsTiming

·        For Dx: this parameter does not apply

·        For Nx and Sx this is the frequency of the annuity payment: 1=annual; 2=semi-annual; 4=quarterly; 6=bi-monthly; 12=monthly; 99=continuous
Optional, default = 12

·        For Cx, Mx, and Rx this is the timing of the insurance payment: 0=mid-year; 1=end of year
Optional, default = 1

CalculationMethod

Method of calculation for fractional ages.
Optional, default = 0

IssueAge

If using generational mortality projection, age at issue.
Optional, default = Age.