Kevin over at the No Debt Plan blog recently advised his readers to avoid mortgage accelerator programs like the plague.  He reasoned that you could set up your own mortgage accelerator program by adding 1/12 of a payment as additional principal to each month’s payment.  I agree with Kevin. You can save a boatload of interest by making extra principal payments.

Sending in extra principal payments sounds good, but I think you need to see the impact - namely, how much interest you can save.  So, I set up an Excel file to calculate the interest savings.  You can access the file by clicking on the following link to my mortgage amortization spreadsheet:

Mortgage Amortization Spreadsheet

To use the spreadsheet, just do the following:

1. Enter your mortgage amount into cell B2
2. Enter your interest rate into cell B4
3. Enter the length of the mortgage in years in cell B6

This will populate the rest of the spreadsheet.  It will also calculate your monthly payment (cell B9), and the interest you can expect to pay over the life of the mortgage (cell B11).  If you want to see how much interest you’ll save by adding extra to your monthly payment, just enter the amount into column H in the appropriate month, and the answer will be calculated for you in cell B16.  You’ll also see the number of months that you’ve shaved off the length of the loan in cell B18.

I would definitely recommend sending in additional principal payments if you have the means to do so.  Obviously, this only makes sense after you’ve retired all of your high-interest credit card debt beforehand, and have a healthy emergency fund established.  But if your mortgage is your last outstanding debt, you can count on a return equal to your interest rate.

Now, open the spreadsheet and have fun crunching numbers!

• The Economics of Lawn Care pfala I'm not an envious person.  When someone experiences some good fortune, I'm genuinely happy for them.  I compliment people if they have nice stuff, or if their houses look nice.  But I think that my neighbor, The Lawn Freak, has finally gone overboard. What the heck is THAT......
• 5 Years to Pay Off a $100K Debt Photo by quaziefoto A Wisconsin family won the Professional Achievement and Counseling Excellence (PACE) Award for paying down $106K in debt.  You can read the original article by clicking the following link: The Biggest Losers (of Debt): How a Family Shed $106,000 in Debt While they still have a......
• Barbaric Links: Debt Edition I read a lot of good posts this week regarding debt.  Here are some of my favorite posts on this topic: Kevin at No Debt Plan shares his frustrating lunch encounter; Credit Card Watch prepares to save money with 0% APR credit cards; FiveCentNickel hears ironic debt advice on his......

• Money Merge Account Analysis Pt 6 If you have not yet done so, please read part 1, part 2, part 3, part 4, and part 5 of this series first, then read on. This week, I'll offer some of the exaggerated claims made by those who likely don't even understand what they are talking about. "......
• My Extra Payments towards my Auto Loan was not being applied to Principal! It was a cold winter day in 2006.  I was 6 months out of law school working at a firm where I usually stayed till about 7pm.  I walked to my trusty, lovable Nissan 240sx.  This car had so many miles the odometer literally stopped working (I am not......
• Getting Out of Debt Quickly pt 4 This is part 4 of a 4 part series on getting out of debt quickly. Make sure that you read all four parts in order to get the most out of this sequence of hints on getting yourself or your family out of the debt trap. If lenders happen to......