Conditional reference on average interest calculation

  • Thread starter Thread starter PiPPo
  • Start date Start date
P

PiPPo

Hello,

One of the typical problems of modeling in finance is that when
interest is calculated on average outstandings a circular reference is
created. A possible solution is to have Excel calculating the interest
expense/income through iterations. Does anyone know, if other solutions
exist?

Thank you very much,

Pippo
 
Pippo,

Use some of the financial functions, which do those sorts of things in one go?

But, we'd be better able to help if you posted an example of the type of data that you have, and
what result you want.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Excel Iterative calculations 3
Using a reference to calculate moving average 3
Excel Average dates help 0
Calculation options change arbitrarily 1
Calculating interest due on late loan payments 1
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge 3
Resolve Circular Ref Issue 3
Need Help Resolving Circular Ref 1

Back
Top