GETCATCHUPLIMIT

Determines the DC contribution catchup limit as defined in 414(v)(2)(B)(i) for the year specified assuming the specified increase rate (if year is in the future).

Formula Syntax

GETCATCHUPLIMIT(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

GETCATCHUPLIMIT(YEAR(NRD), 0.035 ) returns the 414(v)(2)(B)(i) catchup limit at NRD assuming an increase rate of 3.5%

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com