LBO Debt Schedule: Amortization, Mandatory Repayments, and Cash Sweeps

Introduction

The debt schedule is the most mechanically complex component of the LBO model. It tracks each tranche of debt through the holding period, calculating interest expense, mandatory principal payments, cash sweep provisions, and optional prepayments for each year. The debt schedule determines how quickly the company deleverages, which directly affects the equity value at exit and the sponsor's returns.

Debt paydown is one of the three value creation levers in an LBO (alongside EBITDA growth and multiple expansion), and for many deals, it represents 20-30% of total returns. Building the debt schedule accurately is essential for a reliable LBO model.

Beginning Balance

Each year starts with the outstanding balance of each debt tranche. In Year 1, this is the amount drawn at closing from the sources and uses table. In subsequent years, it is the prior year's ending balance.

Interest Expense

Interest is calculated on each tranche at its applicable rate:

Total interest expense flows to the income statement and reduces pre-tax income and cash flow available for debt repayment.

Mandatory Amortization

Scheduled principal repayments required by the loan agreement. Term Loan B typically has 1% annual mandatory amortization (meaning 1% of the original principal is repaid each year, with the remaining 99% due at maturity). Term Loan A may have higher amortization (e.g., 5-10% annually). High-yield bonds typically have no mandatory amortization (bullet maturity).

Cash Sweeps (Mandatory Prepayments)

Many leveraged loan agreements include a cash sweep (also called an excess cash flow sweep or mandatory prepayment provision). This clause requires the company to direct a percentage of its excess free cash flow (typically 50-75%) toward mandatory debt repayment. The percentage often steps down as leverage decreases:

Excess Cash Flow (in Leveraged Finance)

The cash flow remaining after all operating expenses, taxes, capital expenditures, working capital changes, scheduled debt service (interest + mandatory amortization), and permitted investments have been deducted. This is the base to which the cash sweep percentage is applied. The precise definition is negotiated in the credit agreement and can vary significantly between deals. Common exclusions include capital expenditures up to a budgeted amount, permitted acquisitions, and certain restricted payments (dividends to the sponsor, if allowed). A borrower-friendly definition of excess cash flow produces a smaller sweep base, preserving more cash for the company and the sponsor. A lender-friendly definition captures more cash for debt repayment. The negotiation of this definition is one of the most consequential terms in the credit agreement from the sponsor's perspective.

An important nuance: the precise definition of the leverage ratio used for the step-down test matters enormously. Whether leverage is measured using gross debt or net debt (after netting unrestricted cash), how subordinated or PIK instruments are treated, and whether EBITDA is calculated on a trailing or pro forma basis can all affect whether the step-down thresholds are reached. Borrowers sometimes negotiate favorable definitions that make it easier to reach the lower sweep thresholds, preserving cash for operations or distributions.

Cash Sweep (Excess Cash Flow Sweep)

A mandatory prepayment provision in leveraged loan agreements that requires the borrower to use a specified percentage of its excess free cash flow each year to prepay outstanding debt. The sweep percentage typically decreases ("steps down") as the company's leverage ratio improves, reflecting the reduced risk as the company deleverages. Cash sweeps accelerate debt paydown beyond the scheduled amortization, which benefits both lenders (faster principal recovery) and equity holders (reduced leverage increases equity value). Cash sweeps are the primary mechanism through which debt paydown creates value in an LBO.

Optional Prepayments

After mandatory amortization and cash sweep payments, the company may have remaining cash that can be used for optional (voluntary) debt repayment. The model typically assumes the company uses all or most of its remaining free cash flow to prepay debt, starting with the highest-cost tranche (to minimize interest expense).

Prepayment Waterfall

Debt is typically repaid in order of seniority:

1. Revolver (repaid first, then available for re-draw) 2. Term Loan (mandatory amortization + cash sweep) 3. Senior unsecured notes (may have call protection, preventing early repayment for 2-3 years) 4. Subordinated / mezzanine (typically has call protection; not prepaid early unless at a premium)

For each year in the model, the calculation for each debt tranche follows this sequence:

To make the mechanics concrete, consider a company acquired in an LBO with the following capital structure:

The senior unsecured notes remain at $150 million throughout (bullet maturity, no amortization). Total debt decreases from $550 million to approximately $393.5 million over 5 years, a reduction of $156.5 million. This $156.5 million of debt paydown flows directly to equity value at exit: if the company's enterprise value at exit is $1.3 billion (10x exit multiple on $130 million EBITDA), equity at exit is $1.3B - $393.5M = $906.5M versus the initial equity of $450 million, a 2.0x MOIC.

Notice how the cash sweep amounts increase in the early years (as EBITDA grows and more excess cash flow becomes available) and then decrease in later years (as leverage drops below 4.0x and the sweep percentage steps down from 75% to 50%). This front-loading of debt repayment is intentional: by aggressively paying down debt when leverage is highest, the company reduces its interest burden faster, creating a virtuous cycle where lower interest expense generates more free cash flow for further repayment.

The revolving credit facility requires special treatment in the debt schedule because it functions differently from term debt. The revolver is typically sized at $50-100 million for a mid-market LBO and is undrawn at closing (it does not appear in the closing capital structure). Its purpose is to provide liquidity for working capital fluctuations, seasonal cash needs, or unexpected expenses.

In the LBO model, the revolver serves as a cash flow balancing mechanism. If the company's operating cash flow is insufficient to cover interest expense, capital expenditures, and mandatory debt service in a given period, the model automatically draws on the revolver to cover the shortfall. If cash flow is sufficient, any existing revolver balance is repaid before other debt (since revolver debt is the most senior and should be minimized).

