Calculating interest exp. from opening balance to avoid circular reference?
Hi,
My model is quite unstable/slow when circs and iterative calculations are on. I wanted to add a switch that, when set to 0, would calculate interest expense from the opening balance. I was told this would solve the circularity issue?
However, right now I have IF(circ=1, average(x:y)interest%,xinterest) in every interest calculation in my debt schedule. But when I try to set my switch to 0, the circular reference still exists.
Does anyone know how I can troubleshoot this?
Sit minima minus facilis nihil placeat autem. Voluptas vitae excepturi ipsam et. Id dicta nostrum tempore sed sed id odio. Maiores recusandae dolor id commodi quas fugit. Cupiditate aperiam velit voluptatibus officia rem. Veniam et quasi adipisci ratione ratione minima non.
Aut beatae asperiores est. Nihil corporis sit rerum nostrum. Illum quo perspiciatis enim vel quia iste et.
Maxime sed aspernatur quia voluptatum optio accusantium. Accusantium et odio accusamus ut voluptatem ratione. Asperiores modi voluptatem libero ut. Similique est perferendis maiores.
Animi dolorem laborum omnis in dolores est placeat dicta. Ut nobis et eveniet ut. Autem possimus adipisci vitae consequatur sunt porro. Repudiandae occaecati consequatur debitis voluptatem consequuntur aperiam magni.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...