The CMI’s Mortality Projections Working Party has evaluated the P-Spline and Lee-Carter methodologies for projecting mortality

The CMI is not seeking approval for the methodologies, which we regard very much as ‘Work in Progress’. We certainly do not feel that we have the answer in this area, and it is only by exposing the work fully to the profession that the benefits and features of the methodologies will become apparent. Neither do we rule out the use of other stochastic or non-stochastic approaches. However, it is not the CMI’s role to set standards in this area.

From 2005 to 2008 the CMI made available software with the aims of illustrating these methodologies, assisting the profession to debate the issues and to help users validate the results of their own work. The CMI would like to express its thanks to James Kirkby and Dr Iain Currie of Heriot Watt University for developing this software.

The software uses the statistical package R, together with the R(D)COM interface. The software was withdrawn for new users early in 2009 after the CMI became aware that it is not compatible with newer versions of R and/or the interface. Registered users of the software were notified in January 2009 that they may need to retain existing versions of R and the interface for the software to remain functional.

The software is now available on request to anyone able to locate appropriate versions of R and the interface

To obtain the software please complete the Software Request Form and return it to the CMI.

The software requires the statistical package R to be installed together with the R(D)COM interface which allows Excel to call R. Please note that the software will not function on Excel 97 or earlier versions as these do not contain some of the VBA commands required by the software.

The software is of an experimental nature and is not commercial grade

It is made available on the understanding that you agree to the following conditions:

  • the software is illustrative and the CMI accepts no liability for its use
  • no support can be provided for the software
  • it is the user’s responsibility to source versions of R and the interface and to ensure that the software functions correctly with these
  • the software has been made available for your use only. Colleagues or others wishing to use the software should use the form to seek their own permission to use it
  • agreement to abide by the terms of the GPL licence.

In using the software we request that you communicate any errors or issues you discover to the Life Office Mortality Committee by emailing mortality@cmib.org.uk at the earliest opportunity. The CMI are keen that results produced by the software are discussed with the Committee, before any public comment is made. We hope you will feel able to abide by this request.

Instructions for installing the software

The software is provided in zipped format. You will need to copy all the contents into a single directory. Explanatory notes are contained in the User Guide and the GPL licence is contained in “GNU General Public License.doc”. The software itself creates an add-in to Excel. A spreadsheet is also supplied containing data for male assured lives from 1947 to 2005, for ages 20 to 90 and for all durations combined.

The latest version of the software was released in November 2007 and contains a number of changes to the previous version issued from April 2007, notably correction of an error relating to deviance residuals in the Lee-Carter functionality. Read the Exposure note for more information.

In addition the exposure data supplied with the software is central exposure and does not require adjustment before use (previously initial exposures were supplied).

All the changes from the previous version are documented within the User Guide. Registered users are automatically being supplied with the updated version.

Related documents

Contact Details

If you have any questions about the CMI please email

info@cmilimited.co.uk

Filter or search events

Start date
E.g., 06/12/2019
End date
E.g., 06/12/2019