The revolver's mechanics create another layer of circularity in the model: the interest expense on the revolver depends on the drawn balance, which depends on the cash flow, which depends on the interest expense. This is typically handled through the same iterative calculation approach used for the broader debt schedule circularity.

The debt schedule creates a circular reference in Excel: interest expense depends on the debt balance, which depends on free cash flow (after interest), which depends on interest expense. This circularity is unavoidable because the optional prepayment amount depends on how much cash is left after paying interest, but the interest amount depends on how much debt was prepaid in prior periods.

There are two standard approaches to resolving the circularity:

Iterative calculation: Excel can be configured to recalculate circular formulas multiple times until they converge (File > Options > Formulas > Enable iterative calculation, set to 100 iterations with 0.001 precision). This allows the model to solve the circularity automatically. The downside is that iterative calculation applies to the entire workbook, which can cause issues if other worksheets have unintentional circular references.

Circuit breaker approach: Insert a toggle cell (typically at the top of the debt schedule) that switches between 0 and 1. When set to 0, the cash sweep and optional prepayment formulas are suppressed (set to zero), breaking the circularity and allowing the model to calculate without iteration. When set to 1, the full formulas activate, and the model relies on iterative calculation to converge. The circuit breaker is invaluable for debugging: if the model produces an error or fails to converge, the analyst can toggle the circuit breaker to 0, identify the issue in the non-circular state, fix it, and re-enable the circularity.

Excel Layout

The standard Excel layout for the debt schedule uses one column per year (or quarter, for more detailed models) and rows organized by debt tranche. Within each tranche, the rows follow the calculation sequence:

1. Beginning balance 2. Mandatory amortization 3. Cash sweep (mandatory prepayment) 4. Optional prepayment 5. New borrowings (if applicable, such as revolver draws) 6. PIK accrual (for PIK instruments) 7. Ending balance 8. Interest expense (calculated on the average or beginning balance)

Each tranche gets its own block of these rows, and a summary section at the bottom aggregates total debt outstanding, total interest expense, and total principal payments. The summary totals flow to the income statement (interest expense), the cash flow statement (principal payments), and the balance sheet (ending debt balances).

Common Modeling Errors

Forgetting the MIN function for prepayments: When calculating optional prepayments, the formula must include a MIN constraint to ensure the prepayment does not exceed the outstanding balance. Without this, the model can produce negative debt balances, which are economically impossible. The formula should be: =MIN(available cash for prepayment, beginning balance - mandatory amortization - cash sweep).

Using ending balance instead of beginning balance for interest: Interest should be calculated on the beginning balance for each period (since interest accrues on the debt outstanding at the start of the period). Some models use the average of beginning and ending balances for a more precise estimate, particularly when significant prepayments occur during the period.

Not linking the revolver correctly: The revolver should draw automatically when cash flow is negative (the company needs liquidity) and repay automatically when cash flow turns positive. This requires an IF function that checks the cash flow available after all other debt service and switches between borrowing and repaying based on the sign of the remaining cash.

Ignoring the call schedule for high-yield notes: If the model prepays high-yield bonds in Year 1 or 2, it should include the call premium (typically 104-106% of par in Year 1, declining to 100% by Year 3-4). Ignoring the premium understates the cost of early repayment and overstates the cash available for other uses.

Quarterly vs. Annual Debt Schedules

Most interview-level and pitchbook LBO models use an annual debt schedule. More detailed models (used by PE firms for actual investment decisions) may use a quarterly schedule to capture the timing of cash flows and debt payments more precisely. Quarterly models are also necessary for testing maintenance covenants, which are measured quarterly. The tradeoff is complexity: a quarterly model has four times as many columns and requires quarterly revenue and expense projections, which may not be available or may be highly seasonal.

The debt schedule provides the inputs for quarterly (or annual) covenant compliance testing. The two most common maintenance covenants in leveraged loans are:

Total leverage ratio: Total debt (from the debt schedule's ending balance) divided by trailing EBITDA. A typical covenant might require total leverage below 6.0x at close, stepping down to 5.5x by Year 2 and 5.0x by Year 3. The debt schedule must project the leverage trajectory to verify the company maintains sufficient headroom above these thresholds under both the base case and the downside scenario.

Interest coverage ratio: EBITDA divided by total cash interest expense (from the debt schedule). A typical covenant requires minimum 2.0x coverage. As debt is paid down and interest expense decreases, coverage ratios improve, providing increasing headroom. However, if EBITDA declines (recession, competitive pressure), coverage can deteriorate even as debt balances decrease.

The sponsor's investment committee evaluates covenant headroom as a key risk metric. A deal with only 10% headroom to the leverage covenant (covenant at 6.0x, projected leverage at 5.4x) has minimal room for EBITDA underperformance before triggering a breach. A deal with 25% headroom (covenant at 6.0x, projected leverage at 4.5x) can absorb a significant EBITDA decline before the covenant becomes a concern. The debt schedule is the analytical foundation for these calculations.

The speed of debt paydown directly affects returns. Faster paydown reduces the leverage ratio, increasing the equity value at exit. In the worked example, if the company pays down $250 million of $500 million in debt over 5 years (through mandatory amortization, cash sweeps, and optional prepayments), the equity at exit increases by $250 million relative to a scenario where no debt was repaid. This deleveraging is "free" to the equity holder: the company's operating cash flows are doing the work, not additional equity investment.