Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\PBGC functionsPBGC functions\PBGCPremium, PBGCPremiumCap, PBGCPremiumME, PBGCPremiumVar

PBGCPremium, PBGCPremiumCap, PBGCPremiumME, PBGCPremiumVar

These functions all share the same parameters:

·        PBGCPremium returns the PBGC single-employer flat rate premium amount.

·        PBGCPremiumCap returns the PBGC single-employer variable rate premium per participant cap.

·        PBGCPremiumME returns the PBGC multiemployer flat rate premium amount.

·        PBGCPremiumVar returns the PBGC single-employer variable rate premium amount.

More information can be found at PBGC web site.

Syntax

PBGCPremium (DeterminationYear, LawYear, [WageInflation])

PBGCPremiumCap (DeterminationYear, LawYear, [WageInflation])

PBGCPremiumME (DeterminationYear, LawYear, [WageInflation])

PBGCPremiumVar (DeterminationYear, LawYear, [WageInflation])

Parameter Name

Description

DeterminationYear

A 4 digit number. If the DeterminationYear is after the LawYear, this is a projected calculation based on the WageInflation assumption.

LawYear

A 4 digit number.
Optional; default =
DeterminationYear

WageInflation

The assumed rate of increase in the National Average Wage, used to project the Wage Based (old) at the DeterminationYear.

This is used only for a projected calculation.

Optional: default = 0%