I need to set up a spreadsheet to keep track of our corporations stockholders
loans. They Are charging 10% interest annually. The interest needs to be
calculated at the time any transaction is entered and the balance changes.
Please help
--
Bookkeeper

Interest over a period of time is simply the annual rate times the balance
times the number of days divided by 365.

Calculating from a date in A4 to a date in A5 on a balance in E5 the
following should work in C5.

=round( .1 * E5 * (A5-A4) / 365, 2)







"SWBookkeeper" wrote:

> I need to set up a spreadsheet to keep track of our corporations stockholders
> loans. They Are charging 10% interest annually. The interest needs to be
> calculated at the time any transaction is entered and the balance changes.
> Please help
> --
> Bookkeeper