LBO Mechanics · 10 min read · Updated November 2026

How to Build an LBO Debt Schedule: Revolver, Term Loans, PIK and the Cash Sweep

How to build an LBO debt schedule: the order of operations, revolver and cash sweep formulas, PIK accrual and the circularity switch, with a worked schedule.

On this page 9 sections

An LBO debt schedule tracks every tranche of debt from close to exit: opening balance, mandatory repayment, revolver draws and repayments, prepayments from the cash sweep, PIK interest added to principal, ending balance and interest. It takes cash flow from the cash flow statement and sends interest back to the income statement, which is why it is where most models break.

On a simplified teaching schedule of the house case on this site (assumptions below), a $75 million term loan and a $5 million revolver draw are repaid in full by year 5, leaving $20.2 million of cash and $245 million of equity at a 6.0x exit. The full distribution workbook starts with a $4.5 million revolver draw and ends with $20.87 million of cash. It reaches a similar exit by a different path. Compare the 2028 collections shock below to see what a smooth cash conversion assumption can hide.

What an LBO Debt Schedule Tracks

Each tranche gets its own block in the schedule because each one behaves differently. The overview below comes from a teaching exhibit in Private Equity in Action (Zeisberger, Prahl and White, 2017, Case 12, Exhibit 12.6), which cites Breaking Into Wall Street. The rates, tenors and covenants describe that historical exhibit. Use the signed terms for a particular deal.

Tranche Rate and form Tenor Amortization Prepayment and covenants
Revolver Lowest; floating; cash 3 to 5 years None Prepayable; maintenance covenants
Term loan A Low; floating; cash 4 to 6 years Straight line Prepayable, sometimes with call protection; maintenance covenants
Term loan B Higher; floating; cash 4 to 8 years Minimal Prepayable, sometimes with call protection. The historical example has maintenance covenants. Institutional loans can be covenant-lite.
Senior notes Higher; fixed; cash 7 to 10 years Bullet Call protection; incurrence covenants
Subordinated notes Higher; fixed; cash 8 to 10 years Bullet Call protection; incurrence covenants
Mezzanine Highest; fixed; cash or PIK 8 to 12 years Bullet Call protection; incurrence covenants

Read the credit agreement before building a quarterly test. A covenant-lite term loan may restrict actions such as issuing debt through an incurrence test instead of requiring ongoing compliance with a maintenance ratio. See Boston Fed research on leveraged-loan covenants.

Two columns drive the schedule’s logic. Amortization decides the mandatory repayment line. The prepayment provisions identify eligible tranches, allocation rules, call protection and any premium. A higher-ranking lien alone does not determine which loan receives an optional payment. For financing assumptions by tranche, see step 3 of our LBO build guide.

The Order of Operations

Every period runs the same sequence. Mandatory payments come before optional ones, and this model repays the revolver before the sweep: a revolver is meant to cover temporary shortfalls, and repaying it restores capacity the company can draw again. That order is a modeling choice, not a ranking. Which lender is repaid first in a default depends on the financing documents and the collateral.

One period of an LBO debt schedule
  1. Cash flow before debt repaymentCash from operations less capex, after cash interest and tax, from the cash flow statement.
  2. Add opening cash above the minimumOnly cash above the minimum operating balance is available to repay debt.
  3. Pay mandatory amortizationContractual repayments on each term loan, tranche by tranche.
  4. Draw or repay the revolverDraw to cover any shortfall, up to the limit; repay first when there is surplus.
  5. Run the cash sweepAllocate the agreed share of eligible cash to the tranches specified in the documents.
  6. Accrue PIK interestAdd the period's PIK interest to that tranche's principal; no cash moves.
  7. Close the periodEnding balances, ending cash, interest for the income statement and the covenant tests.

Ending cash = minimum cash + whatever is left after the sweep. If the sweep is 100% and the revolver covers any deficit, cash stays at the minimum while eligible term debt remains.

Paul Pignataro writes the repayment logic as plain conditions before turning them into a formula: if the cash available is negative, raise cash; if it is positive and larger than the debt, repay the debt; if it is positive and smaller, repay only as much as the cash allows (Financial Modeling and Valuation, 2nd ed., 2022, ch. 7, p. 253). Every formula in the schedule is a version of those three sentences.

From the testBramblewick Seafood · The assignment

A debt schedule, with paydown and amortization where they apply. It must have a fully functioning revolver, even if the revolver is never drawn

We want to see that you can build the model from scratch. Do not use a template or a pre-set model or format.

