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?
| +160 | UBS Tech layoff | 52 | 1d |
| +153 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 24 | 11h |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 14h |
| +73 | Leaked Interview Questions to Recruiting Services | 39 | 4m |
| +59 | Are target prospects getting dumber? | 27 | 12h |
| +58 | How do YOU manage networking requests? | 17 | 19h |
| +37 | Quitting After First 4 months | 12 | 1d |
| +34 | MBB Pay Raises | 26 | 1d |
| +19 | Rothschild UK - Mining & Healthcare 2026 | 5 | 3d |
| +19 | Career Crossroads | 2 | 2d |
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.
Est vel ut nostrum modi officia deserunt. Consequatur vel in vel inventore. Autem et pariatur rerum voluptas qui sit culpa corporis.
Soluta consequatur enim magnam eius aut iste adipisci iure. A dicta perferendis ea eum laboriosam ratione molestiae. Ut et eius rem quaerat consequatur placeat ducimus quia.
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...