You can also use the RATE function in Excel to calculate the interest ... you will need to have the loan's interest rate, the number of payments you have made at that point in the future (NPER ...