1 / 13

Comprehensive Guide to Processing RP2000 Mortality Tables in Relius

This guide provides detailed instructions on processing RP2000 mortality tables within the Relius system. Access the RP2000 tables at the defined benefit section of the 12.0 website, in the RP2000tables.zip file. Learn how to create new names and import table entries, utilize yield curves, and understand target assumptions under the Pension Protection Act. Discover specifics regarding valuations, interest rates, and contributions, while also gaining insights into annuity calculations and reporting. Optimize your actuarial analyses with these essential specifications.

yan
Download Presentation

Comprehensive Guide to Processing RP2000 Mortality Tables in Relius

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Plan Processing in Relius

  2. Table Entry • Mortality • RP 2000 tables • Located on 12.0 website under Defined Benefit • RP2000tables.zip • Create new name and import

  3. Table entry (continued) • Yield curves • PBGC • PVAB • Rates immediately preceding valuation date • Target • Uses specification regarding number of months prior to valuation date • All values provided by the Internal Revenue Service beginning in Notice 2007-81

  4. Plan Specifications • Actuarial Methods / Pension Protection Act • Target Assumptions • Select base mortality tables (RP2000) • One time per calendar year • Projection is currently fixed • Applicable months • Similar to lookback period for determining target interest rates • Probability of lump sum • 0-100 • Delete and startover

  5. Plan Specifications (continued) • Segment rates • Target yield curve using applicable months • High quality bond • Used IF discount rate transition selected • Final rates • Blended using 1/3 2/3 rule • Used for 2008 / 2009 • Override • Generally should NOT be used if rates entered properly (uses most current)

  6. Plan Specifications (continued) • Optional combined mortality • Blends annuitant / nonannuitant mortality • Weighting • Tables are currently fixed • Used to create Optional combined table • Discount rate transition • Temporary blending of 4 year weighted current liability rate and segmented interest rates from yield curve

  7. Plan Specifications (continued) • Actuarial equivalent floor • Unisex mortality tables which have been released by the Internal Revenue Service • Revenue Ruling 2007-67 • 50/50 blend of Optional table • Non-annuitant issue with IRS • Current interest segments • PVAB yield curve using prior month • Override • Generally should NOT be used if rates entered properly

  8. Reports • Checking results • Contributions \ DB Employee \ Pension Protection Act • Annuity calculations • Annuity • Lump sum

  9. Annuity checking report

  10. Reports (continued) • Contributions \ DB Analysis \ 412 and 404 Contributions – Pension Protection Act • Funding percentages \ At-Risk Status • Minimum Required Contribution • Maximum Required Contribution

  11. DB Analysis for PPA

  12. DB Analysis for PPA

  13. DB Analysis for PPA

More Related