Here’s an interesting tool I found while trying to find out which mortgage product reduced the overall debt by the most over a certain period.
This calculator produces amortization tables for the mortgage which show the remaining balance at the end of each year.
The rate you input is used for the entire term but if you are considering a 5 year fixed mortgage, the table will show the mortgage balance at the end of 5 years.
Don’t forget to check the ‘Show amortization’ box.
If you are looking at a variable rate mortgage, any calculation will not reflect any changes in the rate.
When calculating don’t forget to add any fees onto the amount you wish to borrow for an accurate calculation.
For example if you are looking at a mortgage with a 5 year fixed rate and you wish to borrow £150,000 but the lenders arrangement fee is £1500, (unless you are paying this upfront) the total borrowing will be £151,500.
This way you can easily find out if a Fixed rate mortgage with an arrangement fee will leave you better off at the end of the offer period than a mortgage without an arrangement fee.
If you are looking at a 5 year fixed offer, you must put in the entire term of the mortgage eg. 25 years then look at the tables to find the end of 5 years.
Email This Post
Any information shared on UKMoneyPot does not constitute financial advice. The Website is intended to provide general information only and does not attempt to give you advice that relates to your specific circumstances. You are advised to discuss your specific requirements with an independent financial adviser.
February 19th, 2008 at 4:45 pm
Have checked out this firm’s calculators, and the rest of the site.
WOW!! What a mine of information. Superbly presented - and makes this subject interesting!!
August 9th, 2008 at 6:10 pm
Very impressive. Keep up the good work!