Circular references Cash flow planning
The model that I’m building for the client includes circular reference. I need to calculate the amount of the loans and net debt that depend on the Free cash flow sum for the period. Free cash flow at the same time includes interests paid, that is calculated for the net debt. When i'm changing any parametrs that effects FCF net Debt and interests is changing according to this for the current and future years. In Excel it’s calculates with Enable iterative calculation option on. Does anyone could help me with solutions and best practices for this case in Anaplan? I suppose it’s a common case with financial planning models.