LBO Model Debt Schedule in Excel: Build Term Loan, Senior Notes and Cash Sweep Step by Step

An LBO model debt schedule in Excel tracks each tranche of acquisition debt year by year: opening balance, mandatory amortization, optional prepayments from a cash sweep, closing balance and interest. In a typical buyout the schedule holds a revolver, a term loan B and senior notes, and it feeds interest expense into the income statement and debt paydown into the cash flow statement. Built properly, it tells you how fast the sponsor deleverages and how much equity value that creates.

This guide builds the schedule tranche by tranche, using structures taken from real credit agreements and real deals. You can follow it in a blank spreadsheet model or check it against an Excel template you already use.

How an LBO Model Debt Schedule in Excel Is Laid Out

Start from how real buyouts are financed. Morgan Stanley led the roughly $13 billion commitment behind the 2022 Twitter buyout. It included a $6.5 billion senior secured term loan, a $500 million revolver, and two $3 billion bridge loans (one secured, one unsecured) that were expected to convert into senior and junior bonds, according to The Middle Market. In September 2025, JPMorgan committed $20 billion of debt to the $55 billion take-private of Electronic Arts by Silver Lake, Saudi Arabia's PIF and Affinity Partners. Bloomberg reported that the debt was expected to be rated in the single-B range and sold as a mix of leveraged loans and high-yield bonds.

Both deals pair a floating-rate term loan that the company can prepay with fixed-rate notes it cannot easily prepay. Your schedule has to model that difference. Lay it out in this order, with years running across the columns:

Cash available for debt repayment block: beginning cash, plus free cash flow before debt repayment, less minimum cash.
Revolver: beginning balance, draws or repayments, ending balance, interest, commitment fee on the undrawn amount.
Term loan B: beginning balance, mandatory amortization, optional prepayment (sweep), ending balance, interest.
Senior notes: beginning balance, repayment (usually zero until maturity), ending balance, interest.
Summary and credit stats: total debt, net debt, total leverage, senior secured leverage, interest coverage.

For the rest of this guide we use one illustrative deal: $100 million of EBITDA, total debt of 5.0x ($500 million), split into a $300 million term loan B and $200 million of senior notes, with a $50 million revolver undrawn at close. Set up an assumptions tab with these inputs before you write a single formula in the schedule.

Takeaway. Keep every rate, spread, amortization percentage and sweep percentage on the assumptions tab. The schedule itself should hold formulas only, with no hardcodes.

Step 1: Build the Term Loan B

The term loan B is the most mechanical tranche, and the one the sweep pays down. Its standard terms show up in public credit agreements. Gartner's 2017 credit agreement, filed for its CEB acquisition, describes a term loan B maturing seven years after closing with 1% annual amortization and the balance due at maturity (Gartner 8-K, 2017). Endo International's 2015 facility sets B-2 amortization at 1.0% of initial principal per year (Endo 8-K, 2015).

Rows and formulas

Beginning balance: Year 1 links to the sources and uses table ($300 million). Each later year links to the prior year's ending balance.
Mandatory amortization: =-MIN(Original_Principal*Amort_Pct, Beginning_Balance). The MIN stops the loan going negative once the sweep has paid most of it off. Base it on original principal, as the credit agreements above do, not on the current balance.
Optional prepayment (sweep): links to the cash sweep block built in Step 3.
Ending balance: beginning plus mandatory plus optional (both entered as negatives).
Interest rate: =MAX(SOFR_Curve, Floor)+Spread. Put a SOFR forward curve on the assumptions tab by year.
Interest expense: rate multiplied by the average of beginning and ending balance, behind a circularity toggle (see the section on circularity below).

Use real pricing as a sanity check. Reorg reported that the Twitter term loan carried a margin of SOFR plus 475 basis points with a 0.5% floor (Reorg). In our example, SOFR at 4.0% plus a 350 bps spread gives 7.5%. On $300 million that is about $22.5 million of Year 1 interest before any paydown, and $3 million of mandatory amortization.

Takeaway. Hand-check Year 1. Mandatory amortization should equal exactly 1% of original principal, and interest should land within a rounding error of rate multiplied by opening balance.

Step 2: Build the Senior Notes

Senior notes are simpler to model, but they are where most junior analysts make the expensive mistake of letting the sweep repay them. High-yield notes are bullet instruments, so the full principal comes due in one payment at maturity. They also carry hard call protection, so repaying them early means paying a premium. A term loan B, by contrast, can usually be prepaid at little or no penalty once a short soft-call period ends. The Twitter structure shows why the split matters. Both $3 billion bridges were meant to be refinanced into bonds, and when the market turned the banks were left holding all $13 billion, facing estimated losses of $500 million or more according to the Wall Street Journal as cited by Business Standard.

Rows and formulas

Beginning balance: $200 million from sources and uses.
Repayment: =-IF(Year=Maturity_Year, Beginning_Balance, 0). In our example the notes run eight years, one year past the term loan, which matches the usual order where the senior secured loan matures first.
Ending balance: beginning less repayment.
Interest expense: =Beginning_Balance*Coupon. With a fixed coupon and no paydown, average balance and beginning balance give the same number, so this tranche adds no circularity.

At an 8.0% coupon, the notes cost $16 million a year. Add the term loan and Year 1 cash interest comes to roughly $38.5 million, or 2.6x EBITDA-to-interest coverage. That ratio is the first number a lender will look at.

