TFSA Over-Contributions

August 29th, 2014 by Potato

The stats on how many people got nastygrams from the CRA with penalties for over-contributing to their TFSAs this year have come out, and there’s a lot of shock over the fact that this keeps happening. Young recently made that mistake.

I will say it again: the onus is on you to track it yourself. The web portal is known to be dramatically out-of-date. IMHO the CRA should just take it down because it’s misleading and the opposite of helpful. Young suggests calling to get a more up-to-date reckoning. This may be more up-to-date than carbon dating the archeological evidence in the sedimentary layers of the web portal, but I can guarantee someone will be caught by this system also being out-of-date at some point. There is no getting around the fact that the CRA can’t give you an updated contribution limit if the banks haven’t sent them the information (and as an aside, it’s really weird to me that phoning will get you more up-to-date information than the computer system, like we live in an age where there’s a pile of paper forms on somebody’s desk that haven’t been entered into the computer yet). And the CRA will not accept responsibility for telling you that you have contribution room left when they later determine that you don’t.

I make tracking it simple on myself: I max it out in one call the first week of January, and then forget about it for the rest of the year. Now that’s only possible because I had non-registered savings and investments when the TFSA was launched, and continued to have non-registered funds every year, so I just have to call up TD, make an in-kind transfer of some shares, and contribute whatever cash is needed to round out to the limit (which I can then use to buy e-series with inside the TFSA).

But whether you have a simple system so you don’t screw it up (like contributing in one chunk, or an automatic monthly contribution that keeps you under the limit), track it religiously, or go through all your statements on an as-needed basis to forensically re-create the events in question, ultimately it’s up to you to not over-contribute.

Other Rent-vs-Buy Calculators

August 22nd, 2014 by Potato

I’ve done a lot of things I’m proud of. I think the rent-vs-buy spreadsheet has to feature somewhere near the top of that list (at least if we limit the discussion to things I’ve done for personal finance). It’s the only such calculator to let you include the risk of future rate increases, and includes many important factors without completely blowing the whole thing open to the maze of apples-to-basement-suite type comparisons. Rather than starting blank or with valuations that may have been relevant in 1995, it’s prepopulated with recent data from Toronto (and every 6 months or so I even update the interest rate projections based on what’s available in the mortgage market). Moreover because it’s a spreadsheet you can check the math (or tweak it to do an apples-to-basement-suite comparison) if you so choose.

Really the only drawback is that it’s a spreadsheet rather than a flashy widget (and I keep meaning to get around to learning how to code those but it’s just too big a time commitment for me now), which seems to hurt its popularity. Because other rent-vs-buy calculators are still popular, let’s take a tour through the options.

New York Times: The NYT calculator was updated recently. It takes a neat approach in that instead of getting you to tell it what the cost of rent is, it computes what the equivalent breakeven rent would, and leaves it up to you: “if you can rent for less than this, then rent.” It also has itty-bitty graphs that show you the sensitivity of the outcome to each factor. Now, I prefer my approach because it’s clearer what the magnitude of that is. Maybe you can rent for less, but if it only works out to $10k more over 10 years, maybe “pride of ownership” is worth that. Or maybe the difference merely looks small when expressed in monthly terms: if NYT says to rent below $2500/mo and you find a place for $2000, maybe that sounds like it’s close enough to break-even that you’ll just buy. But if you saw how quickly that difference compounds into hundreds of thousands of dollars, maybe your decision would be different. There’s no way in the current NYT calculator to enter your market rent to make a comparison.

My main beef with the NYT calculator is that you have to tweak it for Canadians in really non-intuitive ways. The big change is that you have to set your tax rate to zero — in the calculator it’s not the investments that are being taxed, but that Americans get a tax deduction for mortgage interest. I think the NYT one is the most-recommended one out there. Even Rob Carrick recommends it on a regular basis, which stings because the refinements to my calculator came about through discussions on his facebook page. Rob Carrick why don’t you love me??? Ahem. Anyway, it’s not bad — actually rather good if you’re American — it’s just that the link doesn’t usually come with the appropriate Canadian conversion kit, and there are Canadian calculators [waves] available.

