IMPORTANT NOTE
The CMI has issued a Preliminary response to consultation on the draft graduations of the CMI SAPS 2000-2006 mortality experience. In particular, the CMI wants to highlight that a discrepancy in age definition between the data used and the software resulted in the draft tables over-stating mortality rates by half-a-year.
The preliminary response indicated that the CMI hoped to publish final tables by the end of June 2008. The CMI has carried out a significant amount of work in the meantime to update its methodology and systems. This work has led to the identification of a number of further data issues that have taken time to resolve. A revised dataset has now been produced and the SAPS Mortality Committee is working on finalising the graduations. However, this work is not expected to be complete before September 2008.
Working Paper 31 contains an analysis of the CMI SAPS experience for the period 2000 to 2006 based on data collected by 30 June 2007. This report was originally made available to CMI SAPS members in October 2007. It is now made publicly available, together with summary files of the data used in the analysis. No changes have been made to the report since it was issued in draft form to SAPS members.
Working Paper 31 can be accessed here [pdf]
Summary data files are provided in Excel spreadsheets below.
All classes of pensioner, males, split by pension amount
Males 0-2999.xls [3,096kb]
Males 3000-4499.xls [2,962kb]
Males 4500-8499.xls [2,972kb]
Males 8500-12999.xls [2,776kb]
Males 13000+.xls [2,763kb]
All classes of pensioner, females, split by pension amount
Females 0-1499.xls [3,098kb]
Females 1500-2999.xls [3,063kb]
Females 3000-4749.xls [3,035kb]
Females 4750+.xls [3,018kb]
All classes of pensioners, males and females, not split by pension amount
All data.xls [6,254kb]
Working Paper 32 contains proposed graduations of the data underlying Working Paper 31. These are the first graduations performed on the SAPS data, and the CMI SAPS Mortality Committee is particularly keen to receive feedback. It should be stressed that the mortality tables contained in this Working Paper are issued as part of a consultation process, and may change before final publication. The mortality rates are also made available in spreadsheet form.
It is the responsibility of any actuary or other person using a published mortality table to ensure that it is appropriate for the particular purpose to which it is put.
Working Paper 32 can be accessed here.[pdf 883kb]
An Excel spreadsheet containing the mortality rates can be accessed here [xls]
Erratum (added 22/01/2008)
It has been brought to our attention that Figure 46 in Working Paper 32 incorrectly shows a comparison of the Female Pensioners Amounts Light qx’s against the PCFL00(C=2003)mc table. This should have been a comparison of the Female Pensioners Lives qx’s against that table.
The tables will be presented at sessional meetings of the Faculty of Actuaries and the Institute of Actuaries, providing further forums for discussion and feedback.
The meeting of the Institute of Actuaries is at the Royal College of Surgeons in London at 5pm on Monday 28 January. Further details
The meeting of the Faculty of Actuaries is at the Royal College of Physicians in Edinburgh at 5pm on Tuesday 5 February. Further details