Loan Amortization and Payment Calculator for Excel (2007 & 97-2003)
ads>
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.
Comments & Conversation on this Article...
One Response to Loan Amortization and Payment Calculator for Excel (2007 & 97-2003)
Wait! Got a question on your own project?
Ask your question in our Home Improvement Help Forums.
Otherwise, leave a note here!
November 18th, 2009 9:15 am
P- what kind of bug? It works for me in 2007. When are you getting the bug?