Revolver Cash Sweep Model: Balance Sheet Plug Explained

Key Takeaways

• The revolver cash sweep model uses the revolving credit facility as the balance-sheet plug that draws when the company needs cash and repays when it has excess, preventing impossible negative cash balances.
• A 75 percent cash sweep on a 400 million term loan can reduce principal by over 30 million in a single year of strong free cash flow, compressing next year's interest expense materially.
• The most common error is letting the revolver balance go negative, always wrap the formula in MAX(0, …) because a negative revolver balance is economically impossible.
• In LBO models the cash sweep is the primary deleveraging mechanism; ignoring it understates equity at exit and flatters the sponsor's IRR by leaving excess cash sitting unproductively on the balance sheet.

What It Is

A revolving credit facility (revolver) is a pre-arranged line from a bank that a company can draw on, repay, and redraw at will, up to an agreed commitment amount. In a financial model, it serves two purposes. First, it is a real source of short-term liquidity with a real interest cost. Second, it is the mathematical plug that absorbs any mismatch between cash generated by operations and cash needed for mandatory debt service, capex, dividends, and minimum cash balances.

A cash sweep is a clause that diverts a specified percentage of excess cash flow (after mandatory uses) toward paying down long-term debt. Sweeps show up routinely in LBO loan agreements and project finance.

The Intuition

Without a revolver, a model that shows a cash shortfall simply displays a negative cash balance, which is not possible in real life. The company would draw on a line of credit, issue short-term paper, or default. The revolver in a model stands in for that behavior. It is the difference between a model that balances on every scenario and one that breaks the moment operations soften.

Cash sweeps add realism on the other side. Highly levered borrowers do not get to keep surplus cash. The lender contractually pulls it to accelerate debt paydown. Without a sweep, a model will show cash piling up indefinitely on the balance sheet of a company that, in reality, would have paid that cash against its debt years earlier.

How It Works

A typical sequence at the end of each period in the model follows this logic.

1. Compute cash flow before financing activity.
2. Subtract mandatory debt amortization and required minimum cash balance.
3. If the result is positive, apply the cash sweep percentage (e.g. 75 percent)
   to pay down term loans in order of priority.
4. Any remaining cash stays on the balance sheet.
5. If the result is negative, draw on the revolver up to the commitment limit
   to cover the gap.

The revolver roll-forward is a standard tranche in the debt schedule, but its ending balance is computed as a formula, not an input. A common structure is:

Revolver ending balance = MAX(0, Revolver beginning
                              + Cash shortfall after all other financing)

Interest on the revolver and on the sweepable term loan is based on the average balance, which depends on the ending balance, which depends on cash flow, which depends on interest. This produces a circular reference. The practical solution is to enable Excel's iterative calculation (File > Options > Formulas), with a low max change threshold (around 0.001) and around 100 iterations. An alternative is to compute interest on beginning balance only, which breaks the circularity at the cost of a small timing inaccuracy. More on this in the circular reference article.

Worked Example

A hypothetical levered company has a 50 million revolver at SOFR plus 300 (rate 7.5 percent), starting year 1 with a 10 million draw. Term loan B has 400 million outstanding with a 75 percent cash sweep on excess free cash flow. Minimum operating cash is 20 million.

Year 1 sources and uses (simplified):

Cash flow from operations                 120
Capex                                     (40)
Mandatory TLB amortization (1 percent)     (4)
Interest paid (all tranches)              (35)
Cash available before sweep                41

Excess cash above minimum balance          41
Cash sweep to TLB (75 percent)            (31)
Remaining cash on balance sheet           10

Because the company had enough cash to cover operations, no revolver draw was needed. The 10 million existing draw sits unchanged unless a separate rule repays it. The TLB ending balance falls from 400 to 365 (mandatory 4 plus sweep 31). If next year's cash flow drops by 60 million, the model would instead draw on the revolver to bridge the gap, up to the 50 million commitment.

Common Mistakes

1. Letting the revolver balance go negative. A negative revolver is nonsense (the bank is not paying the company to hold cash). Always wrap the formula in MAX(0, ...) so the balance floors at zero and excess cash sits as cash instead.

2. Breaching the commitment limit silently. If the cash need exceeds the revolver commitment, the model should flag the shortfall, not quietly absorb it. Add a MIN() against the commitment cap and a separate row showing any unfunded gap.

3. Applying the cash sweep before mandatory items. The sweep hits only what remains after debt amortization, capex, interest, and minimum cash. Putting it earlier in the waterfall overstates deleveraging.

4. Forgetting the minimum cash balance. Companies cannot run their balance sheet at zero cash. Subtract a realistic minimum (often set by covenant or policy) before calculating sweepable cash.

5. Circular reference ignored entirely. With interest on average balance plus a revolver plug, the model will cycle unless iterative calculation is on. Ignoring the #NUM! errors and leaving them in the file is a sign the modeler does not understand why they appeared.

Frequently Asked Questions

Q: What is a revolver cash sweep model in simple terms? A revolver cash sweep model automatically draws on a revolving credit facility when the company runs short of cash and uses contractually specified excess free cash flow to pay down term debt, keeping the balance sheet consistent under any operating scenario.

Q: How does a revolver cash sweep model affect investment decisions? It shows how quickly a levered company deleverages and how much cushion exists before the revolver commitment is fully drawn. Investors in leveraged credits or private equity need to see this to assess refinancing risk and equity return potential.

Q: What is a real-world example of a revolver cash sweep model? A company with 400 million of term debt, 41 million of excess cash flow, and a 75 percent cash sweep clause pays down 31 million of principal in year one, the debt schedule shows this explicitly while a one-line debt balance would miss it entirely.

Q: How can investors use or avoid revolver cash sweep errors? Investors should check that the model's revolver balance is bounded by MAX(0, ...) and MIN(..., commitment), and that the sweep waterfall applies only after mandatory amortization, interest, capex, and minimum cash are deducted.

Q: How is a revolver cash sweep model different from a standard debt schedule? A standard term loan or bond schedule uses fixed amortization inputs. The revolver and cash sweep use formula-driven balances that respond to the model's cash position, which is why they introduce circular references that require iterative calculation in Excel.

Sources

1. Wall Street Prep. "Revolver Debt | Formula + Calculation Example." https://www.wallstreetprep.com/knowledge/modeling-revolving-credit-line-excel-free-template/
2. Macabacus. "Cash Sweep and Revolving Debt Repayment Guide." https://macabacus.com/operating-model/revolver-cash-sweep
3. Investment Banking Analysts. "How Cash Sweeps and Revolvers Work Together in LBO and Corporate Models." https://investmentbankinganalysts.com/how-cash-sweeps-and-revolvers-work-together-in-lbo-and-corporate-models/
4. A Simple Model. "LBO Model with Cash Sweep." https://www.asimplemodel.com/insights/lbo-model-with-cash-sweep

Disclaimer

This article is educational content only and is not financial advice. Nothing here is a recommendation to buy, sell, or hold any security. Consult a licensed advisor before making investment decisions.