Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\Social Security functionsSocial Security functions\SSQC

SSQC

SSQC returns Wages Needed for Quarter of Coverage for a given year. Bend points are used in the formula to calculate the Social Security Primary Insurance Amount (PIA). The exempt amounts are determined each year based on changes in the National Average Wage Index.

SSQC for year 𝑥 is based on the following formula:

 

Prior year amounts are published in a historical table.

 

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

More information can be found at the Social Security web site.

Syntax

SSQC (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.

This is used only for a projected calculation.

Optional: default = 0%