Excel VBA Project: Late Invoice Interest Calculation
Budget: $10 – $30 USD
I'm seeking assistance on an Excel project focused on computing interest on overdue invoice payments, using both Excel formulas and VBA, if necessary.
I need to calculate interest on a late invoice payment based on monthly interest rates. Here's a brief overview of the task:
- The invoice due date is 24/08/2022 and it was paid on 14/07/2023.
- The original invoice amount was 14,976.43.
- This means the invoice was outstanding for 324 days.
I have a table of monthly interest rates, structured with separate monthly rates for each year. The challenge lies in splitting the 324 days into months, applying the relevant monthly interest rates, calculating the interest for each month, and summing these amounts together.
This is just one example; I have over 100 rows that need to be calculated in the worksheet.
I'm looking for a freelancer who can create a new module for the VBA code, and help automate this process for me. Ideally, you should have:
- Extensive experience with Excel and VBA
- Strong understanding of financial calculations and interest computations
- Ability to work with large data sets
- Good communication skills to explain the solution clearly
I would appreciate your guidance and expertise in this matter. Thank you.
I need to calculate interest on a late invoice payment based on monthly interest rates. Here's a brief overview of the task:
- The invoice due date is 24/08/2022 and it was paid on 14/07/2023.
- The original invoice amount was 14,976.43.
- This means the invoice was outstanding for 324 days.
I have a table of monthly interest rates, structured with separate monthly rates for each year. The challenge lies in splitting the 324 days into months, applying the relevant monthly interest rates, calculating the interest for each month, and summing these amounts together.
This is just one example; I have over 100 rows that need to be calculated in the worksheet.
I'm looking for a freelancer who can create a new module for the VBA code, and help automate this process for me. Ideally, you should have:
- Extensive experience with Excel and VBA
- Strong understanding of financial calculations and interest computations
- Ability to work with large data sets
- Good communication skills to explain the solution clearly
I would appreciate your guidance and expertise in this matter. Thank you.