Daily Interest Loan Spreadsheet
Budget: $15 – $25 USD
I need a clean, fool-proof spreadsheet that lets me record roughly 900 separate loan increments spread over the prior six years and have each amount accrue simple interest day-by-day until its project payment date. Because I’m not an Excel power user, I’m looking for a turnkey file that keeps all of the formulas safely tucked away yet allows me to add or edit entries without breaking anything.
Core functions I expect:
• Easy data-entry table where I can drop in the disbursement date and principal for every increment.
• Automatic daily simple-interest calculation (principal × rate × days/365) that continues to run until the preset six-year maturity date for each line.
• Summary section that shows running totals and a final payoff figure at any moment.
You’re free to choose Excel, Google Sheets, or another mainstream tool—as long as I can open it on a typical Windows 11 machine and adjust the interest rate from a single cell. Clear labeling, light conditional formatting to highlight approaching maturities, and a couple of example rows so I can see how to input new data will make the hand-off painless.
About 900 loan installments and dates entered, to compute simple interest to get total owed, user ability to amend amounts and dates and number of entries.
Core functions I expect:
• Easy data-entry table where I can drop in the disbursement date and principal for every increment.
• Automatic daily simple-interest calculation (principal × rate × days/365) that continues to run until the preset six-year maturity date for each line.
• Summary section that shows running totals and a final payoff figure at any moment.
You’re free to choose Excel, Google Sheets, or another mainstream tool—as long as I can open it on a typical Windows 11 machine and adjust the interest rate from a single cell. Clear labeling, light conditional formatting to highlight approaching maturities, and a couple of example rows so I can see how to input new data will make the hand-off painless.
About 900 loan installments and dates entered, to compute simple interest to get total owed, user ability to amend amounts and dates and number of entries.