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.
Freedom from having to pay taxes, for 5 more days, if you Netfile. This extension only applies if you are going to use Netfile to submit your return, and it only applies if you owe money. As was pointed out by someone, if the government owes you money, they don’t really care WHEN you submit your taxes (but you better be sure you are getting a refund before you procrastinate like that).
Stats Canada reported that economic activity shrunk by 0.2% in February, and this was caused by shrinking manufacturing and wholesale trade, what caused this? Don’t know but it’s not a good indicator that the Canadian economy is going to “weather the U.S. downturn well” as has been said by a few economists. One month does not a downturn make, but it’s something to remember.
This month is a new month, and for me, it means a complete month with lower interest rates on my Mortgage and my line of credit. TD’s prime lending rate is 4.75% right now and if you are curious what rates you can get on a Line of Credit, read Michael James’ essay on that topic, especially the comments, which are very telling as well. I will be taking this opportunity to make the same payments I always make and thus taking more principal off these debt devices.
That is where they have been in the Ottawa area, and driving has been much more expensive. I am paying about $10 more a week for my car to drive (which is a 50% gain in what I was spending), just in gas costs also (not including car wear and tear and insurance). I am attempting to offset that by NOT buying coffee at work (yes I am attempting that again). So far this week, I have only bought 1 coffee, which means I have not bought about 8, so that is quite good (and it does add up to my goal of $10.00 or so). I will keep my readers informed of my progress.
Alcatel (ALA) announced some hefty bad numbers yesterday, with a 5th consecutive losing quarter. This combined with a warning on sales figures and fresh lay off talk, makes the Ottawa Tech sector a little more jittery this month. Nortel (NT) announces Friday morning, and there are concerns of similar statements from the former High Tech juggernaut.
What does this have to do with me? I live in this world, and a jittery world it is right now.
As has been pointed out by both Canadian Capitalist and Michael James the Bank of Canada’s 1/2 point rate drop has not been reflected by the major banks yet, in terms of Mortgage rates (especially in longer term mortgages). Short term mortgages and credit vehicles that are typically based on the Prime interest rate, do reflect this dropping, but longer terms (greater than 6 months) certainly do not reflect this drop.
Why are Mortgage Rates not Lower? Darn good question. Currently the TD Bank’s prime rate is 4.75% and that is also what they are charging on their variable rate 6 month mortgage, however, after that the rates start climbing, to a maximum of 7.75% for a ten year fixed rate mortgage (more than twice the current Bank of Canada rate).
Remember that all rates posted on these sites are negotiable in some fashion or another, and here we come to the real core of this post.
If the bank says, “We don’t negotiate Mortgage rates”, simply leave, and call a Mortgage Broker and you might be surprised that the Broker can get a cheaper rate from the exact same bank (and remember the Broker makes money on this too).
Remember, if you are a good credit risk and you want to truss yourself up with a long term debt like a Mortgage, the Banks want you! They want your business, and they want your money passing through them. They want you even more, if you carry balances on your Credit Cards, but let’s not go to that subject today, but remember, the bank wants your business, and keep that in mind.
When you are talking to a bank about Mortgage rates and such, it is an excellent time to discuss getting Free Banking too. This corporation wants your business, now is the time to be asking (or demanding) for the best deal you can get. Be prepared to talk to a few banks, and also be prepared to be promiscuous with that information, tell the banks the deals other banks are offering you, and see if they will match the deal or even make a better deal (I don’t suggest lying, mostly because I am a lousy bluffer or liar, being dishonest isn’t the way to go).
Let me be honest, I am awful at negotiating, but I am learning that it is an important skill to develop, so I work on it. It is all a game for me, and getting the best deal I can, is the goal of the game. A really good tactic is to get friends or family to tell you what deal they got, and see if you can beat that deal. You may not get that deal, but maybe you’ll get a better deal, you never know, until you negotiate.
The only thing I can tell you for sure, if you do not try to negotiate, you will not get a good deal from the bank. Strangely the opposite of this is not true (i.e. if you negotiate you will get the best deal), but, if you don’t negotiate, I promise you will not get a good deal (unless your father or mother or a relative owns the bank or works at the bank, but then you are playing the game by using connections, so go for it).