Category Archives: Tools

The Canada Pension Plan Mystery

Let’s face the facts estimating your CPP pension when you retire early is very hard to do.  For a lot of people doing it yourself is a bit of mystery.  So today is the step by step guide to doing your own estimate. Actually in all my calculations or looking for it I’ve only found one site that works: from the government of Canada.

The calculator lets you do a few interesting things.  First it let’s you see what you get if you start collecting the money between 60 and 70.  Also it allows you to change your average earnings at some point during your life which you can use to simulate an early retirement.

So here is the procedure to get your estimate:

  1. Get a statement of contributions with a current estimate of your CPP benefits. You can either get a copy from online or request a paper copy to be mailed to you.  Or if you have the paperwork average your income from the year you turned 18 to now.  If you don’t have it you can still use the calculator, but the estimate is rough.
  2. Got to this calculator at first you will deal with entering your date and month of birth and then do your OAS estimate.   We you get to the section about your CPP benefits do the following.
  3. It will ask you if you have an estimate.  If so, select Yes.  Then enter in your estimate of your pension and the month and date of the estimate.
  4. If you don’t have an estimate do the following.  Select No.  Then it will let you select your average earnings from when you turned 18 till now in $5000 intervals up to  $46,300 (the max).  I highly caution you to choose a lower number.  Most people forget how little they earned back between 18 and 25 and it will really drag down your average.  For example in my case if I didn’t have an estimate I would likely guess my current average is $35,000.
  5. Then at the bottom of either page it will ask if you want to see what happens if you take your CPP between 60 and 64.  I selected Yes.
  6. Then pick your start age.  I took 60.
  7. Then it will give you an estimate of your pension at 60. Hit Next.
  8. Then it will ask do you want to estimate what happens if your future earnings change.  Here is where you can simulate an early retirement.  Select Yes.
  9. Now you can pick two income estimates and an age when the first will stop and the second will start.  So if you expect to fully retire early choose the second estimate at zero.  If you plan to do some work till your 65 enter a very low number.  In my case I choose $35,000 till age 45 and $5000 from that point onwards.
  10. Then it will provide a modified pension amount.  Again you can choose to take it early.  I selected Yes.
  11. I picked 60.  Then I got my pension estimate of $338 per month starting at age 60.

So there is your step by step guide the the wonder world of CPP estimates.  Oh, a point of caution.  The calculator may get buggy if you keep shifting back and fowards changing numbers.  So do one estimate stop and then restart the calculator if you want to try something else.  Enjoy.

The Box Diagram

Alright. I will face the facts I’m a bit of money tracking geek. In my quest to reduce my bank fees a while back I developed a little tool which allowed to me keep the minimum number of accounts and keep my total transactions to a bare minimum. I call it the box diagram. All you need to use it is your accounts and one excel sheet.

You see I can infinitely divide up any account I own into smaller pieces if I want. For example, the saving account typically has at least four or five sub accounts to it that I track in a spreadsheet. For example, I may have the following sub accounts: insurance, Christmas, vacation, Tim’s slush fund, and parental leave savings.

Now typically moving money around for that many sub accounts could be a nightmare, but the box diagram can take all my monthly transactions for these areas into a single bank transaction.

This is what a generic box diagram looks like:

In ——->___BOX____——->Out

Now here is how I use it:

$150 Insurance–>

$125 Christmas–>

—->$100 Tim’s Slush Fund

$200 Leave Savings–>

Therefore net I need to move into savings $150+$125+$200-$100=$375.  I just enter the correct transaction amounts into my excel sheet for each move, but for the actual bank transfer I only move the money once.  So in this case four transactions become one.

Now this is just how I do it.  If you have a different method, please share.

How much do you need to Retire – Version 3 – Part V

Alright after four long days we finally pull off this information together to see if I can retire at 45 (at least in theory). For your reference here are links to the rest of series:

Part I – Finding out your spending in retirement
Part II – Government Benefits
Part III – Company Pensions
Part IV – Retirement and Taxable Accounts

First a quick review of the numbers and when I expect to start collecting them.

From 45 to 60:
Here I only plan to use my taxable investment accounts, RRSP accounts and that $2000/year dividends I mentioned.

From 60 to 65:
At this stage we expect to collect CPP ($6660/year) and start to use my pension money ($2344/year) and keep using the RRSP, taxable accounts and dividends.

From 65+:
I’ll be keep using my CPP, pension money, RRSP, dividends and OAS ($12,054/year).

In order to make this clear I put together a spreadsheet to show how the money is being used at each stage. The far right column is what is required from the taxable accounts and RRSP each year.

http://spreadsheets.google.com/pub?key=pIbm-AobFY4BMy_GmkftoWA

So now to make this all work I need to simulate a draw down of the money in the RRSP’s and taxable accounts. To keep this fairly simple I’m going to merge the RRSP into one pool of money and assume I can split the withdrawal amounts proportionally between the accounts (ie: the RRSP pool is bigger so it will cover more of the expenses). I dig out that same calculator I’ve been using all week and enter the following for the first stage ages 45 to 60:

RRSP (45 to 60)

Start at $224,652
Saving rate of -$1189.87/month (this is just that 58% of the $24,618/year in the spreadsheet)
At 4.0% for 15 years (I reduced the return to reflect a more conservative portfolio)
Results in $116,118.71

Taxable Account (45 to 60)

Start at $163,228
Saving rate of -$861.63/month (this is just that 42% of the $24,618/year in the spreadsheet)
At 4.0% for 15 years
Results in $85,085.25

Ok so far so good, but I still need to keep using this accounts from ages 60 to 65:

RRSP (60 to 65)

Start at $116,118.71
Saving rate of -$754.67/month (this is just that 58% of the $15,614/year in the spreadsheet)
At 4.0% for 5 years
Results in $91,746.70

Taxable Account (60 to 65)

Start at $85,085.25
Saving rate of -$546.49/month (this is just that 42% of the $24,618/year in the spreadsheet)
At 4.0% for 5 years
Results in $67,657.07

Well that isn’t bad so far, but now I’m on to the really long haul ages 65 to 90:

RRSP (65 to 90)

Start at $91,746.70
Saving rate of -$172.07/month (this is just that 58% of the $3560/year in the spreadsheet)
At 4.0% for 25 years
Results in $160,512.73

Taxable Account (65 to 90)

Start at $67,657.07
Saving rate of -$124.60/month (this is just that 42% of the $3560/year in the spreadsheet)
At 4.0% for 25 years
Results in $119,544.86

What?!?! How did my numbers increase? Simple I wasn’t pulling off enough money to out pace the interest. So that means I have excess money in my retirement calculations. So obviously I have a bigger buffer than I thought even with my 1% reduction in investment performance. As a point of interest I tried lowering the interest rate to see if I could run out of money on the taxable account in that last run of time (65 to 90). So at 0.5% interest I would still have over $36,000 at age 90. Basically as it stands I can’t run out of money regardless of how long I live. It also provides a nice buffer in case the government decides to cut back the OAS program on me.

Yet there is a hole in the above calculations. I forgot to account for my $90,000 vacation fund back in Part I. Yet I haven’t used any money from down sizing a house and my total savings here isn’t my total free cash flow for the year (I could still save more). So in either case I feel I have enough back up plans to cover myself (for those who are truly curious you could recalculate the above with an extra $3000 a year expense from ages 45 to 75 to see if I could do with any additional savings).

So how much is it going to cost me to retire at age 45? Well recall all of these calculations are in today’s dollars so at age 45 I should own my house and have around $475,000.  So much for that million dollar price tag people keep going on about.

Have a great weekend everyone and let me know if I missed anything in the above.