GETLATEADJUST

Actuarially accumulates an annuity from the start date to the end date.

Do not use this function if the underlying actuarial basis uses segment rates. For these calculations, you should instead use a ratio of annuity factors.

Formula Syntax

GETLATEADJUST(StartDate, EndDate, BasisDate, "AnnuityDef", Method)

StartDate: the date from which to accumulate.

EndDate: the date to which to accumulate.

BasisDate: the date on which actuarial equivalence should be determined (only applies if actuarial basis uses variable interest or mortality).

"AnnuityDef": name of the annuity factor that specifies the payment parameters of the annuity being accumulated. This name must be enclosed in quotes.

Method: indicates which method should be used when developing the accumulation factor as follows:

  • 0: Mortality and Interest
  • 1: Interest Only
  • 2: Mortality but only interest during the accumulation period
  • 3: Ratio of Nx
  • 4: Interpolated integer-age increase factors
Examples

GETLATEADJUST(NRD, ACD, ACD, "annuity_LRF", 2) returns an accumulation factor from ACD to NRD.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com