Calculate Daily Interest

S

SWBookkeeper

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
 
E

Ed Cones

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)
 
Top