GETEARLYADJUST

Actuarially reduces an annuity from the normal date to the early date.

Note: 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

GETEARLYADJUST(EarlyDate, NormalDate, BasisDate, "AnnuityDef", Method)

  • EarlyDate: the date to which the reduction is applied.
  • NormalDate: the date from which to reduce.
  • 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 reduced. This name must be enclosed in quotes.
  • Method: indicates which method should be used when developing the reduction 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
  • GETEARLYADJUST(ACD, NRD, ACD, "annuity_LRF", 3): returns a reduction factor from NRD to ACD.
Related Topics
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com