Retirement Calculator – Part 1 of 3 – Introduction

July 2nd, 2012 by Potato

Most of what I write is aimed at younger folk: people my age, and also people who are likely to stumble upon and read blogs in the first place. So I talk a fair bit about investing and saving for retirement, but not much about what to do when that switch to living off your accumulated capital starts looming close.

Recently, someone outside my typical audience asked me that deceptively simple question: can I retire?


There are a fair number of calculations and factors that go into that decision. At the most basic level it all comes down to finding ways to meet your spending needs until you don’t have spending needs any more (i.e.: you die). How much will you spend, how much do you have? What will your rate of return be, and how long might you live?

People have come up with some quick rules-of-thumb which I think are a little chancy: I’m all for approximations, especially when it comes to long-range forecasting where precision is impossible, but setting some percentage withdrawal rate seems just a little too simple. So I decided to tackle the problem from something like a first principles approach: what would the finances look like after the first year of retirement — where would the money go out, where would it grow? And for the year after that? And so on.

I made a fairly simple spreadsheet that will just take some assumptions on returns, and run through the scenario of drawing down the savings while at the same time earning returns on the investments.

You can download the spreadsheet — Potato’s Retirement Calculator — right here.

It’s not the most complex retirement calculator: there are some software packages out there that include a tax package to estimate your tax liability to the dollar, and that run massive Monte Carlo simulations on a whole gamut of market return scenarios. But given how uncertain the future is, I think this should serve many of you well enough — and since it’s spreadsheet-based, it’s easy to see the calculations, fix any bugs that might be there, or customize it for your own use.

Just enter your assumptions about rates of return, inflation, pension income, CPP/OAS, and investments, and then the spreadsheet will tell you approximately how old you’ll be be when the money runs out.

There are some quirks: for one, I didn’t set it up to solve the inverse problem (given spending and life expectancy, calculate the investment nest egg needed). For another, I originally set it up for an age 60 or 65 comparison, and CPP/OAS, and pension really only fit into those ages or later. It’s not hard to change for your own case, but it’s not as automatic as the other variables.

Download it, give it a try, and let me know what you think. Also be sure to check out the next two posts for more details.

Part 2: details on variables and calculations.

Part 3: running through scenarios.


Blueberry Portfolio Month 1: Our First Profit

June 13th, 2012 by Potato

This is a monthly update from the Blueberry Portfolio. The events I talked about below happened approx 8 months ago.

Well, it’s been about a month since I started managing the Blueberry Investment Portfolio. In that time, the TSX has swung way down (12%), then most of the way back up, ending down just 2.5%.

The broker is reporting the portfolio as down just 0.3%, which I call a win, but given that the money was safely ensconced in a savings account before that, any loss can perhaps be viewed with derision.

This of course was not the case even just a few days ago. In the initial discussions of where to put the money, a planned core holding was going to be Berkshire Hathaway, the conglomerate controlled by Warren Buffett. Unfortunately I didn’t figure out how to buy US-listed securities in time, and some good news came out that drove the stock up over 10%. Though it may still be a good investment at 10% more, I didn’t feel like chasing it, and besides, buying in the US does add some complications.

Another missed opportunity was Armtec: once a darling stock in that magical “infrastructure” business that was supposed to get a boost from government stimulus spending, Armtec actually stumbled of late, and after suspending dividends started to trade like it was going out of business completely. I had just started to do my due diligence on it one Friday, planning to finish on the weekend. I didn’t get around to it that weekend, but figured I’d have plenty of time to finish over the next week. Unfortunately sometimes the market doesn’t give you the benefit of time, and by the middle of the week Armtec had jumped 120%. There’s no way to know if I would have felt comfortable buying it after doing my reading, but it still feels like a miss.

So we missed a few good opportunities.

We also had some rough luck with the stocks we did buy, finding Superior Plus melting away roughly 20% after buying it at what had already looked like bargain-basement prices. Even what I thought were solid names like Canexus and Futuremed were nearly as bad this month. The worst though was Daylight Energy, which dropped 32% over the course of the month.

However, our biggest loser turned into our biggest winner this week as a takeover offer for Daylight came through. Though we could have collected a few more percentage points by waiting until the closing date, I thought it might be prudent to sell into the market, and did just that last week, generating our first realized profit (and also bringing the portfolio almost back up to even).

And of course Daylight is an exemplary case to use in demonstrating that even when you get it all right in the market and end up making money, you certainly don’t get there by experiencing the market go straight up. We had to ride through some pretty gut-wrenching declines before we made it to today.

