ANNUITYINTRATE

Determines the interest rate for an annuity factor as of the calculation date specified.

Formula Syntax

ANNUITYINTRATE("DefName", CalculationDate, Segment)

DefName: this must be contained within quotes.

CalculationDate: fixed date such as DATE(1,1,2015) or system date such as CALCDATE.

Segment: refer to the following to determine which segment to specify.

0: this is the value to specify unless you want to get one of the segment rates for an annuity that uses segmented rates under PPA.

1: for an annuity factor that uses segmented rates, this will return the first segment rate.

2: for an annuity factor that uses segmented rates, this will return the second segment rate.

3: for an annuity factor that uses segmented rates, this will return the third segment rate.

Examples

ANNUITYINTRATE("annFactor_LS", CALCDATEINPUT, 0): would return the interest rate applicable to the specified annuity factor, annFactor_LS, as of the calculation date.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com