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?
| +89 | [2026 - October] Unbiased Prestige Rankings | 53 | 2h |
| +87 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 19 | 18h |
| +78 | You should probably leave IB | 26 | 1d |
| +45 | Why Do We Turn Comments? | 10 | 1d |
| +43 | Tomorrow Will Be Better | 5 | 4d |
| +41 | Moelis PCA vs Lower tier BB Coverage | 30 | 22h |
| +25 | Banking (Un)fortunately Still Needs You: My Case for Bankers in the AI Era | 3 | 1d |
| +24 | How much should you ask questions / seek feedback as an intern? | 9 | 4h |
| +24 | UBS IB #24 in US M&A in 2026 | 10 | 1h |
| +23 | Lateraling as Analyst | 21 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Ab et et totam et consequatur architecto ea numquam. Ullam magnam voluptas ipsam. Suscipit assumenda sequi eos qui et. Quasi dolor aut est libero et aut quidem. Neque ut eaque numquam.
Voluptatibus voluptates asperiores nulla cum est ipsam sunt. Iste culpa velit et accusamus officia maiores. Nostrum sunt molestiae fugit facere doloremque voluptatem.
Perspiciatis delectus non quia et repudiandae vitae aspernatur. Consectetur sed eveniet animi nobis. Ipsum iste qui illo exercitationem ut temporibus.
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...