Speaking of take-overs, another large position in the portfolio is Capital Power Income Fund, which has received a take-over offer from Atlantic Power Corp. The deal is a little strange in that you have the option of either getting cash for your shares, or shares in the purchasing company, Atlantic Power. What’s really strange though is that about half the people will have to choose shares, or they’ll run out of cash. So odds are good that since the Capital Power shares were trading at a big discount to the take-over price, everyone will want cash. Thus, everyone is likely to end up with a mix of about half shares and half cash (though the default option is shares, so anyone who doesn’t bother to read their mail will get stuck with shares).

When we bought, Capital Power was trading as though you were just going to get shares, and at a discount to cash — but since we should get at least half as cash, we should do better than that. It works out to about a 2% return, which in just about 4 months is pretty decent (~6% annualized, with very little risk, and as much as 12% annualized if we get all cash). And that isn’t including the healthy dividend, either. Today, the Atlantic Power shares have traded lower, so even though Capital Power is still in the same place, it’s as though the discount has gone away (if we were proper arbitraguers, we would have shorted ATP).

Introducing the Blueberry Portfolio

May 21st, 2012 by Potato

A little while ago I was approached with a unique opportunity: to actively manage an investment portfolio for someone else, which we named the Blueberry Portfolio. For this, I’ve been writing monthly letters about what has been happening in the portfolio, which gives me a bit of pre-written content to post here when I get busy in RL. At first the letters will be coming in with a 7-8 month lag, but I anticipate I’ll post them more than once a month, letting you catch up to near-real-time.

At the time I started, it was my understanding that this investor had a balanced and well-diversified portfolio, and that the Blueberry portfolio was free to invest somewhat aggressively without paying much heed to diversification. The goal was to use a value style with a fair bit of concentration. My idea going in was to have about 5 “core” positions with weightings of about 10% each, and another 10-15 smaller positions.

In the way of fees, I was to share in the profits (after trading fees) in a manner that can only be described as generous, with no fees for under-performance [it is at this point that you probably realize the owner of the Blueberry portfolio is a relation, and the fee structure is a convoluted gift]. The initial benchmark was absolute – comparing performance to a HISA, but at my suggestion we also compared relative performance to the Canadian Index ETF XIU (since that’s where this money would have gone otherwise).

The initial core positions identified were Berkshire Hathaway, Capital Power Income Fund, Chemtrade Income Fund, Daylight Energy, and Google. Almost immediately, I ran into an embarrassing problem: I couldn’t figure out how to execute trades on US securities in the portfolio. So the portfolio became Canadian-only; Canexus was bumped up to “core” weighting, and only 4 stocks had that high a weighting. The smaller positions were built as opportunities presented themselves — which didn’t take long in the summer of 2011.

Hopefully you’ll find these letters worth your time: they’re not Buffett partnership quality, but they will give you some insight into my thought processes, and allow you to follow along (with a time lag) with actual portfolio performance.

Valuing a Pension

May 7th, 2012 by Potato

Good news: I got a job offer this week!

The offer was laid out a little differently than I was expecting in that it comes with a defined benefit pension! These days a DB pension is a rare, nearly mythological thing, and it definitely adds value to the offer, possibly even more than a higher up-front salary. Being well, me, I decided to try to use a bit of spreadsheeting to come up with an approximation of how valuable that DB pension is to me. There are doubtless actual actuaries out there who would laugh at my attempts to do this from first principles, but if they do decide to correct my methods, I will welcome the learning opportunity :)

So without getting too far up into my business, let’s use some nice round fabricated numbers and suppose for the sake of argument here that I had a competing job offer with no pension but a $5k higher salary, and wanted to try to value the pension to compare (as much as is possible) the two offers. The DB pension involves taking some percentage of my salary from me to invest in the plan, and that is matched by contributions from my employer. Let’s say that my employer’s contributions would amount to $3.5k/year. That might be one quick way to value the DB: the amount of the bonus contributions from my employer. However, a pension is a little more complicated than that: I can’t actually use that money the way I would want to (whether for investing or spending), yet it’s also less risky than investing on my own in stocks/ETFs/e-series index funds would be.

If I go to the pension calculator provided on the website of the pension fund, I can see that with certain assumptions (namely that I’d continue to work for the same employer until age 60) that the pension would provide a stream of income in retirement, let’s say $26k/year here. A pension is a bit different than having a pool of investable assets in that it provides protection against longevity: no matter how old I manage to live to, the pension will continue to pay without running out. On the other hand, there’s less flexibility and no inheritance to leave behind if I do die early. Let’s be somewhat fair to the pension and assume I’ll live to a nice ripe old age of 89 (a few years longer than the actuarial tables might otherwise suggest).

What pool of capital would I need to provide that $26k yearly income? Assuming a conservative 2% real return, that would be roughly $594k saved at age 60. To get to that point, I’d have to save a fair bit every year between now and then. Using a slightly higher rate of return during the saving years (3% real) and assuming that the contributions increase at 1% per year (in-line with the raises I used in the pension calculator), that would be a hefty savings of almost $13k per year.

