Forum Discussion

CarrieinVermont's avatar
CarrieinVermont
Copper Contributor
Nov 15, 2021

Interest calculator on a past due invoice

I have a customer who has not been making regular payments for more than a year. I need a calculator that will take in the invoices written, subtract the payments received and calculate the monthly interest that we could charge to the customer and present them with a cumulative total amount due. 

 

4 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    CarrieinVermont 

     

    In the inserted file you will find an example that you can develop further or just use :).

     

    I would be happy to know if I could help.

     

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

    • CarrieinVermont's avatar
      CarrieinVermont
      Copper Contributor

      NikolinoDE 

      Thank you but this is NOT at all what I need. It's not a loan with a definite payoff date and I need to include compound interest. 

      Carrie

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor

        CarrieinVermont 

        What I have sent you is food for thought for your plan.

        The forum is there to get help with a project or plan.

        If you would like to have a worksheet tailored to your needs,

        this is more a commissioned work and not the help for self-help that you can get here.

        However, I wish you every success in your project.

Resources