The Mortgage Planning Spreadsheet

Yes!! It. Is. Here!!!

In many of my articles I have encouraged you to use a spreadsheet to track, measure and improve your spending not to mention mutilate your mortgage more effectively. It is also great for motivational purposes and, as I’m sure many will testify to, addictive. I know you all want to kill that mortgage and do it quickly. You want a plan that’s proven to work, easy to follow and simple to understand without all that annoying finance mumbo-jumbo crap. Well today I thought I’d let loose something I’ve been working on for many years. Something that will be the centrepiece in destroying your mortgage.

I could no doubt sell this to many people with the right spin, but that’s not the point of this site. This site is about teaching and pushing you to mutilate that mortgage of yours. I want to provide you, the reader, with the best information possible for free so that you can cut through all the crap out there and focus on the true important things that make a difference in paying off a mortgage. Most “pay off your mortgage quicker” posts are cheap, top 10 style lists that say the same old dry stuff again and again (seriously, Google it, it’s horrible). “Make sure you’re getting a good interest rate“, “Make sure you pay fortnightly“. They are bits of candy that you can read in 1-2 minutes, think “yeah, those are some alright idea’s” and then close it down feeling good about yourself that you’ve read it.

I want you to come to Mutilate The Mortgage for far more advanced, leading class help in getting rid of your debt and this is to be the crown jewel. This spreadsheet forms a strategy that guides you step by step in paying off that mortgage quicker whilst not treading too far into the “deprivation zone” so many people associate with budgeting. So don’t just browse over this document like it’s one of those “Top 10” lists, if you are looking for those disposable reads leave this site now as it’s not for you. This is to become the centrepiece to mutilating your mortgage. It is important, will take up a small amount of your time (5 minutes or so each month) and there is a learning curve, but the rewards are extremely worthwhile. You will feel more in control of your finances, you will have a specific end date for your mortgage that will greatly motivate you and you will be able to see in real time what effect your expenses have on the loans end date.

The spreadsheet itself hasn’t taken me multiple years to build, however the research, ongoing testing, refinement and ultimate creation has taken over 3 years to put together. Throughout the years I have investigated dozens of various possibilities to cut down mortgage terms and only kept the best. The ones that make the MOST impact on the loan. It may seem simple on the surface, but that is just the honest brutal truth coming through. It is the result of many, many revisions. It’s been filtered, optimized, tested, optimized again, tested again and tweaked with all the most important things you’ll need built right into it and simplified to the core. To mutilate a mortgage it must take top priority and you must cut away all the other expenses so that everything possible is thrown at getting rid of that giant elephant. This spreadsheet combines all the complex research, adds in a pinch of psychological points and boils it all down to a specific plan to freedom. So without further ado, I give you…

The Mortgage Planner Spreadsheet

The Mortgage Planning Spreadsheet

Known from now onwards as “The Spreadsheet”

Step 1:

Click the link above (or this one) and be whisked away to a land of pleasant looking spreadsheet cells that are super easy to personalize. Please note, for those of you squeamish about entering in personal financial details online this is a read only version. This means that to actually edit and use this for your own purposes (which I highly suggest) you will have to make a copy for yourself. This copy will be bound by your Google Account and so no one else has access to it. Making a copy is simple, just open the spreadsheet and click “File -> Make a copy…” as shown below.

Your Own Mortgage Spreadsheet

If you’d rather not work with Google Drive then you can also choose to download it as an Excel file and use it that way. Use the “File -> Download as” option.

Once that’s done your new copy will open up in a new window.

Step 2:

Once you have copied the document to your own Google Account you can begin editing the fields as specified by the orange instructions. You should only change the blue fields and there are tips on some of them with further clarification. Fill out your:

  • Personal Information
  • Income Information
  • Mortgage Information
  • The Expenses tab.

When filling out the Expenses tab (the tabs of the spreadsheet are located at the bottom) please don’t feel that you have to be 100% perfect.

“The greatest enemy of a good plan is the dream of a perfect plan.” – Prussian General Karl von Clausewitz, Vom Kriege, 1832

Even if you simply estimate the numbers off the top of your head it is better than doing nothing, the main focus should be on just getting some information in there. If your expenses aren’t 100% accurate then the numbers will be off, but as you continue to use The Spreadsheet you will be able to update them and approach perfection. In truth, even my own Expenses tab isn’t 100% perfect as expenses fluctuate wildly I’ve found. You may start a new exercise routine of swimming daily, decide you don’t need a haircut as often, want to travel more and so on however with The Spreadsheet you can quickly punch in the new number and make an informed decision of whether that new expense is REALLY worth it or not. One of the biggest advantages of The Spreadsheet is its ability to simulate “what if” scenarios on the fly. “How much sooner would we pay off the mortgage if we only had one car?” is something that’s easily answered. Simply delete the “Car Expenses” and look at your Mortgage Plan tab for an updated end date.

 Step 3:

Once you’ve entered in all the figures you can now have a look at all the automatically calculated data and graphs. The main area is the very first Dashboard tab which gives you a snapshot of what should be happening money wise each fortnight. Who is getting paid what, how much your loan payments should be and how much each of your expenses are. It also gives you your total net position and a graph outlining your specific mortgage plan.

