Revolver in a Financial Model

A revolver's job is to guarantee the company never shows negative cash. In each period, the model checks: after all operations, capex, debt payments, and the minimum cash buffer, is there a shortfall or a surplus? If short, the revolver draws (borrows) just enough to cover the gap. If surplus, the revolver repays whatever balance is outstanding, down to zero. This makes it the automatic 'plug' that keeps the three statements integrated and balanced — without it, a model could project impossible negative cash balances during lean years.

The mechanics: (1) compute cash flow available before the revolver — net of operations, investing, mandatory debt repayments, and the minimum cash balance the company wants to keep. (2) If that figure is negative, the revolver draw = the shortfall (capped at the facility limit). If positive, the revolver paydown = the lesser of the surplus or the outstanding revolver balance. (3) The ending revolver balance flows to the balance sheet, and interest on the revolver flows to the income statement. Use MIN and MAX functions to enforce the caps. Because revolver interest hits net income, which loops back to cash flow and the revolver balance, this creates the classic circularity.

Don't confuse a revolver with a term loan. A term loan is drawn once and amortizes on a fixed schedule; you can't re-borrow what you repay. A revolver is reusable — draw, repay, redraw as needed, like a credit line. In an LBO model the revolver is typically undrawn at close and exists as a liquidity backstop, while term loans and high-yield bonds do the heavy lifting. The revolver's interest is what most commonly triggers the model's circular reference, so it's usually paired with a circularity breaker switch to keep the model stable.