 |
09-27-2007, 11:53 AM
|
#1
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,377
|
My dad recently sold his business and has a bunch of key man life insurance he no longer needs. He thinks he might be able to extract some value in the form of a life settlement.
He's 69 and in fairly good health, and my impressions wrt life settlements are:
1) You have to be knocking on death's door
2) The life settlement "industry" is full of sharks who will offer pennies on the dollar
Anybody have any experience with life settlements? Any recommendations for non-sharks who can offer him a fair deal or at least an appraisal of his policies?
__________________
Favorite ERF quote: "I'm not going to waste my time on someone who's more interested in being stubborn or obtuse or intolerant." -- Nords
Favorite ERF error message: "Sorry Nords is a moderator/admin and you are not allowed to ignore him or her."
|
|
|
09-27-2007, 01:00 PM
|
#2
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 10,802
|
Is this a paid up, whole life policy? Is there any stated endowment value?
One issue is maybe the policy would be valuable to him as an estate planning tool? This is an area where FPs who work with well-to-do clients are often up to speed, as well as good estate planning attorneys. Also, the guy who sold him the policy may have suggestions.
A whole life policy will have a cash value- that is your rock-bottom pay-out for surrendering the policy back to the issuer today. Beyond that, you can value the policy the same way a purchaser might. Get tables showing raw survival for a cohort of men. Like 87544 men alive on their 69th B’day. Then advance year by year, making a fraction of (starters-completers)/starters for each year. Then take these fractions, and multiply each one by the discounted value of the payout for one who dies during that year.
Add all these discounted payouts and that should give a pretty good benchmark for the value of the policy. There are a few things you would be ignoring. You could adjust the figures for half year averages, assuming that half will die in each half of the year. But I think it is a complication that is not necessary.
You may spot some problem with my algorithm. I haven’t done this in a while, and I don’t have a data-set handy to test it. But I think it should be sound. Let me know if you try it and get a weird result.
Ha
__________________
Above all, humans are political animals.
Nota bene: I am either a moron or an idiot. So don't pay any attention to anything I say or you are one too. Please consult your financial advisor, astrologer or proctologist for whatever it may be that you are seeking.
|
|
|
09-27-2007, 02:18 PM
|
#3
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,377
|
Thanks, Ha. I think my math is buggy.
If I understand your algorithm, you're saying that the present value of a policy would be: SUM over years of (death probability * present value of benefit).
I'm using the following table for death probabilities:
Actuarial Life Table
And I'm using benefit/(1+discount_rate)^years for the present value of the benefit, which I suspect is incorrect.
So, for a discount rate of 5% and a benefit value of $1M, the first term in the sum for a 69 year old is .026454 * $1M = $26,454.
And the second term = 0.028904 * $950,380.95 = $27,527. So, the sum of the terms seems to be getting too large too quickly.
Can anybody find my bug?
__________________
Favorite ERF quote: "I'm not going to waste my time on someone who's more interested in being stubborn or obtuse or intolerant." -- Nords
Favorite ERF error message: "Sorry Nords is a moderator/admin and you are not allowed to ignore him or her."
|
|
|
09-27-2007, 02:49 PM
|
#4
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 10,802
|
Off the top of my head, I think using annual death rates introduces a flaw. My mental model is that of a viatical company buying say 100,000 policies from 100,000 69 year old men. Each year they will get some payouts. But since each year the pool will be reduced, the expected payout will be less by that reduction.
For example, which would be worth more? 100,000 policies on 100,000 (70) year old men, or the 97,354 policies that will be left at age 70 from a pool begun at age 69?
So we have to reduce the expectancy at each age to account for the shrinking pool. After all, no more than 100% of these guys can die, right?
Let's see if that fixes it.
Ha
__________________
Above all, humans are political animals.
Nota bene: I am either a moron or an idiot. So don't pay any attention to anything I say or you are one too. Please consult your financial advisor, astrologer or proctologist for whatever it may be that you are seeking.
|
|
|
09-27-2007, 03:09 PM
|
#5
|
|
Thinks s/he gets paid by the post
Join Date: Aug 2006
Posts: 1,441
|
Ha's explanation seems intuitively correct to me. Once the numbers are in a spread sheet, I suppose a check would be to set the discount rate to zero and see if the present value is $1 million.
|
|
|
09-27-2007, 03:03 PM
|
#6
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,377
|
I think I'll have to research this a bit. I tried multiplying each term by the remaining population fraction (1-death_probability), but it still seems to grow too fast....
__________________
Favorite ERF quote: "I'm not going to waste my time on someone who's more interested in being stubborn or obtuse or intolerant." -- Nords
Favorite ERF error message: "Sorry Nords is a moderator/admin and you are not allowed to ignore him or her."
|
|
|
09-27-2007, 03:29 PM
|
#7
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 10,802
|
Agree. I reduced each year probability of death by multiplying by(1-death rate of previous year). Then I summed all the undiscounted values until age 119. It comes out to almost $8mm. By my reasoning it should equal only $1,000,000- the maximum that can be collected no matter how long it takes.
So I have a logic flaw. I need to go out in the sunshine for a while- but if you haven't figured it out my evening, I'd enjoy getting back to it. Please post your solution when you do figure it out.
I have a feeling that if we work with the raw number of survivors each year, it will jump out more clearly.
ha
__________________
Above all, humans are political animals.
Nota bene: I am either a moron or an idiot. So don't pay any attention to anything I say or you are one too. Please consult your financial advisor, astrologer or proctologist for whatever it may be that you are seeking.
|
|
|
09-27-2007, 04:04 PM
|
#8
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 10,802
|
OK, couldn't leave. I found the flaw. If you start with raw numbers it is easier to keep things straight. I didn't bother to do the discounts yet, but the flaw was in the number of horses still in the pool each year. I think your discount formula is good. However, I would imagine that viatical firms use 15% at least.
If you aren't satisfied with what you come up with, PM me with your email and I’ll send you my spreadsheet.
Now I really am going out!
__________________
Above all, humans are political animals.
Nota bene: I am either a moron or an idiot. So don't pay any attention to anything I say or you are one too. Please consult your financial advisor, astrologer or proctologist for whatever it may be that you are seeking.
|
|
|
09-27-2007, 03:20 PM
|
#9
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,377
|
With a discount rate of 0, the value grows to over $1M after only 17 years using:
SUM over years of {death_probability * (1 - death_probability) * pv_benefit}
__________________
Favorite ERF quote: "I'm not going to waste my time on someone who's more interested in being stubborn or obtuse or intolerant." -- Nords
Favorite ERF error message: "Sorry Nords is a moderator/admin and you are not allowed to ignore him or her."
|
|
|
09-27-2007, 04:36 PM
|
#10
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,377
|
I just got back from a walk myself. I came up with something that looks a little better, but I'll compare to your solution after I get back from some errands.
Basically, I think the original algorithm was close, but each term double counted the previous term values. Now, I get a value of $84K using a 5% discount rate for a $1M policy on a 69 yo male.
I'll try to verify that, and then I need to subtract out premium payments to get the remaining value (if any).
__________________
Favorite ERF quote: "I'm not going to waste my time on someone who's more interested in being stubborn or obtuse or intolerant." -- Nords
Favorite ERF error message: "Sorry Nords is a moderator/admin and you are not allowed to ignore him or her."
|
|
|
09-27-2007, 05:32 PM
|
#11
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 10,802
|
Quote:
Originally Posted by twaddle
Basically, I think the original algorithm was close, but each term double counted the previous term values. Now, I get a value of $84K using a 5% discount rate for a $1M policy on a 69 yo male.
|
One of us is far afield. My value is quite a bit higher. Some of the FPs on the board must have access to whole life quotes. A quick check for the maximum value is what an insurance company would charge your Dad for a new single pay policy. You would have to adjust that for payments still due
Ha
__________________
Above all, humans are political animals.
Nota bene: I am either a moron or an idiot. So don't pay any attention to anything I say or you are one too. Please consult your financial advisor, astrologer or proctologist for whatever it may be that you are seeking.
Last edited by haha; 09-27-2007 at 05:44 PM.
|
|
|
09-28-2007, 09:47 AM
|
#12
|
|
Thinks s/he gets paid by the post
Join Date: Aug 2006
Posts: 1,441
|
According to the linked actuarial table, the life-expectancy for a large group of 69 year-olds is about 14 years, so the PV of $1 million at 10% for 14 years is about 263k; at 15% = 141k; at 5% = 505k. If you subtract the PV of the premiums from this amount, I would think it would be pretty close.
I'm not sure what discount rate the buyer would use, although I am sure it is not 5%. Also, the buyer would probably tack on a few extra years on the assumption that those in poor health would not sell the policy.
|
|
|
09-28-2007, 10:13 AM
|
#13
|
|
Thinks s/he gets paid by the post
Join Date: May 2004
Posts: 4,306
|
Isn't there a requirement that an individual get certification of a diagnosis of near-term demise before receiving these payments? The cash value is available at any time, but I thought tapping into the death benefit had some strings attached.
If not, I'd think a lot of folks now feeling the pressure from adjustable-rate mortgages would be using this to get a few hundred extra bucks every month (regardless of the later consequences of not having insurance)
__________________
"Freedom begins when you tell Mrs. Grundy to go fly a kite." - R. Heinlein
|
|
|
09-28-2007, 10:33 AM
|
#14
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2003
Posts: 9,991
|
Quote:
Originally Posted by samclem
Isn't there a requirement that an individual get certification of a diagnosis of near-term demise before receiving these payments? The cash value is available at any time, but I thought tapping into the death benefit had some strings attached.
If not, I'd think a lot of folks now feeling the pressure from adjustable-rate mortgages would be using this to get a few hundred extra bucks every month (regardless of the later consequences of not having insurance)
|
Nope, this is the seedy secondary market for life policies, AKA "stranger-owned life insurance." I wouldn't touch this with a 10 foot stick.
__________________
"And Jesus spake, 'Become thou now fishers of adjustable rate mortgages'" - New Conservative Bible
|
|
|
09-28-2007, 10:35 AM
|
#15
|
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 10,802
|
Quote:
Originally Posted by FIRE'd@51
According to the linked actuarial table, the life-expectancy for a large group of 69 year-olds is about 14 years, so the PV of $1 million at 10% for 14 years is about 263k; at 15% = 141k; at 5% = 505k. If you subtract the PV of the premiums from this amount, I would think it would be pretty close.
|
This isn't the way an actuary does it. They take each year separately, and discount a payment at that point appropriately.
Ha
__________________
Above all, humans are political animals.
Nota bene: I am either a moron or an idiot. So don't pay any attention to anything I say or you are one too. Please consult your financial advisor, astrologer or proctologist for whatever it may be that you are seeking.
|
|
|
09-28-2007, 10:42 AM
|
#16
|
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,377
|
Quote:
Originally Posted by haha
This isn't the way an actuary does it. They take each year separately, and discount a payment at that point appropriately.
|
Looks like they might use a couple methods:
Life Settlement Valuation, Life Settlement Investors, Viatical Investors
I've seen discount rates range from 12-20% in some discussions on the net.
Of course, the future value of premium payments hugely offsets the present value of the benefits. And, assuming insurance companies are rational about pricing premiums, the premiums should fully offset the present value of benefits unless your health has materially changed during the term of the policy.
So, I consider the calculation interesting but academic. I did learn a few new tricks with excel, though.
I told him to shop his policy around at a few places and report back what he finds....
__________________
Favorite ERF quote: "I'm not going to waste my time on someone who's more interested in being stubborn or obtuse or intolerant." -- Nords
Favorite ERF error message: "Sorry Nords is a moderator/admin and you are not allowed to ignore him or her."
|
|
|
 |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Hybrid 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
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

|