I built an lbo model that's balanced and working okay, but it's taking a long time to run through iterations to balance everything. I turned off automatic calculations for data tables and it still takes ~4,000 iterations to get through all the circular references. Any advice to get this to run faster without macros?
| +138 | What’s “the path” now? | 56 | 2h |
| +86 | Is Everyone Too Bearish on PE? | 30 | 1h |
| +48 | Why would anyone do PE in long term in 2026? | 12 | 1d |
| +37 | 3rd Year IB Analyst, Top Bucket, Still No PE Offer. What Would You Do? | 19 | 5h |
| +25 | Is This Normal in LLM PE | 10 | 3d |
| +24 | Q&A: What It’s Actually Like Working at an Independent (Fundless) Sponsor | 4 | 1d |
| +21 | UMM PE or High Paying Strat Finance? | 9 | 59m |
| +21 | Striking out in last rounds | 2 | 2d |
| +20 | On Cycle Preparation | 8 | 1d |
| +16 | Would you use a centralized sponsor research page before meetings? | 6 | 6d |
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.
Sounds like you didn't build it correctly. A good model minimizes the amount of circularity
I'm not sure how to avoid circularity when adding certain pieces into the model (PIK added in a few more) and there are a lot of debt instruments in the model. Any tips?
In terms of speeding up the model, those suggestions helped, but the ending values are still quite a bit off and need more iterations to get the balance sheet to balance.
Usually it's because of how the model is constructed and not due to an inherent conceptual circular/iterative reference.
Minima qui nam a maxime quia dolor tempora nulla. Qui expedita unde quia et. Fugit et excepturi et dolorem iste voluptatem. Neque earum nisi et consequatur voluptatem cumque. Rerum aliquid a enim pariatur est quia. Adipisci suscipit adipisci similique enim est.
Sit non rem veritatis deserunt labore non vel. Et eaque reprehenderit suscipit tenetur ea veniam.
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...