GETBENLIMIT

Determines the annual benefit limit as defined in 415(b) for the year specified assuming the specified increase rate (if year is in the future).

Formula Syntax

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

GETBENLIMIT(YEAR(NRD), 0.035 ) returns the benefit limit at NRD assuming an increase rate of 3.5%

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com