Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\IRS functionsIRS functions\KeyAmount

KeyAmount

This function returns the 416(i)(1)(A)(i) Key Employee Compensation dollar amount for a given year. An employee who is an officer of the employer with annual compensation greater than this amount is defined as a key employee.

KeyAmount for year 𝑥 is based on the following formula:

 

Where 𝐶𝑃𝐼𝑦𝑒𝑎𝑟  is the “3rd quarter CPI” (sum of the CPI-U for the months of July, August, and September) in the given year. (September CPI is usual published around October 13.)

If the amount so determined is not a multiple of $5,000, it is rounded to the nearest multiple of $5,000. Not less than the amount for the prior year.

 

Note:

·        Prior to 2002 there was a different limit.

Syntax

KeyAmount (DeterminationYear, [LawYear], [Inflation])

Parameter Name

Description

DeterminationYear

A 4 digit number, or an optional text value as shown in the table below. If the DeterminationYear is after the LawYear, this is a projected calculation based on the Inflation assumption.

Click to view various options for the DeterminationYear parameter.

LawYear

A 4 digit number.
Optional; default =
DeterminationYear

Inflation

The assumed rate of inflation: the IRS Cost-of-Living Adjustment for future years, as measured by the year-over-year increase in CPI-U.

This is used only for a projected calculation.

Optional: default = 0%