Endres Actuarial
  • Home
  • Excel Add-in
  • Versions
  • Download
  • Purchase
  • Contact
  • Terms
  • News

EAC PV Tools updated for new mortality tables -- version 2018.7

2/14/2018

0 Comments

 
EAC PV Tools is updated in version 2018.6 with new mortality tables and other enhancements:
  • 2019 IRS tables under 430(h)(3)(A) and 417(e)(3) -- The IRS has released Notice 2018-02 which establishes the 2019 static mortality tables for minimum funding requirements under §430(h)(3), and for minimum present value under §417(e)(3) for distributions with annuity starting dates that occur during stability periods beginning in the 2019 calendar year.
  • 2018 ERISA Section 4044/4050 mortality tables -- The PBGC has published 2018 tables under ERISA Section 4044 (for valuing annuities in distress and involuntary single-employer plan terminations) and ERISA Section 4050 (for valuing annuities of missing participants). https://www.pbgc.gov/prac/mortality-retirement-and-pv-max-guarantee/erisa-mortality-tables
  • Added new present value methods using traditional Nx and Dx commutation functions.
  • Added new commutation functions: lxy, Cxy, Dxy, Mxy, Nxy
  • Audit feature has been enhanced, new "audits" added.
  • Added ability to multiply the mortality improvement projection scale by a factor.
  • Smaller file size and faster startup.
0 Comments

IRS Issues Proposed Regs on Mortality Tables for DB Plans

12/29/2016

0 Comments

 
It looks like the long expected change to the IRS prescribed mortality tables is finally here, proposed to take effect in 2018. Read the news at ASPPA web site here. The proposed regulations are here and here and here. Work to add the new tables has begun and will be available just as soon as possible, allowing you to see what the new proposed tables look like and to evaluate the effect of the proposed change.
0 Comments

EAC PV Tools Version 2016.3

1/29/2016

0 Comments

 
  • New function AE gives actuarial equivalent adjustment factors, e.g. early retirement reductions.
  • New function SegRate gives a minimum present value segment interest rate.
  • New function SegRateText gives the 3 minimum present value segment interest rates in a text string that can in turn be used as an input into other present value functions.
  • Minimum present value segment interest rates are automatically downloaded from the IRS.GOV web site.
  • Significant speed improvements, especially when using generational mortality.
  • Smaller file size and faster load.
  • Fixed a minor interpolation problem with joint annuities (äxy) when using fractional ages.
  • Corrected a issue where the add-in failed to communicate with my FTP site to look for updates or to enter an activation code.
  • Get “cash flow forecast” year-by-year using an “Excel Array Formula”. For example, if you are using the function “PVSL” to get the present value of a single life annuity, you can use “PVSL” in an array formula to get the expected payment (before interest discount) for any number of future years returned as an array. I will provide more on that later. If you need that kind of result it is a neat feature that is powerful and extremely fast.
  • Added parameter-specific help in the “fx” Insert Function dialog box.
0 Comments

EAC PV Tools Version 2015.9

10/17/2015

0 Comments

 
Recent updates are implemented:
  • Mortality Improvement Scale MP-2015 and RP2006 (adjusted RP-2014).
  • Table RPH-2014 added.
  • New function wx provides turnover rates from published "T tables".
  • Fixed qx for ages < 30 for RP-2000 white collar and blue collar. This was a very small correction, all other qx are unchanged.
0 Comments

Mortality Improvement Scale MP-2015 and RP-2006 (adjusted RP-2014)

10/17/2015

0 Comments

 
The SOA published mortality improvement Scale MP-2015. The SOA web page is here. The report is here. The mortality improvement sales are here (Excel). In this report the SOA published the so-called RP-2006 table which is the RP-2014 adjusted backwards to 2006 by removing the improvement based on MP-2014. The result is the 2006 Base Mortality Rates, i.e. the raw rates underlying the RP-2014 table. Available in version 2015.9. Read more here and here.
0 Comments

RPH-2014 mortality tables added

10/17/2015

0 Comments

 
The RPH-2014 headcount-weighted tables have been added to the master library of tables. The rates in these tables, denoted RPH2014 (for retirement plans by headcount), were published by the SOA in November 2014. More information is here. Excel tables are here. The Society of Actuaries web page for RP-2014 is here. More on RP-2014 is here. Available in version 2015.9.
    • RP-2014 Mortality Tables Report
    • RP-2014 Mortality Rates (XLS)
    • RP-2014 Mortality Tables Response to Comment
    • RP-2014 Mortality Tables Exposure Draft
    • Mortality Improvement Scale MP-2014
    • SOA Mortality Table Letter to the IRS