As I’ve said before, your mortgage is quite likely THE most important expense going on in your life. Other expenses pale in comparison and getting all up in arms about petrol going up 4 cents a litre is stupid if you’re completely ignoring your mortgage. Most will dislike this idea but use The Spreasheet fortnightly. Each fortnight, around pay day, give it a quick 1-2 minute look over. Update your bank account values (as you just got paid), make sure your mortgage is at where your plan says it should be at and if you feel like it, maybe have a look at what expenses you may need to investigate. Yes, this is an ongoing thing. Yes, it requires discipline. No, it’s not hard, it takes in total about 5 minutes per month to do and will save you thousands of dollars. It might seem simple, but it is the secret to conquering Long Term Problems.

Finally:

As a last point in describing The Spreadsheet I’d like to point out the giant red bold note on the Dashboard tab.

“Until this debt is erased, the mortgage is priority number one.”

This should ideally be read every fortnight or so to continuously remind you that no, you’re not rich. No, you shouldn’t be going out and spending that money on useless crap. You want to mutilate that mortgage? Great! Then it is priority number one. Of all the tips, tricks, voodoo spells, spreadsheets, tweaks and so on, NONE of them are a substitute for not putting as much of your income as possible into the mortgage. This is what those throw away articles won’t tell you. They never address it because it is hard to do and hard to stick to but it is achievable, just pull up The Spreadsheet each pay day and make sure you’re on track. After a while you will be able to look back in pride as you see just how far you’ve come and how destroyed your mortgage is.

 

The Mortgage Planning Spreadsheet is a post from: www.MutilateTheMortgage.com


CRUSH YOUR MORTGAGE IN 7 YEARS AND SAVE $300,000
     

12 Responses to “The Mortgage Planning Spreadsheet

  • Love the spreadsheet but would it be possible to add in an offset balance to see what it contributes to reducing the mortgage balance?

    Also can I ask, even if I do not ask the bank to increase my repayments if I pay the extra /difference myself so I have it as redraw (as a backup) this is basically the same right as long as I stay committed?

    • Thanks Ken!

      You’ll have to edit it yourself to add in the offset balance I’m afraid. Would be quite tricky too from what I can see as it’d have to have it’s value updated daily in order to calculate the exact amount, therefor you’d have to update it every day with your account balance even if the spreadsheet supported it.

      As for your other question yeah it is essentially the same thing. Only difference is with Redwar most banks have a minimum amount (say $1,000) and others also have a fee to do it too. With taking money in/out of the offset account though those things don’t matter. We have both an offset account and heaps of Redraw and I consider them basically the same thing.

      The other tip is that because Mortgage Mutilators are normally putting 2, 3 or ever 4 times the “minimum repayment” into their mortgage each cycle, you can just temporarily reduce that amount for that cycle if you really need the funds for some emergency. So if your minimum is $1,000pf but you normally put $3,000pf in, just put in the $1,000 and use the remaining $2,000 for whatever it is you need.

  • Hey – really like the spreadsheet but I’m having trouble entering the data as I’ve taken out a mortgage on my own (yes – no partner to pay it off). Any help/suggestions on how to do it? If I delete “Jill’s” name it mucks everything up, and if I leave it in there then there are some errors on the dashboard and it says my mortgage goes UP (instead of down).

  • On the your Mortgage Plan tab is it calculating the interest on the loan correctly? And I take it that the current mortgage balance data is entered excluding interest?

    I tried comparing 4.99% and modifying to 15% and the end date with the set recommended repayment is only a few months later which would not be right??

  • Sorry please ignore my comment, I was being silly and not copying down properly

  • Great spreadsheet! Have been looking for something like this tool and this blog on the internet for a long time. Very thankful I was directed here from the Whirlpool forums.

    Keep up the great work!

  • Hi there, love this spreadsheet. I’m a self confessed Minimalist and Frugal lover and am making double payments per month on our mortgage ($175K) on one income with no other debts. We live on one income voluntary, (with 2 teenagers), We have beautiful home in semi rural Melb on quarter acre with mountain views galore, eat extremely well and have a luxury or two such as a V8 boy toy car for my partner that he drives only on weekends and we have an outdoor spa (my luxury). But we manage because we watch our expenses and have no other debt and we are mindful consumers. Believe it or not we have had people look down on us because we are proactive to live off one wage, needless to say those people are no longer part of our “people”. I surround myself with positive like minded friends who encourage and make you laugh out loud often.
    This spreadsheet was great to see in black and white. Highly recommend to all.. I have a saying nowadays to people which is “Income is Irrelevant.. It’s your Expenses and your Mindset that will make you or break you”.. I’m up for the challenge to up our payments even further.. Love your website and so great to see fellow Aussie, instead of the American sites I’ve been reading lately.. Cheers!

  • Hi,

    The spreadsheet is not available can you please re check the link and update it for me? The article is great read with good information!

    thanks

    • Hi Dave,
      Glad you liked the piece :-)

      As for the Spreadsheet, I’ve just loaded the link up on another computer and everything seems to work fine. One thing is that you may not have the “Make a copy…” option available if you’re not signed into your Google Account. If you’d rather not work with Google Drive at all then you can also choose to download it as an Excel file and use it that way. Just use the “File -> Download as” option. Hope this helps!

Trackbacks & Pings

Leave a Reply

Your email address will not be published. Required fields are marked *