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).

CommencementAge

Age of annuitant at benefit commencement.

·       If CommencementAge > CurrentAge then it will be valued as a deferred annuity.

·       If CommencementAge is missing or zero, then CommencementAge is assumed to be = CurrentAge and it will be valued as an immediate annuity

LevelAge

Age at which amount of annuity changes for the leveling option.

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.

YearsCertain

Number of years guaranteed payments. May be an integer, or a factional amount (e.g. years & months).
Optional, default = 0

AgeSetback

Mortality table age set-back. A negative number is a set-forward.
Note that you can also define a setback using the "/sb" option in the table definition (or "/sf").
Optional, default = 0.

Frequency

Number of payments per year:
Optional, default = 12

COLA

Periodic cost-of-living adjustment applied to the benefit amount.
Optional, default = 0
Rates can be defined using these COLA definitions.

CalculationMethod

Method of calculation
Optional, default = 0

NoPreRetMort

The defines the application of pre-retirement mortality for a deferred annuity.
Optional, default = 0.

StopAge

Age when the annuity benefit stops -- no payment at this age.
Optional, default = to end of the mortality table.

AnnTiming

Defines when the payments are made in the period.
Optional, default = 0.