Actuarial Outpost > Life Applying Mortality Improvement Table
 User Name Remember Me? Password
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

 DW Simpson Global Actuarial & Analytics Recruitment Download our 2017 Actuarial Salary Survey now with state-by-state salary information!

 Thread Tools Search this Thread Display Modes
#1
10-11-2011, 11:25 AM
 Implicit Differentiation Join Date: Jul 2006 Posts: 18
Applying Mortality Improvement Table

At mort.soa.org, I found mortality improvement table (table 900, US Projection scale A). Assume an issue age of 50, the mortality improvement table looks like this:

Age Mortality Improvement
50.....0.0160
51.....0.0156
52.....0.0152
53.....0.0148

I am confused how I apply this to my mortality rates. I can think of two methods, and I'm not sure which is correct. Assume an issue age of 50, at attained age 53, what should be my adjustment to mortality rate?

A) (1 - 0.0148)^3 = 95.63%
B) (1 - 0.0152) * (1 - 0.0156) * (1-0.0160) = 95.39%
#2
10-11-2011, 11:59 AM
 echo Member Join Date: Nov 2002 Posts: 883

http://www.soa.org/files/xls/researc...xpect-calc.xls

Here is a link to a spreadsheet that does a mortality improvement calculation.
#3
10-11-2011, 01:18 PM
 Numbers Nerd Member SOA AAA Join Date: Sep 2001 Location: Midwest College: University of Wisconsin Favorite beer: Ale, Lager, you name it Posts: 1,642

And if you don't feel like following the link:
Age 50 qx will be 0.984^n in n years
Age 51 qx will be 0.9844^n in n years
and so on.

Thus A) is the correct choice.
#4
10-11-2011, 02:57 PM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for duolingo and coursera Favorite beer: Murphy's Irish Stout Posts: 87,006 Blog Entries: 6

Quote:
 Originally Posted by echo http://www.soa.org/files/xls/researc...xpect-calc.xls Here is a link to a spreadsheet that does a mortality improvement calculation.
That's my spreadsheet, isn't it...[downloading] yes it is.

I didn't use one of the mortality improvement scales, because it was getting too complicated trying to explain results as it was. I used a very simple 1%/year improvement factor.

Just go into spreadsheet options, and turn on the sheet tabs and go to the sheet labeled "Calcs". You'll see the mortality improvement factors in column C (yes, just a constant) - you can put other numbers in that column, and you'll see what happens.
__________________
It's STUMP

LinkedIn Profile
#5
09-28-2018, 07:02 PM
 ElDucky Free Mason Join Date: Jul 2004 Location: In a van, down by the river Studying for Let me worry about blank Favorite beer: Trappistes Rochefort 8 Posts: 43,023

Is this accurate for the entire select period, or only at duration 0?

Looking at the vbt 2015 female table, most ages have an improvement of 0.0075.

These are the first 4 durations at age 32 F ANB RR100.

0.08 0.14 0.17 0.19

Let's say the person was 32 in 2015. Is it correct that the 2018 mortality is 0.19 (1-0.0075)^3?

Also, let's say I want mortality for the past, instead of the future, so I want to go back 20 years, based on a 2015 table. Can I just do the reverse calc? 0.08*(1-0.0075)^-20 = 0.093?

Reading more, it seems that from 2009-2015 that's ok, but before that it was to use actual improvements. I cannot find what those actual improvements should be.
__________________
I live near the cows.

Last edited by ElDucky; 10-02-2018 at 06:36 PM..

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT -4. The time now is 04:48 AM.

 -- Default Style - Fluid Width ---- Default Style - Fixed Width ---- Old Default Style ---- Easy on the eyes ---- Smooth Darkness ---- Chestnut ---- Apple-ish Style ---- If Apples were blue ---- If Apples were green ---- If Apples were purple ---- Halloween 2007 ---- B&W ---- Halloween ---- AO Christmas Theme ---- Turkey Day Theme ---- AO 2007 beta ---- 4th Of July Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.16954 seconds with 9 queries