Getsmarteraboutmoney: This one IS BROKEN. Stop sending people to it. I talked about the “wonky” results back in December, and emailed them about it as well. They acknowledged the problem back in March and said they would fix it soon. Well, it’s still broken and there isn’t even a notice on the webpage about it or anything. The main problems are that it always sells in year 30, so you can’t compare other holding periods (even though the graph visually implies that it is looking at break-even times), but the larger error is that it does not compound the differences in cashflow between the renting and buying option. That can really skew the difference between the options over a long time period. Otherwise it is flashy and pretty and has sliders for all the right things, so it should be good to go in a couple of years when they finally fix the back-end calculations. Of course, that just makes the math errors that much more tragic because it looks like it should be fancy and trustworthy.

RBC: To be clear, they call it a “rent or buy calculator,” not me. It is simply not a calculator to compare the two options. The only inputs are how much you pay in rent, what interest rates are, and how long you want your amortization period to be. Then it tells you how much house you could buy with a mortgage payment “equivalent” to your rent — note that it ignores tax and maintenance and opportunity cost and insur– just all the costs. Every ownership cost you can think of, it is ignored. I’m hoping it ranks so highly in Google because they bribed someone and not because people are actually linking to that POS.

In fact as a short-cut, if a rent-vs-buy calculator doesn’t have an input for your investment return as a renter, just throw it away. It’s likely missing a number of other important factors for the decision. Naturally, Genworth’s is similarly biased, as are most of the other big bank ones. CIBC’s is not that bad, but it does miss transaction costs and insurance. Its rates of return for a renter’s investment and the house are are unhelpfully labelled “market appreciation” and “rate of return” — you tell me which is which.

First Foundation: They recently launched their suite of calculators, including a rent-vs-buy calculator. It seems to do all the calculations properly and includes the most relevant factors. I could nitpick and add the ability to include future rate increases or whatever, or to start with all three tabs open, but the only real criticism I have of it is that the default for maintenance is zero rather than some wrong-but-better-than-zero approximate number. Also, the property taxes are annual while the maintenance is monthly. It’s explained in the tooltip, but the average user buzzing through it might get wonky results before realizing the problem. It’s not mine, and I can quibble, but the math checks out and it includes the important factors others often miss — First Foundation gets the nod.

Money Geek: I opened it up and I was like “nnnnnnuuugggggghhhhhhhh…” as my brain started to overload. This must be how other people feel when they open one of my ridiculously overly detailed spreadsheets. I can’t actually evaluate it because it only works in the bleeding-edge versions of Excel. But it’s there if you can get past that technical challenge.

Yahoo Finance: I’ve seen this exact one around on other sites, so it must be a licensed calculator/widget. Anyway, all the tax issues of being American, without the benefit of sensible defaults (0% selling cost yet 5% house appreciation?). It’s also a little odd in that it subtracts the opportunity cost of investing the down-payment from the owner’s side rather than adding the value to the renter’s side — I haven’t thoroughly tested it to see if that still gives the correct results but a spot test looked in the ballpark.

Life Insurance Bete Noire

August 4th, 2014 by Potato

Just before Blueberry was born, we had a discussion about why we didn’t need life insurance for our situation. I’d like to broaden that discussion a bit, but I have to tread carefully. There are many who are under-insured not because they have decided that insurance isn’t for them, but because they just haven’t gotten around to it yet. I don’t want to encourage further procrastination (well, I do — don’t go off and work, read my blog!), and it can be very important for many people out there. But at the same time the insurance sale may be a bit heavy-handed and the base assumptions seem to increase the apparent need. Part of that may be my perspective: my value system is compatible with the idea that my survivors’ lifestyle shouldn’t be completely untouched (let alone improved) by my passing.

Here is why I’m out of the mainstream:

  1. my idea of dependents
  2. my idea of lifestyle of survivors
  3. my assets/situation

The idea of dependents is a bit of a strange one these days: kids are and always will be, but we are long past the time when the typical family consisted of one breadwinner head-of-household and a stay-at-home spouse (who was typically the female head-of-household). Many families are dual-income now, and even many of the ones that presently aren’t could be (modern stay-at-home mom or dad is likely university educated and had a career before getting hitched at an ever-later age and spawning). So your family would be without your income if you died, but they could still have some income. In our case, Wayfare actually has a much higher earnings potential than I do, and after Blueberry’s in school she could ramp up her hours worked to fully offset any loss of income from my death.