Events calendar

  • The Great Risk Transfer – Breakfast briefing and launch event

    Staple Inn Hall, High Holborn London WC1V 7QJ
    31 January 2019

    Spaces available

    Launch of the IFoA’s 2020 thought leadership campaign The Great Risk Transfer. The campaign will examine the trend of the transfer of risk from institutions to individuals, and how people can be better equipped to manage the financial risks they now face. At this breakfast event the IFoA will launch a call for evidence on this topic.

  • Sessional Meeting - Silent Cyber Assessment Framework

    Staple Inn Hall, High Holborn, London, WC1V 7QJ
    9 December 2019

    Spaces available

    The (re)insurance industry is faced with a growing risk related to the development of information technology (IT). This growth is creating an increasingly digitally interconnected world with more and more dependence being placed on IT systems to manage processes. Note: Registration is from 17.30 in time for the sessional to begin at 18.00.

  • CPD Member Event in Shanghai, China

    Function Room, F39, S1 Fuson Group, the Bund Finance Centre, No.600 Zhongshang East 2nd Road, Huangpu District, Shanghai Chinese address:BFC外滩国际金融金融中心,S1复星集团,39层报告厅,上海中山东二路600号
    9 December 2019

    Spaces available

    The IFoA’s President-elect Tan Suee Chieh will visit Shanghai. We will host CPD and Awards Presenting event on Monday 9 December 2019. The event is part of Mr Tan’s first presidential trip to China.

  • Professional Skills Training - London (10 December 2019)

    Staple Inn, High Holborn, London WC1V 7QJ  
    10 December 2019

    Spaces available

    This event will be of interest to students and recently qualified actuaries.

    A 2 hour CPD event designed to meet the IFoA’s Stage 3 Professional Skills Training under the IFoA’s CPD Scheme 2019/2020.  The content and discussion at this session is particularly tailored to actuarial students and newly qualified actuaries working in any area and the format is interactive, so you should come along prepared to take part in the discussions with your peers.

  • IFoA Joint Member Event with the Sunshine Insurance Group, Beijing China

    Room TBC, Kuntai International Plaza, No.12, Chaowai Street, Chaoyang District, Beijing 地址:会议室待定,北京市朝阳区朝外大街乙12号1号楼昆泰国际大厦
    12 December 2019

    Spaces available

    The IFoA’s President-elect Tan Suee Chieh will visit Beijing. We will co-host CPD and Awards Presenting event with the Sunshine Insurance Group on Thursday 12 December 2019. The event is part of Mr Tan’s first presidential trip to China.

  • ARC Sessional Research Event: Drivers of Mortality - Risk Factors and Inequality

    Staple Inn Hall, High Holborn, London, WC1V 7QJ
    6 January 2020

    Spaces available

    The authors will focus on a large dataset obtained from the UK’s Office for National Statistics (ONS) and related sources. Data are available at the level of Lower Super Output Areas (LSOAs) – small geographical areas with, typically, 1000-2000 residents and include death counts, exposures and a significant number of socio-economic variables including the index of multiple deprivation (IMD).

  • SIAS Event: My Journey to Data Science, Big Data and AI

    Staple Inn Hall, High Holborn, London, WC1V 7QJ
    7 January 2020

    Spaces available

    Patrick Lee is an actuary who has made the transition to working in software architecture and artificial intelligence (AI). He holds Microsoft Professional qualifications in Data Science, Big Data and AI and is currently working towards a DevOps (the automation of software testing and deployment) qualification. He is a member of the IFoA Council and is also President of the Wessex Actuarial Society. He is also a member of the IFoA and the RSS's joint Data Science Focus Group and will talk on the ethical use of AI. 

  • Spaces available

    This presentation covers the detail for how the matching adjustment is calculated. A small simple example spreadsheet is provided and discussed in detail.

    For actuaries wanting to get more involved with the matching adjustment, this is the opportunity to get a detailed description of the mechanics involved. This includes cashflows derisking, PRA tests as well as hypothecation.

    The presentation is provided by James Sharpe who has worked on a number of matching adjustment calculations with several firms.

  • IFoA Volunteer Recognition Reception

    Staple Inn, 4 High Holborn, Holborn, London WC1V 6DR, UK
    15 January 2020

    Spaces available

    As a thank you to all our Institute and Faculty of Actuaries (IFoA) volunteers, you are invited to join us at Staple Inn Hall, for an evening of drinks, canapes and networking, in London.

    IFoA President, John Taylor, will be attending and will make a speech

    If you support the IFoA as a volunteer (member or non-member), or in any other role, and you are going to be in London on 15 January, please book your place and join us at this reception.

     

  • Sessional Meeting - Operational Risk Dependencies

    Royal College of Physicians of Edinburgh 9 Queen St Edinburgh EH2 1JQ
    20 January 2020

    Spaces available

    The Operational Risk Working Party aims to assist actuaries and others in the modelling and management of operational risk. One of the key challenges in modelling operational risk is the modelling of dependencies between operational risks, and between operational and non-operational risks such as market, credit and insurance risk. Their paper seeks to assist in this regard, and help develop good practice in setting assumptions and modelling operational risk dependencies. 

  • KSS event in Glasgow: Public Sector Pensions

    Hymans Robertson, Glasgow 20 Waterloo St, Glasgow
    30 January 2020

    Spaces available

    – the unappreciated key assumption, the resulting unsustainable promises, the unmanaged risk and the unrecognised debt? 

    Speaker: Allan Martin will present this talk on 30 January in Glasgow, Stirling and Edinburgh. If you wish to register for another location please return to the Events Calendar.

  • KSS event in Stirling: Public Sector Pensions

    M&G Prudential, Stirling Craigforth Campus, Stirling
    30 January 2020

    Spaces available

    – the unappreciated key assumption, the resulting unsustainable promises, the unmanaged risk and the unrecognised debt? 

    Speaker: Allan Martin will present this talk on 30 January in Glasgow, Stirling and Edinburgh. If you wish to register for another location please return to the Events Calendar.

  • KSS event in Edinburgh: Public Sector Pensions

    Hymans Robertson 1, Exchange Place, Semple St, Edinburgh
    30 January 2020

    Spaces available

    – the unappreciated key assumption, the resulting unsustainable promises, the unmanaged risk and the unrecognised debt? 

    Speaker: Allan Martin will present this talk on 30 January in Glasgow, Stirling and Edinburgh. If you wish to register for another location please return to the Events Calendar.

  • Professional Skills Training - London (11 February 2020)

    Staple Inn, High Holborn, London WC1V 7QJ         
    11 February 2020

    Spaces available

    A Trusted Profession

    A 2 hour CPD event designed to meet the IFoA’s Stage 3 Professional Skills Training under the IFoA’s CPD Scheme 2019/2020This session is suitable for actuaries working in any area (i.e. it is not specifically aimed at Pensions, GI or any other technical discipline) and is interactive, so you should come along prepared to take part in the discussions.

  • Sessional: Impact of E-cigarettes Working Party

    Royal College of Physicians, 9 Queen St, Edinburgh EH2 1JQ
    24 February 2020

    Spaces available

    This sessional meeting will be of direct interest to actuaries and others working in the in the Health and Care, Life or Pensions sectors or indeed actuaries with an interest in morbidity or mortality. Note: Registration is from 17.30 in time for the sessional to begin at 18.00.

  • Professional Skills Training - Edinburgh (25 February 2020)

    IFoA (Edinburgh), Level 2, Exchange Crescent 7 Conference Square Edinburgh EH3 8RA
    25 February 2020

    Spaces available

    A Trusted Profession

    A 2 hour CPD event designed to meet the IFoA’s Stage 3 Professional Skills Training under the IFoA’s CPD Scheme 2019/2020This session is suitable for actuaries working in any area (i.e. it is not specifically aimed at Pensions, GI or any other technical discipline) and is interactive, so you should come along prepared to take part in the discussions.

  • Spring Lecture 2020, Edinburgh - Vicky Pryce

    Assembly Rooms, 54 George St, Edinburgh EH2 2LR
    25 March 2020

    Spaces available

    What next in Economic Policy?

    Please join us on 25 March 2020 for our annual Spring Lecture presented by Vicky Pryce in Edinburgh. 

  • IFoA Asia Conference 2020, Kuala Lumpur

    CCEC Nexus, 7, Jalan Kerinchi, Bangsar South, 59200 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur, Malaysia
    24-25 June 2020
    Spaces available

    The sixth annual Asia Conference once again offers a prestigious line-up of home and international speakers discussing the insurance and financial industry’s innovation and change in Asia. This year's conference in Kuala Lumpur will be hosted by Tan Suee Chieh, IFoA’s first Asian President. He will also make his Presidential address at this conference and will expand on the important elements of IFoA’s new strategy. 

    Additionally, this landmark conference will showcase how the IFoA is reinventing itself to support its members to succeed and thrive in a digital age, within traditional businesses and beyond, as a global organisation. 

    Not to be missed by international industry players, opinion formers, academic and industry leaders, actuaries and non-actuaries.