Interest + Tax Circularity

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.

Comments (4)

 
Feb 2, 2020 - 3:47am

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

Start Discussion

Popular Content See all

LETS FKING GO BOYS
+133IBby Intern in Corporate Finance">Intern in CorpFin
You Did it Citi
+120OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind
HELP: Sticky Situation with Boss
+109OFFby 2nd Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 2 in IB-M&A
Idgaf anymore
+31IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
Anyone else just want out of this shit?
+28IBby 2nd Year Analyst in Investment Banking - Generalist">Analyst 2 in IB - Gen
Evercore Target Schools?
+26BSCHby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
To Snitch or not to Snitch?
+19OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind

Total Avg Compensation

March 2021 Private Equity

  • Principal (7) $694
  • Director/MD (15) $627
  • Vice President (61) $374
  • 3rd+ Year Associate (63) $267
  • 2nd Year Associate (121) $248
  • 1st Year Associate (256) $223
  • 3rd+ Year Analyst (24) $164
  • 2nd Year Analyst (58) $137
  • 1st Year Analyst (168) $119
  • Intern/Summer Associate (18) $71
  • Intern/Summer Analyst (182) $59

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
CompBanker's picture
CompBanker
97.8
5
redever's picture
redever
97.7
6
frgna's picture
frgna
97.6
7
Addinator's picture
Addinator
97.6
8
Edifice's picture
Edifice
97.5
9
NuckFuts's picture
NuckFuts
97.5
10
bolo up's picture
bolo up
97.5