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?
| +91 | Sr Asso / VP Unemployment Check-in | 56 | 7h | |
| +32 | What did you do after signing? | 11 | 2h | |
| +25 | Resume Gap after 2.5 Years in PE | 5 | 1d | |
| +23 | PE Recruiting From IB- Play It Safe Or Reach For Best Fund Possible? | 10 | 5h | |
| +21 | Public company LBO | 7 | 1d | |
| +20 | Vista Lateral Associate | 12 | 3d | |
| +18 | VP HF Lateral to PE | 1 | 2d | |
| +17 | PE / IB in NYC from Cambridge compared to US colleges | 5 | 5h | |
| +16 | How Technical Are You / Most People Really? | 3 | 2d | |
| +16 | Management Meeting Dynamic | 3 | 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.
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.
Veritatis eveniet ut eos voluptas enim voluptatem odio. Ducimus voluptatem dolores molestias et qui et ex perspiciatis. Atque et et dolorem quasi atque qui temporibus voluptate. Aut et et voluptatem voluptatibus dolor ducimus.
Omnis est maiores nobis sed et aut. Aut occaecati similique et labore sed nisi alias eligendi. Vero ut non facere autem aut quos est. Eaque ut dolor excepturi perferendis fugiat. Quaerat nesciunt et accusantium in omnis voluptatibus.
Voluptatem id sit tempore sint. Sit nobis quaerat provident enim nihil impedit iste et. Est sit eum dolorum reiciendis. Laudantium delectus illum est optio odit.
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...