Interest calculator on a past due invoice

%3CLINGO-SUB%20id%3D%22lingo-sub-2966032%22%20slang%3D%22en-US%22%3EInterest%20calculator%20on%20a%20past%20due%20invoice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2966032%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20customer%20who%20has%20not%20been%20making%20regular%20payments%20for%20more%20than%20a%20year.%20I%20need%20a%20calculator%20that%20will%20take%20in%20the%20invoices%20written%2C%20subtract%20the%20payments%20received%20and%20calculate%20the%20monthly%20interest%20that%20we%20could%20charge%20to%20the%20customer%20and%20present%20them%20with%20a%20cumulative%20total%20amount%20due.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2966032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

@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.

@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

@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.

Thank you. I have several methods to come up with amounts that are "close enough". I just wonder if there is a worksheet that someone has already figured out and could share it with me.
Carrie