We are offering Excel custom functions to generate Single Life, Single Life with Period Certain, and Joint and Survivor annuity purchase rates (deferred annuity factors) using the 3-tiered interest rates required by the Pension Protection Act of 2006 (PPA).  With this worksheet open, you can incorporate these functions into your own worksheets for individual termination calculations or any other calculations you may want to complete outside of your normal valuation system.

We are offering this on a "shareware" basis.  Please complete the following form and we will email the fully functional worksheet to you.  You are free to test and use the functions for one week.  These factors are developed from first principles, not commutation functions.  See the "Proof" tab for a detailed breakdown of the calculations.  In our testing, the factors were within about 0.01% of the factors developed using commutation functions.  Prior to using the spreadsheet, we ask that you test a sample of factors against whatever software you have available.  If you decide to keep and use the custom functions, please mail a check for $50 to:

Woodley & Associates, Ltd.
P.O. Box 397
Hereford, AZ  85615

Those who have paid for the software will receive updates such as the addition of new mortality tables as they are published.  Note also that it is possible to add your own mortality tables on the tab labeled "LValues".

To request a copy of the Excel file containing the custom functions, please complete the following form.  Note that all fields are required, including the "Agree" check box at the end of the form.

When you click on the "Submit" button, the data in the form will be emailed to Woodley & Associates, Ltd. and you will receive the worksheet by reply email within 24 hours.

If you have any questions, please email us at joe@woodley.ws