Interest calculator on a past due invoice

Copper 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