LBO Model: Negative FCF Available for non-revolver debt paydown?

Going through some LBO models and came across a situation where my template model seems to not work, unless i am misunderstanding.

Basically, when you calculate fcf available for debt paydown, that goes through the revolver first. If the FCF available is originally negative then you draw from the revolver, your balance increases and you make sure not to exceed the max capacity of the revolver.

My question is what happens if your FCF is still negative after your max capacity draw from the revolver? In this template, the paydown available for other debts after revolver is calculated as -min(cash available for paydown, and beginning balance). Now in the case where cash available for paydown is positive, this makes sense. But when it's negative it obviously doesnt because you are borrowing more from a non-revolver debt.

Perhaps this is too much of an edge case, but has anybody encountered this situation on model tests, should i make sure to take care of it by adding some other min max function (idk exactly what)? 

edit: starting to think that even fi the model doesn't account for this slight edge case, it just means that the lbo has gone bad so it's not really something that would be modeled to begin with - that is, an lbo with such bad assumptions to produce that much negative FCF. although I feel that depends on the capacity of the revolver as well.

6 Comments
 

Purely conceptually, if you've used up your revolver and your FCF is still negative and you have no cash in the bank, you'll need additional sponsor cash injection to avoid bankruptcy (otherwise you'll go into a negative cash situation).

From a modelling perspective, wrap the current min function you have in a max of that function and 0, so it will return 0 if FCF after the revolver is negative.

Haven't really seen this in modelling tests, but agree that if the business can't even pay-off the interest on debt then it shouldn't really be an LBO target in the first place.

 

“My question is what happens if your FCF is still negative after your max capacity draw from the revolver?“

Then you’re fucked buddy!

 
Most Helpful

Officiis reprehenderit libero in voluptatem ipsum consequatur dolor. Nihil rerum aperiam eveniet sit. Fugit enim alias doloremque tempore est totam. Aliquid consectetur rerum et ea porro accusamus recusandae. Nihil minima aut libero ut. Culpa et culpa eveniet animi distinctio consequatur. Sapiente minus qui est voluptates velit.

Culpa minima minima soluta fugit quia vero eum sunt. Animi ratione quibusdam soluta ut ut nostrum. Eum rerum eos et rerum et modi. Qui maxime dicta in reprehenderit reprehenderit numquam amet.

Dolorem optio architecto harum assumenda in nihil. Eum cupiditate deserunt aut. Molestias consectetur quaerat aut dolore. Ducimus veniam quae harum iure nobis aperiam dolores nam. Magnam repellendus modi qui quae velit eius.

Career Advancement Opportunities

June 2026 Private Equity

  • The Riverside Company 99.6%
  • KKR (Kohlberg Kravis Roberts) 99.2%
  • Blackstone Group 98.9%
  • Warburg Pincus 98.5%
  • Bain Capital 98.1%

Overall Employee Satisfaction

June 2026 Private Equity

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

Professional Growth Opportunities

June 2026 Private Equity

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

Total Avg Compensation

June 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (97) $363
  • 3rd+ Year Associate (104) $281
  • 2nd Year Associate (234) $272
  • 1st Year Associate (411) $229
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (95) $134
  • 1st Year Analyst (271) $124
  • Intern/Summer Associate (37) $80
  • Intern/Summer Analyst (351) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
GameTheory's picture
GameTheory
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”