Line of Credit Schedule

[pranjal]

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 !!!

[sambit]

plz find attached file.

[Hercules1946]

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 !!!

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