Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Life
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Not looking for a job? Tell us about your ideal job,
and we'll only contact you when it opens up.
https://www.dwsimpson.com/register


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 03-14-2019, 06:01 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 35,736
Default LIME recalculating a table

In the 2nd edition of "LIFE INSURANCE & MODIFIED ENDOWMENTS Under Internal Revenue Code Sections 7702 and 7702A" by Desrochers et al...

On page 25, table 2.1 NSP per $1,000...

I'm trying to manually recalculate that myself...just because and for other reasons.

I'm not matching up, though.

From the SOA (https://mort.soa.org/), I used table #1136, "2001 CSO Select and Ultimate Male Composite, ANB
2001 Commissioners Standard Ordinary (CSO) Select and Ultimate Table - Male Composite. Basis: Age Nearest Birthda"

I used an interest rate of 4% & endowed the thing at age 100.


Did I use the correct mortality table? The book says "2001 CSO male aggregate, ANB, endowment at 100, 4%, curtate".

tqx is just the product of all the previous tpx's * that year's mortality, right?

Anyway, if you can see what I'm doing wrong or just plain know how to set it up, I'd love to know how.

Thanks,
###
Reply With Quote
  #2  
Old 03-15-2019, 09:30 AM
urysohn's Avatar
urysohn urysohn is offline
Member
 
Join Date: Feb 2010
Posts: 16,904
Default

What was the book's table value for age 25? (I only have the first edition available)

I get $144.15 for the NSP using the assumptions you listed. If you got something just higher, I'd check the endowment age. You want q(99)=1.

When I calc NSPs, I use a simple mental exercise which translates into a formula. I picture a binary tree:
"If you live, you get next year's NSP. If you die, you get the death benefit. Either way, you discount it back to the beginning of the year"

Formulaically, if I'm coding this into cell C50 for example, I'd have: ((1-B50)*C51+B50*1)/(1+INTRATE)
where column B has my q's.
I always code it first for the omega age, then copy up. Unnecessary, but part of my mental exercise keeping the recursive nature of the formula in mind.

Last edited by urysohn; 03-15-2019 at 09:39 AM..
Reply With Quote
  #3  
Old 03-15-2019, 11:44 AM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 35,736
Default

Thanks for your response.

The book has an NSP of 147.21 for age 25.

Here are all the #s:
25, 147.21
35, 206.64
45, 291.24
55, 402.11
65, 534.82


Just in case it wasn't clear in the OP, here are the listed Assumptions: "2001 CSO male aggregate, ANB, endowment at 100, 4%, curtate"

Last edited by 1695814; 03-15-2019 at 12:00 PM..
Reply With Quote
  #4  
Old 03-15-2019, 12:24 PM
Sleeping Dragon Sleeping Dragon is offline
Member
 
Join Date: Jun 2003
Posts: 129
Default

Those NSPs are based on the ultimate mortality, not the select and ultimate.
Reply With Quote
  #5  
Old 03-15-2019, 02:09 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 35,736
Default

Quote:
Originally Posted by Sleeping Dragon View Post
Those NSPs are based on the ultimate mortality, not the select and ultimate.
Excellent.

Using that bit of info & ury's method I'm able to replicate the numbers now.

Thanks, both, for your help.

(Just in case it's useful for anyone, I've attached a copy of my work.)
Attached Files
File Type: xlsx LIME Table 2.1 - Copy.xlsx (24.2 KB, 4 views)

Last edited by 1695814; 03-15-2019 at 02:13 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 06:53 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.14246 seconds with 12 queries