Formula Functions Available in Excel
Below is a list of the formula functions that are available in Excel after enabling this Add-in:
ANNFACTOR_BYAGE:
returns an annuity factor by age.
ANNFACTOR_BYDATE:
returns an annuity factor by date.
CONVFACTOR_BYAGE:
returns an actuarial conversion factor by age.
CONVFACTOR_BYDATE
returns an actuarial conversion factor by date.
COMVAL_BYAGE:
returns a commutation function value by age.
COVCOMP:
calculates Covered Compensation as defined in 401(l)(5)(E) of the Internal Revenue Code.
EARLYFACTOR:
returns an actuarially equivalent reduction factor for early retirement.
LATEFACTOR:
returns an actuarially equivalent increase factor for late retirement.
LIFEEXPECT_BYAGE:
returns life expectancy by age.
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com