|
| 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.
Attachments ---------------- Interest Calc.ods (23KB - 137 downloads) Interest Calc.xls (13KB - 139 downloads)
| |
|