How to Calculate a Loan or Mortgage with Excel
February 5th, 2009After last week’s post about the budget template, it made me think of another template I love that comes as part of Microsoft Excel: a loan or mortgage calculator, with an amortization table. I created a little demo video showing you how to find it and explaining the basics of how it works.
I found this template after complaining to my friend, Ben, about needing a tool that would help me figure out how long it would take to pay off my mortgage. Near the beginning of the mortgage, I paid an extra $30/month towards principal, then later started paying something more like $70. There were also a few random cases where I had a freelance job or got a tax return and would put that money towards the mortgage principal. There weren’t any loan calculators out there that provided a simple way to accommodate those variations in additional principal payments. My friend suggested I make one in Excel. When I went to do that, I discovered there was a template that did exactly what I wanted. Thanks, Ben!
If you have a loan or mortgage, you really need to try this out. I find it highly motivating for paying off debt, because it makes it easy to see exactly what will happen if you apply different amounts. The video explains it all.
Feel free to share your two bits if you are aware of any enhancements or even of other templates you have found useful.
Subscribe to RSS
I'm Michael Crowther, and I'm passionate about sharing the peace of mind that comes from budgeting, saving (including debt elimination), and investing.