Excel Lending Tracker Enhancements
Budget: ₹600 – ₹1,500 INR
I already run my small lending operation from an Excel workbook I built myself. It works, but I now need a few targeted upgrades from someone who lives and breathes spreadsheets.
What I’m after
• Review and correct existing formulas so every interest-rate calculation is precise and transparent.
• Set up a straightforward macro (or small VBA script) that automates routine tasks—think rolling the balance forward, stamping today’s date, or dropping new loan rows into the right place.
• Keep everything in the same single workbook; no need for fancy dashboards or external add-ins this time around.
Key details
• The sheet tracks individual borrowers, principal, dates, and daily/weekly interest.
• All interest calculations must stay accurate even when I adjust the rate or payment frequency.
• I’d like clean, readable formulas—no hard-coded numbers hidden inside.
Deliverable
A revised Excel file that:
1. Calculates interest correctly for every loan record.
2. Includes at least one “one-click” macro that posts routine updates.
3. Arrives with a brief note explaining any new columns, formulas, or VBA you added.
If this sounds simple to you and you can turn it around quickly, I’d love to work together and get my tracker running smoothly.
What I’m after
• Review and correct existing formulas so every interest-rate calculation is precise and transparent.
• Set up a straightforward macro (or small VBA script) that automates routine tasks—think rolling the balance forward, stamping today’s date, or dropping new loan rows into the right place.
• Keep everything in the same single workbook; no need for fancy dashboards or external add-ins this time around.
Key details
• The sheet tracks individual borrowers, principal, dates, and daily/weekly interest.
• All interest calculations must stay accurate even when I adjust the rate or payment frequency.
• I’d like clean, readable formulas—no hard-coded numbers hidden inside.
Deliverable
A revised Excel file that:
1. Calculates interest correctly for every loan record.
2. Includes at least one “one-click” macro that posts routine updates.
3. Arrives with a brief note explaining any new columns, formulas, or VBA you added.
If this sounds simple to you and you can turn it around quickly, I’d love to work together and get my tracker running smoothly.