Announcement: SOA congratulates the new ASAs and CERAs for May 2022.

A System to Evaluate and Compare Defined Contribution Plans

The Society of Actuaries’ Pension Section is pleased to make available material that develops an actuarial framework for assessing defined contribution retirement plan benefits.  The report was authored by Marc Des Rosiers.


A System to Evaluate and Compare Defined Contribution Plans

A System to Evaluate and Compare Defined Contribution Plans

A System to Evaluate and Compare Defined Contribution Plans - Presentation


If you have any questions or comments regarding the report, please contact Steve Siegel, Research Actuary at

Thank You

The SOA’s Pension Section would like to thank the following individuals for their input on the project:

Dylan Porter, Chair

Michael Economos

Cindy Levering

Andrea Sellars

Joe Tomlinson

Jack VanDerhei

Steven Siegel, SOA Research Actuary

Andrew Peterson, SOA Staff Fellow

Barbara Scott, SOA Research Administrator

Copyright and Disclaimers

Important: The DC Evaluation Framework Spreadsheet ("Software") posted on this site is the property of the Society of Actuaries ("SOA") and is protected under U.S. and international copyright laws. It was created for the SOA by Marc Des Rosiers, FSA.

The Software has been developed for the benefit of actuaries FOR EDUCATIONAL USE ONLY, although others may find it useful. The SOA makes the Software available to individual users for their personal use on a non–exclusive basis. No commercial use, reproduction or distribution is permitted whatsoever.

The SOA and the author make no warranty, guarantee, or representation, either expressed or implied, regarding the Software, including its quality, accuracy, reliability, or suitability, and HEREBY DISCLAIM ANY WARRANTY REGARDING THE SOFTWARE'S MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE. The SOA and the author make no warranty that the Software is free from errors, defects, worms, viruses or other elements or codes that manifest contaminating or destructive properties. In no event shall the SOA or the author be liable for any damages (including any lost profits, lost savings, or direct, indirect, incidental, consequential or other damages) in connection with or resulting from the use, misuse, reliance on, or performance of any aspect of the Software including any instructions or documentation accompanying the Software. The SOA and the author make no representation or warranty of non–infringement of proprietary rights of others with respect to the Software. The entire risk as to the uses, outputs, analyses, results and performance of the Software is assumed by the user. This Disclaimer applies regardless of whether the Software is used alone or with other software. The model, accompanying documentation, and methodologies contained herein do not represent an official position, statement, or endorsement on behalf of the SOA or its members, nor should the material be construed to do so. It is the product of a research effort commissioned by the SOA to add to the library of resource tools for the evaluation of defined contribution arrangements and further knowledge in that area. The model is neither intended to preclude the use of other methodologies for the evaluation of defined contribution arrangements for any purpose nor provide a statement or position on the use, application, or preferability of other methodologies as compared to the methodology described herein.

The opinions expressed and conclusions reached by the author are his own and do not represent any official position or opinion of the SOA or its members. The SOA makes no representation or warranty to the accuracy of the information.