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

PVPBGCMax

PVPBGCMax returns the present value of the PBGC maximum guaranteed benefit under IRC Section 436(d)(3)(A)(ii) and ERISA 206(g)(3)(C)(i)(II).

The amounts are determined each year by PBGC in accordance with methodology provided in Technical Update 07-4.

More information can be found at the PBGC web site:

·        Present Value of PBGC Maximum Guarantee

·        Maximum Monthly Guarantee Tables

Syntax

PVPBGCMax (DeterminationYear, LawYear, Age, [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

Age

The annuitant’s age. Must be a whole number.

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%