That’s right – predict the future! Ok, this method won’t help with lottery tickets, horse racing, stock prices or anything else that will make you rich quick, however it does apply to retirement planning, particularly with predicting the future values of your retirement income and retirement expenses which of course is all you need to calculate to predict your retirement. Planning your retirement is not as simple as tying your shoes but it’s not so complicated that you have to pay an advisor thousands of dollars to figure it out for you.
Everyone has heard all the scary stories about how you will need one million dollars to retire, or two million…or whatever. These numbers sound unreachable for someone who might only have a retirement portfolio of $100k (or no retirement portfolio for that matter) but it’s important to remember that these are future dollars. One million dollars in twenty years is the equivalent to $560,613 dollars right now assuming 3% inflation. This is admittedly still a large number but it’s a lot less than a million dollars.
In the past, to calculate my retirement scenario, I had assembled a complex retirement spreadsheet that involved using the future value of all contributions, withdrawals, taxes, income etc. This worked reasonably well except that it was complicated and didn’t lend itself to change very easily. One of the things I learned from Four Pillars of Investing was to calculate retirement scenarios using today’s dollars to greatly simplify things. The way this is accomplished is to subtract your estimated inflation rate from your estimated portfolio return to get a “real return” and to use today’s dollars for everything else such as portfolio contributions and anticipated withdrawals.
I’ve created a relatively simple retirement scenario in the spreadsheet below, which is for someone (Bob) who is turning 40 this year, has a $250k portfolio and contributes $10k per year. He desires $45k of gross income in retirement at age 60. His expected investment return is 7% but I will subtract 3% inflation to get a real return of 4%. We will also assume that he will get no other income other than from this portfolio and that contributions are made at the end of the year. He will retire at the end of the year in which he turns 60. The goal of this exercise is to determine if he is contributing enough to meet his goal of $45k (in today’s dollars) gross income in retirement. We will also use the “4% rule” which basically states that the initial annual withdrawal from a retirement portfolio should be 4% of the portfolio. This will be discussed in many future posts as it is a particular favourite subject of mine!
If you check out the spreadsheet you will note some interesting things. By age 60 his $250k portfolio has grown to $889k in today’s dollars. Twenty years from now that portfolio will actually be $1,654,516 in year 2027 dollars. This sounds like an incredible amount but it isn’t enough to meet the Bob’s requirement of $45k gross income in today’s dollars. I calculate the portfolio each year by multiplying the previous year value by 1.04 and adding the contribution to that.
As you can see at the bottom of the sheet, 4% of $845k is only $35,575 which falls far short of Bob’s expected gross income.
Tomorrow we will look at a couple of solutions for Bob so he can achieve his goals.