I'm sure that most of you know this, but I just learned it and it was really handy, so....
Microsoft has a bunch of free excel templates (including investment calculator, retirement calculator, budgeting, credit card tracker, etc). Many of them are pretty good tools. I chose to create my own spreadsheet to track my early mortgage payoff though, for the following reasons:
- it allowed me to truly understand the mechanics of mortgage amortization, and see how additional payments impacted the balance at different points throughout the loan. This might be an easy concept for others, but without going through the exercise of building the spreadsheet myself, I don't know how well I would have understood the "nuts and bolts" of it all.
- it allowed me to build in some features that I wanted, that weren't included in standard templates, like charting the payoff balance, charting the interest savings, comparing std payoff against early payoff, etc.
- it allowed me to see just how far ahead we were. For example, I could look at our current balance, and see that with a "normal" payoff routine, we wouldn't be at that point until say, 2035. This helped keep me motivated.
Having a spreadsheet for early mortgage payoff was an invaluable tool for me.