Plug in a Financial Model
It's the line that soaks up extra cash or covers a cash gap so the model balances on its own. Excess cash builds up the cash balance; a shortfall draws on the revolver. It's a designed mechanism, not a fudge.
Definition
A plug in a financial model is the balancing line item — most often the cash balance or a revolving credit facility (revolver) — that automatically absorbs any surplus or shortfall of funds so that the balance sheet balances and the three-statement model ties out in every period without manual intervention.
What a plug actually does
After you project all the operating, investing, and financing activities, the model produces a net cash flow for the period. The plug is where that net flow lands. If the business generates surplus cash, the plug (cash balance) simply grows. If the business runs short — cash before financing goes negative — the plug (a revolver) is drawn down to fund the gap, keeping cash from going negative. The plug is the mechanism that makes the model self-balancing: whatever doesn't tie out elsewhere flows into it. This is legitimate model design, not a hack — the term 'plug' just describes the balancing role.
Cash sweep vs revolver plug
In an LBO the plug usually works in two directions via a cash flow waterfall. When the company generates excess cash, a 'cash sweep' uses it to pay down debt (mandatory or optional prepayment), so the debt schedule acts as the plug on the upside. When cash is short, the revolver is drawn — the revolver is the plug on the downside. The standard formula: revolver draw = MAX(0, minimum cash − cash available before revolver), and revolver repayment = MIN(beginning revolver, cash available above minimum). This two-sided logic keeps cash at or above a minimum operating level while routing surplus to debt paydown.
The wrong kind of plug
There is a dangerous misuse: forcing the balance sheet to balance by hardcoding a plug into a balance sheet line (e.g., 'other assets = liabilities + equity − everything else'). This makes the model technically balance while masking a real linking error. A correct plug flows through the cash flow statement (cash or revolver), so the balancing is a consequence of real, traceable cash movement. If your balance sheet only balances because of a forced plug line and not because cash flow ties out, you have a balance-sheet-doesn't-balance bug hiding behind a band-aid.
Worked Example — With Real Numbers
A company must hold a $50 minimum cash balance and starts the year with $50 cash and a $0 revolver. Operating + investing + mandatory debt cash flow nets to −$30. Cash available before the revolver = $50 − $30 = $20, which is below the $50 minimum. The revolver plug draws MAX(0, $50 − $20) = $30, so the revolver balance becomes $30 and cash returns to $50. Next year the business nets +$80; the model repays MIN($30 revolver, surplus above minimum) = $30 to clear the revolver, and the remaining $50 builds the cash balance to $100. The plug absorbed both the shortfall and the surplus.
Key Takeaways
A plug is the balancing item — usually cash or a revolver — that makes a model tie out each period.
Surplus cash grows the cash balance; a cash shortfall draws the revolver to avoid negative cash.
In LBOs the plug is two-sided: a cash sweep pays down debt on the upside, the revolver funds the downside.
Revolver draw = MAX(0, minimum cash − cash available); repayment = MIN(beginning revolver, surplus above minimum).
A correct plug flows through the cash flow statement — never hardcode a balance sheet line to force a balance.
Common Mistakes in Interviews
Forcing the balance by hardcoding a balance sheet line instead of routing the plug through cash flow.
Letting the cash balance go negative because there's no revolver plug to fund shortfalls.
Forgetting the minimum cash floor, so the revolver never draws even when cash dips too low.
Building a one-directional plug (draws only) that never repays the revolver from surplus cash.
How Interviewers Test This
Interviewers ask 'what's the plug in a model and how does the revolver work?' Answer: the plug is the line that absorbs cash surplus or shortfall so the model balances — cash builds up on the upside, the revolver is drawn on the downside to keep cash above its minimum. Then state the formula: revolver draw = MAX(0, min cash − cash before revolver). Knowing the MAX/MIN logic separates people who've built a model from those who've only read about one.
Related Concepts
Directly referenced in this topic
Balance Sheet Doesn't Balance
A balance sheet doesn't balance when, in a [three-statement model](https://www.i...
Three-Statement Model
A three-statement model is a financial model that integrates a company's [income...
Debt Schedule
A debt schedule is a supporting schedule in a financial model that tracks each t...
Leveraged Buyout (LBO)
A Leveraged Buyout (LBO) is the acquisition of a company using a significant amo...
More Financial Modeling
12 more concepts in this category
Topic Guides
Firms That Test This
Practice Plug in a Financial Model questions
400+ interview questions with AI feedback. Free to start.
Start PracticingMaster Plug in a Financial Model and 100+ More Concepts
Get the full IB Flash experience and walk into your interview with confidence.
AI Interview Coach
Real-time feedback on your answers
1,000+ Practice Questions
Across IB, PE, HF, VC & more
Financial Modeling Tests
Excel-based skill assessments
Or explore our free tools to get started