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?
| +220 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 53 | 55m |
| +116 | ONLY THESE BANKS OR YOU STRUCK OUT | 34 | 3h |
| +110 | IB Energy Drink Tier List / Ranking | 73 | 2h |
| +91 | PJT M&A Group Selection 2026 | 14 | 1d |
| +56 | Firm Thinks I'm Lying About Offer | 18 | 21h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 1d |
| +33 | Stay at Weak Dealflow Team or Lateral? | 10 | 7h |
| +32 | Indiana University Fraternity Pipelines | 16 | 1h |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 1d |
| +30 | Rogo AI | 10 | 3h |
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.
Praesentium consequatur quod ducimus quis eos facere. Architecto laborum mollitia asperiores saepe nam enim numquam. Molestiae minima error ab ullam consequatur sit.
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...