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?
| +195 | Americas M&A League Table Q2 Updated | 77 | 15h |
| +142 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 37 | 4h |
| +126 | Restructuring: Anti-climactic Experience | 34 | 14h |
| +94 | IB Net Worth / Savings Check | 43 | 16h |
| +79 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 18 | 3h |
| +78 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 3d |
| +54 | Stop sleeping on UBS - it’s pretty good | 15 | 1h |
| +48 | 2026 VAULT PRESTIGE RANKINGS | 29 | 21m |
| +39 | Investment Banking is Hard | 17 | 2d |
| +32 | AI + Financial Modelling | 11 | 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.
Quia nemo corrupti eos beatae ut recusandae consectetur. Et aut ea aperiam placeat cupiditate quia. Minima mollitia perferendis et dicta voluptas ipsum beatae.
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...