Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\PBGC functionsPBGC functions\PBGCXRAge

PBGCXRAge

PBGCXRAge returns the PBGC expected retirement age for ERISA section 4044 calculations.

More information can be found at PBGC web site.

Syntax

PBGCXRAge (YOB, ERA, URA, MonthlyBenefit, [HighCategoryOverride], [ValuationYear])

PBGCXRACategory (YOB, ERA, URA, MonthlyBenefit, [HighCategoryOverride], [ValuationYear])

Parameter Name

Description

YOB

Participant's year of birth.

ERA

Participant's earliest retirement age.

Must be from 30 to 80.

URA

Participant's unreduced retirement age.

Must be from 40 to 80, not less than ERA.

MonthlyBenefit

Monthly amount of pension benefit payable to the participant and commencing at the ERA.

HighCategoryOverride

TRUE=

HighCategoryOverride

Description

TRUE

The "high" benefit category will be used.

FALSE

The appropriate benefit category will be used.

Default = FALSE.

ValuationYear

The calendar year in which the actuarial valuation date occurs.