In other words, the DB pension could be worth a lot more than just the employer match being put up every year.

There are a few wrinkles though: the rate of return might be too conservative. I’m not too concerned on that point, since even if I use a more aggressive rate of return (3% in retirement, 5% in the savings years) the value of the DB plan still seems to be greater than the up-front salary of the hypothetical competing offer: I’d have to save $8.6k/yr on my own under those assumptions, which is still $5.1k more than the amount being taken off for the pension. Even if they gave me an additional $5k up front that I saved on my own, I might prefer the pension due to lower market and longevity risks (plus I’d lose out to taxes if I ran out of RRSP contribution room).

The other big wrinkle is that this is all assuming that I stay in the job (and that the pension plan doesn’t get significantly modified) until I turn 60. What seems to be weird about the pension calculation (which may be an artifact of the web calculator but I believe is actually in the payout calculation) is that there’s no time value to contributions: all that seems to matter is years of service. If I work from 33-36, that’s 3 years of service and seems to be worth the same as if I worked from 57-60. Yet clearly money saved while in my thirties should be able to compound and provide more monthly income in retirement than money contributed in my fifties. If I end up moving to a different job in the next few years, then my pension contributions won’t be compounding in the same way as if I had saved some money and invested it in an RRSP. That gets complicated though, since there is the option to cash out the commuted value to a LIRA, and I can’t find any way of estimating that. If I choose to leave the pension alone, then it looks like it’s still about as good as the amount I’m contributing and the employer match growing at 5% (then 2% during the payout years).

Though it’s tough to decide how valuable a DB pension is, it looks like it’s worth at least as much as the employer match, and possibly triple that. The older one is (and the longer one stays on the job), the more valuable the DB pension benefit becomes.

Take CPP Early?

May 2nd, 2012 by Potato

A reader asks whether or not he should start taking CPP early. There are hundreds of articles out there asking this very question, but that’s not going to stop me from giving you my take on it, too! [Edit: can’t believe I forgot to link to Michael James’ post on the matter, which has a graph!]

For those who are unaware, CPP stands for Canada Pension Plan: you pay into the plan in your working years, and in return in your sunset years the plan pays you a small pension. The normal age for that to happen is 65, but you can start taking payments as early as 60 if you like, or put off withdrawing until age 70. Taking it early incurs a penalty (you get 36% less if you start at 60), while you get a bonus to your payments if you defer taking it. My impression from reading all the articles along the way was that the system was set up to be pretty close to break-even, so you should just start taking payments early if you needed them, and defer if you didn’t (e.g., if you were still working at age 60).

But the question has been posed, so let’s answer it!

First up, the very simple case of not giving any value to having the payments early (i.e.: not investing). In that case there’s a break-even point around age 74 in terms of how much total money you can pull from the plan: if you die before age 74, you’ll have squeezed the most out of the plan by taking CPP right at 60. If you live longer, you’ll be glad for having put off withdrawing until age 65 to get that bigger benefit, and it’ll add up to getting more out of the plan in the end. This agrees with most of the articles I’ve found.

If you invest the money you start taking right away (or equivalently, keep more money in your investments because you’re spending the CPP money), then that gives more benefit to having money early on (it compounds). With a 3% real return, that pushes the break-even point back to age 76, and with a 6% return, it pushes the break-even back to age 80.

One non-financial reason for taking it early was given somewhere (and unfortunately I’ve closed the tab, or I’d give credit): even if you get less total payout, you should still take it early because you’ll enjoy a bit of money more at age 60 than you will more money at age 70. Your lifestyle expenses may be higher when you’re a young retiree in good health than when you’re older, so even a reduced pension will be put to better use. On the flip side, your medical bills may be higher in later life, and the higher payout of a deferred CPP payment may come in handy then.

Update: years after this, I’ve had more time to think about this, and the case for deferring is much stronger. That’s because I wasn’t properly considering the importance of longevity insurance — it’s not just about some break-even age. If you can defer, then defer — if you have no savings, then you may have no choice but to take it as soon as you stop working. As for the last point about enjoying it more when you’re younger, when you factor it all in that’s rubbish too — if you have the savings, then you can spend your savings while you’re younger to enjoy the spending at a younger age, which you can do with confidence because the higher CPP payments later in life will be guaranteed and inflation-adjusted. If you want to instead take CPP early to spend when you’ll enjoy it, you’ll end up having to hold back more of your own savings, as you have to be more conservative with your longevity and return assumptions. It feels different to spend the government cheque than your own savings, but you can safely spend more earlier in retirement (out of your own savings) by deferring!

So my final answer is a little wishy-washy: most people will expect to live beyond the break-even point, so waiting until the “normal” age of 65 to take CPP should make sense. However, it’s not by a huge margin, so if you need the money starting at age 60, then take it starting at that point.