Amortization Table - Circular reference

[Anonymous]

I am trying to create a amortisation table in powerBI but am stuck as circular references keep occuring.

A typical amortisation table has the opening present value, a repayment amount (fixed), an interest amount (variable)

Added together it becomes the closing present value.

However, I am currently stuck as my opening present value by nature includes the accumulation of all the interest amounts in previous periods. As a result, I cannot create an interest column (formula = opening present value * 0.01%), since it creates a circular reference. 

has anyone encountered this before? 

Regards,

[Anonymous]

Thanks for your fast response. I know they use each other. My issue is that I don't know how to not use each other. 

My interest expense depends on how much interest and rental was paid in the past and I don't know how to write a formula to deal with this. 

[amitchandak]

@Anonymous , both formula uses each other other

check 4th last in first one and 3rd from Top in second one