Hello,
First post here, so please can someone help me?
I am trying to calculate interest on a list of invoices which have daily due dates. Problem is they are still currently unpaid so I also need to project interest based on weekly payments offered.
Example of data:
Invoice Inv date Due date Value
123456 18/08/2018 29/09/2018 61.87
123457 25/08/2018 06/10/2018 4,945.91
123458 25/08/2018 06/10/2018 18.27
123459 01/09/2018 13/10/2018 23.78
123460 01/09/2018 13/10/2018 5,007.51
So I can calulate the interest as of today but need to calculate the interest based on future weekly schduled payments of say 100.00 a week.
Anyone able to help with a formula please?
Thanks
Bookmarks