What's is this spreadsheet?
A comprehensive Excel Home Loan Spreadsheet showing a breakdown of your home loan payments by month.
Get the interest and principle portions and play around with extra monthly payments and see what effect they have on the overall term. There is also a simple graph showing the expected payment date. This is what I used myself when paying off my home loan and for interest sake yo can read about why I decided to pay off my home loan early instead of investing the extra money.
This home loan spreadsheet is the result that you would get if you took my Udemy course which explains all the formulas and why you should set things up the way they are. For more on the course or to see a demo of the spreadsheet – view the Udemy Course here.
NOTE: The currency format is South African Rands, but you can obviously set this to any currency as this will work for any country.
You will be able to calculate
- Savings from additional payments
- How much sooner you will pay off your loan
What people say
A fully editable Excel spreadsheet