Social Security Tax

Formula

[OpenInputValueBlock]

IF (NOT @ISUDA([Dimension("DIM_NAME_SCENARIO")], "ACTUAL"))

IF ("Tax Region" == [TaxRegion.USA])

IF ("CYTD Total Salary"<= "SSTax Cap")"SSTax Rate1" * "Total Salary";

ELSEIF("CYTD Total Salary (Prior)"<= "SSTax Cap")"SSTax Rate1" * ("SSTax Cap" - "CYTD Total Salary (Prior)") + "SSTax Rate2" * ("CYTD Total Salary" - "SSTax Cap");

ELSE"SSTax Rate2" * "Total Salary";

ENDIF

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates simple Social Security Taxes (FICA) based on a tax region, rate and cap.