0

How to Model Spouse Expiring and Social Security going away

How does one handle a situation modeling a spouse expiring before the end of the illustration? Since he's 7 years older than me and statistics point toward him expiring at a younger age than myself, it doesn't make sense to show his Social Security income continuing all the way to the end of the scenario.

 

RE: Social Security... actually the higher of your two benefits will continue for life of the surviving spouse.  We do not do this automatically because we don't ask you to "tell us when someone might die".  That's very speculative first of all, and we don't really have a good way to ask that.

You can model this mathematically though.

To model this, set the STOP AGE of the Social Security benefit that is the LOWER of the 2 benefits.  So let's say John and Susan both have Social Security and John passes away.  Whichever benefit is smaller... set the Stop Age on that one to model the age of that spouse when John passes away.  This will then stop the lower benefit.

If there is life insurance, you also add that on Cash Infusions.

0 comments

Please sign in to leave a comment.