Experts, shmexperts! All the major sites were calling for a cut to 2.75% on the overnight rate, well the Bank of Canada saw some sense and held their ground and did not cut the rates this time. I think this is a good idea given the Inflation Boogie Man is out there and I suspect he is going to come and stay for a while too!
The comment from the Bank of Canada States:
If current levels of energy prices persist, total CPI inflation will rise above 3 per cent later this year. However, with the Canadian economy operating in excess supply, core inflation is expected to remain below 2 per cent through 2009. Both total and core inflation should converge on 2 per cent in 2010 as the economy returns to balance.
Against this backdrop, the Bank now judges that the current stance of monetary policy is appropriately accommodative to bring aggregate demand and supply into balance and to achieve the 2 per cent inflation target. There continue to be important downside and upside risks to inflation in Canada, which the Bank will monitor closely.
In my humble opinion, for me, I should be paying down my mortgage and debt load, and not concentrating on my retirement.
Until about 1 year ago, I had the potential to get a very good pension from my employer (the pension was capped and a new pension system put in place, although I still have some equity built up in my now capped pension), so I was actually investing heavily in a Spousal RRSP to ensure an income splitting model when I retire.
Currently I save about 8% of my income in RRSP or retirement funds (without including the new Pension that I am currently part of, that I am not sure what value it has yet).
Saving 8% annually approaches what I should be saving for my retirement as a minimum (last I heard most “experts” said 10% is a minimum you should save for your retirement). I suspect I am ok for retirement, whatever that actually means to me (given I don’t think I can retire for a long time, due to family commitments).
What do I mean by the title of this post then? I actually am on the “RRSP That’s the Ticket” side of the question of whether to invest in your retirement or pay off your debts? My answer is I think I made a mistake, and should have been much more aggressively paying off my debt load (which is not as low as it should be currently).
I make this statement as my opinion of how my debt load is affecting me. Let me be clear, carrying debt is making me sick, it keeps me up at night, it distracts me and worries me every day since I went into debt many years ago. I am confident this worry has affected my health directly, worrying about this debt and the scenarios that come from still carrying this debt, this late in my working career.
What should I be doing now is the next interesting question? I think I need to sit down with my wife and figure out how to change all of this, but we were going to do that anyhow given it is almost the end of this home finance quarter.
After last week’s “show and tell” about Mortgage worksheet calculators, the next question to ask yourself is which is more important to pay into your Retirement Fund (RRSP or 401k) or pay off your Mortgage (and debts)? Since the U.S. model has tax implications for paying off your Mortgage, and I do not wish to mention the Smith Manoeuvre for Canada, let’s just concentrate on the Canadian model.
In a lot of cases this question is of no real value since a lot of people can only afford to pay for their living expenses and do not have free money to pay for their retirement or speed up their debt payments, for those folks, the job is hard enough, but I encourage you to find savings somewhere and do something more with your found money than “party” with it.
Some of the reasons I have heard and espouse for paying down your mortgage first would be:
The reasons to put money in your retirement funds are many as well:
That would be telling, I’ll write some more about this tomorrow, but I am open to discussion, pointers to good articles, and any other comments folks might have about what the right choice for them was and is (remember at the end of this, it is a personal choice on your part).
Now that we have figured out how to track our Mortgage using this Mortgage Work Sheet with Excel , we can now start doing some interesting tricks to see what we can do with our Mortgages.
I have some dear friends who paid off the houses they lived in, very quickly each time they moved from house to house (as their family grew). They both had good paying jobs, so they set up a simple goal with their Mortgage, each Mortgage payment they made, they were going to “double up” (i.e. pay a double payment to the bank). They had chosen the type of Mortgage (so there were no penalties to make extra payments) and sure enough they paid off their houses incredibly quickly.
How quickly could this be? If we go back to the model I have been using all week, this is how fast our family could pay off their house if they doubled up on their payments.
| Date | Payment | Interest | Principal | OverPayment | Balance | Total Interest |
| 01-Jun-08 | $0.00 | $100,000.00 | $0.00 | |||
| 1-Jul-08 | $636.84 | $489.80 | $147.04 | $636.84 | $99,216.12 | $489.80 |
| 1-Aug-08 | $636.84 | $485.96 | $150.88 | $636.84 | $98,428.40 | $975.75 |
| 1-Sep-08 | $636.84 | $482.10 | $154.74 | $636.84 | $97,636.83 | $1,457.85 |
| 1-Oct-08 | $636.84 | $478.22 | $158.62 | $636.84 | $96,841.37 | $1,936.07 |
| 1-Nov-08 | $636.84 | $474.33 | $162.51 | $636.84 | $96,042.02 | $2,410.40 |
| 1-Dec-08 | $636.84 | $470.41 | $166.43 | $636.84 | $95,238.76 | $2,880.81 |
| 1-Jan-09 | $636.84 | $466.48 | $170.36 | $636.84 | $94,431.56 | $3,347.29 |
| 1-Feb-09 | $636.84 | $462.52 | $174.32 | $636.84 | $93,620.41 | $3,809.81 |
| 1-Mar-09 | $636.84 | $458.55 | $178.29 | $636.84 | $92,805.28 | $4,268.36 |
| 1-Apr-09 | $636.84 | $454.56 | $182.28 | $636.84 | $91,986.16 | $4,722.92 |
| 1-May-09 | $636.84 | $450.55 | $186.29 | $636.84 | $91,163.03 | $5,173.46 |
| 1-Jun-09 | $636.84 | $446.51 | $190.32 | $636.84 | $90,335.87 | $5,619.97 |
| And a lot of time passes | ||||||
| 1-Jan-14 | $636.84 | $191.50 | $445.34 | $636.84 | $38,015.14 | $23,351.38 |
| 1-Feb-14 | $636.84 | $186.20 | $450.64 | $636.84 | $36,927.66 | $23,537.57 |
| 1-Mar-14 | $636.84 | $180.87 | $455.97 | $636.84 | $35,834.86 | $23,718.44 |
| 1-Apr-14 | $636.84 | $175.52 | $461.32 | $636.84 | $34,736.70 | $23,893.96 |
| 1-May-14 | $636.84 | $170.14 | $466.70 | $636.84 | $33,633.17 | $24,064.10 |
| 1-Jun-14 | $636.84 | $164.73 | $472.10 | $636.84 | $32,524.22 | $24,228.83 |
| 1-Jul-14 | $636.84 | $159.30 | $477.54 | $636.84 | $31,409.85 | $24,388.14 |
| 1-Aug-14 | $636.84 | $153.84 | $482.99 | $636.84 | $30,290.02 | $24,541.98 |
| 1-Sep-14 | $636.84 | $148.36 | $488.48 | $636.84 | $29,164.70 | $24,690.34 |
| 1-Oct-14 | $636.84 | $142.85 | $493.99 | $636.84 | $28,033.88 | $24,833.19 |
| 1-Nov-14 | $636.84 | $137.31 | $499.53 | $636.84 | $26,897.51 | $24,970.50 |
| 1-Dec-14 | $636.84 | $131.74 | $505.09 | $636.84 | $25,755.58 | $25,102.24 |
| 1-Jan-15 | $636.84 | $126.15 | $510.69 | $636.84 | $24,608.05 | $25,228.39 |
| 1-Feb-15 | $636.84 | $120.53 | $516.31 | $636.84 | $23,454.91 | $25,348.92 |
| 1-Mar-15 | $636.84 | $114.88 | $521.96 | $636.84 | $22,296.11 | $25,463.80 |
| 1-Apr-15 | $636.84 | $109.21 | $527.63 | $636.84 | $21,131.64 | $25,573.01 |
| 1-May-15 | $636.84 | $103.50 | $533.34 | $636.84 | $19,961.47 | $25,676.51 |
| 1-Jun-15 | $636.84 | $97.77 | $539.07 | $636.84 | $18,785.57 | $25,774.28 |
| 1-Jul-15 | $636.84 | $92.01 | $544.83 | $636.84 | $17,603.90 | $25,866.29 |
| 1-Aug-15 | $636.84 | $86.22 | $550.61 | $636.84 | $16,416.45 | $25,952.51 |
| 1-Sep-15 | $636.84 | $80.41 | $556.43 | $636.84 | $15,223.18 | $26,032.92 |
| 1-Oct-15 | $636.84 | $74.56 | $562.27 | $636.84 | $14,024.07 | $26,107.48 |
| 1-Nov-15 | $636.84 | $68.69 | $568.15 | $636.84 | $12,819.08 | $26,176.17 |
| 1-Dec-15 | $636.84 | $62.79 | $574.05 | $636.84 | $11,608.20 | $26,238.96 |
| 1-Jan-16 | $636.84 | $56.86 | $579.98 | $636.84 | $10,391.38 | $26,295.82 |
| 1-Feb-16 | $636.84 | $50.90 | $585.94 | $636.84 | $9,168.60 | $26,346.71 |
| 1-Mar-16 | $636.84 | $44.91 | $591.93 | $636.84 | $7,939.83 | $26,391.62 |
| 1-Apr-16 | $636.84 | $38.89 | $597.95 | $636.84 | $6,705.05 | $26,430.51 |
| 1-May-16 | $636.84 | $32.84 | $604.00 | $636.84 | $5,464.21 | $26,463.35 |
| 1-Jun-16 | $636.84 | $26.76 | $610.07 | $636.84 | $4,217.30 | $26,490.11 |
| 1-Jul-16 | $636.84 | $20.66 | $616.18 | $636.84 | $2,964.28 | $26,510.77 |
| 1-Aug-16 | $636.84 | $14.52 | $622.32 | $636.84 | $1,705.13 | $26,525.29 |
| 1-Sep-16 | $636.84 | $8.35 | $628.49 | $636.84 | $439.80 | $26,533.64 |
That’s amazing, you pay off the house in 8 years (give or take a month or two). Can most people do this? Not very likely, but it is something to think about and play with. Can you pay off your house early if you give up going out as much, and instead pay your Mortgage down? That is the question to ask.
With this worksheet you can explore the following interesting scenarios:
Use this worksheet as a tool, and learn about what you can and cannot do when you buy your house.
Yesterday I showed how the simple PMT() function in Excel can be used to estimate your periodic mortgage payments, if you have all the pertinent information. Today we can use that information to build a schedule to show your mortgage payments and how they change your Mortgage Principle over time.
First a clarification, as was pointed out by one of my commenters, the PMT() function gives you the wrong periodic payment, due to Canadian Mortgages having their interest compounded semi-annually (twice a year) whereas in the U.S. it is compounded annually. The fix for this is to change the first entry in your PMT function from:
I like a Mortgage Schedule Table, just because it gives you the ability to understand where you stand in terms of paying off your loans.
Each row of the table will show a payment, how it breaks down in terms of interest and principle payment and how much principle remains after each payment (sounds simple doesn’t it, well it is):
Let’s try this example and show some of the sheet. Assume a $100,000 Mortgage, with an interest rate of 5.95% compounded semi-annually, with a 25 year pay back with monthly payments. We use the PMT() function to find out that our monthly payment will be $636.84.
The sheet will be laid out in the following way:
| Mortgage Schedule | |||||
| Mortgage Amount | $100,000.00 | Interest | 5.950% | ||
| Monthly Payment | $636.84 | Years | 25 | ||
| Periods/Year | 12 | ||||
| Term | 300 | ||||
| Start | 01-Jun-08 | ||||
| ========================================================================== | |||||
| Date | Payment | Interest | Principal | Balance | Total Interest |
| 01-Jun-08 | $0.00 | $100,000.00 | $0.00 | ||
| 1-Jul-08 | $636.84 | $489.80 | $147.04 | $99,852.96 | $489.80 |
Simple isn’t it?
You just keep going line by line for 25 * 12 times for all the payments and you will see the loan drop to zero. Hopefully tomorrow I will have a link to the example worksheets I set up, for both US and Canadian Mortgages.
More interesting versions of this is if you add an OVERPAYMENT column and then start seeing what happens when you add extra payments early on and how much faster your mortgage gets paid off!