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.
Related Topics
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com