Results 1 to 3 of 3

Thread: Line of Credit Schedule

  1. #1

    Lightbulb Line of Credit Schedule



    Register for a FREE account, and/
    or Log in to avoid these ads!

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

  2. #2
    plz find attached file.
    Attached Files Attached Files

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by pranjal View Post
    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
    Last edited by Hercules1946; 2014-12-11 at 05:17 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •