plz find attached file.
In need of a line of credit schedule to keep track of the daily balances along with interest portion to plan repayments.I have prepared a schedule but haven't been able to work out a formula to calculate the daily interest portion and the outstanding balance.For preparation it can be assumed loan is for 75 days and the rate of interest is 11% for 75 days.The schedule has been attached for reference.Hope to get a reply soon !!!
plz find attached file.
Isn't this the same problem you posted here, which is waiting for you to respond to a reply showing the same approach as sambit above?
http://www.excelguru.ca/forums/showt...cking-schedule
Last edited by Hercules1946; 2014-12-11 at 06:17 PM.
Bookmarks