The Other tab on the Export Screen allows users to enter additional values used by plan formulas and defined contribution calculations. The values entered on this tab apply to the current export.
- User rates:
- Rate 1, Rate 2, and Rate 3: numeric values available to plan formulas through the USERRATE1, USERRATE2, and USERRATE3 operands. The labels may be replaced with plan-specific wording to describe the value expected by the plan. Enter a percentage as a decimal when required by the applicable formula (for example, enter 0.06 for 6%).
Note: User rates can be referenced in plan formulas using the USERRATE operands.
- User values:
- Value 1 through Value 10: additional user-entered values available to plan formulas through the USERVALUE1, USERVALUE2, and corresponding USERVALUE operands. Depending on the plan design, a user value may represent an amount, number, date, or other numeric input. The labels may be replaced with plan-specific wording to identify the value expected by the plan.
Note: User values can be referenced in plan formulas using the USERVALUE operands.
- Defined contribution:
- Employee Contribution Rate: the participant contribution rate to use for defined contribution calculations. Enter the rate as a decimal (for example, enter 0.06 for 6%).
- Asset Rate of Return: the annual investment return assumption to use when projecting defined contribution amounts. Enter the rate as a decimal (for example, enter 0.07 for 7%).
- DC Account Balance: the participant's defined contribution account balance to use in the export calculation.
- As of Date: the date on which the DC Account Balance was measured. When an account balance is entered, make sure the corresponding date is also correct.
Note: Defined contribution inputs can be retrieved in plan formulas using the GETCALCINPUT function.
- Filter Formula: Specifies the criteria participants must meet to be included in the export.
- Store inputs in Calculation History: Stores all calculation inputs, including assumptions and values entered on the Other tab, so they can be retrieved later.
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com