***Seems simple: I need a sheet with DAILY entries mimicking a high street
bank loan account, ie. where the annual interest rate may be changed on any
date, and credits/debits to the loan will immediately effect the balance and
interest accruing.***

DETAIL:
Please can you help with a formula which will return the correct DAILY
balance on an interest-bearing loan account with irregular transactions?

Monthly templates are no use as the interest rate or debits/payments on the
loan account may change any day.

You would expect to simply divide the annual interest rate by 365.25, but it
seems to require 366.5 or more before my results agree with standard mortgage
or loan calculators. Perhaps the high street banks we are trying to mimic
are doing funny sums to work out our daily interest!

4 columns a
DATE INTEREST RATE TRANSACTIONS BALANCE

Thanks for any help you can offer.
Best wishes,
Cameron