Spouse's Death Simulation

[markarmond]

I am attempting to simulate the death of a spouse 8 years into retirement and plan for the reduced SS benefits as well as calculating the spent resources ie. funds left and recalculate remaining funds from the fictional point of death forward. Anyone know how to key that In? I tried and "-" negative return for 8 years with no success. Any ideas?

[jimr]

The first step would be to list all the changes in cash flows that you expect (both income and expense cash flows). Next, identify if there would be any changes in assets that would need to be accounted for.

Once you know what the cash flows would look like, you can use the lower table in additional inputs to enter everything using appropriate start and end dates for each cash flow. Be sure to zero out the retirement expenses and retirement income inputs on the main page so there's no double counting, since it'll probably make sense to have all your retirement cash flows spelled out in additional inputs instead.