The Revolver Formula

Pignataro collapses the three conditions into one Excel expression (p. 256):

Revolver draw / (repayment) =
    −MIN(cash available after mandatory repayments,
         revolver opening balance)

It works in both directions. If cash available is −$4 million, MIN returns −4 and the formula draws $4 million. If cash available is $12 million and the revolver balance is $5 million, MIN returns 5 and the formula repays $5 million. Two refinements make it production grade:

  • Cap the draw at the facility limit, and for an asset-based revolver at the borrowing base, whichever is lower.
  • Flag any shortfall the revolver cannot cover. A model that silently lets cash go below the minimum is hiding a liquidity problem.
Availability       = MIN(facility limit, borrowing base)
Draw / (repayment) = MIN(−MIN(CashAvailable, RevolverOpening),
                         Availability − RevolverOpening)
CashAfterRevolver  = CashAvailable + Draw / (repayment)
Unfunded shortfall = −MIN(0, CashAfterRevolver)

If the borrowing base falls below the amount already drawn, Availability − RevolverOpening turns negative and the formula forces a repayment. This example assumes an immediate cure. Use the agreement’s cure period or permitted overadvance when modeling an actual facility. If cash cannot fund the cure, show the gap.

The Cash Sweep

A borrower can choose to use spare cash for an optional prepayment. A credit agreement can also require an annual payment based on its own definition of excess cash flow. The two amounts need separate lines if their timing or definitions differ. Geoff Yates and Mike Hinchliffe note that the percentage is negotiated and depends on how highly leveraged the deal is at the outset (A Practical Guide to Private Equity Transactions, 2010, p. 186). In a model:

Cash sweep = MIN(SweepPct × MAX(0, CashAfterRevolver),
                 MAX(0, TermDebtAfterAmortization))

The two MAX terms do different jobs. The first stops a negative cash figure from turning the sweep into new term debt with no lender behind it. The second stops a loan that is already repaid from going below zero. Any deficit the revolver could not cover stays in CashAfterRevolver, where the shortfall flag picks it up.

A 100% optional sweep keeps cash at the minimum while eligible debt remains and liquidity is sufficient. At 50%, the unswept share stays on the balance sheet. If the intent is to retain that share permanently, exclude previously retained cash from the next period’s sweep base. Otherwise the model will sweep part of it again.

For a contractual example, Alvotech’s December 2025 credit agreement sets its annual excess cash flow percentage at 50% above 4.0x total net leverage, 25% above 3.5x through 4.0x, and zero at or below 3.5x. Only the calculated payment above $10 million is due. A flat percentage of cash above an operating minimum would give a different answer. Alvotech credit agreement, section 2.05(2)(a)

What a capped revolver looks like. Take an illustrative bad year, not from the house case: cash available after mandatory repayments is −$12.0 million, the revolver already carries $22.0 million, its limit is $30.0 million, the borrowing base has fallen to $26.0 million and $40.0 million of term loan is outstanding.

Line Calculation Result
Availability MIN($30.0M limit, $26.0M borrowing base) $26.0M
Revolver draw MIN(−MIN(−12.0, 22.0), 26.0 − 22.0) $4.0M
Cash after revolver −12.0 + 4.0 −$8.0M
Cash sweep, safe formula MIN(100% × MAX(0, −8.0), MAX(0, 40.0)) $0.0M
Unfunded shortfall −MIN(0, −8.0) $8.0M, flagged
Cash sweep, unsafe formula MIN(100% × −8.0, 40.0) −$8.0M

The unsafe version hides the problem twice. Its negative sweep adds $8.0 million to the term loan that no lender agreed to provide, and because that phantom loan fills the hole, ending cash still shows the minimum. The safe version leaves the $8.0 million in plain sight, which is what a downside case is for: the company needs equity, a waiver or a larger facility, and the model should say so. Our LBO modeling traps guide covers the other revolver and PIK mistakes reviewers see most.

Exhibit A

Five years on the simplified teaching schedule

The full distribution case opens with a $75 million term loan, a $4.5 million draw on a $30 million revolver, $80 million of sponsor equity, $4.5 million of fees and $5 million of minimum cash. For the teaching schedule below, the opening revolver and fees both round to $5 million. The $75 million term loan amortizes at 1% of original principal per year. Term and revolver interest are 9% and 6%, respectively, both on opening balances in this illustration. Cash flow before financing is 66.5% of EBITDA, with a 25% tax shield on interest. Figures are in $ millions, rounded for display.

