Loan Amortization and Payment Calculator for Excel (2007 & 97-2003)
I was playing with amortization schedules in Excel 2007 and created this nifty (and pretty simple) tool for calculating home loan amortization schedules for up to a 40 year loan…
I figured it might come in handy for others, so I cleaned it up. You can download it below.
You enter:
- purchase price
- closing cost %
- down payment
- term of loan in years
- annual loan interest rate
- annual property tax rate
- annual homeowner’s insurance
And it gives you:
- monthly payment
- principal balance after each monthly payment
- total interest over the life of the loan
- and more…
Download Links
Got Suggestions?
I’d love to make this little tool better. If you think of a useful modification, leave it in the comments.
Good article? Give us a +1. Else, leave a comment suggesting how we can improve.
Comments & Conversation on this Article...