SteveR said:
Each of us has a unique set of variables that we need to balance. I don't see any one number or any one system that will work for everyone.
Amen
I have pathological variables. I haven't found any spreadsheet or program that can possibly deal with it accurately. I have written one, but I don't have a monte carlo engine to deal with the expected investment returns.
a small example:
I will have a pension coming. It attains full value at age 55. If I take it earlier, it is reducet 0.5% per month before age 55. Up until age 60 it is not inflation proofed. Age 60-65 it is 50% protected (versus CPI). After 65, 75% indexed.
If that's not weird enough, I can also take the "level income option." That involves a larger pension until social security eligibility (at age 66 for me), thereafter substantially reduced. This is to combat the "windfall elimination provision." so in theory I can prevent some of my SS from being eaten up. Since I got my 40 quarters in before becoming a state employee (Alaska opted out of SS in 1987), I will in theory get some SS, but it is subject to being reduced due to the pension.
combine that with 2 pensions of my wife (both small, one indexed to cpi, one like mine), IRAs and RRSPs with minimum distribution requirements at age 70, after-tax investments etc., and it can get pretty overwhelming.
All of this is complicated by the US-Canada tax treaty, differing tax rates and policies etc.
If anyone knows of a spreadsheet with the flexibility to handle all this (and more) let me know.
When I try to deal with these issues, I program the Canadian tax rates into the program (in other words I make the assumption they will stay higher than the US rates). I also have to make assumptions about currency exchange values. How much do I devalue the US dollar in 20 years?
loads of fun....