View mortgage principal vs interest rate being paid

[Myfirstsecondthird]

I have been trying to look for this but cannot find it on the midst of all the different mortgage calculators.

I am aware that at the start of the mortgage you are paying more interest and then this reduces down. I would love to have some sort of calculator that gives you a value or even a graph of how much interest and capital you are paying at each stage (month?).

Thanks

Is this for a new mortgage? You can easily work this out for the beginning by multiplying the balance outstanding by the interest rate and dividing by 12 to calculate how much interest you’ll be paying per month - obviously it’ll reduce slightly each month as you pay off the capital.

For example I am half way through a 25 year term, owe £100k on an interest rate of 1.79% which is approx £150 interest per month. My total payment is £800 so I’m repaying £650 capital each month. The amount of interest reduces by a few pounds each month (give or take as months have a different number of days)

@Myfirstsecondthird I used this excel file to track my mortgage overpayment. It is really good to get the information you ask and also compare mortgage rates.

www.locostfireblade.co.uk/spreadsheet/Index.html

@Marmut I didn't manage to download the spreadsheet, but had a bit of thinking from both your posts and I now have a spreadsheet :). So thank you so much for your help.