Calculate Daily Interest

  • Thread starter Thread starter SWBookkeeper
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed & Reducing Balance Loan Calculation. 4
Quarterly payment calculation question 4
Calculating interest due on late loan payments 1
Inserting and retaining an input variable 4
EXCEL problem- mortgage 0
[newbie] financial accounting (2) 1
Keeping track of loan payments and interest 4
Spreadsheet for calculating interest charges 2

Back
Top