Calculating interest

  • Thread starter Michael S. Montoya
  • Start date
M

Michael S. Montoya

I have a client that wants to calulate 10% interest on open balances. His
clients will be making monthly payments (not always for the same amount and
not always on the same date). I believe the interest is to be compounded
daily. So far, I have only been able to find formulas for annuities with
fixed monthly payments, but nothing for what I have explained above (I don't
think the IRR function will work either by reading the description of it).

Does anyone have an idea on this one?
 

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

Top