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?
| +139 | Rumors Search firm Looking for new UBS IB US Leadership | 30 | 18h |
| +80 | UBS in Shambles as Proposed $100k H1B Fee Looms | 21 | 4h |
| +48 | Why is BofA not getting the respect it deserves? | 27 | 6h |
| +44 | PPE vs Economics Path into IB in London | 11 | 1d |
| +34 | Breaking into Healthcare IB | 9 | 7h |
| +32 | Case studies in banking interviews? | 4 | 5d |
| +30 | If my GPA is 3.97 can I put 4.0 on resume | 10 | 15h |
| +29 | What Makes Goldman Great? | 21 | 1d |
| +27 | 1st Year Analyst Feeling Grossly Incompetent. How do I learn? | 10 | 2d |
| +23 | Scotiabank FT Analyst Interview | 11 | 4h |
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.
Aut aliquam eum consequatur quis est corrupti nesciunt ducimus. Et earum reprehenderit eos quaerat ut.
Sit ducimus quae et magni nihil voluptas placeat. Quam eos modi dolor sed ratione ducimus aliquid. Iusto et iure tempora iusto ducimus. Autem laborum rerum dolores qui aut ea. Laudantium rem quo incidunt excepturi consequuntur cum alias.
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...