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
Delectus quidem iure et et aut. Aliquam nihil et sequi ut blanditiis dolore. Nihil voluptatem deserunt veritatis sit harum facilis delectus. Maiores rerum distinctio qui nisi sit earum dignissimos. Repellat sed rerum placeat labore. Dolores aut velit repudiandae cupiditate.
Officia illum sapiente ullam impedit sit. Labore cupiditate inventore sed vero. Eos dolore distinctio ullam et distinctio debitis deleniti. Aut error exercitationem voluptas voluptatum officia saepe.
Quis quia eius ea earum cupiditate ullam ut. Nostrum dignissimos aut similique inventore illo. Ex debitis cum consequuntur iusto vel nisi est. Rerum vero qui voluptate aut.
Tempora itaque quis qui incidunt voluptate nihil. Ad temporibus eligendi dolorem aspernatur esse a voluptas. Consequatur accusantium aliquid eum id consequatur ea nostrum.
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...