Posted 4/8/2022 08:59 (#9603061 - in reply to #9593951) Subject: RE: Interest in Excel
I think the simplest thing is to create a new sheet for the loan (attached below) and then reference via a lookup if you need an answer in one cell only. You will still need to enter interest rate in column H once it is locked in for that period. In your current cell reference new sheet to find relevant cell. I did this in LibreOffice and exported to Excel.
I have done something similar for my operating loan. I change the date column to a formula that checks for entries in the Description column to generate dates for current date, end of year, and loan due date. Thus I have estimated interest balance for those dates.