Planned Maintenance: SOA login will be intermittently unavailable from Saturday, June 19th 11:00PM CST to Sunday, June 20th 5:00AM CST.

2D to 1D Conversion Tool – Updated for Scale MP-2015

This tool is presented here with permission from Bob Howard.

Bob Howard, a member of RPEC, has developed a spreadsheet-based program that produces a set of one-dimensional mortality improvement factors that when projected generationally with a given set of base mortality rates produces near-term annuity values that closely approximate corresponding annuity values determined using the full two-dimensional Scale MP-2015.  The tool has been updated since the previous release to allow users to input their own customized set of base mortality rates.


The workbook uses macros. Some companies may have technology policies that could disallow access to the workbook.


The Society of Actuaries does not warrant this tool as fit for use in any respect, and no warranty whatsoever should be assumed or implied by any individual of this product or its fitness for any particular purpose. Actuaries, insurers, regulators and other parties use this tool at their own risk. The SOA disclaims all responsibility for any party’s use or misuse of its tools and for any work product generated through use or misuse of the tools.

By accepting, I acknowledge that I have read and understand the above disclaimer language.

AGREE (Download Tool) |  Disagree