You could also use Excel to create a traditional amortisation table to calculate what portion of any repayment is capital or interest.
As shown below we can use a bucket to create the table and then create a new row which calculates the capital portion of the repayment (total repayment minus interest repayment will give the capital portion).
This is a manual method but there are some functions that do it.
To see the full course contents click here.