AgTalk Home
AgTalk Home
Search Forums | Classifieds (30) | Skins | Language
You are logged in as a guest. ( logon | register )

Interest in Excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
H3f
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.



Attachments
----------------
Attachments Interest Calc.ods (23KB - 19 downloads)
Attachments Interest Calc.xls (13KB - 24 downloads)
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)