Interest calculation in an integrated model

How do i calculate interest on an overdraft in an integrated model ? Excel ( 13 ) tells me its circular and will not allow the action .

Thanks 

Joe Considine
Parents
No Data
Reply
  • Other routes:

    One which works well if your interest calculations are at the bottom or ideally after a sub-total, is to take the (opening balance + (the month's cashflow movements excluding the interest)/2) x the interest rate

    A second is to have the interest cashflow in the month after the charge.
Children
No Data