IRS functions

Excel Functions

Function Name	Category	Description
Catchup	IRS, DC	414(v)(2)(B)(i) Catch-up Contribution
CatchupSIMPLE	IRS, DC	414(v)(2)(B)(ii) SIMPLE Plan Catch-up Contribution
CompLimit	IRS, DC	401(a)(17) & 404(l) Compensation Cap
Controli	IRS	1.61-21(f)(5)(i) Control Employee – Officer
Controliii	IRS	1.61-21(f)(5)(iii) Control Employee – Other
CovComp	IRS	Covered Compensation
DB415Limit	IRS	415(b)(1)(A) DB Maximum Annuity
DC415Limit	IRS, DC	415(c)(1)(A) DC Maximum Annual Addition
DeferralLimit	IRS, DC	402(g)(1) Elective Deferral Limit
DeferralLimit403	IRS, DC	403(b) Elective Deferral Limit
DeferralLimit457	IRS, DC	457(e)(15) Elective Deferral Limit
DeferralLimitSIMPLE	IRS, DC	408(p)(2)(E) SIMPLE Elective Deferral Limit
ESOPLimitA	IRS	409(o)(1)(C) ESOP Payouts, 5-Year Limit
ESOPLimitB	IRS	409(o)(1)(C) ESOP Payouts, Additional 1-Year Limit
HCEAmount	IRS	414(q)(1)(B) HCE Definition
IRACatchup	IRS, DC	219(b)(5)(B) IRA Catch-up Contribution Limit
IRALimit	IRS, DC	219(b)(5)(A) IRA Contribution Limit
IRSCOLA	IRS	IRS cost-of-living adjustment
KeyAmount	IRS	416(i)(1)(A)(i) Key Employee Compensation Dollar Amount
NonSpousePCT	IRS, DC	1.401(a)(9)-6 Non-spouse JS Percentage Limit
NumExpPay	IRS, DC	IRS Publication 575, Expected Number of Payments
SEPMin	IRS	408(k)(2)(C) SEP Minimum Compensation

Various options for DeterminationYear parameter

DeterminationYear can be entered as a year, or as a text string – the values that can be returned are shown in the following table:

Parameter Name

Description

DeterminationYear

A 4 digit number, or an optional text value as shown in the table below. If the DeterminationYear is after the LawYear, this is a projected calculation based on the Inflation assumption.

The following options for DeterminationYear are available:

Value	Description
Year	· A positive number returns the actual amount for the year. · A negative number returns the unrounded amount for the year.
"next"	The value for the following year that will occur if the rounding “increment” is triggered.
"needed"	The year-over-year CPI ratio (annual inflation) needed in order to trigger next rounding “increment”.
"code"	The Code section and a descriptor of this function.
"irc"	The Code section of this function.
"descr"	A descriptor of this function.
"increment"	For cost of living adjustments: if the unrounded indexed value is not a multiple of the “increment”, then the value is rounded to the next lower multiple of the “increment”.
"base value"	For cost of living adjustments: the value for the “base year” that is to be indexed.
"base year"	For cost of living adjustments: the year of the “base value”.
"base CPI"	For cost of living adjustments: the sum of the CPIs for applicable three months in the base year. This is the denominator in the indexing CPI ratio.