Financial modelling8 min read
LBO Model: Debt Tranches and Repayment Schedule
In an LBO model, debt decides the price you can pay, the return and the risk: tranches, rates, ranking, amortisation and cash sweep. Here is how to structure €100m of debt in three tranches, build the repayment schedule and test the covenants, with a full worked example.

Why an LBO model is built around debt
In an LBO model, debt decides almost everything: the price a fund can pay, the return it earns and the risk that the company misses its payments. The paper LBO simplifies this part to the extreme, with a single debt repaid out of all the available cash flow. The full model does the opposite: it splits the debt into tranches, gives each one its own rate, ranking and repayment profile, then checks year after year that the company's cash flows are enough.
The debt tranches of an LBO model
An LBO is rarely financed with a single loan. Lenders do not all accept the same risk, and each level of risk has its price. The four most common tranches:
| Tranche | Ranking | Repayment | Indicative rate | Usual leverage |
|---|---|---|---|---|
| Senior A (term loan A) | Senior | Straight-line amortisation over 5 to 7 years | 5 to 7% | 1.5x to 3x EBITDA |
| Senior B (term loan B) | Senior, behind A | Bullet, prepaid through the cash sweep | 6 to 8% | 1x to 2x |
| Mezzanine | Subordinated | Bullet, often with warrants attached | 10 to 13% | 0.5x to 1.5x |
| PIK | Subordinated | Bullet, interest capitalised | 11 to 15% | 0 to 1x |
Three terms to remember. Ranking says who is repaid first if the company defaults: senior before mezzanine, mezzanine before shareholders. Bullet means the principal is repaid in one go at maturity; only the interest is paid each year. PIK (payment in kind) describes debt whose interest is not paid but added to the principal: the balance grows every year until exit.
The rates are orders of magnitude that move with the market and the size of the deal. On small and mid-sized deals, a unitranche (a single bullet debt, at an intermediate rate, lent by a debt fund) often replaces the senior plus mezzanine pairing.
The cash sweep completes the structure: after interest and mandatory amortisation, all or part of the available cash prepays the debt, usually senior A first and then senior B. The credit agreement sets the share swept, often between 50% and 100% of the excess cash flow, sometimes stepping down as leverage falls.
Worked example: structuring €100m of debt
Let us go back to Cible SA, the fictional company from the paper LBO: revenue of €100m, an EBITDA margin of 20%, growth of 5% a year, capex of 3% of revenue equal to depreciation, working capital of 10% of the increase in revenue, and tax at 25%. The fund buys at 8.0x EBITDA, or €160m, and sells at the same multiple after five years. As in the paper LBO, transaction fees and minimum cash are ignored.
In the paper LBO, the €100m of debt (5.0x EBITDA) was a single line at 7%, repaid out of all the available cash flow. Let us structure it:
| Tranche | Amount | Leverage | Rate | Repayment |
|---|---|---|---|---|
| Senior A | €40m | 2.0x | 6% | €5.7m a year over 7 years (40 ÷ 7), plus the sweep |
| Senior B | €40m | 2.0x | 7.5% | Bullet; sweep once A is repaid |
| Mezzanine | €20m | 1.0x | 11% | Bullet, at exit |
| Total | €100m | 5.0x | 7.6% on average in year 1 |
The equity put in by the fund stays at 160 − 100 = €60m. The cash sweep is set at 100% of the cash flow available after mandatory amortisation.
The repayment schedule
Interest is calculated on the opening balance: 40 × 6% + 40 × 7.5% + 20 × 11% = €7.6m in year 1, against €7.0m with the single debt at 7%. The cash flow available for debt is calculated as in the paper LBO: EBITDA, less capex, less the increase in working capital, less tax, less interest paid.
| Year | Available cash flow | Interest paid | Amortisation A | Sweep A | Sweep B | Senior A | Senior B | Mezzanine | Total debt |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 40.0 | 40.0 | 20.0 | 100.0 | |||||
| 1 | 7.2 | 7.6 | 5.7 | 1.5 | 0 | 32.8 | 40.0 | 20.0 | 92.8 |
| 2 | 8.2 | 7.2 | 5.7 | 2.4 | 0 | 24.7 | 40.0 | 20.0 | 84.7 |
| 3 | 9.2 | 6.7 | 5.7 | 3.5 | 0 | 15.5 | 40.0 | 20.0 | 75.5 |
| 4 | 10.3 | 6.1 | 5.7 | 4.6 | 0 | 5.1 | 40.0 | 20.0 | 65.1 |
| 5 | 11.5 | 5.5 | 5.1 | 0 | 6.4 | 0 | 33.6 | 20.0 | 53.6 |
In €m, figures rounded to one decimal place. Balances are year-end.
Read the first row: €7.2m of available cash flow, of which €5.7m is mandatory amortisation. That leaves €1.5m for the sweep. The margin is thin: if year 1 EBITDA came in €2m below plan, the company could no longer cover its repayment. That is why senior A is spread over 7 years here rather than 5 (€8.0m a year, out of reach in year 1).
Thanks to the sweep, senior A is repaid in five years instead of seven; in year 5, the sweep moves on to senior B for €6.4m. The mezzanine waits for the exit.
What the structure does to the return
At exit, enterprise value is 25.5 × 8.0 = €204.2m. Deduct €53.6m of remaining debt: equity value is €150.6m, a MOIC of 2.51x and an IRR of 20.2%. A third variant replaces the mezzanine with €20m of PIK at 12%:
| Structure | Interest over 5 years | Debt at exit | Equity at exit | MOIC | IRR |
|---|---|---|---|---|---|
| Single debt at 7% (paper LBO) | €28.9m | €50.5m | €153.7m | 2.56x | 20.7% |
| Senior A + senior B + mezzanine | €33.1m | €53.6m | €150.6m | 2.51x | 20.2% |
| Senior A + senior B + PIK at 12% | €20.6m paid and €15.2m capitalised | €55.6m, of which €35.2m is PIK | €148.6m | 2.48x | 19.9% |
Half a point of IRR separates the three structures; the risk differs far more. The PIK variant frees up €2.2m of cash a year at the start, when the company is at its most indebted, and pays for it at exit with a balance that has grown from 20 to €35.2m (20 × 1.12⁵). A structure is judged on the repayment schedule and the covenants, not on IRR alone.
Covenants: what the schedule must prove
Lenders read two ratios, written into the credit agreement as covenants (financial undertakings whose breach lets the lender demand repayment):
- Leverage: total debt divided by EBITDA. The agreement sets a declining ceiling, for example 5.0x at entry, then 4.75x, 4.25x, and so on.
- Interest cover: EBITDA divided by interest paid. A common floor: 2.0x to 3.0x.
| Year | Leverage (debt ÷ EBITDA) | Cover (EBITDA ÷ interest) |
|---|---|---|
| 0 | 5.0x | |
| 1 | 4.4x | 2.8x |
| 2 | 3.8x | 3.1x |
| 3 | 3.3x | 3.5x |
| 4 | 2.7x | 4.0x |
| 5 | 2.1x | 4.6x |
Your model should show these two lines against the thresholds in the agreement, with the headroom expressed as a percentage of EBITDA: by how much can EBITDA fall before the covenant breaks? In year 1, a leverage ceiling of 4.75x breaks if EBITDA falls below €19.5m (92.8 ÷ 4.75), which is 7% below plan. Funds generally aim for headroom of 20% to 30%.
Five modelling pitfalls
- Interest circularity. Calculated on the average balance for the year, interest depends on the sweep and the sweep on interest: Excel goes round in circles. Calculate it on the opening balance, as here, or switch on iterative calculation with your eyes open.
- A negative sweep. When available cash flow does not cover mandatory amortisation, the sweep formula turns negative and "repays" the debt in reverse. Floor it at zero and show a warning: it is a funding need, not a repayment. In a full model, that need is met by a revolver, the LBO's revolving credit facility.
- Forgetting the PIK in exit debt. Capitalised interest does not go through the cash flow, so it gets forgotten. At exit, it is the capitalised balance that must be deducted from enterprise value, €35.2m in the example, not the initial €20m.
- The order of repayment. The agreement says which tranche receives the sweep first. Sweeping the mezzanine before the senior debt gives a false IRR and a false risk profile.
- Minimum cash. A company needs cash to operate: the cash swept is the cash above that minimum. The bridge between enterprise value and equity value deals with the same point from the buyer's side.
Three checks before you trust the result
- The debt balances. Opening balance + capitalised interest − amortisation − sweep = closing balance, for every tranche and every year. A check column should show zero.
- Sources equal uses. Debt plus equity = price paid plus fees plus minimum cash. If the equality breaks when you change a leverage input, a tranche is not linked to the uses.
- The IRR can be recovered by hand. With a MOIC of 2.51x over five years, the IRR calculation gives 2.51^(1/5) − 1 = 20.2%. If the model shows something else, the exit cash flow or its date is wrong. To see where that return comes from, build the value creation bridge.
Structure your debt in a complete model. Bridgesheet's Excel LBO model links sources and uses, four debt tranches (senior A and B, mezzanine, PIK), a configurable cash sweep, management equity, covenants and the value bridge, all in formulas, for €49 and no subscription. It is an estimate, not a certified valuation or investment advice.