The assumptions of what the needs of survivors will be also seems a little over-the-top to me: some sites suggest full income replacement until you would have retired. But if I’m not there to spend part of that money, it means that my survivors would have an economically better life than if I were still there (except for the dark void in their hearts). Liabilities are also a typical factor in calculators estimating your needs: having enough to instantly pay off the mortgage is common, but seems to imply that they would or should stay in the same house, rather than downsizing, and that the surviving spouse wouldn’t be paying any of that down. For mortgagees, some insurance is a good idea because house prices can go down and transaction costs can be high, and you don’t want your survivors trapped and unable to extract the equity to move on.

The typical assumptions seem to imply that the survivors won’t make any adjustments in their life, work, or spending to compensate for the loss, which can lead to some large insurance needs. Instead, I figure that if I die, Wayfare and Blueberry will be free to move to a smaller, cheaper rental. There will be no need for a place so large with one person down (my whole dual-monitor home office set-up will reduce the room needs by one, and I don’t think Wayfare needs a kitchen half as large as the one I insisted on). And part of the reason for living in the over-crowded fourth circle of hell Toronto is the arcane arithmetic of the two-body problem and large populations; freed of that constraint they could move to a cheaper centre like Hamilton or London. Combined, a smaller place in a less-expensive town (or even less-expensive part of Toronto) could cut rent costs in half. On top of that is the significantly non-zero probability that Wayfare will find a replacement spouse who is gainfully employed.

Having a contingency so that these adjustments don’t have to happen right away makes sense, as does enough coverage for daycare until Blueberry is in full-time school. That’s where our situation also helps with my estimate of minimal insurance needs: we already have over a year’s worth of expenses saved up, and supportive parents who could provide an additional layer of security if we badly screwed up the math. As it turns out, my job came with group benefits for some measure of life and disability insurance (and it is the disability insurance I am more worried about).

Death is tragic, but from a financial perspective it’s not the biggest cause of young families losing an income. Divorce can not only rip daddy away, but cause massive upheaval and lead to a chunk of the “estate” being lost to lawyers. I’m ok with the idea that if I die, even with just 2 years of income for insurance coverage, my family will still be better off than those who started from similar circumstances and got a divorce. But I don’t want to make the delta so large that perverse incentives form.

Back to insurance: I actually found it quite hard to find ballpark quotes on disability insurance outside of my group plan. For life insurance I think it is important to disaster-proof your life, but the actual coverage need might not be quite as high as some calculators suggest, if you’re ok with the idea of your survivors taking basic steps to adjust for the loss.

The Automagical Financial Planning Ballparkinator

April 14th, 2014 by Potato

TLDR: A single, straight-line calculation of invest $X/yr at Y% returns is a little too simplistic for your retirement planning, but a Monte Carlo or exhaustive simulation can be overwhelming. I think a good middle-ground is to find a ballpark number of how much you need to save, and to see where that puts you under good, decent, and relatively poor investment outcomes so you can figure out if you’re in the right ballpark. Download Potato’s Automagical Financial Planning Ballparkinator here.

I think hands-down the most common two questions I get related to finances are “how do I…” (for which I’ve written a whole book and have a course) and “how much do I need to save, anyway?” There are a host of tools available on the internet to try to answer this, but they’re all fairly simplistic — as few as three factors are considered, with many hard-coded variables. If you’re still decades away from retirement then you really just need a ballpark number to get started, and for that those tools are pretty good — heck the “save 10% of your income” rule-of-thumb is not terrible, and it doesn’t even specify whether it refers to pre-tax or after-tax income, or to what age range it applies.

But of course I wanted something a little more detailed with more things to tweak. More importantly, I wanted to put up side-by-side comparisons of some important scenarios so people didn’t have to refresh their web browser a dozen times to get an idea of where to go. May I present Potato’s Automagical Financial Planning Ballparkinator. Available in Excel.

There are many possible shapes to the future, so how much you need to save decades in advance will only ever be a rough estimate. This will help you figure out what the general ballpark estimate of that number should be. It’s based on my retirement planning spreadsheet calculator — I added a more robust tax calculation (including OAS clawbacks), and of course the whole soup-to-nuts saving through retirement component, but have removed some of the finer features (like non-flat budgets and personal inflation rates). It does include a separate field for your investing fees (MERs) so you can see the impact of those without having to directly adjust the returns in the scenarios (and more directly, to put that factor front-of-mind).