Line Year 1 Year 2 Year 3 Year 4 Year 5
EBITDA 29.0 31.0 33.2 35.6 38.3
Cash flow before financing (66.5%) 19.3 20.6 22.1 23.7 25.5
Cash interest, after tax (5.3) (4.5) (3.4) (2.1) (0.6)
Cash available for debt repayment 14.0 16.1 18.7 21.6 24.8
Mandatory amortization (0.75) (0.75) (0.75) (0.75) (0.75)
Revolver repayment (5.0) 0.0 0.0 0.0 0.0
Cash sweep to the term loan (8.2) (15.4) (18.0) (20.8) (8.9)
Term loan, ending 66.0 49.9 31.2 9.6 0.0
Revolver, ending 0.0 0.0 0.0 0.0 0.0
Cash, ending 5.0 5.0 5.0 5.0 20.2
Total debt ÷ EBITDA 2.28x 1.61x 0.94x 0.27x 0.00x
  1. The revolver goes first. Year 1 repays the $5 million draw before a dollar of the sweep reaches the term loan.
  2. Interest falls as the debt falls. Cash interest drops from $7.05 million in year 1 to $0.86 million in year 5, so more cash reaches the sweep each year.
  3. The sweep runs out of debt. In year 5, $24.8 million is available, the last $9.6 million of term loan goes ($0.75 million of amortization and an $8.9 million sweep), and cash builds to $20.2 million.
  4. The exit ties. At the displayed precision, 6.0 times $38.3 million gives $229.8 million of enterprise value. Add $15.2 million of excess cash for about $245 million in sponsor proceeds, or 3.06x and a 25.1% five-year IRR on $80 million. If you rebuild from the five one-decimal EBITDA figures printed here, rounding gives $20.27 million of ending cash and $245.07 million of proceeds.

What the full workbook actually repays

The workbook models receivables, inventory, payables, capex and taxes year by year. In 2028, the year with a 30-day collections delay, the total increase in operating working capital uses $17.68 million of cash. That leaves $2.04 million for optional repayment and $47.00 million of term debt outstanding. In the teaching schedule, the same year ends with about $31.2 million of term debt. Both versions finish debt-free.

Workbook line ($M) 2026 2027 2028 2029 2030
Cash interest before tax 6.99 6.03 4.45 4.20 0.66
Mandatory term repayment 0.75 0.75 0.75 0.75 0.75
Optional term repayment 6.87 16.85 2.04 38.58 6.92
Ending term loan 67.38 49.79 47.00 7.67 0.00
Ending revolver 0.00 0.00 0.00 0.00 0.00
Ending cash 5.00 5.00 5.00 5.00 20.87

The workbook repays the opening $4.5 million revolver in 2026. Its $6.99 million of first-year interest is 6% on that opening draw plus 9% on the average of $75.00 million and $74.25 million, the term loan balance after mandatory amortization. The optional sweep occurs after interest. At exit, $229.43 million of enterprise value plus $15.87 million of cash above the operating minimum yields $245.30 million for the sponsor, or 3.07x and a 25.1% five-year IRR. Full workbook and case walkthrough

Formula view of the teaching schedule

The following formulas use the rounded $5 million opening revolver and opening-balance interest. Repayments appear as negative cash flows. The names stand for model cells.

Line Year 1 formula Year 1
Cash flow before financing = EBITDA × 66.5% 19.3
Cash interest, after tax = −(TL_open × 9% + Rev_open × 6%) × (1 − 25%) (5.3)
Cash available = CF_before_financing + Interest + (Cash_open − MinCash) 14.0
Mandatory amortization = −MIN(1% × TL_original, TL_open) (0.75)
Cash after mandatory = Cash_available + Mandatory 13.2
Revolver draw / (repayment) = MIN(−MIN(Cash_after_mandatory, Rev_open), Availability − Rev_open) (5.0)
Cash after revolver = Cash_after_mandatory + Revolver 8.2
Cash sweep = −MIN(Sweep% × MAX(0, Cash_after_revolver), MAX(0, TL_open + Mandatory)) (8.2)
Unfunded shortfall (flag) = −MIN(0, Cash_after_revolver) 0.0
Term loan, ending = TL_open + Mandatory + Sweep 66.0
Cash, ending = MinCash + Cash_after_revolver + Sweep 5.0

PIK Interest: Debt That Grows

Payment-in-kind (PIK) interest adds to principal, so the balance compounds. The financing documents specify the note’s maturity, coupon frequency and priority. In this example there are no interim repayments. Each year the ending balance equals opening principal times one plus the annual PIK rate.

