Parameter Name

Description

CurrentAge

Current age of the annuitant (i.e. the age at the valuation date). May be provided as an integer, or as a fractional amount (e.g. years & months). If the age is not a whole number, the result is based on interpolation on results at whole ages.

InterestRate1

Segment rate 1 -- to discount payments made during the first 5 years (years 1 to 5). Must be a single number.

·       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%.

InterestRate2

Segment rate 2 -- to discount payments made during the next 15 years (years 6 to 20).

InterestRate3

Segment rate 3 -- to discount payments made after the first 20 years (years 21 and later).

CalcYear

The IRS table year, i.e. for distributions subject to § 417(e)(3) with annuity starting dates during stability periods beginning in CalcYear.

MortTableType

The type of static mortality table to use:

Sex

“m” or “f”; not used if type of table is “Applicable Table” because this is a unisex table.

Term

Number of years for term insurance. May be an integer, or a factional amount (e.g. years & months).
If Term is not a whole number, then the function will interpolate on results for whole numbers.
Optional, default = whole life.

Increasing

TRUE or FALSE to define an increasing life insurance.
Optional, default = FALSE.

InsTiming

Defines when the payments are made in the year of death.
Optional, default = 1.