Can I solve this a better way?

[MortgageLender]

I've got to tabulate the daily interest charges on Loans from Loan inception to current date.

I've got a PRINCIPAL_ACCOUNTS table.  Each transaction in that table has a date and an amount of increase or decrease in the principal balance, and the updated outstanding balance as fields.

Ive got a similar INTEREST_RATE changes table to track each time the user changes his/her borrower's rate including date of change and what the new rate is as fields.

Ive got a DAILY INTEREST CHARGES TABLE that captures the outstanding principal balance, the RATE in effect, and has calc field for the calculated daily interest charge for each day based on BALANCE and RATE in effect for that day.  Each record in this table represents each day since loan was funded.

CURRENTLY---I run a script to update the DAILY INTEREST CHARGES table records for each loan.  It deletes all records in the DAILY INTEREST CHARGES table for the loan (or all loans).  It loops through the PRINCIPAL ACCOUNTS and INTEREST RATE CHANGES tables grabbing values of RATE and BALANCE for each day, and repopulates the DAILY INTEREST CHARGES table for each loan through the current date.

THIS TAKES A LONG TIME.  Is there a more clever way?  

 

Thanks for any ideas!!