0 Comments

IRS announces static mortality tables for 2016

7/31/2015

0 Comments

 
In Notice 2015-53 the IRS provides updates the static mortality tables to be used for defined benefit pension plans. Because these tables are based on existing methodology, EAC PV Tools handles these tables without modification. For 2016 the 417(e)(3) applicable mortality table name is "LS2016".
0 Comments

EAC PV Tools Version 2015.6

6/5/2015

0 Comments

 
  1. Very fast start up for Excel 2013. Microsoft did something in the latest version of Excel that makes it perform differently as compared to Office 2010. Excel 2013 is included with Office 2013 and Office 365. (By the way, Office Online does not allow the use of add-ins.)
  2. New parameter to allow for temporary annuities.
  3. New function ProjScale returns the age-based factor for a given mortality improvement scale.

0 Comments

EAC PV Tools updated in Version 2015.1

1/24/2015

0 Comments

 
  1. Incorporated the SOA's corrected tables for the collar- and the quartile-specific Employee rates. The corrected tables can be found here on the SOA website. This issue has no impact on other RP-2014 tables -- all Healthy Annuitant rates, the Total Employee rates, and all Disabled Retiree rates – are unaffected.
  2. User-defined mortality tables can created and saved in a text file. Create your own q's -- project, blend, combine, and feed into the function call. The text file must be saved in the same folder as the add-in file. Click here for more information.
  3. PVSL and PVJL functions have been enhanced to allow the user to specify no pre-retirement mortality.
  4. Life insurance and cash refund annuity functions have been enhanced to allow the user to specify the timing of payment of the death benefit mid-year or end-of-year (default is end-of-year).
  5. Improved handling of Excel's file links to avoid the pesky "#NAME?" error when opening files that were created on a different computer or by a different user.
  6. New function DecrLifeIns to return the present value of decreasing life insurance, useful for the calculation of a cash refund annuity.
0 Comments

RP-2014 Mortality Table Report released by SOA

11/19/2014

0 Comments

 
Updates on RP-2014 and Scale MP-2014 Resources

As anticipated in last week's communication, the Society of Actuaries (SOA) has released a revised RP-2014 Mortality Tables Report, which includes the previously announced corrections to the collar- and quartile-specific Employee mortality rates. The revised report is available on the SOA website.

The RP-2014 Comment Response Document's Section 3 has also been updated with the latest progress made in the effort to provide Pension Benefit Guaranty Corporation (PBGC) mortality data to the SOA.

In addition to the revised materials, the SOA's Retirement Plans Experience Committee (RPEC) has announced the release of two additional resources related to the RP-2014 and Mortality Improvement Scale MP-2014 reports:

Headcount-weighted versions of the RP-2014 tables

An additional set of tables has been developed using the same underlying datasets and method used to construct the RP-2014 tables, but with mortality rates weighted by headcount rather than by amount. RPEC believes that these headcount-weighted mortality tables, denoted RPH-2014, might be more suitable than amount-weighted rates in certain applications. These new tables can be found in the Supplement to the RP-2014 Mortality Tables Report.

A new Excel-based tool that implements the RPEC_2014 model

The MP-2014 Report acknowledges that some actuaries may wish to construct two-dimensional mortality improvement scales based on assumption sets other than that used by RPEC to construct Scale MP-2014. This tool produces two-dimensional mortality improvement rates under the RPEC_2014 model based on user-selected assumption sets. Download the RPEC_2014 model implementation tool.
0 Comments
<<Previous

    Archives

    May 2025
    October 2024
    June 2024
    May 2024
    March 2024
    January 2024
    November 2023
    October 2023
    May 2023
    December 2022
    September 2022
    July 2022
    April 2022
    December 2021
    November 2021
    February 2021
    January 2021
    December 2020
    November 2020
    May 2020
    December 2019
    November 2019
    October 2019
    August 2019
    April 2019
    March 2019
    December 2018
    August 2018
    February 2018
    November 2017
    October 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    February 2016
    January 2016
    October 2015
    July 2015
    June 2015
    January 2015
    December 2014
    November 2014
    October 2014
    June 2014
    May 2014
    February 2014
    January 2014
    November 2013
    October 2013
    September 2013
    August 2013
    April 2013
    March 2013

    RSS Feed

Endres Actuarial Computing
Copyright © 2014-2025
Endres Actuarial Computing
All rights reserved
email: [email protected]
phone: 952-221-1000