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

SSFactor

SSFactor returns the Social Security reduction factor for early retirement, or the late increase factor for delayed retirement.

·        Early retirement: a benefit is reduced 5/9 of one percent for each month before normal retirement age, up to 36 months. If the number of months exceeds 36, then the benefit is further reduced 5/12 of one percent per month.

·        Delayed retirement: credits are applied according to the following table:

Year of Birth

Credit Per Year for Delayed Retirement

1917-24

3.0%

1925-26

3.5%

1927-28

4.0%

1929-30

4.5%

1931-32

5.0%

1933-34

5.5%

1935-36

6.0%

1937-38

6.5%

1939-40

7.0%

1941-42

7.5%

1943 and later

8.0%

Note: Persons born on January 1 of any year should refer to the credit percentage for the previous year

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

Syntax

SSFactor (Birthdate, CommencementAge)

Parameter Name

Description

Birthdate

Date of birth.

CommencementAge

Age of commencement.