Use a Spreadsheet to Track Interest

I have made up a spreadsheet to keep track of our mortgage repayments, how much interest we are paying and all our extra repayments.

Ad

I made it to help keep us motivated and to show how any extra repayments are going to help us.

It is also good because in a second I am able to check if the interest the bank has charged us is correct.

I have also anticipated times when we might be able to increase our repayment and punched in numbers ahead of time to calculate the exact date our loan can be paid off.

I have read books that say you can save this much time and money off your mortgage. But with the spreadsheet I have been able to prove to myself and my partner that we CAN save $333,000 and pay our mortgage off in less than 6 years instead of 30.

The spreadsheet itself is easy enough to create. here is what you need. I used excel.

  • Column A- Date (Start with your settlement date) and drag down a lot
  • Column B- Day Number. 1,2,3...etc (you can hide this later but will use it for calculations.)
  • Column C- Amount owing. The first cell will be the amount you borrowed e.g 200,000. The following cell will equal column F from the row above (previous "new balance")
  • Column D- Daily interest rate. Interest Rate (pa)/365 + 1 (for 7.5% interest type (0.075/365) + 1
  • Column E- repayment, enter the first repayment on the correct date and so on.
  • Column F- New Balance = Column C * Column D - Column E. (Amount owing * Daily interest rate - repayment)

That's the basis of it, from here it is easy to work out how much interest you are paying per day (amount owing * (daily interest-1) and how much of your house you actually own = the original amount - new balance.

Source: I created the spreadsheet myself, but I was inspired by Anita Bells book "Your Mortgage and how to pay it off in 5 years".

By Monica from Kalgoorlie, Australia

Flag
February 8, 20080 found this helpful

Keeping track of your mortgage is important because the mort. co. (at least the one we had) made mistakes on a regular basis. They'd apply the payment to principal, not interest, or tell us we were overdue, when we weren't...

By keeping track I was able to straighten them out.

Ad
ReplyWas this helpful?Helpful? Yes
January 18, 20150 found this helpful

We paid ours off last July! Best feeling in the world!

ReplyWas this helpful?Helpful? Yes
January 20, 20150 found this helpful

This is just too confusing for me to calculate or even put in Excel!

ReplyWas this helpful?Helpful? Yes

Add your voice! Click below to comment. ThriftyFun is powered by your wisdom!

Related
In This Article
Paying Off a Loan Quickly
Paying Off a Loan Quickly
< Previous
Categories
Budget & Finance AdviceJanuary 30, 2008
Guides
Potted Rosemary plant.
Keeping Track of Plant Information
Keeping Track of Events in a Calendar
Keeping Track of Events
A home with bright green lawn surrounded by beautiful flower beds.
Adding Points of Interest to Lawns
A woman signing a contract.
Keeping Track of Contract End Dates
More
🎄
Christmas Ideas!
🍂
Thanksgiving Ideas!
Facebook
Pinterest
YouTube
Contests!
Newsletters
Ask a Question
Share a Post
You are viewing the desktop version of this page: View Mobile Site
© 1997-2016 by Cumuli, Inc. All Rights Reserved. Published by . Page generated on November 22, 2016 at 7:11:24 PM on 10.0.1.8 in 989 msecs. Use of this web site constitutes acceptance of ThriftyFun's Disclaimer and Privacy Policy. If you have any problems or suggestions feel free to Contact Us.
Loading Something Awesome!