Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't work with Excel a lot, so there's probably an easy answer, or a template out there for this, but I'm not sure even where to look.

    I work in a law office and we sometimes collect past due accounts for our business clients. Sometimes we end up in situations where the debtor comes to our office and makes monthly payments until the debt is paid. Our clients are entitled to interest on the unpaid balance from payment to payment, so that if a payment is made 8/11/2009, reducing the balance to, for example, $10,286.39 and the next payment is not received until 9/15/2009, the interest will be calculated on the $10, 286.39 for 35 days (not a 30 day month).

    Can someone tell me how to do this or point me to a template that does it.

    Thanks.

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='CharliesDaughter' post='788478' date='11-Aug-2009 14:37']I don't work with Excel a lot, so there's probably an easy answer, or a template out there for this, but I'm not sure even where to look.

    I work in a law office and we sometimes collect past due accounts for our business clients. Sometimes we end up in situations where the debtor comes to our office and makes monthly payments until the debt is paid. Our clients are entitled to interest on the unpaid balance from payment to payment, so that if a payment is made 8/11/2009, reducing the balance to, for example, $10,286.39 and the next payment is not received until 9/15/2009, the interest will be calculated on the $10, 286.39 for 35 days (not a 30 day month).

    Can someone tell me how to do this or point me to a template that does it.

    Thanks. [/quote]
    The attached file gives a working example.
    Attached Files Attached Files
    Regards
    Don

Posting Permissions

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