This revised Excel template instantly creates a list of mortgage repayments by year and by month. The interest and capital amounts are calculated for each month and year, together with the loan outstanding at the end of each period. A simple chart shows how interest payments reduce as the capital element of the loan is repaid. Enter your mortgage amount, period in years, and the annual interest rate, then click on the calculate button and all the figures are instantly updated.
The fully working demo version allows variation of the interest rate and period. The mortgage value defaults to a standard amount. Try it for yourself and give us your feedback. The password free version of this Excel template below has no restriction on the mortgage value.
We also have a monthly repayment mortgage calculator that includes rate variations here .
Our introductory video will be available shortly. Check out our You Tube channel for more video tutorials. Meanwhile, contact us if you have any questions, or if you would like this template adapted for your own company.
The editable version of this worksheet is without restrictions and passwords, allowing you to freely view and change the code etc, to meet your own requirements. Price will be subject to the current rate of UK VAT where applicable.
We recommend that you add our email address (email@example.com) to the contacts in your email program to help prevent our emails from going into the spam/junk mail folder.