Suppose the sponsor replaces $15 million of its $80 million equity with a 12% PIK note at the holding company. The operating company does not guarantee it, so the note ranks behind the bank debt because of where it sits; our senior vs subordinated debt guide explains why. The bank debt and the cash sweep are unchanged; the note grows every year and is repaid from the exit proceeds ahead of the equity.

Teaching schedule with a $15M, 12% PIK noteStacked columns of debt from close to year 5. At close: $75.0 million term loan, $5.0 million revolver and $15.0 million PIK note. The term loan falls to $66.0 million, $49.9 million, $31.2 million, $9.6 million and zero, while the PIK note grows to $16.8 million, $18.8 million, $21.1 million, $23.6 million and $26.4 million, the only debt left in year 5 (highlighted).Teaching schedule with a $15M, 12% PIK noteTerm loanPIK noteRevolver$0M$25M$50M$75M$100M$95.0MClose$82.8MY1$68.7MY2$52.3MY3$33.2MY4$26.4MY5Teaching schedule. The term loan pays 9% interest and 1% of original principal annually.The 6% revolver is repaid before spare cash goes to the term loan. PIK accrues at 12%annually.
Case Without PIK ($80M equity) With PIK ($65M equity)
Base case 3.06x, 25.1% 3.36x, 27.4%
Year-2 recession 2.09x, 15.9% 2.16x, 16.7%
Flat EBITDA 1.68x, 10.9% 1.66x, 10.7%

Here the only equity cash flows occur at entry and exit, and the PIK note has no interim payments, fees or tax benefit. Under those assumptions, substituting the note for equity raises sponsor IRR when the original equity IRR exceeds 12%. In the flat case the equity earns less than the note costs, and the PIK makes it worse. We treat the PIK interest as not deductible for tax, a simplification; deductibility depends on the jurisdiction and the instrument.

PIK also splits three numbers that a reader expects to move together: reported profit, taxable profit and cash. John Gilligan and Mike Wright’s worked buyout, a £13.35 billion deal with seven layers of finance under UK rules of the time, shows a first-year pre-tax loss of £398 million after £1,146 million of interest, of which only £447 million is paid in cash. The same year shows £725 million of taxable profit and £201 million of cash tax, partly because the rolled-up interest was not deductible (Private Equity Demystified, 2008, pp. 64-68).

Interest and the Circular Reference

The interest base should reflect when principal moves. An opening/closing average approximates borrowing or repayment spread through the period. A payment on the last day barely reduces that period’s interest. Using the ending balance after an optional sweep creates a circular reference because the sweep itself depends on after-interest cash flow. Pignataro walks through enabling iterative calculation in Excel and limiting the number of iterations (pp. 241-256). Two habits keep it safe:

  • Add a circularity switch. One cell toggles interest between average balances and opening balances. If the model throws errors, switch it off, fix the cause, switch it back on.
  • Keep the switch near the top of the model, labeled, so a reviewer can find it in a timed test.

Opening-balance interest removes that circularity. The full distribution workbook also avoids it by excluding optional repayments from the interest base. State the convention beside the rate so a reviewer can reproduce the calculation.

Checks Before You Send the Model

  1. No balance below zero, and no sweep that adds debt. This schedule shows repayments as negative cash flows, so a negative sweep line is correct: the standalone sweep formula returns a positive repayment, and the roll-forward enters it with a minus sign. What must never happen is a balance the MINs fail to stop at zero, or a sweep that increases a balance, which is new borrowing.
  2. No cash below the minimum. If a period shows it, the revolver is capped or broken, and the downside has a liquidity problem.
  3. The balance sheet balances in every period, with the schedule’s ending balances flowing to it, starting from an opening balance sheet that balances on day one (purchase price allocation).
  4. Interest ties. On a consolidated basis, this example’s interest expense equals cash interest plus PIK accrual. Add any other interest expense modeled separately, such as amortization of debt issuance costs, before checking a full income statement.
  5. The exit uses ending balances. Exit equity deducts every tranche at its year-of-exit balance, PIK included, and adds cash above the minimum.

Debt schedule traps

