GETCOMPLIMIT

Determines the annual compensation limit as defined in 401(a)(17) for the year specified assuming the specified increase rate (if year is in the future).

Formula Syntax

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

GETCOMPLIMIT(YEAR(NRD), 0.035 ) returns the 401(a)(17) compensation limit at NRD assuming an increase rate of 3.5%

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com