In writing my recent article The magic of a one-time partial mortgage payment: your net worth increases I ended up polishing up and optimizing my Mortgage Prepayment Analysis Calculator Spreadsheet
Pay off mortgage early calculator/spreadsheet
Now you can easily run scenarios with just a few clicks with the new Mortgage Prepayment Analysis Calculator and Spreadsheet.
Simply “Make a Copy” of the spreadsheet.
Then punch in your info here:
You can toggle your expected returns here. I set it at 8% as default:
And then you can let the spreadsheet do the rest of the analysis for you. It should look something like this:
So, if like me you end up trying to decide between paying down your mortgage or investing, you can calculate out the best option for your specific mortgage.
Please let me know if you run into any issues with the spreadsheet in the comments. Thanks!