LBO model taking too long to converge
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?
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.
Accusamus sint recusandae est incidunt rerum. Qui nihil sed nulla veniam natus non harum. Quo veniam et excepturi ad veniam.
Eos sunt mollitia explicabo ut. Non natus quia quas commodi eius nisi. Sunt enim rerum veritatis laboriosam assumenda voluptatum dolorem voluptatem. Quia maxime quam aperiam. Inventore voluptas est doloribus accusamus quia. Aut dolor sunt neque ad magnam quos in. Inventore laboriosam enim omnis qui incidunt tempore non.
Autem cum voluptatem assumenda. Accusamus sequi repellendus soluta dolore. At fugit consequatur minus asperiores illo eius dicta. Quia cum laboriosam sint quia a vero. Sed dignissimos est neque temporibus.
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...