I noticed some of you that found my free amortization calculator were interested in being able to input additional payments to see how it would shorten the life of your mortgage. So I took the time to come up with the additional calculations to automate the process for you. This amortization calculator is still based on a standard 30 year mortgage with monthly payments, however I added a column called “Additional Payment”. In my example, I defaulted the additional payment column to $50, and as you can see, on a $90,000 loan amount, the additional $50 takes the 30 mortgage down to about 23 1/2 years. Not bad for a little bit more paid each month. Now, in order for this to work for you, you must instruct the bank in writing with each additional payment that you intend for the entire amount to go towards principle only. Without this instruction, they may apply a part of it to interest, just like your regular payment. Here’s a quick look at the first ten payments in this amortization tool:
|Amortization Calculator with Additional Payments Applied|
|Original Loan Amount||$90,000.00|
|Automatic Calculation Area|
|Month (You may replace with Date)||Total Payment (PI Only)||Additional Payment||Total to Principle||Total to Interest||New Balance|
All you have to do with this amortization calculator is input your original loan amount and interest rate, and then input your additional payment amount in the appropriate column. This calculator is flexible, e.g. you can enter a different additional payment amount each month if you wish, and the calculations will automatically adjust. Have fun with this, and sign up for my RSS feed for updates to all the latest and greatest at this personal finance blog.
You may download the Amortization Calculator with Additional Payments Applied .xls free of charge.