Gold Loan Excel Manager
Budget: ₹600 – ₹1,500 INR
I need a single Excel workbook that lets me run my gold-backed lending operation without jumping between files. Within the sheet I must be able to enter principal, tenure and rate, have simple interest calculated automatically, record every repayment as it arrives, and watch the outstanding balance update in real time. Each loan record should also carry fields for item description, weight, purity and current market value so I can see at a glance whether the pledged gold still covers the balance.
To keep day-to-day work smooth, the workbook has to open on a clean dashboard and include three ready-to-use templates—one tab for new loan applications, one for the full repayment schedule generated from the inputs, and one consolidated collateral list that tracks every item across all active loans.
Key deliverables
• Automated simple-interest calculator tied to repayment tracking
• Dynamic repayment schedule that recalculates after each entry
• Collateral tracker with live LTV indicator
• Built-in templates: Loan Application, Repayment Schedule, Collateral List
• Clear, protected formatting so team members can’t accidentally overwrite formulas
I’m working exclusively in Microsoft 365, so please build and test in that environment and keep external macros to a minimum—native formulas and tables are strongly preferred. Once complete, a short Loom or PDF walkthrough showing how to add a new loan, post a payment and review collateral will serve as final acceptance documentation.
To keep day-to-day work smooth, the workbook has to open on a clean dashboard and include three ready-to-use templates—one tab for new loan applications, one for the full repayment schedule generated from the inputs, and one consolidated collateral list that tracks every item across all active loans.
Key deliverables
• Automated simple-interest calculator tied to repayment tracking
• Dynamic repayment schedule that recalculates after each entry
• Collateral tracker with live LTV indicator
• Built-in templates: Loan Application, Repayment Schedule, Collateral List
• Clear, protected formatting so team members can’t accidentally overwrite formulas
I’m working exclusively in Microsoft 365, so please build and test in that environment and keep external macros to a minimum—native formulas and tables are strongly preferred. Once complete, a short Loom or PDF walkthrough showing how to add a new loan, post a payment and review collateral will serve as final acceptance documentation.