It calculates forward based on your current savings rate (and a bunch of other assumptions) to find out how long your money will last under that plan, and also estimates backwards from your budget needs, accumulation years investment returns, and a sustainable withdrawal rate to rough out how much you should be saving (annually). Note that the backwards calculation bundles all account types together for the calculation and does not account for taxes — a much rougher estimate and more similar to the simplistic web-based tools common on many bank websites.

The results are presented in a little table to examine three scenarios for future returns (a base, worst, and best case), which you can of course define yourself, and for four risk profiles/asset allocations: ultra-conservative (all fixed income), balanced (50/50), risk tolerant (mostly stocks), and all stocks. This is important as the rules of thumb like “save 10%” are based on having enough of a balance to get something close to equity-like returns on your savings. If you are like many people today, scarred by 2008 and unable to contemplate anything more volatile than a package of bonds, then you will have to cut your spending budgets and save substantially more every year to make up for that ultra-conservatism in your investments. Similarly, if you don’t start investing until you’re in your 50’s, then you’ll have to put away substantially more than 10% of your income.

Figuring out your future spending needs may be the most difficult part. For your future budget you can start with your current spending needs, and take your best guess as to how they will change in the future. More travel, but less commuting? No more mortgage payments, but added expenses for lawn care & snow removal that you used to handle yourself? The default in the spreadsheet is to take 75% of your current spending budget, but definitely put careful consideration into this figure — and try out a few iterations.

Note that this is not a full financial plan, not by a long shot. There’s nothing here about contingency plans, goals, motivations, asset allocation, rebalancing plans, insurance, emergency contacts1, taxes and tax shelters, short-term savings goals, or really much of anything else. I’m hoping one day someone will get around to showing us what a good, complete financial plan looks like. Until then: ballpark, get started, evaluate, adjust.

Also, if you need help estimating how much you’ll get from CPP, I have a tool for that here.

1 – no, not poison control. Who will calm you down when markets are roiling? Who will your family call if you’re dead or incapacitated, who has your will?

Update, April 16, 2014: Thanks to Spudd at CMF (no relation) for pointing out that there was a problem with early retirement scenarios and the RRIF table. I’ve provided rough guidance for that going back to age 20 — it might not be the right amount to start withdrawing from an RRSP right away, but it should be reasonably close and at least returns something for early retirement scenarios now. I’ve replaced the sheet on the site, the link remains the same.

Update, July 2017: I’ve fixed the “backwards” calculation with a better approximation, one that uses a few different ranges of sustainable withdrawal rates. There was also a pretty bad bug when RRIF withdrawals satisfied cashflow needs, but money was still being pulled from a TFSA anyway that’s now fixed.

Rebalancing Spreadsheet

April 4th, 2014 by Potato

Canadian Capitalist and Squawkfox have created rebalancing spreadsheets to help you when it comes time to rebalance your portfolio. They are somewhat simplistic and hard-coded with the funds — this is a good thing if you’re following the Sleepy Portfolio or one of the Couch portfolios: just enter the current value, the money you have to add, and see how to split your new purchase up.

I wanted one with a bit more flexibility: one that would allow for a few broad categories of investments, with sub-investments. For instance, if I had small bits of cash left over at various points through the year I might throw them into a TD e-series fund, and as long as my overall Canadian/US/International split was ok I wouldn’t worry about rebalancing the e-series versus ETF splits. Or similarly if I had several sub-products to make up one sector, like counting BRK.B and VTI together for US exposure, but not caring too much whether that split was 50/50 or 60/40. Also rather than just entering the current value, the sheet lets you enter the price and the number of units in your various accounts. With the units entered, half the work is done for the next time you want to rebalance (just update the unit prices).

The sheet calculates and displays the variances (how much you are off by), and then also calculates how many units of each fund you need to buy to get back into balance. Note that you should generally round down so that you don’t over-spend the funds in your brokerage account. In the top row you can enter how much new cash you have to invest, or enter a negative value to withdraw cash from your portfolio.

The spreadsheet is available here in Excel, or through Google Docs* here. Enjoy!

* – Google can try to call it Drive, but Docs has stuck with me.