You can download the following document to excel and it will allow you to calculate the interest and principal repayments over the loan repayment period.
NB. download from google sheets to ensure it’s working. The formula do not work on google sheets.