TrapWhat goes wrongHow to catch itFix
Sweeping before the revolver is repaidThe term loan falls while the revolver stays drawn.Check the revolver balance in the years the sweep runs.Repay the revolver first, then sweep the remaining cash.
Paying PIK interest in cashCash interest includes the PIK coupon and the PIK balance never grows.Look for a PIK principal line that compounds.Accrue PIK to principal, show it as non-cash interest and repay it at exit.
Sweeping all cash, including the minimumCash falls to zero after the sweep.Find where minimum cash is subtracted from cash available.Sweep only cash above the minimum operating balance.
A sweep that can go negativeIn a bad year the term loan balance rises with no new loan in sources and uses.Look for MAX(0, ...) around the cash in the sweep formula.Sweep only positive cash and show any remaining deficit as an unfunded shortfall.
An uncapped revolverIn the downside the revolver draws more than the facility allows.Compare the peak revolver balance with the limit and the borrowing base.Cap the draw and flag any shortfall it cannot cover.
A circular reference with no switchOne bad input fills the model with errors that will not clear.Look for iterative calculation turned on without a toggle.Add a labeled circularity switch, or calculate interest on opening balances.

Debt schedule build checklist

  • One block per tranche: opening, mandatory, optional, PIK, ending, rate and interest.
  • Cash available starts from the cash flow statement and excludes minimum cash.
  • Revolver formula draws on shortfalls, repays first on surplus and is capped.
  • Sweep percentage is an input, applied after the revolver to positive cash only and capped at the balance.
  • PIK accrues to principal and appears at exit.
  • Circularity switch or opening-balance interest, labeled.
  • Debt, cash and balance sheet checks pass in every period, base and downside.

Frequently Asked Questions

What is a debt schedule in an LBO model? The tab that tracks every tranche of debt from close to exit: opening balance, mandatory repayment, revolver draws and repayments, optional prepayments from the cash sweep, PIK interest added to principal, ending balance and interest. It takes cash flow from the cash flow statement and sends interest back to the income statement.

How does a cash sweep work in an LBO? In this model, repay the revolver first. Multiply the positive cash left above the operating minimum by the sweep percentage, capped at the term loan balance after mandatory amortization. A negative cash balance above the minimum produces a zero sweep and a shortfall to flag. A contractual excess cash flow payment follows the credit agreement’s definition, timing and thresholds.

What is the revolver formula in an LBO model? After mandatory repayments, draw enough to restore minimum cash, up to unused availability. When cash exceeds the minimum, repay the lesser of the surplus and the opening revolver balance. For an asset-based line, availability is the lower of the facility limit and the eligible borrowing base. Model any required cure if the opening draw exceeds that limit, then flag any unfunded cash shortfall.

How does PIK interest work? Payment-in-kind interest increases the loan’s principal. A $15 million note with 12% PIK compounded annually grows to about $26.4 million after five years. In this example it uses no cash during the hold and is repaid from exit proceeds ahead of the equity.

Why does an LBO debt schedule create a circular reference? When interest is calculated on the average of the opening and ending debt balance, interest depends on how much debt is repaid, which depends on cash flow after interest. Either calculate interest on opening balances, or enable iterative calculation and add a switch that turns the circularity off when the model breaks.

What order should the debt schedule follow? Start with opening cash plus cash flow after cash interest and tax. Reserve minimum cash, pay scheduled amortization, then draw or repay the revolver. Apply remaining cash to the eligible tranches in the order specified in the agreement. Roll up PIK interest, close the balances and check liquidity.

Sources

Books and frameworks:

  • Paul Pignataro, Financial Modeling and Valuation, 2nd ed. (Wiley, 2022), ch. 7, “The Debt Schedule, Circular References, and Finalizing the Model”: circular references and iteration, p. 241; the paydown conditions, p. 253; the −MIN formula, p. 256. The capped and shortfall versions above are ours.
  • Claudia Zeisberger, Michael Prahl and Bowen White, Private Equity in Action (Wiley, 2017), Case 12, Exhibit 12.6: overview of debt in LBOs.
  • Geoff Yates and Mike Hinchliffe, A Practical Guide to Private Equity Transactions (Cambridge University Press, 2010), ch. 6, p. 186: excess cash flow prepayments.
  • John Gilligan and Mike Wright, Private Equity Demystified, 1st ed. (ICAEW Corporate Finance Faculty, 2008), pp. 64-68: the worked buyout’s financing structure (Table 4.6), profit after funding (Table 4.7), cash flow and tax (Tables 4.9 and 4.12).

Our calculations:

Revision History

  1. : Reconciled five years of debt, cash and interest to the distribution workbook and distinguished optional sweeps from contractual excess cash flow payments.
  2. : Distinguished the historical term loan B covenant example from covenant-lite structures.
  3. : First published, with a worked debt schedule and a PIK variant on the house distribution case.