Part Payment Interest Calculator in Excel
Budget: ₹600 – ₹1,500 INR
I need an Excel worksheet that can calculate interest for partial payments based on an annual interest rate.
I'm trying to create an excel interest calculator for invoices that are overdue. Interest is calculated on payments made on the payment date and for part payments also
FOR Eg,
Invoice 1 - 100000 Invoice date 01/12/2023 Due date : 02/12/2023
Payment made on 10/12/2023 : 30000
Payment made on 15/12/2023 : 40000
Payment made on 20/12/2023 : 30000
I shall feed the excel invoice date, invoice amount and due date for each invoice; as well as payment dates and payment amounts and then excel has to calcaulte interest
Attached excel sheet which I use, however most of its manual, since I'm unable to automatically add rows for interest calculations for part payments.
Can someone help on this ?
I'm trying to create an excel interest calculator for invoices that are overdue. Interest is calculated on payments made on the payment date and for part payments also
FOR Eg,
Invoice 1 - 100000 Invoice date 01/12/2023 Due date : 02/12/2023
Payment made on 10/12/2023 : 30000
Payment made on 15/12/2023 : 40000
Payment made on 20/12/2023 : 30000
I shall feed the excel invoice date, invoice amount and due date for each invoice; as well as payment dates and payment amounts and then excel has to calcaulte interest
Attached excel sheet which I use, however most of its manual, since I'm unable to automatically add rows for interest calculations for part payments.
Can someone help on this ?