|
Function Name |
Category |
Description |
|
DC |
Projected DC account balance |
|
|
BLS |
Inflation adjustment factor (based on
CPI-U) |
|
|
AE |
Actuarial equivalent factor for early & late commencement. |
|
|
AE |
Actuarial equivalent factor for early commencement. |
|
|
AE |
Actuarial equivalent factor for late commencement. |
|
|
AE |
Actuarial equivalent factor to convert a single life annuity
to a certain & life annuity. |
|
|
AE |
Actuarial equivalent factor to convert a single life annuity
to a joint life annuity. |
|
|
AE |
Actuarial equivalent factor to convert a single life annuity
to a joint life annuity with certain period. |
|
|
AE |
Actuarial equivalent factor to convert a single life annuity
to a level income annuity. |
|
|
Age and date |
Age in complete years and months --
months portion |
|
|
Life expect |
Age at death for a given probability of
survival |
|
|
Age and date |
Convert a numerical age to text |
|
|
Age and date |
Convert a numerical age to text |
|
|
Age and date |
Age in complete years and months --
years portion |
|
|
Age and date |
Age in complete years and months |
|
|
Regulatory |
A multi-purpose function that returns the result of one of
the many regulatory functions that are available |
|
|
Interest |
Function to return any available rate |
|
|
Single
life |
Present value of single life cash refund annuity |
|
|
Single
life |
Present value of single life cash refund annuity -- according to
Jordan |
|
|
Joint life |
Present value of joint life cash refund
annuity |
|
|
Single
life |
Present value of single life cash refund annuity -- simplified parameters with PPA
interest and mortality |
|
|
IRS, DC |
414(v)(2)(B)(i) Catch-up Contribution |
|
|
IRS, DC |
414(v)(2)(B)(ii) SIMPLE Plan Catch-up Contribution |
|
|
IRS, DC |
401(a)(17) & 404(l) Compensation Cap |
|
|
IRS |
1.61-21(f)(5)(i) Control Employee – Officer |
|
|
IRS |
1.61-21(f)(5)(iii) Control Employee – Other |
|
|
IRS |
Covered Compensation |
|
|
BLS |
CPI-U All Urban Consumers |
|
|
BLS |
Sum of 3rd quarter CPI-U (July + August
+ September) |
|
|
BLS |
CPI-W Urban Wage Earners and Clerical
Workers |
|
|
Commutation |
Commutation function |
|
|
Commutation |
Commutation function |
|
|
Age and date |
Date addition |
|
|
Age and date |
Convert a numeric age to a date |
|
|
Age and date |
Convert a date to text (m/d/yyyy) |
|
|
Age and date |
Convert a date to text (mmmm d, yyyy) |
|
|
IRS |
415(b)(1)(A) DB Maximum Annuity |
|
|
IRS, DC |
415(c)(1)(A) DC Maximum Annual Addition |
|
|
Life ins |
Present value of decreasing life
insurance |
|
|
Life ins |
Present value of decreasing joint life
insurance |
|
|
Life ins |
Present value of decreasing life
insurance (with PPA int and mort) |
|
|
IRS, DC |
402(g)(1) Elective Deferral Limit |
|
|
IRS, DC |
403(b) Elective Deferral Limit |
|
|
IRS, DC |
457(e)(15) Elective Deferral Limit |
|
|
IRS, DC |
408(p)(2)(E) SIMPLE Elective Deferral Limit |
|
|
Commutation |
Commutation function |
|
|
Commutation |
Commutation function |
|
|
Life expect |
Expected age at death = age + life exp |
|
|
Life expect |
Expected age at death = age + life exp |
|
|
More PV |
Explanation of the referenced EAC
function |
|
|
Single
life |
Effective interest rate for single life annuity |
|
|
Single
life |
Effective interest rate for single life annuity – simplified
parameters |
|
|
Age and date |
Elapsed time in complete years and
months |
|
|
IRS |
409(o)(1)(C) ESOP Payouts, 5-Year Limit |
|
|
IRS |
409(o)(1)(C) ESOP Payouts, Additional 1-Year Limit |
|
|
IRS |
414(q)(1)(B) HCE Definition |
|
|
Interest |
Interest rate description |
|
|
Interest |
Interest discount |
|
|
IRS, DC |
219(b)(5)(B) IRA Catch-up Contribution Limit |
|
|
IRS, DC |
219(b)(5)(A) IRA Contribution Limit |
|
|
IRS |
IRS cost-of-living adjustment |
|
|
Life expect |
IRS Table I Single Life Expectancy (for
RMD pre 2022) |
|
|
Life expect |
IRS Table II Joint Life and Last
Survivor Expectancy (for RMD pre 2022) |
|
|
Life expect |
IRS Table III Uniform Lifetime (for RMD
pre 2022) |
|
|
Life expect |
IRS Joint and Last Survivor Table (for
RMD 2022+) |
|
|
Life expect |
IRS Single Life Table (for RMD 2022+) |
|
|
Life expect |
IRS Uniform Lifetime Table (for RMD
2022+) |
|
|
IRS |
416(i)(1)(A)(i) Key Employee Compensation Dollar Amount |
|
|
Life expect |
Life expectancy |
|
|
Life expect |
Life expectancy -- joint life |
|
|
Life expect |
Life expectancy (with PPA mortality) |
|
|
Life ins |
Net single premium for life insurance |
|
|
Life ins |
Net single premium for joint life
insurance |
|
|
Life ins |
Net single premium for life insurance
(with PPA int and mort) |
|
|
Commutation |
Survivorship |
|
|
Commutation |
Survivorship (with PPA mortality) |
|
|
Commutation |
Joint survivorship |
|
|
Med tax rate |
Medicare tax rate (HI) for employees |
|
|
Med tax rate |
Medicare tax rate (HI) for employers |
|
|
Med tax rate |
Medicare tax rate (HI) for self-employed workers |
|
|
More PV |
Mortality table description |
|
|
More PV |
Mortality improvement factor |
|
|
More PV |
Mortality improvement factor – short |
|
|
Single
life |
Canadian section 8517 present value factor |
|
|
Commutation |
Commutation function |
|
|
Commutation |
Commutation function |
|
|
SocSec |
National average wage index |
|
|
Single
life |
Single life level endowment factor |
|
|
IRS, DC |
1.401(a)(9)-6 Non-spouse JS Percentage Limit |
|
|
IRS, DC |
IRS Publication 575, Expected Number of Payments |
|
|
Commutation |
Commutation function |
|
|
Commutation |
Commutation function |
|
|
PBGC |
PBGC maximum monthly guaranteed benefit |
|
|
PBGC |
PBGC maximum monthly guaranteed benefit for a 50% joint &
survivor annuity |
|
|
PBGC |
PBGC single-employer flat rate premium amount |
|
|
PBGC |
PBGC single-employer variable rate premium cap |
|
|
PBGC |
PBGC multiemployer flat rate premium amount |
|
|
PBGC |
PBGC single-employer variable rate premium amount |
|
|
PBGC |
PBGC
expected retirement age category (low, medium, high) for ERISA section 4044
calculations |
|
|
PBGC |
PBGC expected retirement age for ERISA section 4044 calculations |
|
|
Single
life |
Pre-retirement discount: interest, mortality, termination |
|
|
Life expect |
Probability of survival = |
|
|
Life expect |
Probability of survival (with PPA
mortality) = |
|
|
Life expect |
Probability of survival due to turnover |
|
|
More PV |
Mortality improvement factor at age 𝑥
= |
|
|
Period certain |
Present value of a period certain annuity |
|
|
Period certain |
Present value of a period certain annuity -- simplified parameters with PPA
interest and mortality |
|
|
Joint life |
Present value of joint life annuity |
|
|
Joint life |
Present value of joint life annuity --
simplified parameters |
|
|
Joint life |
Present value of joint life annuity --
simplified parameters with mortality = GAM83 |
|
|
Joint life |
Present value of joint life annuity --
simplified parameters with mortality = GATT2003 |
|
|
Joint life |
Present value of joint life level
income annuity |
|
|
Joint life |
Present value of joint life annuity --
simplified parameters with PPA interest and mortality |
|
|
Joint life |
Present value of joint life annuity --
simplified parameters with mortality = UP84 |
|
|
Joint life |
Present value of joint life annuity --
alternative setup |
|
|
Joint life |
Present value of joint life annuity
with certain period – general formula |
|
|
Single
life |
Present value of single life level income annuity --
multi-purpose function |
|
|
PBGC |
Present value of the PBGC maximum guaranteed benefit |
|
|
Single
life |
Present
value of single life annuity |
|
|
Single
life |
Present
value of single life annuity -- simplified parameters |
|
|
Single
life |
Present
value of single life annuity -- simplified parameters with mortality = GAM83 |
|
|
Single
life |
Present
value of single life annuity -- simplified parameters with mortality =
GATT2003 |
|
|
Single
life |
Present value of single life level income annuity |
|
|
Single
life |
Present
value of single life annuity -- simplified parameters with PBGC interest and
mortality |
|
|
Single
life |
Present
value of single life annuity -- simplified parameters with PPA interest and
mortality |
|
|
Single
life |
Present
value of single life annuity -- simplified parameters with mortality = UP84 |
|
|
Commutation |
Probability of survival |
|
|
Commutation |
Probability of survival (with PPA mortality) |
|
|
Commutation |
Joint Probability of survival |
|
|
Commutation |
Probability of death |
|
|
Commutation |
Probability of death (with PPA mortality) |
|
|
Commutation |
Joint Probability of death |
|
|
Interest |
120% Federal Mid-term Rate |
|
|
Commutation |
Commutation function |
|
|
Interest |
Minimum present value segment rate |
|
|
Interest |
Minimum present value segment rates: 3
rates in a text string |
|
|
Interest |
Minimum present value segment rates in
a long text string |
|
|
Interest |
Minimum present value segment rate
(alternative function) |
|
|
IRS |
408(k)(2)(C) SEP Minimum Compensation |
|
|
Commutation |
Various single life commutation functions |
|
|
Single
life |
Calculates various single life mortality
functions |
|
|
SocSec |
Social Security benefit calculation |
|
|
Interest |
Spot rate from yield curve |
|
|
SocSec |
Social Security bend point 1 in PIA
formula |
|
|
SocSec |
Social Security bend point 2 in PIA
formula |
|
|
SocSec |
Social Security bend point 1 in Maximum
Family Benefit formula |
|
|
SocSec |
Social Security bend point 2 in Maximum
Family Benefit formula |
|
|
SocSec |
Social Security bend point 3 in Maximum
Family Benefit formula |
|
|
SocSec |
Social Security cost-of-living adjustment |
|
|
SocSec |
Social Security coverage threshold for
domestic employees |
|
|
SocSec |
Social Security coverage threshold for
election workers |
|
|
SocSec |
Birth date of a person attaining SSNRA
in year |
|
|
SocSec |
Social Security early retirement age |
|
|
SocSec |
Social Security early retirement date |
|
|
SocSec |
Social Security early retirement age |
|
|
SocSec |
Higher exempt amount under the earnings test |
|
|
SocSec |
Lower exempt amount under the earnings test |
|
|
SocSec |
Social Security reduction factor for early retirement, or the
late increase factor for delayed retirement |
|
|
SocSec |
Social Security full retirement age
(same as SSNRA) |
|
|
SocSec |
Social Security maximum benefit |
|
|
Other |
Convert Social Security number to text
with dashes |
|
|
SocSec |
Social Security normal retirement age |
|
|
SocSec |
Social Security normal retirement date |
|
|
SocSec |
Social Security Normal Retirement Age |
|
|
SocSec |
Wages needed for a quarter of coverage |
|
|
SocSec |
Substantial gainful activity amount – blind |
|
|
SocSec |
Substantial gainful activity amount - nonblind |
|
|
SocSec |
Social Security tax rate (OASDI) for employees |
|
|
SocSec |
Social Security tax rate (OASDI) for employers |
|
|
SocSec |
Social Security tax rate (OASDI) for self-employed workers |
|
|
Commutation |
Commutation function |
|
|
Interest |
1-Year Treasury Rate (average all
business days in month) |
|
|
Interest |
3-Year Treasury Rate (average all
business days in month) |
|
|
Interest |
5-Year Treasury Rate (average all
business days in month) |
|
|
Interest |
10-Year Treasury Rate (average all
business days in month) |
|
|
Interest |
10-Year Treasury Rate (first business
day in month) |
|
|
Interest |
30-Year Treasury Rate (average all
business days in month) |
|
|
TRate30IRS |
Interest |
30-Year Treasury Rate (IRS 30-yr TSR) (average
all business days in month) |
|
SocSec |
Social Security contribution and
benefit base |
|
|
SocSec |
Medicare Hospital Insurance taxable
wage base |
|
|
SocSec |
Social Security “old-law” contribution
and benefit base |
|
|
SocSec |
Most recent year in the Social Security wage base table |
|
|
Commutation |
Probability of termination |
