This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Update
Reset
Print
Please note that this is a simple calculator and the author will not be held responsible its use
Contact a financial advisor if you need assistance.
Debt Repayment Calculator (Home loan or other)- the benefit of early and continuing payments
Fill in all the blue cells and then look at/ print the summary below in yellow
We have left some sample numbers in the cells to show you what to do. Delete them and put in your own numbers
Inputs
Loan Amount- How much the bank will give you
Term of repayments- Slide for months (maximum of 300)
Interest Rate per annum
As a result the approximate monthly repayment will be
How much extra will you put in each month
What will you increase it by each year (0% if nothing)
When loan repaid, what do you plan to do with your monthly payments
-
Waste it
Continue to pay the same amount to a investment
If you invest it what do you think your return will be per year (%)
What do you think house prices will grow at annually (%)
Summary
Loan will be repaid fully in
Total Drawdown from bank
Total Scheduled Repayments made
Total Additional Repayments made
Interest Paid over life of loan
In 30 years time you will have
A house worth at least the purchase price with no debt
If the house grows at your expected rate it will be worth another
Investments worth
Assets Worth