Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Life
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.


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 10-11-2011, 12:25 PM
Implicit Differentiation Implicit Differentiation is offline
 
Join Date: Jul 2006
Posts: 18
Default 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%
Reply With Quote
  #2  
Old 10-11-2011, 12:59 PM
echo echo is offline
Member
 
Join Date: Nov 2002
Posts: 881
Default

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

Here is a link to a spreadsheet that does a mortality improvement calculation.
Reply With Quote
  #3  
Old 10-11-2011, 02:18 PM
Numbers Nerd's Avatar
Numbers Nerd Numbers Nerd is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Midwest
College: University of Wisconsin
Favorite beer: Ale, Lager, you name it
Posts: 1,632
Default

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.
Reply With Quote
  #4  
Old 10-11-2011, 03:57 PM
campbell's Avatar
campbell campbell is offline
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
Default

Quote:
Originally Posted by echo View Post
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
Reply With Quote
  #5  
Old 09-28-2018, 08:02 PM
ElDucky's Avatar
ElDucky ElDucky is offline
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
Default

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..
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 08:05 AM.


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.31611 seconds with 9 queries