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

PBGC functions

Excel Functions

Function Name

Category

Description

PBGCMax

PBGC

PBGC maximum monthly guaranteed benefit

PBGCMax50JS

PBGC

PBGC maximum monthly guaranteed benefit for a 50% joint & survivor annuity

PBGCPremium

PBGC

PBGC single-employer flat rate premium amount

PBGCPremiumCap

PBGC

PBGC single-employer variable rate premium cap

PBGCPremiumME

PBGC

PBGC multiemployer flat rate premium amount

PBGCPremiumVar

PBGC

PBGC single-employer variable rate premium amount

PBGCXRACategory

PBGC

PBGC expected retirement age category (low, medium, high) for ERISA section 4044 calculations

PBGCXRAge

PBGC

PBGC expected retirement age for ERISA section 4044 calculations

PVPBGCMax

PBGC

Present value of the PBGC maximum guaranteed benefit