Amortization schedule in AR
I am looking for amortization schedule in AR.Please let me know if you have come across a utility in AR.
I have a client that has offerred installments on overdue delinquent recivable.
They want to calculate interest on daily basis.
On receiving early payment of the installment the customer will pay interest on lower net balance.
On a late payment , customer will pay interest on the balance till the payment was received.
Principal balance $2000
Ten Installments $200 each due every 1 st of the month
Amortization will lokk like:
Principal | 2000 | |||
Payment Date | Payment | Principal Applied | Interest aapplied | Principal balance |
1/1/2011 | 200 | 196 | 4 | 1804 |
1/23/2011 | 200 | 197 | 3 | 1607 |
3/7/2011 | 200 | 195 | 5 | 1412 |