Understanding Actuarial Practice (UAP) Online Resources
These documents and spreadsheets are provided for informational and educational purposes only. The Society of Actuaries makes no representation or guarantee with regard to its content, and disclaims any responsibility or liability in connection with the use or misuse of any information provided herein. These documents and spreadsheets should not be construed as professional or financial advice. Statements of fact and opinions expressed herein are those of the individual author and are not necessarily those of the Society of Actuaries or its officers, directors, staff or representatives. The Society of Actuaries does not endorse or make any guarantee with regard to any products, services or procedures mentioned or herein. All of these materials are copyright © 2012, Society of Actuaries.
Click each link below to open or download the indicated file.
A single spreadsheet, life section tables and solutions, contains calculations for various examples and solutions to selected exercises in these chapters
Section 13.1.4 — The experience study on lapse rates at the end of the level term period is in three files:
Section 13.1.7 Exercises
- The solutions to Exercises 13.1 and 13.3 are in the spreadsheet for Chapters 13-18.
- The solutions for the other exercises are in the Section 13.1.7 solutions file
The spreadsheet of returns for Exercise 13.3 is FAP S&P 500 Returns.xls.
Section 13.2.5 Exercises — The solutions to all these exercises are in the spreadsheet for Chapters 13-18.
Section 14.2.1 Exercise — The solution to this exercise is in the spreadsheet for Chapters 13-18.
The paper by Jennifer Rankin referenced in Section 14.4, " Should You Go Global?"
The paper by James C. H. Anderson referenced in Section 15.1.2, " Gross Premium Calculation and Profit Measurement for Nonparticipating Life Insurance."
Section 15.2.6 Exercises
- The solutions to Exercises 15.1 and 15.4-6 are in the spreadsheet for Chapters 13-18. The solutions for the other exercises are in the Section 15.2.6 solutions file
The paper by Shane Chalke referenced in Section 16.1.7, " Macro Pricing."
The asset share spreadsheet for Example 16.4 is separate from the spreadsheet with the other examples.
Section 16.7 Exercises
- The solution to Exercise 16.5 is in the spreadsheet for Chapters 13-18. The solutions for the other exercises are in the Section 16.7 solutions file.
The two files for the SOA-LIMRA study discussed in Section 17.4 are:
The GRET study discussed in Section 17.5.2 is available only as a link the NAIC website.
Section 17.6 Exercise
The solution for this exercise in the Section 17.6 solutions file.
The 2001 Commissioners Standard Ordinary mortality table used in Example 18.1. The same file has the 2000 Annuity mortality table used in Example 18.3.
The SOA's Table Manager discussed in Section 18.2.4 is available by link. Because the table manager is frequently updated, we prefer to link to the source rather than provide a copy at the book's website.
Section 18.7 Exercises'
- The solutions to Exercises 18.1-2, 18.4-5, and 18.7-12 are in the spreadsheet for Chapters 13-18. The solutions for the other exercises are in the Section 18.7 solutions file
Written Solutions to the exercises in Chapters 21-27 are in the file Answers to Retirement Benefits exercises.
Excel solutions for selected exercises are in the file Solutions to retirement benefits exercises.
The file Health Case Study contains files that support various examples in these chapters.
The file Solutions to Health Section Exercises contains the solutions for all exercises in this section.
The file Health Section Solutions contains spreadsheets that support some of the solutions.