Updated Articles

  1. Cycle 3 Restatement

    Cycle 3 Restatement
  2. How To...

    This section presents the condensed general process, scenarios for various situations, and helpful hints. A. General Process This is a summary of the general process for every proposal. The additional scenarios below use this general process, al...
  3. Quick Start Guide

    This guide is intended to give a quick tour of how the ftwilliam.com DB Proposal Module works. If you have additional questions, please contact support by clicking the drop-down box in the upper right corner of the software that displays your userna...
  4. FTW Step 12: Year-End Processing & Compliance Testing

    Prior to running compliance tests: For EOY valuations: Be sure data for the DB plan through year-end is already current. This should already include combo plan data from a DC plan per the last section of  Step 10  above. If it was not added pr...
  5. FTW Step 11: Valuation Liabilities for Replication / First Year Valuation

    Scrub task parameters  – The override parameters should reset each year to 'No' and this is generally what you want for ongoing processing after the conversion year. There are times when you may want to override calculations in years after convers...
  6. FTW Step 10: Census Data for Replication Year & ongoing years

    Primary Grid for census data  – In the Census tab, verify that the  Primary Grid is set to * ftw DB Census Collection (ce207db) . This will automatically update from the conversion year if you used the standard conversion grid in the prior year. I...
  7. FTW Step 9: Set Actuarial Assumptions

    Valuation methods & assumptions  – Complete the 'Specifications > Actuarial Methods & Assumptions' sections. Other than segment rates that are determined automatically each year, the assumptions will carry-forward from year-to-year unless you make...
  8. FTW Step 8: Add next Plan Year

    Add Year End  - In the top-right corner of the DB Compliance screen, click the drop down for Year End and select Add Year End. This will create a plan year following the Conversion Year. For an ongoing plan , this year will be for the  purpose ...
  9. FTW Step 7: Run Scrub for Conversion Year

    Click on the 'DB Compliance Tasks' tab Data overrides  – The conversion process assumes certain pre-calculated data exists. The overrides shown below are automatically set to Yes to bypass calculations and rely on the data provided. You can see t...
  10. FTW Step 6: Additional Conversion Data & Compensation History

    Add compensation history Compensation history is essential for the following reasons: Determining the correct IRC 415 final average compensation for highly compensated individuals for both CB and DB plans, and Determining final average compe...