Amount calculation with or without interest

[sarveshinsingh]

Hi, I have some data to prepare every month and I want an excel formula which can ease my work.

Example of the data.

There is an Invoice of 980.00 which should due on or before 15th of every month if not paid then 1.5% compound interest will be added until paid. And if amount paid partially before due date then interest calculated after deducting the payment and if paid after the due date then interest to be added on the amount then deducting the paid amount.

it is simple when due is for a month or 2 but it becomes little difficult to calculate if more months.

pls help...

[#2]

@sarveshinsingh 

Unfortunately I don't have the time to take on the task individually,

but I can send you an old file from me where you can work on it and work out your own solution.

Hope to be able to help you with this.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

Thank Nikolino, his file i helpful but it is not giving me he desired result.

But thanks for your efforts.