social

Paying Off a Loan Quickly

January 30, 2008

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

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

Advertisement

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.

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

 
Read More Comments

More Solutions

This page contains the following solutions.

July 23, 2004

When we were just buying our first home, we made sure it didn't have any pre-payment penalties, then I ordered an amortization schedule from the mortgage co. I could see that we were paying just a pittance on the principal every month, but lots on the interest. By sending in small amounts every so often, we paid off our loan 8 yrs earlier and saved thousands in interest payments. You can send an extra principal payment every month or 2 & 3 principal payments once every so often.

Advertisement

If you just make monthly payments, you will not break even (pay the same on principal & interest) until year 23 on a 30 year loan, so you can see that almost all the money paid out every month is the interest to the mortgage co. This tip is easy to do the first several years when the principal payment is small. Harder to do on the back end of the loan when you pay a lot more of the principal off. By Linda from OKC

 
Read More...
Categories
Budget & Finance AdviceJanuary 31, 2013
Pages
More
🍀
St. Patrick's Ideas!
🎂
Birthday Ideas!
💘
Valentine's Ideas!
Facebook
Pinterest
YouTube
Instagram
Categories
Better LivingBudget & FinanceBusiness and LegalComputersConsumer AdviceCoronavirusCraftsEducationEntertainmentFood and RecipesHealth & BeautyHolidays and PartiesHome and GardenMake Your OwnOrganizingParentingPetsPhotosTravel and RecreationWeddings
Published by ThriftyFun.
Desktop Page | View Mobile
Disclaimer | Privacy Policy | Contact Us
Generated 2024-01-30 09:57:06 in 14 secs. ⛅️️
© 1997-2024 by Cumuli, Inc. All Rights Reserved.
https://www.thriftyfun.com/Paying-Off-a-Loan-Quickly.html