Valuation Setup Cheat Sheet

Use the settings below to reproduce the calculation treatment required for your valuation.

Setup Mappings

Table lookup and age/service measurement settings are on the Decrements tab of the sponsor’s Valuation Assumption Provision. Apply the lookup settings to both Decrement Table Rate Lookup and Salary Scale Rate Table Lookup, where applicable. Table lookup rounding does not set eligibility or annuity-factor ages.

Input or calculationDBP setup
Age and service use a fixed 366-day calendar. Age/Service Measurement: Years, Days (366)
Age-based tables use age nearest birthday. Age Rounding: Nearest in both Decrement Table Rate Lookup and Salary Scale Rate Table Lookup.
Birth and hire dates are supplied, with no separate service input. Service Determination: Hire Date
Service Rounding: Nearest
Service is reported as a start date. If that date is DBP’s first employment date:
Service Determination: Hire Date
Service Rounding: Truncated
Service is supplied as a value or service definition. Service Determination: the Participation, Credited, or Vesting Service Definition that reproduces that service.
Service Rounding: Truncated
Service includes fractional years without rounding. In each applicable Service Provision:
Round Type: None
Each benefit’s EAN funding period ends with its last benefit-producing event. For each applicable active benefit item, on its Attribution tab:
Attribution Stop Date: Final decrement date

Frequent Scenarios

Reconstructing Employee Contributions

To project employee contributions backward using a rate implied by a reported contribution balance:

  1. Create an Account Definition that accumulates total salary paid through the valuation date.
  2. Calculate the implied rate as the reported contribution balance divided by that accumulated salary.
  3. Use the implied rate in a separate Account Definition to reconstruct historical contributions.
  4. From the valuation date forward, use the configured future contribution rate.

Replacing a Stored Inactive Benefit

When a benefit item replaces a stored inactive benefit, use the provision’s Inactive Benefit Override Filter to identify the affected population and set Annual Benefit to 0. This excludes the stored benefit from valuation so the replacement benefit item supplies the payment.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com