Tracking Monthly Finance Charges for Overdue Invoices: A Spreadsheet Solution?

[MHamernik]

Need to set up a spread sheet that shows interest month by month on overdue payments from several unpaid (or underpaid) invoices.

I have 13 such invoices, their unpaid amounts, aging in days, and the interest rate.

Spread sheet to start from earliest invoice up until 06/14/2019. Thanks!

 

[Wilmer]

Need to set up a spread sheet that shows interest month by month on
overdue payments from several unpaid (or underpaid) invoices.

I have 13 such invoices, their unpaid amounts, aging in days, and the interest rate.

Spread sheet to start from earliest invoice up until 06/14/2019.

Suggest you contact an accounting firm...

 

[MHamernik]

It's still a math problem ("Business Mathematics" topic is there for a reason), would appreciate it if you don't waste my time with stupid responses.

 

[Wilmer]

...would appreciate it if you don't waste my time with stupid responses.

Ok. Hope someone else here steps in and helps you. Good luck.