SLIDE 1
PE/Win Navigation for DB Plans Kim Roberts, QPA, APA John Baratka, - - PDF document
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
SLIDE 2
SLIDE 3
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 3
Navigation Levels
3 main levels for Defined Benefit
– Plan – Sources – Employee
SLIDE 4
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 4
Navigation Plan Level
SLIDE 5
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 5
Plans|Dates Plans|Provisions|Eligibility
SLIDE 6
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 6
Plans|Provisions|Comp Plans|Provisions|AvgComp
SLIDE 7
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 7
Plan|Provisions|Limits/TH Plan|Provisions|Limits/TH
SLIDE 8
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 8
Plan|Provisions|Vesting Plan | Provisions | Retirement
SLIDE 9
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 9
Plan | Assumptions | Pre-retirement Plan | Assumptions | Post-retirement
SLIDE 10
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 10
Plan | Assumptions | Post-retirement Plan | Assumptions | Post-retirement
Default from transfer from DOS
– Uses commutation functions
Yield Curve
SLIDE 11
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 11
Plan | Assumptions | Post-retirement
Drop down for Look back month
– Rates automatically entered
Plan | Assumptions | 410(b) / 401(a)(4)
SLIDE 12
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 12
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
SLIDE 13
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 13
Plan | DB | Carryover / Prefunding Balances
Plan | DB | Shortfall Amortization
SLIDE 14
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 14
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
SLIDE 15
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 15
Plans | DB - Contributions Plans | DB - Contributions
SLIDE 16
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 16
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
SLIDE 17
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 17
Sources | Type/Name Sources - Eligibility
SLIDE 18
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 18
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
SLIDE 19
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 19
Sources - Benefit Sources - Benefit
Use Operators with open and close parens
for multiple level formula
SLIDE 20
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 20
Sources - Benefit Sources - Benefit
Level detail | make your formula
SLIDE 21
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 21
Sources | Benefit Using Levels Employees - Census
Employees|Census has 5 tabs
– Employee – Service – Address, phone, beneficiary, notes, etc – Edit – Browse
SLIDE 22
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 22
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
SLIDE 23
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 23
Employees | Census | Service
Employees | Census | Address, etc.
SLIDE 24
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 24
Employees | Census | Edit Employees | Census | Browse
SLIDE 25
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 25
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
SLIDE 26
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 26
Employees | Compensation - Payroll Employees | Compensation | Compensation and Hours History
SLIDE 27
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 27
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
SLIDE 28
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 28
Employees | Sources - Detail
Employees | Sources | Defined Benefit
SLIDE 29
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 29
Employees | Sources | Defined Benefit Employees | Sources | Defined Benefit
SLIDE 30
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 30
Employees | Sources | Cash Balance
Cash Balance Employees | Accounts | Account Balance
SLIDE 31
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 31
Employees | Testing
410(b)/401(a)(4) Top-heavy 415 limits
Employees | Testing | 410(b)/401(a)(4)
SLIDE 32
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 32
Employees | Testing | Top-heavy Employees|Testing|415 Limits
SLIDE 33
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 33
Investments for Cash Balance Transactions for Cash Balance
SLIDE 34
DB/Win Navigation 12/10/2009 (c) 2009 DATAIR 34
Reports Reports
SLIDE 35