If you want to model an early call, add a separate row for the call premium (for example, 104 in the first callable year, stepping down toward par). Put a toggle on it and leave it off in the base case.

Takeaway. Leave the notes out of the sweep logic entirely. If your model repays bonds from excess cash in Year 2, your IRR is overstated.

Step 3: Build the Cash Sweep in the LBO Model Debt Schedule

The cash sweep sends excess cash to prepay the term loan. In a real credit agreement, the sweep percentage is set by the "Excess Cash Flow" definition and falls as leverage drops. E.W. Scripps' 2025 credit documentation requires 50% of Excess Cash Flow to prepay term loans, stepping down to 25% and then 0% at first-lien net leverage of 3.50x and 3.00x (E.W. Scripps 8-K, 2025). Cumulus Media's 2024 facility uses the same 50/25/0 ladder at total net leverage of 4.25x and 3.75x (Cumulus Media 8-K, 2024).

Most sponsor models assume a 100% sweep, because sponsors usually pay down debt voluntarily to cut interest. Build both a contractual sweep percentage and a voluntary prepayment toggle.

The cash available block, step by step

Beginning cash: prior year ending cash.
Plus free cash flow before debt repayment: EBITDA less cash interest, cash taxes, capex and the change in working capital. In our Year 1, $100m less $38.5m interest, $12m tax, $20m capex and $4m working capital gives $25.5m.
Less minimum cash: say $10 million, with opening cash also at $10 million.
Less mandatory amortization: $3 million, leaving $22.5 million.
Revolver draw or repayment: =MAX(-Revolver_Beg, MIN(Cash_After_Mandatory, 0)) handles draws when cash is negative. Then repay any drawn balance first with =-MIN(Revolver_Beg, MAX(Cash_After_Mandatory,0)). Combine the two into one row once you trust them.
Cash available for sweep: what is left after the revolver.
Sweep percentage: a lookup against the leverage grid, for example =IF(Leverage<=3.0,0,IF(Leverage<=3.5,25%,50%)), with an override cell for the 100% voluntary case.
Term loan prepayment: =-MIN(Cash_For_Sweep*Sweep_Pct, TLB_Beg+TLB_Mandatory).

In our example, opening leverage is 5.0x, so the contractual sweep is 50% and the Year 1 prepayment is about $11.25 million. Under a 100% voluntary assumption it is $22.5 million. Over five years that gap compounds into a materially different exit net debt figure, so show both cases on the returns page.

Test the leverage step-down on the prior period's leverage, not the current one. Using current-year leverage creates a second circular loop and can flip the sweep percentage back and forth between iterations.

Takeaway. Pull the defined Excess Cash Flow terms from the actual credit agreement or commitment letter. A headline 50% sweep applies after deductions for capex and permitted payments, so it is usually much less than half of free cash flow.

Circularity, Checks and Stress Tests

Interest on average balances creates a loop. Interest affects free cash flow, free cash flow sets the sweep, the sweep sets the ending balance, and the ending balance sets interest. Two fixes are standard:

Iterative calculation: File, Options, Formulas, enable iterative calculation with 100 iterations and a maximum change of 0.001.
Circuit breaker: a single cell (1 or 0) on the assumptions tab. Interest formulas read =IF(Circ=1, AVERAGE(Beg,End), Beg)*Rate. When the model throws #REF or #VALUE errors, set the cell to 0, fix the error, then switch it back.

Add these checks to the bottom of the schedule and roll them into one master check cell:

No tranche balance below zero in any year.
Ending cash at least equal to minimum cash.
Revolver draw never above the commitment.
Total debt on the schedule ties to the balance sheet.
Net change in cash on the cash flow statement ties to the balance sheet.

Then stress the schedule. Cut EBITDA 20% in Year 2 and add 200 bps to the SOFR curve. A floating-rate term loan reprices immediately, while the notes stay fixed. If the revolver fills up or coverage falls below 1.5x, the structure is too aggressive. Junk-rated deals like EA's single-B profile in the Bloomberg report run close to that line by design.

Takeaway. Do not send a model with the circuit breaker off or the master check showing an error. Reviewers look at those two cells first.

Build It Once, Reuse It on Every Deal

The mechanics above are the same whether the deal is $500 million or the $20 billion JPMorgan put behind Electronic Arts. You need a term loan with 1% amortization and a SOFR floor, bullet notes kept out of the sweep, and a sweep tied to leverage step-downs like the Scripps and Cumulus ladders. A circuit breaker and a master check then keep the whole thing stable. Deals differ in the numbers on the assumptions tab, while the schedule logic stays the same from one deal to the next.

Rebuilding this from scratch on every live deal wastes hours and invites errors in exactly the formulas lenders and investment committees check first. A tested LBO Excel template with the debt schedule, revolver logic, sweep toggles and credit stats already wired lets you spend that time on the questions that change the answer: how much leverage the business can carry, and what happens to returns when rates move. ModelStack's IB and M&A models come with these tranches pre-built and the checks in place, so you enter the term sheet and get straight to analysis.

LBO Model Debt Schedule in Excel: Build Term Loan, Senior Notes and Cash Sweep Step by Step

How an LBO Model Debt Schedule in Excel Is Laid Out

Step 1: Build the Term Loan B

Rows and formulas

Step 2: Build the Senior Notes

Rows and formulas

Step 3: Build the Cash Sweep in the LBO Model Debt Schedule

The cash available block, step by step

Circularity, Checks and Stress Tests

Build It Once, Reuse It on Every Deal

Sources

Related reading