The recently published report by RPEC (Retirement Plans Experience Committee of the Society of Actuaries) on Scale MP-2014 makes reference to making up another scale using the RPEC_2014 Method. Actuaries may need a scale other than MP-2014 for sensitivity testing, to provide margins for adverse deviations, or because the actuary believes that a different long term rate, transition period or balance between the horizontal and diagonal interpolations is warranted.

I have constructed an Excel workbook, which uses VBA code, that implements the RPEC_2014 method. The workbook is made freely available for any personal, research or commercial use with the conditions that

1. you use the workbook at your own risk
2. you do not distribute the workbook for a fee
3. you do not represent the workbook as your own work
4. you recognize that the VBA code was written by me and subject to the GNU General Public Licence, Version 3. (The main implication is that if you distribute the workbook, whether with modifications or without, you must make the code available to any users. See http://www.gnu.org/licenses/gpl-3.0.txt.)

RPEC_2014 Method.xlsm A tool that implements the RPEC_2014 method.

Neither RPEC nor the Society of Actuaries takes any responsibility for my workbook.

to main index

R.C.W. (Bob) Howard, FSA, FCIA
Waterloo, ON