SSMax - EAC Tools -- User Guide

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

SSMax

SSMax returns the maximum Social Security benefit amount for commencement in a given year, assuming the following:

Assumption	Parameter for SocSec Function
Attainment of Social Security Normal Retirement Age in the given year	Birthdate = SSDOBofSSNRAinYear(Year).
Commencement of Social Security benefit at the Social Security Normal Retirement Age	StartDate = SSNormalRetAge(Birthdate)
Quit working at the Social Security Normal Retirement Age.	QuitDate = SSNormalRetAge(Birthdate)
Earnings history equal to the WageBase for every year	EarningsAmount = “max”

Syntax

SSMax (Year)

Parameter Name	Description
Year	Year, not later than the “current law year” = WBTableYear, depending on the most recently available CPI-U date.