PE/Win Navigation for DB Plans Kim Roberts, QPA, APA John Baratka, - PDF document

DB/Win Navigation 12/10/2009 PE/Win Navigation for DB Plans Kim Roberts, QPA, APA John Baratka, EA Agenda � Layout and Navigating � Levels � Calculating � Printing � Searching/Sorting: Plans and Employees (c) 2009 DATAIR 1

DB/Win Navigation 12/10/2009 Navigation � Multiple ways to Navigate – Generally 3 ways to accomplish task – Command Line – List Bar – Folder View Navigation (c) 2009 DATAIR 2

DB/Win Navigation 12/10/2009 Navigation Levels � 3 main levels for Defined Benefit – Plan – Sources – Employee (c) 2009 DATAIR 3

DB/Win Navigation 12/10/2009 Navigation Plan Level (c) 2009 DATAIR 4

DB/Win Navigation 12/10/2009 Plans|Dates Plans|Provisions|Eligibility (c) 2009 DATAIR 5

DB/Win Navigation 12/10/2009 Plans|Provisions|Comp Plans|Provisions|AvgComp (c) 2009 DATAIR 6

DB/Win Navigation 12/10/2009 Plan|Provisions|Limits/TH Plan|Provisions|Limits/TH (c) 2009 DATAIR 7

DB/Win Navigation 12/10/2009 Plan|Provisions|Vesting Plan | Provisions | Retirement (c) 2009 DATAIR 8

DB/Win Navigation 12/10/2009 Plan | Assumptions | Pre-retirement Plan | Assumptions | Post-retirement (c) 2009 DATAIR 9

DB/Win Navigation 12/10/2009 Plan | Assumptions | Post-retirement Plan | Assumptions | Post-retirement � Default from transfer from DOS – Uses commutation functions � Yield Curve (c) 2009 DATAIR 10

DB/Win Navigation 12/10/2009 Plan | Assumptions | Post-retirement � Drop down for Look back month – Rates automatically entered Plan | Assumptions | 410(b) / 401(a)(4) (c) 2009 DATAIR 11

DB/Win Navigation 12/10/2009 Plan | DB | Min / Max � Shows calculated values used to determine: – Minimum Required Contribution – Maximum contribution under 404(o) � Entry of asset values – Accommodates Average Assets – Includes adjustment for discounted prior year contributions Plan | DB | Min / Max (c) 2009 DATAIR 12

DB/Win Navigation 12/10/2009 Plan | DB | Carryover / Prefunding Balances Plan | DB | Shortfall Amortization (c) 2009 DATAIR 13

DB/Win Navigation 12/10/2009 Plans | DB - Contributions Plans | DB - Contributions � Shows Quarterly contribution � Discounts contributions � Tracks Carryover and Prefunding balances used towards Minimum Required Contribution � Tracks Effective Interest Rates � Orders contributions per IRC 430 and 436 regulations (c) 2009 DATAIR 14

DB/Win Navigation 12/10/2009 Plans | DB - Contributions Plans | DB - Contributions (c) 2009 DATAIR 15

DB/Win Navigation 12/10/2009 Plans | DB | FTAP / AFTAP Sources � Benefit formulas � Accrued benefit definition � Typically will use Eligibility tab and Benefit tab � May have multiple sources – Cash balance plans – Rollover accounts (c) 2009 DATAIR 16

DB/Win Navigation 12/10/2009 Sources | Type/Name Sources - Eligibility (c) 2009 DATAIR 17

DB/Win Navigation 12/10/2009 Sources | Vesting Sources - Benefit � Can be as simple or as complex as desired � DOS formulas transferred � Operator � Open and Close Paren � Multiple Levels � Benefit Accrual (c) 2009 DATAIR 18

DB/Win Navigation 12/10/2009 Sources - Benefit Sources - Benefit � Use Operators with open and close parens for multiple level formula (c) 2009 DATAIR 19

DB/Win Navigation 12/10/2009 Sources - Benefit Sources - Benefit � Level detail | make your formula (c) 2009 DATAIR 20

DB/Win Navigation 12/10/2009 Sources | Benefit Using Levels Employees - Census � Employees|Census has 5 tabs – Employee – Service – Address, phone, beneficiary, notes, etc – Edit – Browse (c) 2009 DATAIR 21

DB/Win Navigation 12/10/2009 Employees | Census - Employee Employees - Census � Edit tab – Whole census – Quick entry of employee data – Simplified export of employee data � Browse Tab – Allows only viewing of census (c) 2009 DATAIR 22

DB/Win Navigation 12/10/2009 Employees | Census | Service Employees | Census | Address, etc. (c) 2009 DATAIR 23

DB/Win Navigation 12/10/2009 Employees | Census | Edit Employees | Census | Browse (c) 2009 DATAIR 24

DB/Win Navigation 12/10/2009 Employees | Compensation � Period � Payroll – Information entered here RULES over all other screens where you can enter payroll information. If you enter payroll here, you must change it from this screen. Shared information among plans. � Compensation and Hours history � Average compensation Employees | Compensation - Period (c) 2009 DATAIR 25

DB/Win Navigation 12/10/2009 Employees | Compensation - Payroll Employees | Compensation | Compensation and Hours History (c) 2009 DATAIR 26

DB/Win Navigation 12/10/2009 Employees | Compensation | Average Compensation Employees | Sources � Calculation values � Fields for offsets � Field for actuarial increase � Field for fresh start accrued benefit � Replaces need for DOS employee worksheets (c) 2009 DATAIR 27

DB/Win Navigation 12/10/2009 Employees | Sources - Detail Employees | Sources | Defined Benefit (c) 2009 DATAIR 28

DB/Win Navigation 12/10/2009 Employees | Sources | Defined Benefit Employees | Sources | Defined Benefit (c) 2009 DATAIR 29

DB/Win Navigation 12/10/2009 Employees | Sources | Cash Balance Cash Balance Employees | Accounts | Account Balance (c) 2009 DATAIR 30

DB/Win Navigation 12/10/2009 Employees | Testing � 410(b)/401(a)(4) � Top-heavy � 415 limits Employees | Testing | 410(b)/401(a)(4) (c) 2009 DATAIR 31

DB/Win Navigation 12/10/2009 Employees | Testing | Top-heavy Employees|Testing|415 Limits (c) 2009 DATAIR 32

DB/Win Navigation 12/10/2009 Investments for Cash Balance Transactions for Cash Balance (c) 2009 DATAIR 33

DB/Win Navigation 12/10/2009 Reports Reports (c) 2009 DATAIR 34

DB/Win Navigation 12/10/2009 Resources DATAIR Customer Support Team (630) 325-2600 E-mail: support@datair.com web: http://www.datair.com Release Notes Forums Webinars PE/Win Training DVD (c) 2009 DATAIR 35