LBO Modelling questions (Debt Schedule)

How do you usually structure the debt schedule? I think the clearest way to go about it is to structure it as follows:

CF Available for debt service Debt 1 (BOP, repayment, EOP, interest) CF Available for debt service of second tranche Debt 2 (BOP, repayment, EOP, interest) CF after debt servicing / Change in cash Cash (BOP, change in cash (line above), EOP, Interest) Revolver (BOP, drawn/repaid, EOP, Interest + commitment fee on undrawn)

However, in the WSO PE course, the full LBO 1 is structured as follows:

CF Available for debt service Cash (BOP, change in cash (line above), EOP, Interest) Revolver (BOP, change in cash (line above), EOP, Interest) And then the debt tranches.

Again, I think the first structure is far clearer, taking it step by step and displaying CF available for next element. However, I have come to realize that my way is flawed: when CF is negative, the revolver is drawn, but it is then not repaid until tranche 1 debt is fully repaid (i.e. Debt 1 is prioritized).

So my question is - how do you usually structure the debt schedule? Which is the easiest way (least risk for errors).

Thanks!

1 Comments
 

Repellat molestias consequatur soluta debitis dolores qui nemo est. Vero laborum reprehenderit consequatur quod ducimus.

Career Advancement Opportunities

October 2026 Private Equity

  • The Riverside Company 99.6%
  • Blackstone Group 99.3%
  • KKR (Kohlberg Kravis Roberts) 98.9%
  • Warburg Pincus 98.5%
  • Vista Equity Partners 98.1%

Overall Employee Satisfaction

October 2026 Private Equity

  • Blackstone Group 99.6%
  • KKR (Kohlberg Kravis Roberts) 99.3%
  • The Riverside Company 98.9%
  • Ardian 98.5%
  • Warburg Pincus 98.1%

Professional Growth Opportunities

October 2026 Private Equity

  • Bain Capital 99.6%
  • The Riverside Company 99.3%
  • Blackstone Group 98.9%
  • Starwood Capital Group 98.5%
  • KKR (Kohlberg Kravis Roberts) 98.1%

Total Avg Compensation

October 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (100) $364
  • 3rd+ Year Associate (106) $280
  • 2nd Year Associate (235) $272
  • 1st Year Associate (414) $231
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (273) $126
  • Intern/Summer Associate (39) $80
  • Intern/Summer Analyst (357) $61
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”