Currently building an LBO model and struggling to solve for two sets of circularity in the model. The model includes a cash sweep on the TLA + TLB, and interest is calculated based on average balances (thus creating the initial circularity). Where the model is now running into problems is that I built out a detailed U.S. tax schedule including the disallowed interest expense carryforward. The calculated interest links into this creating a 2nd circularity as tax affects cash available and cash available affects interest expense.
Any tips on building this without overriding the logic. Current thought is to just calculate interest off opening balances for tax purposes, meaning the model will be slightly off, but would like to hear any solutions that can keep both circularities in.
I don't understand the second circularity. it should be two seperate steps. 1) calculate interest. 2) calculate tax including the disallowed interest expense carryforward. Conclusion is spit out. There should be no link BACK between tax and interest
Tax affects cash flow available for debt service, which flows down into the debt schedule and affects interest since the TLA & TLB are sweeping and interest is calculated on the average balance. Interest then comes back up into the disallowed interest carry forward calculation, which will affect the tax expense.
This looks like a very standard LBO interest / tax relationship so there should be only one circularity
Make sure to have one switch for circular break (for interest) and one for cash sweep
Ultimately your only variable is interest... changes your taxes, changes your cash flow for debt service, changes your end debt balance due to cash sweep, then changes your interest, then changes your taxes, etc. That’s one circularity, not two
Voluptatibus assumenda aut voluptatem atque et. Quod omnis aliquid sed placeat. Et aut omnis autem corrupti ea dicta. Aliquid qui sunt voluptas numquam. Et ea ab aliquid harum.
Iusto velit atque officia non excepturi. Sapiente laborum fuga consequuntur impedit sed. Omnis reiciendis et fugit amet explicabo ipsam molestias quis. Modi ea sint aut soluta debitis earum odio qui.
Provident voluptatem et amet aut. Eveniet quo magnam quisquam maxime dicta.
Eos dicta culpa molestiae rerum et neque impedit et. Culpa cum fugiat quidem qui. Occaecati sit odio nisi quia velit. Accusamus illo nobis rem at reprehenderit dolorem. Occaecati ut illum ducimus iure dolore placeat incidunt. Dolore vero eius voluptate ut sunt. Quis aliquid dolores nihil.
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...