Accrued interest calcualtions
I have a simple table which contains loan disbursements made to multiple clients. The table records each loan disbursement made by client, date, amount, etc.
I wish to calculate the interest charges for each customer accrued between two date fields in adjacent records: (1) the current date when a new loan is made, and (2) the date of the previous loan disbursement. Something like this:
Record 1: Date ... Client ... Disbursement Amount ... Running Loan Total
Record 2: Date ... Client ... Disbursement Amount ... Running Loan Total ... Date (Record 2) - Date (Record 1)
I know a db is not a spreadsheet, but trying to consolidate outstanding disbursements and interest accrued across multiple client spreadsheets is a clumsy and unreliable manual process.