
The biggest responsibility we take on as new homeowners is debt re-payment. That cursed mortgage: It enables us to get the home we want, but then sticks around for 20 to 35 years
It is every homeowner’s dream to be mortgage free, but are we doing everything we can to achieve that goal as soon as possible? (I don’t want to wait 25 or 30 years to be mortgage free, I want it A LOT SOONER than that.)
I found this company that specializes in spreadsheets, and they came up with an excellent mortgage calculator for Canadians. I use it extensively with my clients to figure out mortgage payments, personal budgets, and how it all ties in together. You can download it here: http://www.vertex42.com/Calculators/Canadian-mortgage.html (check out their other offerings for family and personal budgets)
Why I like this calculator:
- It lets you put in all the details of your mortgage and choose your Amortization Period (Great for planning)
- It shows you the Fully Amortized cost of your home (what it really costs at the end of the 20-30 years)
- It shows you the Balance at Term (what you’ll have to renew in 3-5 years – The Interest Paid should make you ill)
- It lets you factor in Extra Payments, and as you do, reflects the impact on your Mortgage. (This is the really cool part of the spreadsheet! This is how you become MORTGAGE FREE!)
Most mortgages today have pre-payment options that allow you to make extra payments, this tool helps you visualize taking advantage of those pre-payments.
Say, for example, you have a $400,000 mortgage at 3.49%, amortized over 30 years (a typical mortgage today). Your monthly payments are $1,788.35, and in 30 years you’ll be mortgage free, (assuming the rate doesn’t change in that time period, which it will, but for argument’s sake, it stays steady)
- In the five year term of the mortgage, you’ll pay off $41,428,60 from your Principal, and $65,872.40 in Interest
- Now, you find an extra $100 (one hundred) dollars per month, and add it as an Extra Payment on your mortgage. Congratulations, you just took 2.58 YEARS off your mortgage, saving you $24,373.41 in INTEREST! (Disclaimer: this does assume your mortgage rate will stay the same the whole time, which it won’t, but the principle applies nonetheless)
- With an extra $100/month, In the five year term of the mortgage, you’ll pay off $47,969.41 from your Principal, and $65,331.59 in Interest. That’s an EXTRA $6,540.81 Paid OFF, and about $500 less interest paid.
How are YOU going to find $100 extra per month? Let us know
Alexx



