Tweet
I have a massive spreadsheet that calculates things 9 ways to Sunday. Lots of inputs for what ifs. Lots of charts and graphs. I must have looked at thousands of scenarios to see what the impact is on our retirement money plan.
Today I decided to add something different. I have always liked the Rich Broke or Dead graph from here:
I decided to incorporate this into my spreadsheet. Finding the rich or broke data was easy. Just picked that out from my built in historical model. The dead part was harder. I used the Social Security mortality data, the Canadian Institute of Actuaries data and 4 of the online calculators that use a lot more inputs. I looked at ideal health (I am not) and my current health (overweight, hypertension, pre-diabetic and history of heart attack). I decided to use those two as my bookends.
Here's the data using my current health:
Well that's depressing. I guess all I really need to do financially is make sure my wife has enough when I'm dead @ 73. :frown:
I have an input to switch to the mortality data for me if I lose weight, exercise and eat right which should eliminate my threats.
That's better, but to be honest, it's still disheartening. Still processing all of this and what it means. What is for certain is I should spend less time futzing with spreadsheets and more time focusing on my health. Seems obvious, but it brings it into sharp focus when my analytical test pilot brain sees it in a chart.
Today I decided to add something different. I have always liked the Rich Broke or Dead graph from here:
I decided to incorporate this into my spreadsheet. Finding the rich or broke data was easy. Just picked that out from my built in historical model. The dead part was harder. I used the Social Security mortality data, the Canadian Institute of Actuaries data and 4 of the online calculators that use a lot more inputs. I looked at ideal health (I am not) and my current health (overweight, hypertension, pre-diabetic and history of heart attack). I decided to use those two as my bookends.
Here's the data using my current health:
Well that's depressing. I guess all I really need to do financially is make sure my wife has enough when I'm dead @ 73. :frown:
I have an input to switch to the mortality data for me if I lose weight, exercise and eat right which should eliminate my threats.
That's better, but to be honest, it's still disheartening. Still processing all of this and what it means. What is for certain is I should spend less time futzing with spreadsheets and more time focusing on my health. Seems obvious, but it brings it into sharp focus when my analytical test pilot brain sees it in a chart.
Comment