Advanced Finance

The Revolver and the Circularity Problem

The revolver is the line that makes a model balance and the line that makes it break. Learn the plug, the loop it creates, and the four ways practitioners actually resolve it.

  • Advanced
  • 7 min total
  • 12 chapters

What decision this helps you make: How to build a debt schedule that ties in every period, survives a downside case, and tells you honestly when the company runs out of money.

What this topic is

In a three-statement or leveraged buyout model, the revolving credit facility is the balancing item: it is drawn when the period generates less cash than the company needs and repaid when it generates more. Because interest depends on the balance and the balance depends on the cash left after interest, the revolver creates a genuine circular reference.

Why it matters

Every serious operating model has this loop somewhere. Handled well, the revolver is the honest answer to "what happens in a bad year." Handled badly, it silently absorbs an unlimited shortfall, hides insolvency behind a plug, and one stray error turns the whole workbook into zeros that never recover.

Who should learn it

Anyone building or auditing a debt schedule — analysts, deal teams, CFOs reviewing a banker's model, and anyone who has ever opened a file full of zeros and not known why.

What you will understand

  • Exactly where the circular reference comes from, algebraically
  • The four standard resolutions and what each one costs you
  • How to build a cash sweep that repays in the right order
  • Why an unbounded revolver is the most dangerous line in a model

Prerequisites

Common misconception

"Circular references are a spreadsheet bug, so a good model avoids them." The circularity is not an artifact of Excel — it is a real property of the economics. Borrowing to cover a shortfall genuinely increases the shortfall, because the borrowing costs interest. Any model that eliminates the loop has approximated the economics, not fixed them. The professional question is not how to avoid the circularity; it is which approximation you have chosen and whether you can defend it.