Actuarial Outpost > Life Applying Mortality Improvement Table
 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

 Upload your resume securely at https://www.dwsimpson.com to be contacted when new jobs meet your skills and objectives.

#1
10-11-2011, 12:25 PM
 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, 12:59 PM
 echo Member Join Date: Nov 2002 Posts: 881

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, 02: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,632

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, 03: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: 85,616 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.

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

#5
09-28-2018, 08: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: 42,233

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 07:36 PM..