As discussed yesterday, we laid out a retirement calculation for Bob, and concluded that he won’t have enough money to reach his desired gross income of $45k in today’s dollars.
What to do? Well either Bob can cut out a few lattes and spa treatments in retirement or he increases his annual contributions or he works a few more years or some combination of all three. The spreadsheet linked below, shows in the first tab named “increase contributions” that he would have to increase his contributions in today’s dollars from $10k to about $19k in order to meet his requirement of $45k in retirement. This amount of contribution probably isn’t realistic given that it’s a huge increase and if he has to double his contribution then he probably has to cut back a lot on his pre-retirement life which might affect his desired spending in retirement. For example if he can live on less money while working then he can live on less money on retirement.
The next two alternatives cover the options if he wants to work later or wants to reduce retirement income.
The second spreadsheet tab named “work longer” – Bob decides that that he can’t live without the lattes and spas either before or after retirement so the only other option is to work longer than age 60. In this case he need $1.1 million in today’s dollars to meet his requirements and has to work until the end of the year in which he turns 65 to fulfill this scenario.
In the last example named “compromise” – Bob says that he can cut some expenses so he will only require $40k in retirement, he will contribute $14k per year but still wants to retire by age 60 – in this case he will have a gross income of $40,690 upon retirement.
So to sum up, Bob can keep his $45k gross income requirement in retirement but he has to work an extra five years to age 65 or increase his contribution from $10k to $19k. Another solution is to work to age 60, increase his contribution to $14k and live on just over $40k in retirement.
Some future posts will deal with more realistic retirement scenarios. If there are two parties involved, Canada Pension Plan, OAS, pension income, and taxes then the scenario becomes a bit more complicated but it’s still relatively easy to calculate.