This excel file will allow you to calculate the interest and capital repayments of your mortgage.