CAFINTRATE

Determines the interest rate for a CAF factor as of the calculation date specified.

Formula Syntax

CAFINTRATE("DefName", CalculationDate, Segment)

DefName: this must be contained within quotes.

CalculationDate: fixed date such as DATE(1,1,2010) 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

CAFINTRATE("CAF_50JS", ACD, 1): returns the first segment interest rate for the CAF names CAF_50JS.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com