FUTA

Formula

[OpenInputValueBlock]

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

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

IF ("CYTD Total Salary"<= "FUTA Cap")"FUTA Rate" * "Total Salary";

ELSEIF("CYTD Total Salary (Prior)"<= "FUTA Cap")"FUTA Rate" * ("FUTA Cap" - "CYTD Total Salary (Prior)");

ELSE

#MISSING;

ENDIF

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates simple Federal Unemployment Taxes based on a tax region, rate and cap.