GETDCDEFLIMIT

Returns the DC elective deferral limit as defined in 402(g)(1) for the year specified.

Formula Syntax

GETDCDEFLIMIT(Year, IncreaseRate)

Year: the year of the desired compensation limit.

IncreaseRate: the annual assumed increase rate for the unrounded limit (for example, 3.5% should be specified as 0.035).

Examples

GETDCDEFLIMIT(YEAR(NRD), 0.035) returns the 402(g)(1) catchup limit at NRD assuming an increase rate of 3.5%

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com